[dusk]

pawn Код:

stock LoadStats(playerid)
{
    new resultquery[256];
    format(resultquery,sizeof(resultquery),"SELECT * FROM users WHERE username = '%s'",Name);
    mysql_query(resultquery);
    mysql_store_result();
    mysql_fetch_row_format(resultquery,"|");
    sscanf(resultquery,"p<|>dddds",PlayerInfo[playerid][alevel],PlayerInfo[playerid][level],PlayerInfo[playerid][money],PlayerInfo[playerid][Mechanic],PlayerInfo[playerid][items]);
    GivePlayerMoney(playerid,PlayerInfo[playerid][money]);
    SetPlayerScore(playerid,PlayerInfo[playerid][level]);
    mysql_free_result();
    return 1;
}

So the thing is,it just doesn't load anything.No compiling errors. I'm pretty sure that the problem is the split part with sscanf.
Could anyone tell me how to use it? Or is the problem elsewhere?
I'm just learning mysql.

[MattSlater]

What MYSQL version are you using?

[Riddy]

Quote:

Originally Posted by MattSlater What MYSQL version are you using?

My guess is either R5 or R6

[dusk]

It's R6

[dusk]

bump,so any answers after getting that information?

[dusk]

anyone? i really need the answer

[dusk]

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

[dusk]

bump

[dusk]

bump

[dusk]

bump.Please help,i cant do anything further without this