[Ayuda] Como guardar posicion al desloguear (MySQL)
#8

pawn Код:
enum sInfo
{
    Float:x,
    Float:y,
    Float:z,
    EsMuerte
};
new SpawnInfo[MAX_PLAYERS][sInfo]; // Esto arriba de todo.

//Y de acб para abajo remplazб:
stock MySQL_Login(playerid)
{
    new query[300], pname[24], savingstring[20];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT * FROM playerdata WHERE user = '%s'", pname);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
        mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "pos_x"); SpawnInfo[playerid][x] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "pos_y"); SpawnInfo[playerid][y] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "pos_z"); SpawnInfo[playerid][z] = strval(savingstring);
    }
}

public OnPlayerSpawn(playerid)
{
    if(SpawnInfo[playerid][EsMuerte]) SetPlayerPos(playerid, SpawnInfo[playerid][x], SpawnInfo[playerid][y], SpawnInfo[playerid][z]);
    return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
    if(SpawnInfo[playerid][EsMuerte] != 0)
    {
        SpawnInfo[playerid][EsMuerte] = 1;
    }
    return 1;
}
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)