Mysql Help.
#1

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!
Reply


Messages In This Thread
Mysql Help. - by TH3_R3D™ - 18.07.2013, 20:02
Re: Mysql Help. - by TH3_R3D™ - 18.07.2013, 21:09
Re: Mysql Help. - by [HiC]TheKiller - 19.07.2013, 01:27

Forum Jump:


Users browsing this thread: 1 Guest(s)