SA-MP Forums Archive
Sqlite question - 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: Sqlite question (/showthread.php?tid=588875)



Sqlite question - Thoma - 13.09.2015

I hope this is the right board...

Lets say 70 people are in my server.. And I need to edit 1 account thats offline without having to download the database the reupload it and run the risk of overwriting a player's score that just logged off with 10,000 score as when i downloaded the db he had 9,500?


Re: Sqlite question - Thomaske - 13.09.2015

Just use a program to edit your database then, no needs to download, upload it again.
you just need to connect to the database host, edit and edit the player you want and done.

you can take a look here, i use it for a long time and never had problems.


Re: Sqlite question - iggy1 - 13.09.2015

You can just update the offline player from the server without external programs or downloading/uploading the file. Just update the player entry as if they was online.

Код:
UPDATE table SET ... WHERE playername = 'playername to update'
Another major problem with downloading/uploading the database, is that while you are editing it, new data will likely be inserted into the database (70 players online). So when you upload your edited database this data will be lost. You can only safely use this method when the server is offline.