[yoran765]

Hi,

I've recently discovered a problem... If I register on my server it will save all the Data into the Database correctly. When I log in it will say that I've registered and I need to login all works fine. But then all the stats reset and everythings set to 0. It has to do with the stock but I don't know what.

PHP код:

stock LoginPlayer(playerid)
{
    new query[126], pName[MAX_PLAYER_NAME], savingstring[128];
    GetPlayerName(playerid, pName, sizeof(pName));
    format(query,sizeof(query), "SELECT * FROM 'accounts' WHERE 'name' = '%s'", pName);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query, "|"))
    {
        Player[playerid][Spawn][0] = mysql_fetch_field_row(query, "spawnx");
        Player[playerid][Spawn][1] = mysql_fetch_field_row(query, "spawny");
        Player[playerid][Spawn][2] = mysql_fetch_field_row(query, "spawnz");
        Player[playerid][Cash] = mysql_fetch_field_row(query, "cash");
        Player[playerid][Score] = mysql_fetch_field_row(query, "score");
        Player[playerid][Admin] = mysql_fetch_field_row(query, "admin");
        Player[playerid][Tutorial] = mysql_fetch_field_row(query, "tutorial");
        Player[playerid][Skin] = mysql_fetch_field_row(query, "skin");
        Player[playerid][Mute] = mysql_fetch_field_row(query, "mute");
    }
    if(Player[playerid][Spawn][0] == 0)
    {
        SetSpawnInfo(playerid, 0, Player[playerid][Skin], 1555.2797, -1019.0566, 23.9063, 120.7054, 0, 0, 0, 0, 0, 0);
    }
    else
    {
        SetSpawnInfo(playerid, 0, Player[playerid][Skin], Player[playerid][Spawn][0], Player[playerid][Spawn][1], Player[playerid][Spawn][2], 0, 0, 0, 0, 0, 0, 0);
    }
    SpawnPlayer(playerid);
    SetPlayerSkin(playerid, Player[playerid][Skin]);
    GivePlayerMoney(playerid, Player[playerid][Cash]);
     SetPlayerScore(playerid, Player[playerid][Score]);
    TogglePlayerSpectating(playerid, false);
    TextDrawHideForPlayer(playerid, blackTD);
} 


Thanks,
Yoran

[Tayab]

I do it this way.

pawn Код:

stock LoginPlayer(playerid)
{
    new data[128];
    new query[126], pName[MAX_PLAYER_NAME], savingstring[128];
    GetPlayerName(playerid, pName, sizeof(pName));
    format(query,sizeof(query), "SELECT * FROM `accounts` WHERE `name` = '%s'", pName);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query, "|"))
    {
        mysql_fetch_field_row(data, "spawnx"); Player[playerid][Spawn][0] = floatstr(data);
        mysql_fetch_field_row(data, "spawny"); Player[playerid][Spawn][1] = floatstr(data);
        mysql_fetch_field_row(data, "spawnz"); Player[playerid][Spawn][2] = floatstr(data);
        mysql_fetch_field_row(data, "cash"); Player[playerid][Cash] = strval(data);
        mysql_fetch_field_row(data, "score"); Player[playerid][Score] = strval(data);
        mysql_fetch_field_row(data, "admin"); Player[playerid][Admin] = strval(data);
        mysql_fetch_field_row(data, "tutorial"); Player[playerid][Tutorial] = strval(data);
        mysql_fetch_field_row(data, "skin"); Player[playerid][Skin] = strval(data);
        mysql_fetch_field_row(data, "mute"); Player[playerid][Mute] = strval(data);
    }
    if(Player[playerid][Spawn][0] == 0)
    {
        SetSpawnInfo(playerid, 0, Player[playerid][Skin], 1555.2797, -1019.0566, 23.9063, 120.7054, 0, 0, 0, 0, 0, 0);
    }
    else
    {
        SetSpawnInfo(playerid, 0, Player[playerid][Skin], Player[playerid][Spawn][0], Player[playerid][Spawn][1], Player[playerid][Spawn][2], 0, 0, 0, 0, 0, 0, 0);
    }
    SpawnPlayer(playerid);
    SetPlayerSkin(playerid, Player[playerid][Skin]);
    GivePlayerMoney(playerid, Player[playerid][Cash]);
    SetPlayerScore(playerid, Player[playerid][Score]);
    TogglePlayerSpectating(playerid, false);
    TextDrawHideForPlayer(playerid, blackTD);
}