Mysql loadstats
#7

I tried fixing it myself,and this is what i have so far:
pawn Код:
public OnPlayerSpawn(playerid)
{
    new moneyquery[256];
    format(moneyquery,sizeof(moneyquery),"SELECT * FROM `users` WHERE `username` = '%s'",Name);
    mysql_query(moneyquery);
    mysql_store_result();
    mysql_fetch_row_format(moneyquery,"|");
    sscanf(moneyquery,"p<|>dssdsdddd",PlayerInfo[playerid][userid],PlayerInfo[playerid][username],PlayerInfo[playerid][pPass],PlayerInfo[playerid][alevel],PlayerInfo[playerid][items],PlayerInfo[playerid][money],PlayerInfo[playerid][level],PlayerInfo[playerid][Mechanic],PlayerInfo[playerid][SkinID]);
    SetPlayerSkin(playerid,PlayerInfo[playerid][SkinID]);
    GivePlayerMoney(playerid, PlayerInfo[playerid][money]);
    mysql_free_result();
    return 1;
}
Could anyone help?
sorry for the posts,i just really need this
Reply


Messages In This Thread
[Mysql + sscanf] Doesn't load info - by dusk - 13.02.2013, 14:47
Re: Mysql loadstats - by MattSlater - 13.02.2013, 19:31
Re: Mysql loadstats - by Riddy - 13.02.2013, 19:31
Re: Mysql loadstats - by dusk - 14.02.2013, 07:23
Re: Mysql loadstats - by dusk - 14.02.2013, 20:03
Re: Mysql loadstats - by dusk - 15.02.2013, 09:22
Re: Mysql loadstats - by dusk - 15.02.2013, 14:13
Re: Mysql loadstats - by dusk - 15.02.2013, 15:48
Re: Mysql loadstats - by dusk - 15.02.2013, 20:05
Re: Mysql loadstats - by dusk - 16.02.2013, 07:59

Forum Jump:


Users browsing this thread: 2 Guest(s)