[DerickClark]

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, "", "");

[Jefff]

Remove , before WHERE

[DerickClark]

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, "", "");

[Jefff]

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

[ikey07]

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

[DerickClark]

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]);