MySQL problem on GMX - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL problem on GMX (/showthread.php?tid=371439)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL problem on GMX (/showthread.php?tid=371439)
MySQL problem on GMX - scottyishere - 23.08.2012
I'm using BlueG's mysql plugin R6-2, I want to modify all of it to threaded R7 soon but I'm experiencing a bizarre problem.
If I GMX the server using RCON it ruins all stored player accounts with random messages in strings and 0 as variables.
Sometimes it happens, sometimes it doesn't. It is happening frequently if there is more than 1 player online.
I tried using mysql_close OnGameModeExit but it made everything worse.
What could be the problem?
Thanks.
Re: MySQL problem on GMX - ZBits - 23.08.2012
are you using any filterscripts for the accounts system?
Re: MySQL problem on GMX - scottyishere - 23.08.2012
Nope, everything is scripted by me.
Re: MySQL problem on GMX - ZBits - 23.08.2012
i dont understand what are you trying to do
like do you want to restart your server or shut it down?
EDIT: What command processor are you using?
Re: MySQL problem on GMX - scottyishere - 23.08.2012
I am using dcmd and old strcmp and when I /rcon GMX the server restarts and after I login again I notice that all stats are broken. Never happens if I close the server window or /q.
Re: MySQL problem on GMX - ZBits - 23.08.2012
show you on gamemodeexit
EDIT: try not to use strcmp most of them causes bug
TIP: Never use 2 command processor in one GM
try to convert strcmp to dcmd
Re: MySQL problem on GMX - scottyishere - 23.08.2012
Well I am in the process of converting strcmp to dcmd but there are a lot of commands and that takes time.
My OnGameModeExit is empty.
Re: MySQL problem on GMX - scottyishere - 24.08.2012
BUMP.
Do you think I should update my mysql plugin to BlueG's R7 and use threaded queries?
Re: MySQL problem on GMX - Vince - 24.08.2012
I suggest simply not using gmx. If you need to restart the mode, then I would save all data and set a timer 3 seconds to call SendRconCommand.