11.07.2017, 15:17
The whole purpose of joining tables is to update values from 3 different tables in 1 query. In other words, this means that you need to get rid of those un-threaded queries about retrieving "NZT" and "Bank" because the query takes care of them and updates accordingly.
I'd rather have another if statement at the very top of the command to check if player is currently online (you've got the name of the player so sscanf with "r" or "u" specifier) and use their user ID directly to execute 3 simple UPDATE queries.
And yeah, thanks for pointing out my silly mistake - that's what happens when you test on yourself in-game!
I'd rather have another if statement at the very top of the command to check if player is currently online (you've got the name of the player so sscanf with "r" or "u" specifier) and use their user ID directly to execute 3 simple UPDATE queries.
And yeah, thanks for pointing out my silly mistake - that's what happens when you test on yourself in-game!