[TH3_R3D™]

pawn Код:

stock LoginPlayer(playerid, password[])
{
    new query[128], pname[MAX_PLAYER_NAME], field[5][32], data[256];
    GetPlayerName(playerid, pname, MAX_PLAYER_NAME);
    
    format(query, sizeof(query), "SELECT Name, Money, PlayerX, PlayerY, PlayerZ FROM accounts WHERE Name = '%s' AND Password = '%s'", pname, password);
    mysql_query(query);
    mysql_store_result();
    
    if (mysql_fetch_row(data))
    {
        split(data, field, '|');
        
        PlayerInfo[playerid][pName]     = strval(field[0]);
        PlayerInfo[playerid][pMoney]    = strval(field[1]);
        PlayerInfo[playerid][pPos_x]    = floatstr(field[2]);
        PlayerInfo[playerid][pPos_y]    = floatstr(field[3]);
        PlayerInfo[playerid][pPos_z]    = floatstr(field[4]);
    }
    GivePlayerMoney(playerid, PlayerInfo[playerid][pName]);
    SetSpawnInfo(playerid, 0, 294, PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], 0,0,0,0,0,0,0);
    return  SpawnPlayer(playerid);
}

When it comes to load, it doesn't load well, it spawns me at blue berry (where cords are 0.0) and money is reset to 0.

why?

Thanks in advance!

[TH3_R3D™]

any help?

[[HiC]TheKiller]

Put

pawn Код:

mysql_debug(1);

Under OnGameModeInit and post the mysql log file that will be generated into your server directory.