06.11.2010, 17:37
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.
Sscanf won't shut the fuck up though with the format specifier, blah..., I'll fix that though. Anyways... Thanks for the help.
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();
}

