22.08.2015, 12:17
Like this i try to save 2 string Banreason and banadmin
its not saving,....
I got this Error
[03:52:33] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' Fly hack WHERE `ID`=1' at line 1
and also how i can load that when he connect again BanAdmin string and BanReason string how i can load them?
its not saving,....
Код:
pInfo[playerid][BanReason] = reason;
pInfo[playerid][BanAdmin] = ServerBan;
new query[128];
mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `Ban`=%d ,`BanAdmin`=%s ,`BanReason`=%s WHERE `ID`=%d",\
pInfo[playerid][Banned],pInfo[playerid][BanAdmin],pInfo[playerid][BanReason],pInfo[playerid][PDID]);
mysql_tquery(mysql, query );
[03:52:33] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' Fly hack WHERE `ID`=1' at line 1
and also how i can load that when he connect again BanAdmin string and BanReason string how i can load them?