[homelessdrop]

Hi guys, i need a help with my saveplayerpos function. This save player last position when he disconnect from the server, and load when he connect, but the problem is, when the player connect. The script save the pos, but when is this loading from the sql, place the player away/underworld how the player disconnect. Maybe is the problem elsewhere but idk where.
(sorry for my bad english)

Код:

public OnPlayerDisconnect(playerid, reason)
{
    SavePlayerPos(playerid);
    return 1;
}

Код:

public LoadPlayer(playerid)
{
	new stringg[128];
    cache_get_value_name_int(0, "pAdmin", PlayerInfo[playerid][pAdmin]);
    cache_get_value_name_float(0, "posX", PlayerInfo[playerid][LastPosX]);
    cache_get_value_name_float(0, "posY", PlayerInfo[playerid][LastPosY]);
    cache_get_value_name_float(0, "posZ", PlayerInfo[playerid][LastPosZ]);
    cache_get_value_name_int(0, "LastInterior", PlayerInfo[playerid][LastInterior]);
    cache_get_value_name_int(0, "LastWorld", PlayerInfo[playerid][LastWorld]);
	format(stringg, sizeof(stringg), "{D0BF53}successful login{ffffff}( {D0BF53}%s {FFFFFF}).", GetName(playerid));
 	SCM(playerid, -1, stringg);
    
    LoggedIn[playerid] = 1;
    SpawnPlayer(playerid);

Код:

public SavePlayerPos(playerid)
{
    new query[140];
    GetPlayerPos(playerid, PlayerInfo[playerid][LastPosX], PlayerInfo[playerid][LastPosY], PlayerInfo[playerid][LastPosZ]);
    mysql_format(db, query, sizeof(query), "UPDATE `accounts` SET `posX`=%f, `posY`=%f, `posZ`=%f, `LastInterior`=%i, `LastWorld`=%i WHERE `pID` = '%d'",\
	PlayerInfo[playerid][LastPosX],
	PlayerInfo[playerid][LastPosY],
	PlayerInfo[playerid][LastPosZ],
	GetPlayerInterior(playerid),
	GetPlayerVirtualWorld(playerid),
	PlayerInfo[playerid][pID]);
    mysql_tquery(db, query);
    return 1;
}

[Calisthenics]

Set player virtual world.
Set player interior.
Call SetSpawnInfo function with PlayerInfo[playerid][LastPosX], PlayerInfo[playerid][LastPosY], PlayerInfo[playerid][LastPosZ] as X, Y, Z parameters.
Call SpawnPlayer function.