MySQL Real Time updating?
#1

Hi, so recently I've gotten in touch with hosting servers, and it was time to go to MySQL, which I've never used before and luckily it's easy to configure. So I was wandering, if it was possible to update ingame things real time with mysql? i.e change someone's money or name via the database while they're still on.
Reply
#2

You could make an in-game command to UPDATE their money amount in the database and reload their money variable.
Reply
#3

AFAIK people mostly do that on logout. The UPDATE etc.
Reply
#4

That is true^ as ca2k said. Now about changing someone's name while they are ingame, that is easy to do with just SetPlayerName, and a database UPDATE for that.

Also - read this: https://sampwiki.blast.hk/wiki/Mysql_tutorial
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)