SA-MP Forums Archive
MySQL not saving. - 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 not saving. (/showthread.php?tid=337352)



MySQL not saving. - Kitten - 25.04.2012

Solved


Re: MySQL not saving. - Roel - 25.04.2012

Well did you already checked to variables? Like if they are correctly cased, do they even exist in your database, things like that because I cannot see the mistake in this code. So I think something wen't wrong at the structur of your database.


Re: MySQL not saving. - Kitten - 25.04.2012

http://i48.tinypic.com/juedmp.png

Not really maybe the code for registering?

pawn Код:
Fixed



Re: MySQL not saving. - Kar - 25.04.2012

pawn Код:
new EscapedText[164];
 format(Query, sizeof(Query), "INSERT INTO `zmplayer` (`Username`, `password`, `Points`, `Kills`, `Deaths`, `mapsplayed`) VALUES ('%s', '%s', 0, 0, 0, 0)",pname(playerid),EscapedText);
 mysql_query(Query);
String length was too short and you mised a '