MySQL ban system, not working.
#4

Add mysql_store_result and mysql_free_result

pawn Код:
format(query, 1024, "SELECT `Banned` FROM `users` WHERE `Nick` = '%s' OR `Ip` = '%s'", GetName(playerid), GetIPAddress(playerid));
    mysql_query(query);
    mysql_store_result();

    if(mysql_num_rows() > 0)
    {
        SendClientMessage(playerid, red, " • ~ _ ~ SAMP-IL Stunts ~ _ ~ •");
        SendClientMessage(playerid, yellow, "You are banned from this server.");

        mysql_free_result();
        format(query, 1024, "SELECT `BannedBy` FROM `users` WHERE `Nick` = '%s'", GetName(playerid));
        mysql_query(query);
        mysql_store_result();
        new string2[256], string3[256];
        new buffer[60];
        mysql_fetch_field_row(buffer,  "BannedBy");
        format(string3,256,"%s",buffer);
        new buffer2[60];
        mysql_fetch_field_row(buffer2,  "BannedBy");
        format(string2,256,"%s",buffer2);
        format(string, 256, "Admin Name: %s. Reason: %s", buffer, buffer2);
        SendClientMessage(playerid, red, string);
        SendClientMessage(playerid, red, " • ~ _ ~ SAMP-IL Stunts ~ _ ~ •");
        Kick(playerid);
        mysql_free_result();
    }
Reply


Messages In This Thread
MySQL ban system, not working. - by ben4uka - 21.07.2011, 22:05
Re: MySQL ban system, not working. - by MadeMan - 21.07.2011, 22:07
Re: MySQL ban system, not working. - by ben4uka - 21.07.2011, 22:10
Re: MySQL ban system, not working. - by MadeMan - 21.07.2011, 22:15
Re: MySQL ban system, not working. - by ben4uka - 21.07.2011, 22:43
Re: MySQL ban system, not working. - by MadeMan - 22.07.2011, 09:17
Re: MySQL ban system, not working. - by ben4uka - 22.07.2011, 11:58

Forum Jump:


Users browsing this thread: 4 Guest(s)