16.02.2013, 15:48
My mysql database looks like this: userid|username|password|alevel|items|Money|level| Job|Mechanic|SkinID|Mseeds|Marijuana|Police
My enum:
And OnPlayerSpawn:
I checked the order like 10 times and still...skin gets loaded from the Mseeds column,can you guys spot the problem?
My enum:
pawn Код:
enum pInfo
{
userid,
username[128],
pPass[128],
alevel,
items[128],
money,
level,
job,
Mechanic,
SkinID,
Mseeds,
Marijuana,
Police
}
pawn Код:
new moneyquery[512];
format(moneyquery,sizeof(moneyquery),"SELECT * FROM `users` WHERE `username` = '%s'",Name);
mysql_query(moneyquery);
mysql_store_result();
mysql_fetch_row_format(moneyquery,"|");
sscanf(moneyquery,"e<p<|>ds[128]s[128]ds[128]dddddddd>",PlayerInfo[playerid]);
mysql_free_result();
SetPlayerSkin(playerid,PlayerInfo[playerid][SkinID]);
GivePlayerMoney(playerid, PlayerInfo[playerid][money]);
return 1;