MySql OnPlayerUpdate - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySql OnPlayerUpdate (/showthread.php?tid=106009)
+- 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySql OnPlayerUpdate (/showthread.php?tid=106009)
MySql OnPlayerUpdate - Matimor - 01.11.2009
Welcome
I have a problem with saving data to MySql (OnPlayerUpdate), I do not know what the reason is that it does not save me, although the variables produces public. I have a record made on the basis of Moderntopii so it should not perhaps be such an error. Everything looks smooth, but the database I see no changes.
Example:
Код:
MySQLUpdatePlayerInt(query, InfoGracza[playerid][pSQLID], "DonateRank", InfoGracza[playerid][pDonateRank]);
Re: MySql OnPlayerUpdate - Sergei - 01.11.2009
No, no and no.
Do not use OnPlayerUpdate to save/load data from files or SQL. It gets called ~54 per second, so that is 54 queries per second what it just too much.
Why would you save donate rank all the time? It doesn't get changed very frequently, does it?
Re: MySql OnPlayerUpdate - Matimor - 01.11.2009
I write to SQL so in public OnPlayerUpdatePlayer query is performed only on my command.