SA-MP Forums Archive
It doesn't save stats - 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: It doesn't save stats (/showthread.php?tid=599863)


It doesn't save stats - E7mad - 31.01.2016

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;
}


Re: It doesn't save stats - E7mad - 31.01.2016

BUMP!

Re: It doesn't save stats - Mencent - 31.01.2016

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