[MySQL] Problem Saving accounts

[MySQL] Problem Saving accounts - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: [MySQL] Problem Saving accounts (/showthread.php?tid=249122)

[MySQL] Problem Saving accounts - HellviRus - 17.04.2011

Hi all,
I am creating a Sql GameMode
But i have a problem in saving account informations ... i've created the tables and everythink ... ( Finally, I think so )
Here is a line of saving an information :

Код:

mysql_query("UPDATE `nlrp` SET pLevel=%d WHERE Name =%s", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][Name]);

Thanks A Lot !

Re: [MySQL] Problem Saving accounts - playbox12 - 17.04.2011

You have to format it, like this.

pawn Код:

new Query[80];
    format(Query, sizeof(Query), "UPDATE `nlrp` SET `pLevel` = %d WHERE `Name` = '%s'", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][Name]);
    mysql_query(Query);

Re : [MySQL] Problem Saving accounts - HellviRus - 17.04.2011

I'll try that thanks ...