[Question] How to save samp player money on mysql (not on open.mp server)

[angelovj8]

How to save samp player money on mysql (not on open.mp server)

[Radical]

Create an integer column named 'money' in the 'accounts' table and store the player's money on disconnect.

query:

PHP Code:

UPDATE `accounts` SET `money` = %d WHERE `id` = ? 


And load it when the player is logged into the account:

PHP Code:

new money;
cache_get_value_int(0, "money", money);
GivePlayerMoney(playerid, money); 


[Konliner]

Create an integer column named 'money' in the 'accounts' table and store the player's money on disconnect.

query:

PHP Code:

UPDATE `accounts` SET `money` = %d WHERE `id` = ? 


And load it when the player is logged into the account:

PHP Code:

new money;
cache_get_value_int(0, "money", money);
GivePlayerMoney(playerid, money); 


This way is very good. But I couldn't think of this. Thanks