[EviLpRo]

hello people.

i have a small problem, with mysql selection..

this my code (ban system), in OnPlayerConnect:

pawn Код:

new result[128];
    format(result,128,"SELECT * FROM `Bans` WHERE `Username`='%s' OR `IP`='%s'",GetName(playerid),GetIP(playerid));
    mysql_query(result);
    mysql_store_result();
    if(mysql_num_rows())
    {
        mysql_store_result();
        while(mysql_retrieve_row())
        {
            new baninfo[8][40];
            mysql_get_field("Username", baninfo[0]);
            mysql_get_field("Adminname",baninfo[1]);
            mysql_get_field("Reason",baninfo[2]);
            mysql_get_field("Date",baninfo[3]);
            mysql_get_field("Time",baninfo[4]);
            mysql_get_field("IP",baninfo[5]);
            mysql_get_field("Type",baninfo[6]);
            mysql_get_field("Days",baninfo[7]);
        }
        if((strval(baninfo[6]) == 1 && strval(baninfo[7]) > 0) || (strval(baninfo[6]) == 0))
        {
            SendClientMessage(playerid,c_red,"You are banned from this server.");
            format(String,256,"Ban Info: {0066ff}Admin: {ffffff}%s {ff9900}• {0066ff}UserName: {ffffff}%s {ff9900}• {0066ff}Reason: {ffffff}%s",baninfo[1],baninfo[0],baninfo[2]);
            SendClientMessage(playerid,c_white,String);
            if(strval(baninfo[6]) == 0) format(String,256,"Ban Info: {0066ff}Date: {ffffff}%s {ff9900}• {0066ff}At: {ffffff}%s {ff9900}• {0066ff}End ban: {ffffff}%s",baninfo[3],baninfo[4],"Never");
            if(strval(baninfo[6]) == 1) format(String,256,"Ban Info: {0066ff}Date: {ffffff}%s {ff9900}• {0066ff}At: {ffffff}%s {ff9900}• {0066ff}End ban: {ffffff}%i Days",baninfo[3],baninfo[4],strval(baninfo[7]));
            SendClientMessage(playerid,c_white,String);
            SendClientMessage(playerid,c_green,"ан дйрк зещб щбап жд айре оецгч, аъд оежоп мтштш тмйе");
            SendClientMessage(playerid,c_green,"suport.GTAZONE.co.il -бфешен дъойлд щм дчдймд щмре, блъебъ");
            return Kick(playerid);
        }
        else
        {
            format(String,128,"DELETE FROM `Bans` WHERE `Username`='%s' OR `IP`='%s'",GetName(playerid),GetIP(playerid));
            mysql_query(String);
            SendClientMessage(playerid,c_red,".дбап щмк йшг, лрс озгщ");
            return Kick(playerid);
        }
    }
    mysql_free_result();

this code is very slowly.
and restart the server to the ban player.

how i can to select the ban information quickly ?

thank's a lot for helpers

[EviLpRo]

bump

[EviLpRo]

I got along, you can lock