MySQL Syntax - 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 Syntax (/showthread.php?tid=375073)
+- 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 Syntax (/showthread.php?tid=375073)
MySQL Syntax - Kitten - 05.09.2012
Fixed.
Re: MySQL Syntax - mkr - 05.09.2012
You're not concatenating those three segments into one query, so at the end of this query is just that third chunk. This is your query:
Код:
pClassFourName,pClassFiveName ,pBanned,pBannedReason,pBannedBy) VALUES('PrivateName', SHA1('privatepassword'), '0','0','0','0','0','0','0','0','0','71.199.3.75', '0','0','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0','0','0','Custom Class 1','Custom Class 2','Custom Class 3','Custom Class 4','Custom Class 5','0','None','None')
Respuesta: MySQL Syntax - Siralos - 05.09.2012
Yo should do, in each of them:
format(query, sizeof(query), "%s[rest of query]", query, [rest of vars])
Re: MySQL Syntax - Kitten - 05.09.2012
Solved