MySQL ban - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL ban (/showthread.php?tid=378772)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL ban (/showthread.php?tid=378772)
MySQL ban - Kitten - 19.09.2012
Fixed!
Re: MySQL ban - Emmet_ - 19.09.2012
You cannot use the WHERE clause in an INSERT statement.
Either use this:
pawn Код:
format(mysqlquery,sizeof(mysqlquery),"INSERT INTO `Users` (`pBanned`,`pBannedReason`,`pBannedBy`) VALUES ('%s','%s','%s')",bvar,reason,PlayerName(playerid));
mysql_query(mysqlquery);