Storing data into the variables...?
#5

I solved the problem. It was something which I thought I had removed from the MySQL database, but apparently not. This is the "LoadAccountVariables();" function I'm using now.

pawn Код:
stock LoadAccountVariables(playerid)
{
    new EscapedName[MAX_PLAYER_NAME];
    if(IsPlayerConnectedEx(playerid))
    {
        mysql_real_escape_string(GetName(playerid), EscapedName);
        format(Query, sizeof(Query), "SELECT * FROM `Accounts` WHERE `Username` = '%s'", EscapedName);
        mysql_query(Query);
        mysql_store_result();
       
        mysql_fetch_row_format(Query, "|");
        sscanf(Query, "e<p<|>s[25]s[147]ddddfffff>",
        PlayerStats[playerid][pUserName],
        PlayerStats[playerid][pPassword],
        PlayerStats[playerid][pAdminLevel],
        PlayerStats[playerid][pMoney],
        PlayerStats[playerid][pScore],
        PlayerStats[playerid][pSkin],
        PlayerStats[playerid][pHealth],
        PlayerStats[playerid][pArmour],
        PlayerStats[playerid][pPositionX],
        PlayerStats[playerid][pPositionY],
        PlayerStats[playerid][pPositionZ]);
    }
    else print("[MySQL ERROR] LoadAccountVariables() was called, but to a non-connected ID.");
    mysql_free_result();
}
Sscanf won't shut the fuck up though with the format specifier, blah..., I'll fix that though. Anyways... Thanks for the help.
Reply


Messages In This Thread
Storing data into the variables...? - by Scenario - 06.11.2010, 16:58
Re: Storing data into the variables...? - by Miguel - 06.11.2010, 17:14
Re: Storing data into the variables...? - by Scenario - 06.11.2010, 17:18
Re: Storing data into the variables...? - by Miguel - 06.11.2010, 17:25
Re: Storing data into the variables...? - by Scenario - 06.11.2010, 17:37

Forum Jump:


Users browsing this thread: 1 Guest(s)