[Tanush123]

I made a position saving, onplayerdis

pawn Code:

if(Logged[playerid] == 1)
    {
        GetPlayerName(playerid,pname,sizeof(pname));
        GetPlayerPos(playerid,PlayerData[playerid][PosX],PlayerData[playerid][PosY],PlayerData[playerid][PosZ]);
        format(query,sizeof(query),"UPDATE accounts SET Adminlevel = %d,Cash = %d,Vip = %d,Member = %d,Leader = %d,Isinorg = %d,Islaw = %d,Isgang = %d,Ispriv = %d,Wantedlevel = %d,Minutesplayed = %d,Hoursplayed = %d,Level = %d,Cig = %d,Sprunk = %d,Snack = %d,Lighter = %d,Fightingstyle = %d,Passport = %d,Bag = %d,Gunlicense = %d,Job = %d,Pot = %d,Crack = %d,Bank = %d,Bankaccount = %d,Carlicense = %d,Fuelcan = %d,Civilskin = %d,Minutestonextlevel = %d,simcard = %d,phone = %d",
        PlayerData[playerid][AdminLevel],GetPlayerMoney(playerid),PlayerData[playerid][vip],PlayerData[playerid][Member],PlayerData[playerid][Leader],PlayerData[playerid][IsInOrg],PlayerData[playerid][IsLaw],PlayerData[playerid][IsGang],PlayerData[playerid][IsPriv],PlayerData[playerid][WantedLevel],PlayerData[playerid][MinutesPlayed],PlayerData[playerid][HoursPlayed],GetPlayerScore(playerid),PlayerData[playerid][Cig],PlayerData[playerid][Sprunk],PlayerData[playerid][Snack],PlayerData[playerid][Lighter],
        PlayerData[playerid][FightingStyle],PlayerData[playerid][Passport],PlayerData[playerid][Bag],PlayerData[playerid][GunLicense],PlayerData[playerid][Job],PlayerData[playerid][Pot],PlayerData[playerid][Crack],PlayerData[playerid][Bank],PlayerData[playerid][BankAccount],PlayerData[playerid][CarLicense],PlayerData[playerid][Fuelcan],PlayerData[playerid][Civilskin],PlayerData[playerid][MinutesToNextLevel],PlayerData[playerid][simcard],PlayerData[playerid][phone],pname);
        mysql_query(query);
        format(query,sizeof(query),"UPDATE accounts SET phonebook = %d,PosX = %f,PosY = %f,PosZ = %f WHERE Name = '%s'",
        PlayerData[playerid][phonebook],PlayerData[playerid][PosX],PlayerData[playerid][PosY],PlayerData[playerid][PosZ],pname);
        mysql_query(query);
    }

On player spawn

pawn Code:

if(PlayerData[playerid][PosX] == 0.0 && PlayerData[playerid][PosY] == 0.0)
    {
        SetPlayerPos(playerid,2418.8110,1122.8837,10.8203);
        SendClientMessage(playerid,orange,"Go inside that building and buy some things!");
        SetPlayerFacingAngle(playerid,79.7240);
        SetCameraBehindPlayer(playerid);
    }
    else return SetPlayerPos(playerid,PlayerData[playerid][PosX],PlayerData[playerid][PosY],PlayerData[playerid][PosZ]);

Public save(i use this to make the files save every second)

pawn Code:

public Save(playerid)
{
    if(Logged[playerid] == 1)
    {
        GetPlayerName(playerid,pname,sizeof(pname));
        GetPlayerPos(playerid,PlayerData[playerid][PosX],PlayerData[playerid][PosY],PlayerData[playerid][PosZ]);
        format(query,sizeof(query),"UPDATE accounts SET Adminlevel = %d,Cash = %d,Vip = %d,Member = %d,Leader = %d,Isinorg = %d,Islaw = %d,Isgang = %d,Ispriv = %d,Wantedlevel = %d,Minutesplayed = %d,Hoursplayed = %d,Level = %d,Cig = %d,Sprunk = %d,Snack = %d,Lighter = %d,Fightingstyle = %d,Passport = %d,Bag = %d,Gunlicense = %d,Job = %d,Pot = %d,Crack = %d,Bank = %d,Bankaccount = %d,Carlicense = %d,Fuelcan = %d,Civilskin = %d,Minutestonextlevel = %d,simcard = %d,phone = %d",
        PlayerData[playerid][AdminLevel],GetPlayerMoney(playerid),PlayerData[playerid][vip],PlayerData[playerid][Member],PlayerData[playerid][Leader],PlayerData[playerid][IsInOrg],PlayerData[playerid][IsLaw],PlayerData[playerid][IsGang],PlayerData[playerid][IsPriv],PlayerData[playerid][WantedLevel],PlayerData[playerid][MinutesPlayed],PlayerData[playerid][HoursPlayed],GetPlayerScore(playerid),PlayerData[playerid][Cig],PlayerData[playerid][Sprunk],PlayerData[playerid][Snack],PlayerData[playerid][Lighter],
        PlayerData[playerid][FightingStyle],PlayerData[playerid][Passport],PlayerData[playerid][Bag],PlayerData[playerid][GunLicense],PlayerData[playerid][Job],PlayerData[playerid][Pot],PlayerData[playerid][Crack],PlayerData[playerid][Bank],PlayerData[playerid][BankAccount],PlayerData[playerid][CarLicense],PlayerData[playerid][Fuelcan],PlayerData[playerid][Civilskin],PlayerData[playerid][MinutesToNextLevel],PlayerData[playerid][simcard],PlayerData[playerid][phone],pname);
        mysql_query(query);
        format(query,sizeof(query),"UPDATE accounts SET phonebook = %d,PosX = %f,PosY = %f,PosZ = %f WHERE Name = '%s'",
        PlayerData[playerid][phonebook],PlayerData[playerid][PosX],PlayerData[playerid][PosY],PlayerData[playerid][PosZ],pname);
        mysql_query(query);
    }
}

Well when i move in game and thencheck my database, it position saves but when i disconnect it goes to 0!

[CyNiC]

Check if the variable 'Logged' dont's reseted before that save the data.

[Tanush123]

i only got logged[playerid] 0; if player connects

[=WoR=Varth]

Why you save them in OnPlayerDisconnect if you already do every second?