OnPlayerDisconnect
#1

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

Remove , before WHERE
Reply
#3

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

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

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

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


Forum Jump:


Users browsing this thread: 1 Guest(s)