It doesn't save stats
#1

Hello, I have a problem, when the player disconnects, it doesn't save his stats, but it loads, I mean, I can edit stats only at the phpMyAdmin website, but if I edit in-game they won't be saved when the player disconnecets, here's my script:

Код:
public OnPlayerDisconnect(playerid, reason)
{
	if(pInfo[playerid][LoggedIn] == 1)
	{
	    new
	        query[160];
	    mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET `Money` = '%d', `Admin` = '%d', `VIP` = '%d', `playerXP` = '%d', `Job` = '%d', `BankMoney` = '%d', `playerWL` = '%d', `JailTime` = '%d', `AdminJailed` = '%d', `Cuffed` = '%d', `Tazed` = '%d' WHERE `ID` = '%d'",
	    pInfo[playerid][Money], pInfo[playerid][Admin], pInfo[playerid][VIP], pInfo[playerid][XP], pInfo[playerid][Job], pInfo[playerid][BankMoney], pInfo[playerid][PlayerWL], pInfo[playerid][JailTime], pInfo[playerid][AdminJailed], pInfo[playerid][Cuffed], pInfo[playerid][IsTazed], pInfo[playerid][ID]);
	    mysql_tquery(mysql, query, "", "");
	    return true;
	}
	SendDeathMessage(INVALID_PLAYER_ID, playerid, 201);
	return 1;
}
Reply
#2

BUMP!
Reply
#3

The length of the query is too short.
PHP код:
new query[300]; 
That is very better.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)