11.05.2014, 02:23
A fairly common problem with MySQL gamemodes is that user accounts are saved over if a new account connects before the saving query fully executes.
You can prevent this from happening by avoiding the use of any variables which reset a connecting players stats until the saving query has completely finished. Alternatively, you could write one incredibly long query which sends the information immediately as the player disconnects (which would require an incredibly long string for a large player account update) or you could use SQL transactions.
You can prevent this from happening by avoiding the use of any variables which reset a connecting players stats until the saving query has completely finished. Alternatively, you could write one incredibly long query which sends the information immediately as the player disconnects (which would require an incredibly long string for a large player account update) or you could use SQL transactions.