Naskot

Members
  • Content Count

    23
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Naskot

  • Rank
    Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hello, If everyone hoster share their banlist (only the cheats, so not the personal ban), the problem will be solved, call of duty 4 would become the game with the least cheaters, since with a ban, they can uninstall the game I invite you to also share your banlist here, this topic does not oblige any host to use it but if he wishes, free to you, but one thing is sure, it ruins the last remaining players of call of duty the plugin is available by default with bigbrotherbot, but it can be compatible with any GUID reader, or a .gsc script
  2. Hi everybody, in front of the recrudescence of cheats on Call of Duty 4, I propose to share my banlist, which contains only cheaters in play, for all server hoster, it's the black beast, because once the cheater used his cheat and is banned from your he just goes on another server, my banlist contains the evidence, so screenshots of all the cheats used, it's a dynamic banlist, to use it is very simple, This Banlist requires BigBrotherBot and the plugin banlist ,you can adapt it differently, this banlist is constantly updated, and it will only contain cheats example: <guid_banlist> <name>NasKoT Banlist</name> <file>/opt/bigbrotherbot/banlist_NasKoT.txt</file> <message>^4$guid^7 is ^1BANNED^7 (GUID 1)</message> <url><![CDATA[http://gameserver.naskot.fr/cod4/?id=XHB66fZzt7OqteOK]]></url> </guid_banlist> list of GUIDs: http://gameserver.naskot.fr/cod4/index.php?id=XHB66fZzt7OqteOK to see the screenshots it's here: http://gameserver.naskot.fr/cod4/index.php?name=0&full=1&id=XHB66fZzt7OqteOK
  3. hi, no its not a truncation but a rounding, this is my ratio and skill my ratio in the database is 1.25968 / in game its rounding at 1.26 so a rounding and the skill 1509.7 in the database is well rounding at 1510 so again a rounding Mysql's Round function works in the same way that is used in all applications, including php web sites, for example. A mysql round function that is used in more than 60% of the planet's websites, including the CMS that is used here, <Invision>. in any case thanks for the help, the problem is solved. cordially
  4. Hello, this request allows you to introduce, if I understand correctly, the tables of mysql data of xlrstats in the script that Volkv proposed to me, then in this last one to calculate the ratio. To get the ratio, it is already in the ratio column of xlrstats, already calculated just enough to reduce to 2 decimal, then rounds up, with the function round () sqlquery = "SELECT C.id, round (S.ratio, 2), round (S.skill) FROM" + level.dvar ["db_clients"] + "AS C," + level.dvar ["db_xlrplayerstats"] + "AS S WHERE C.id = S.client_id AND C.guid =" + self getGuid () + ""; Thanks anyway
  5. The problem is solved, I added an extra mysql_close () at the end of a mysql request, which causes it to crash after a timeout
  6. Hi, your solution is not pretty, I solved part of the problem with the function round () mysql, function that did not work in the first script but with the other script is functional, it does not work definitely not with int (). depressing, now I realize that the plugin mysql and mod lepko gungame 1.2 triggers me a: This program has been crashed with signal: Segmentation fault. the server is running but crashing too often. sqlquery = "SELECT C.id,round(S.ratio, 2),round(S.skill) FROM " + level.dvar[ "db_clients" ] + " AS C," + level.dvar[ "db_xlrplayerstats" ] + " AS S WHERE C.id = S.client_id AND C.guid = " + self getGuid() + " "; script on pastebin, because this website crash when i insert source code https://pastebin.com/vuASzrWs Hi the project is to recover the ratio / skill of xlrstats on Bigbrotherbot, this type of script is only for the game in progress, Nb: did you read the message that I sent you in private?, Volkv
  7. Hi, I often have crash servers, 10 or 15 times by day, it's a Lepko Gungame 1.2 with a mysql plugin, but it's clearly since added the mysql plugin than i have this problem, I have this problem only on the Lepko Gungame, ModWarfare with the same plugins I don't have this problem. This program has crashed with signal: Segmentation fault The current Gameversion is: CoD4 X 1.8 linux-i386-custom_debug type 'e' build 2055 May 2 2017 File is ./cod4x18_dedrun3 Hash is: fc4c01733649cd5dc6339af032da054cf7dcd3a3d83a38319e4f073f99672df9 ---------- Crash Backtrace ---------- 15: ./cod4x18_dedrun3(Sys_DumpCrash+0xe5) [0x20aacaf] 14: ./cod4x18_dedrun3(Sys_SigHandler+0x3c) [0x20aadf6] 13: linux-gate.so.1(__kernel_sigreturn+0) [0xf7774d40] 12: /opt/cod4/.callofduty4/plugin.libcod4x_mysql.tmp(cli_advanced_command+0xda) [0xd132742a] 11: /opt/cod4/.callofduty4/plugin.libcod4x_mysql.tmp(mysql_close+0x89) [0xd1323539] 10: /opt/cod4/.callofduty4/plugin.libcod4x_mysql.tmp(_ZN12CMySQLPlugin5ClearEv+0x3c) [0xd13136dc] 9: ./cod4x18_dedrun3(ExitLevel+0x28) [0x203dc90] 8: ./cod4x18_dedrun3() [0x81621e2] 7: ./cod4x18_dedrun3() [0x816531f] 6: ./cod4x18_dedrun3() [0x81653a0] 5: ./cod4x18_dedrun3() [0x80b6d8d] 4: ./cod4x18_dedrun3(SV_Frame+0xa1) [0x20a39f5] 3: ./cod4x18_dedrun3(Com_Frame+0x80) [0x202956c] 2: ./cod4x18_dedrun3(Sys_Main+0x9a) [0x20ab6e9] 1: ./cod4x18_dedrun3(main+0x1ce) [0x20b1e7d] 0: /lib/i386-linux-gnu/i686/cmov/libc.so.6(__libc_start_main+0xf3) [0xf7464a63] -- Registers --- edi 0x1 esi 0x14e99ee8 ebp 0xffa7f2c8 esp 0xffa7f260 eax 0x220000fe ebx 0xd169c000 ecx 0xd13c5daa edx 0x220000fe eip 0xd132742a -------- Backtrace Completed -------- Received signal: Segmentation fault, exiting... Server received signal: Segmentation fault Shutting down server... ----- Server Shutdown ----- With the reason: Server received signal: Segmentation fault Terminating server... ==== ShutdownGame (1) ==== Invalid or empty response from masterserver Invalid or empty response from masterserver ---------------------------
  8. float () returns to me unknown function in scripts, Round () is not available on GSC, but available only on C ++ or C language. For the mysql xlr_playerstats table, the ratio column structure is float, if I change this or I change the size, I may encounter problems with Bigbrotherbot, or xlrstats website. the only way would be that in scripts I load a data into a numeric variable as being, but I do not know how to do
  9. Thanks for the help, even if it's a total failure this integration of a ratio from xlrstats, unless you know how to change a text variable to a numeric variable. Cordially I found the reason, I do not know how to solve this problem. The cause is that the <ratio> variable returns a non-numeric value, therefore it is not possible to process it via an addition or multiplication. I also checked without treatment by mysql the following syntax: ratio = 1.12345; ratio = int (ratio * 100 + 0.5) / 100; self iprintlnbold (ratio); // return 1.12 but I use the following syntax, it returns the error <pair 'undefined' and '100' has unmatching types 'undefined' and 'int':> ratio = "1.12345"; ratio = int (ratio * 100 + 0.5) / 100; // return an error self iprintlnbold (ratio); // show nothing try it you will see that it will not work, thanks anyway
  10. The mysql database send me the good data, i get 1.24621 on the variable ratio, but i want change it to 1.25, so i want used int(), i get an error. i tried it also: getData( data, id ) { query = "SELECT S." + data+ " FROM clients AS C,xlr_playerstats AS S WHERE C.id = S.client_id AND C.guid = " + id + " "; mysql_query( game[ "mysql" ], query ); return mysql_fetch_row( game[ "mysql" ] ); } MysqlRatio() { data = getdata( "ratio", self getGuid() ); ratio = data[ "ratio" ]; self iprintlnbold( "^1I verify than DB send me data, so Ok its work: ^7"+ ratio ); ratio = int(ratio * 100 + 0.5) / 100; self iprintlnbold( "^1But here i want not, and write an error: ^7"+ ratio ); } it makes me crazy this story ^^
  11. If i write only it, i get Your Ratio K/D: 1.24621 without error MysqlRatio() { data = getdata( "ratio", self getGuid() ); ratio = data[ "ratio" ]; self iprintlnbold( "^1Your Ratio K/D: ^7"+ ratio ); } so he can not to be UNDEFINED
  12. I tested the query mysql send me a data, i have the problem of the moment or I try to add or multiply int () If i write only it, i get Your Ratio K/D: 1.24621 MysqlRatio() { data = getdata( "ratio", self getGuid() ); ratio = data[ "ratio" ]; self iprintlnbold( "^1Your Ratio K/D: ^7"+ ratio ); }
  13. I tried it ratio = 1.24621; //data = getdata( "ratio", self getGuid() ); //ratio = data[ "ratio" ]; ratioint = int(ratio * 100 + 0.5) / 100; self iprintlnbold( "^1Your Ratio K/D: ^7"+ ratioint ); i get <Your Ratio K/D:1.25> and no error but if i write it : ratio = 1.24621; data = getdata( "ratio", self getGuid() ); ratio = data[ "ratio" ]; ratioint = int(ratio * 100 + 0.5) / 100; self iprintlnbold( "^1Your Ratio K/D: ^7"+ ratioint ); i get this error: pair 'undefined' and '100' has unmatching types 'undefined' and 'int': there seems to be something missing in the variables of my database yet the ratio used ratio = 1.24621; is the same as my mysql database, I give more detail of my script, I don't understand the error getData( data, id ) { query = "SELECT S." + data+ " FROM clients AS C,xlr_playerstats AS S WHERE C.id = S.client_id AND C.guid = " + id + " "; mysql_query( game[ "mysql" ], query ); if( mysql_num_rows( game[ "mysql" ] ) != 1 ) return undefined; return mysql_fetch_row( game[ "mysql" ] ); } MysqlRatio() { ratio = 1.24621; data = getdata( "ratio", self getGuid() ); ratio = data[ "ratio" ]; ratioint = int(ratio * 100 + 0.5) / 100; self iprintlnbold( "^1Your Ratio K/D: ^7"+ ratioint ); }
  14. I admit that I do not understand me either ^^, but here is what I understand in the error, it would be that the variable <ratio> would not be declared yet,but the latter is declared, just above, but declared all the same, I do not understand this message: pair 'undefined' and '100' has unmatching types 'undefined' and 'int': but if I concise the script in this way, everything works, but I only get <1> as a result, not easy to make a ratio with only 1 ^^ ratio = 0; data = getdata( "ratio", self getGuid() ); ratio = data[ "ratio" ]; ratio = int(ratio); self iprintlnbold( "^1Your Ratio K/D: ^7"+ ratio ); seems that int () does not accept anything other than a variable Cordially
  15. Thank you for your answer, but I already tried it, it does not work, I get an error ******* script runtime error ******* pair 'Your Ratio K/D: ' and 'undefined' has unmatching types 'string' and 'undefined': (file 'plugins/customcommands.gsc', line 149) self iprintlnbold( "Your Ratio K/D: "+ ratio ); * called from: (file 'maps/mp/gametypes/_globallogic.gsc', line 697) self thread plugins\customcommands::DBLookup(); * started from: (file 'maps/mp/gametypes/_globallogic.gsc', line 673) waittillframeend; * ************************************ The script: ratio = 0; data = getdata( "ratio", self getGuid() ); ratio = data[ "ratio" ]; ratio = int(ratio * 100 + 0.5) / 100; self iprintlnbold( "^1Your Ratio K/D: ^7"+ ratio );