[Ciarannn]

Quote:

Originally Posted by Konstantinos Are you sure that you do not reset the variables in OnPlayerDisconnect and then trying to save? It has to be vice versa.

OnPlayerDisconnect:

Код:

new query[512];
mysql_format(mysql, query, sizeof(query), "SELECT * FROM `users` WHERE `Username` = '%e' LIMIT 1", RPNU(playerid));
mysql_tquery(mysql, query, "SaveCharacter", "i", playerid);

SaveCharacter:

Код:

forward SaveCharacter(playerid);
public SaveCharacter(playerid)
{
	//Load
	PlayerInfo[playerid][pInt] = GetPlayerInterior(playerid);
	PlayerInfo[playerid][pVW] = GetPlayerVirtualWorld(playerid);
	GetPlayerPos(playerid, PlayerInfo[playerid][pX], PlayerInfo[playerid][pY], PlayerInfo[playerid][pZ]);
	//Save
	new query[518];
	mysql_format(mysql, query, sizeof(query), "UPDATE `users` SET Admin=%d, Money=%d, posX=%f, posY=%f, posZ=%f WHERE ID=%d", PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pX], PlayerInfo[playerid][pY], PlayerInfo[playerid][pZ], PlayerInfo[playerid][ID]);
        mysql_tquery(mysql, query);
        printf(query);
}