Serveur Crash after flood a command - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Serveur Crash after flood a command (/showthread.php?tid=405348)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Serveur Crash after flood a command (/showthread.php?tid=405348)
Serveur Crash after flood a command - Guyl - 06.01.2013
Hi,
I have a problem, when i flood a command, my serveur bug, all the command doesn't work i have 'SERVER: Unknow command' on my local server but on my internet server, my server crash.
My command work
Command :
PHP код:
else if(strcmp(tmp,"liste",true) == 0) {
new string[500];
new pname[24];
GetPlayerName(playerid, pname, 24);
new key1 = PlayerInfo[playerid][pPcarkey];
new key2 = PlayerInfo[playerid][pPcarkey2];
new key3 = PlayerInfo[playerid][pPcarkey3];
new key4 = PlayerInfo[playerid][pPcarkey4];
new query[256], rstring[200];
if(key1 == 9999 && key2 == 9999 && key3 == 9999 && key4 == 9999)
{
SendClientMessage(playerid,COLOR_GREEN, "____________________Your vehicles(0)____________________");
SendClientMessage(playerid,COLOR_WHITE, "You don't own any vehicles!");
return 1;
}
if(key1 != 9999 && key2 == 9999 && key3 == 9999 && key4 == 9999)
{
format(query, sizeof query, "SELECT * FROM `vehicles` WHERE `id` = '%d'", key1);
mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleList1", "dd", idx,playerid);
return 1;
}
else if(key1 != 9999 && key2 != 9999 && key3 == 9999 && key4 == 9999)
{
format(query, sizeof query, "SELECT * FROM `vehicles` WHERE `id` = '%d'", key1);
mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleList1", "dd", idx,playerid);
format(query, sizeof query, "SELECT * FROM `vehicles` WHERE `id` = '%d'", key2);
mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleList2", "dd", idx,playerid);
return 1;
}
else if(key1 != 9999 && key2 != 9999 && key3 != 9999 && key4 == 9999)
{
format(query, sizeof query, "SELECT * FROM `vehicles` WHERE `id` = '%d'", key1);
mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleList1", "dd", idx,playerid);
format(query, sizeof query, "SELECT * FROM `vehicles` WHERE `id` = '%d'", key2);
mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleList2", "dd", idx,playerid);
format(query, sizeof query, "SELECT * FROM `vehicles` WHERE `id` = '%d'", key3);
mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleList3", "dd", idx,playerid);
return 1;
}
else if(key1 != 9999 && key2 != 9999 && key3 != 9999 && key4 != 9999)
{
format(query, sizeof query, "SELECT * FROM `vehicles` WHERE `id` = '%d'", key1);
mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleList1", "dd", idx,playerid);
format(query, sizeof query, "SELECT * FROM `vehicles` WHERE `id` = '%d'", key2);
mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleList2", "dd", idx,playerid);
format(query, sizeof query, "SELECT * FROM `vehicles` WHERE `id` = '%d'", key3);
mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleList3", "dd", idx,playerid);
format(query, sizeof query, "SELECT * FROM `vehicles` WHERE `id` = '%d'", key4);
mysql_function_query(MUMU_MYSQL_HANDLE, query, true, "OnVehicleList4", "dd", idx,playerid);
return 1;
}
return 1;
}
http://pastebin.com/eFTYBjXW
My log (when my local server crash) :
http://pastebin.com/7kUfFYFp
Re: Serveur Crash after flood a command - park4bmx - 06.01.2013
maybe mqsql cant load it as fast as your spamming it because of the ping between the server and the host your getting the info from.
so it has timed out or (silently crashed)
Re : Serveur Crash after flood a command - Guyl - 06.01.2013
It's strange cause on other server there is the same system i think
Re: Serveur Crash after flood a command - eesh - 06.01.2013
Post one of your OnVehicleList1 or something. I feel its something related to mysql_free_result();. We have much more ram on home systems than on internet servers so when its running out of memory on the internet one it crashes. Just a plain guess
Re : Serveur Crash after flood a command - Guyl - 06.01.2013
All VehicleList are same.
http://pastebin.com/DfHiFUPh
Re: Serveur Crash after flood a command - eesh - 06.01.2013
can you post this function? MuMu_MySQL_GetInt
Re : Serveur Crash after flood a command - Guyl - 06.01.2013
This function work, i'm sure
Re : Serveur Crash after flood a command - Guyl - 06.01.2013
when i flood this :
http://pastebin.com/fdWkVZiv
the bug come too
Re : Serveur Crash after flood a command - Guyl - 07.01.2013
I have upload my float.inc,
new crashdetect :
http://pastebin.com/Wb0JZ9Wq