Loading a number from MYSQL - Printable Version

Loading a number from MYSQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Loading a number from MYSQL (/showthread.php?tid=415431)

Loading a number from MYSQL - dusk - 13.02.2013

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.

Re: Loading a number from MYSQL - Vince - 13.02.2013

What is the purpose of fetching the entire row if you only need one field?

PHP код:



SELECT money FROM users WHERE username = '%s';

Then use mysql_fetch_int in R6 or earlier or strval in R7 and later.

Re: Loading a number from MYSQL - dusk - 13.02.2013

THANKS a lot for that. Now my problem is that OnPlayerDisconnect it doesn't save the amount(and did yesterday)

pawn Код:

format(query,sizeof(query),"UPDATE users SET Money = '%d' WHERE username = '%s'",PlayerInfo[playerid][money],Name);
        mysql_query(query);

Do you see a problem?

Re: Loading a number from MYSQL - dusk - 13.02.2013

I did. But this is my way of learning

Thats why i'm asking

Re: Loading a number from MYSQL - adsy - 14.02.2013

Is your field "Money" with a capital M or money without a capital M