Mysql Error 2013
#4

Why you don't reuse things?
Код:
public OnPlayerConnect(playerid)
{
    new query[117];
    GetPlayerIp(playerid, PlayerInfo[playerid][IPa], 16);
    mysql_format(c_handle,query, sizeof(query), "SELECT * FROM bans WHERE `pBannedIP` = '%e' OR `pBanned` = '%e'", PlayerInfo[playerid][IPa], GetPlayerNameEx(playerid));
    mysql_tquery(c_handle, query, "OnPlayerBanCheck", "i", playerid);

    mysql_format(c_handle,query, sizeof(query), "SELECT Name, Admin, Reason, unban FROM `tban` WHERE `Name` = '%e' OR `IP` = '%e'", GetPlayerNameEx(playerid),ReturnPlayerIp(playerid));
    mysql_tquery(c_handle, query, "tbancheck", "i", playerid);
Remember: Reuse things when you can and don't make string arrays very big... Use Letter Counter to count the characters, so you don't have very long strings...
And I don't see anything that can cause the connection to drop...
Reply


Messages In This Thread
Mysql Error 2013 - by verlaj - 20.08.2017, 09:52
Re: Mysql Error 2013 - by TheCman - 20.08.2017, 12:21
Re: Mysql Error 2013 - by verlaj - 21.08.2017, 15:13
Re: Mysql Error 2013 - by 10MIN - 21.08.2017, 15:31
Re: Mysql Error 2013 - by verlaj - 22.08.2017, 11:32
Re: Mysql Error 2013 - by aoky - 22.08.2017, 11:52
Re: Mysql Error 2013 - by verlaj - 22.08.2017, 12:31
Re: Mysql Error 2013 - by Misiur - 22.08.2017, 12:49

Forum Jump:


Users browsing this thread: 2 Guest(s)