SA-MP Forums Archive
OnPlayerDisconnect - 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: OnPlayerDisconnect (/showthread.php?tid=597101)


OnPlayerDisconnect - DerickClark - 26.12.2015

It's not saving when i'm leaving the server.

OnPlayerDisconnect:
Код:
   	new query[128];
        mysql_format(mysql, query, sizeof(query), "UPDATE players SET `Score`=%d, `VIP`=%d, `Money`=%d,  WHERE `ID`=%d",PlayerInfo[playerid][pScore],PlayerInfo[playerid][pVIP], PlayerInfo[playerid][ID]);
	mysql_tquery(mysql, query, "", "");


Re: OnPlayerDisconnect - Jefff - 26.12.2015

Remove , before WHERE

Re: OnPlayerDisconnect - DerickClark - 26.12.2015

Quote:
Originally Posted by Jefff
Посмотреть сообщение
Remove , before WHERE
Still not saving the score
Код:
    mysql_format(mysql, query, sizeof(query), "UPDATE players SET `Score`=%d, `VIP`=%d, `Money`=%d  WHERE `ID`=%d",PlayerInfo[playerid][pScore],PlayerInfo[playerid][pVIP], PlayerInfo[playerid][ID]);
	mysql_tquery(mysql, query, "", "");


Re: OnPlayerDisconnect - Jefff - 26.12.2015

Use print(query); and you will see whats wrong or mysql log

Re: OnPlayerDisconnect - ikey07 - 26.12.2015

in the query you have 4 params a.k.a 4x %d, while in the format part you have only score,vip and ID

Re: OnPlayerDisconnect - DerickClark - 26.12.2015

Quote:
Originally Posted by Jefff
Посмотреть сообщение
Use print(query); and you will see whats wrong or mysql log
it print out:
Код:
UPDATE players SET `Score`=0, `VIP`=0, `Money`=21  WHERE `ID`=
- fixed with
Код:
 mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `SCORE`= %i WHERE `ID` = '%d'", GetPlayerScore(playerid), PlayerInfo[playerid][ID]);