[Guyl]

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;
        } 


Crash detect (when my internet server crash):
http://pastebin.com/eFTYBjXW

My log (when my local server crash) :
http://pastebin.com/7kUfFYFp

[park4bmx]

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)

[Guyl]

It's strange cause on other server there is the same system i think

[eesh]

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

[Guyl]

All VehicleList are same.

http://pastebin.com/DfHiFUPh

[eesh]

can you post this function? MuMu_MySQL_GetInt

[Guyl]

This function work, i'm sure

[Guyl]

when i flood this :

http://pastebin.com/fdWkVZiv

the bug come too

[Guyl]

I have upload my float.inc,
new crashdetect :
http://pastebin.com/Wb0JZ9Wq