SQL don't update - Printable Version

SQL don't update - 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: SQL don't update (/showthread.php?tid=287149)

SQL don't update - Ricop522 - 02.10.2011

http://pastebin.com/sB9uNqkY

I don't know, the user don't update..

THANKS FOR THE HELP +REP

Re: SQL don't update - Haydz - 02.10.2011

In your query line you have a , on your last piece of data, once you remove that it should be fine.

pawn Код:

format(sQuery, sizeof(sQuery), "UPDATE `playerinfo` SET `matou` = %d, `morreu` = %d, `dinheiro` = %d, `admin` = %d, `posx` = %f, `posy` = %f, `posz` = %f, `interior` = %d, `skin` = %d, `banco` = %d, `level` = %d, tutorial = %d[HERE],[HERE] WHERE `user` = '%s'",

Remove that to get

pawn Код:

format(sQuery, sizeof(sQuery), "UPDATE `playerinfo` SET `matou` = %d, `morreu` = %d, `dinheiro` = %d, `admin` = %d, `posx` = %f, `posy` = %f, `posz` = %f, `interior` = %d, `skin` = %d, `banco` = %d, `level` = %d, tutorial = %d WHERE `user` = '%s'",

Re: SQL don't update - Ricop522 - 02.10.2011

Thanks! rep