[gurmani11]

PHP код:

enum PlayerData
{
    ID,
    Name[MAX_PLAYER_NAME],
    bool:pSpawned, // Will check if player is spawned then true if not then false
    Password[129],
    IP[16],
    Admin,
    Tester,
    Money,
    Float:posX,
    Float:posY,
    Float:posZ,
    Float:posA
};
new Player[MAX_PLAYERS][PlayerData]; 


PHP код:

public OnPlayerSpawn(playerid)
{
    if(Player[playerid][pSpawned]== false) // Checking if he was spawned already
    {
        SetPlayerPos(playerid,Player[playerid][posX],Player[playerid][posY],Player[playerid][posZ]);
        SetPlayerFacingAngle(playerid, Player[playerid][posA]);
        Player[playerid][pSpawned]= true; // true so he wont respawn on the same position after each death
    }
    return 1;
} 


PHP код:

public OnPlayerConnect(playerid)
{
    Player[playerid][pSpawned]= false; // False to reset player's variable before he logs in to mysql
    return 1;
} 


PHP код:

public OnPlayerDisconnect(playerid, reason)
{
    new query[128], Float:pos[4];
    GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
    GetPlayerFacingAngle(playerid, pos[3]);
    mysql_format(1, query, sizeof(query), "UPDATE `accounts` SET `Money` = %d, `PosX` = %f, `PosY` = %f, `PosZ` = %f, `PosA` = %f WHERE `ID` = %d",
    GetPlayerMoney(playerid), pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]);
    mysql_tquery(1, query, "", "");
    Player[playerid][pSpawned]= false; // False to reset player's variable before he disconnects
    return 1;
} 


PHP код:

forward OnAccountLoad(playerid);
public OnAccountLoad(playerid)
{
    Player[playerid][Admin] = cache_get_field_content_int(0, "Admin");
    Player[playerid][VIP] = cache_get_field_content_int(0, "Tester");
    Player[playerid][Money] = cache_get_field_content_int(0, "Money");
    Player[playerid][posX] = cache_get_field_content_float(0, "PosX");
    Player[playerid][posY] = cache_get_field_content_float(0, "PosY");
    Player[playerid][posZ] = cache_get_field_content_float(0, "PosZ");
    Player[playerid][posA] = cache_get_field_content_float(0, "PosA");
    TogglePlayerSpectating(playerid, false);
    GivePlayerMoney(playerid, Player[playerid][Money]);
    SetSpawnInfo(playerid, 0, 23, Player[playerid][posX], Player[playerid][posY], Player[playerid][posZ], Player[playerid][posA], 0, 0, 0, 0, 0, 0);
    SpawnPlayer(playerid);
    SendClientMessage(playerid, -1, "Te-ai logat cu succes !");
    return 1;
}