Loading a number from MYSQL
#1

So the thing is i want OnPlayerSpawn i want to load the players money,and give it to him.
This is my script for it:
pawn Код:
new moneyquery[126];
    format(moneyquery,sizeof(moneyquery),"SELECT * FROM users WHERE username = '%s'",Name);
    mysql_query(moneyquery);
    mysql_store_result();
    new result[128];
    mysql_fetch_row_format(result, " ");
    sscanf(moneyquery,"i",PlayerInfo[playerid][money]);
    SetPVarInt(playerid, "money",PlayerInfo[playerid][money]);
    GivePlayerMoney(playerid, PlayerInfo[playerid][money]);
    return 1;
There's no errors,but still.. The money just doesn't appear.
Reply


Messages In This Thread
Loading a number from MYSQL - by dusk - 13.02.2013, 08:57
Re: Loading a number from MYSQL - by Vince - 13.02.2013, 09:12
Re: Loading a number from MYSQL - by dusk - 13.02.2013, 09:32
Re: Loading a number from MYSQL - by dusk - 13.02.2013, 10:46
Re: Loading a number from MYSQL - by adsy - 14.02.2013, 11:07

Forum Jump:


Users browsing this thread: 3 Guest(s)