Spawn save!

[Pinki950]

Cum as putea face ca atunci cand un player sa deconectat de pe server sa i se salveze pozitia x, y, z, iar cand se va conecta sa il spawneze in locatia salvata?

[Ph0eniX]

new PQuery[300], Float:X, Float:Y, Float:Z;
GetPlayerPos(playerid,x,y,z);
format(PQuery, sizeof(PQuery), "UPDATE `accounts` SET `posx` = '%.2f', `posy` = '%.2f', `posz` = '%.2f' WHERE `playername` = '%s'", X, Y, Z, GetPlayerName(playerid));
db_query( Database, PQuery );

daca folosesti dini , faci ceva de genu' doar ca pt dini ) nu ma prea pricep la dini srry

[Pinki950]

Topic Solved!

[pawn]#define FILTERSCRIPT

#include <a_samp>

#include <Dini>

#include <dudb>

new Float:positionx;

new Float:positiony;

new Float:positionz;

#if defined FILTERSCRIPT

public OnFilterScriptInit()

{

        print("\n--------------------------------------");

        print(" De la Alexica721 pt voi                  ");

        print("--------------------------------------\n");

        return 1;

}

public OnPlayerConnect(playerid)

{

        LoadStats(playerid);

        return 1;

}

public OnPlayerDisconnect(playerid, reason)

{

        new Float:x;

        new Float:y;

        new Float:z;

        GetPlayerPos(playerid,x,y,z);

        positionx = x;

        positiony = y;

        positionz = z;

        if (!dini_Exists(Pos(playerid)))

        {

                dini_Create(Pos(playerid));

        }

        SaveStats(playerid);

        return 1;

}

public OnPlayerSpawn(playerid)

{

        if (!dini_Exists(Pos(playerid))) {

        SetPlayerPos(playerid, 1676.8462, 1447.7908, 10.7833);

        }

        else

        {

        SetPlayerPos(playerid, positionx,positiony,positionz);

        }

        return 1;

}

Player(playerid)

{

new player[MAX_PLAYER_NAME];

GetPlayerName(playerid, player, sizeof(player));

return player;

}

Pos(playerid)

{

  new a[256]; format(a, sizeof(a), "%s.ini",udb_encode(Player(playerid)));

  return a;

}

SaveStats(playerid)

{

  dini_IntSet(Pos(playerid), "PositionX", floatround(positionx));

  dini_IntSet(Pos(playerid), "PositionY", floatround(positiony));

  dini_IntSet(Pos(playerid), "PositionZ", floatround(positionz));

}

LoadStats(playerid)

{

  positionx = dini_Int(Pos(playerid), "PositionX");

  positiony = dini_Int(Pos(playerid), "PositionY");

  positionz = dini_Int(Pos(playerid), "PositionZ");

}

public OnFilterScriptExit()

{

        return 1;

}

#else

main()

{

        print("\n----------------------------------");

        print(" Nimic de spus");

        print("----------------------------------\n");

}

#endif[/pawn]