MySQL isnt saving - Printable Version

MySQL isnt 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL isnt saving (/showthread.php?tid=177885)

Fixed. - Tekto - 19.09.2010

Fixed. YES

Re: MySQL isnt saving - Tekto - 19.09.2010

BUMP PLEASE.

Re: MySQL isnt saving - Relixious - 19.09.2010

Quote:

"UPDATE users SET Password='%s',Admin='%d',Money='%d' WHERE Name='%s',Kills='%d',Deaths='%d',Score='%d'"

That's not the right query, it has to end with ''WHERE''.

Try this:

Quote:

"UPDATE users SET Password='%s',Admin='%d',Money='%d',Kills='%d',Dea ths='%d',Score='%d' WHERE Name='%s'"

Re: MySQL isnt saving - Vince - 19.09.2010

Print the query, and check for any mistakes you may have made.

Sidenote:

pawn Код:

PlayerInfo[killerid][pScore] = PlayerInfo[killerid][pScore]+2;
PlayerInfo[playerid][pScore] = PlayerInfo[playerid][pScore]-2;

// Can be written like:

PlayerInfo[killerid][pScore] += 2;
PlayerInfo[playerid][pScore] -= 2;