Is there a way to detect SQL Data Changes?

[FlyingSpoon]

Say if I made an external site and I update something via PHP to the database, (e.g. UPDATE users SET rank=? WHERE username=?, 4, Light); And in-game is there a way to detect this change has been made? Like, it detects the change and outputs, "[Web] You rank has been updated". I know I can do this using setTimer, but I don't want it to be an endless loop, I just want it to be so that if a SQL Data has changed or been updated, it will detect it.

[NeXuS™]

You can create a call in the PHP file to the MTA server.

[ShayF2]

Best way is to run a timer on server side checking the data in the sql, since the sql connection stays constant.

[IIYAMA]

Afaik mysql does have such things as events:

https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html

(never used it thought)

I am not sure what the possibilities with this are, but it can do a part of the administration for you.

 

Edited February 23, 2018 by IIYAMA