SA-MP Forums Archive
SQLite data leak - 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 data leak (/showthread.php?tid=664629)



SQLite data leak - KaliDobrev - 05.03.2019

Hello, can someone tell me why my server with SQLite saved system sometimes loses user data when disconnecting or restarting the server?
How could I solve it? and what is causing it?

I stress: This never happened to me, I had the server online before and never lost any data, it may be the attacks I'm receiving? (The attacks are DDoS with botnet)


Re: SQLite data leak - Pottus - 06.03.2019

Do you make queries to your db when a user disconnects?


Re: SQLite data leak - KaliDobrev - 06.03.2019

Quote:
Originally Posted by Pottus
Посмотреть сообщение
Do you make queries to your db when a user disconnects?
Yes.


Re: SQLite data leak - Pottus - 06.03.2019

You just found your problem then. Saving anything other than immediately means running the risk of data loss.


Re: SQLite data leak - KaliDobrev - 06.03.2019

Quote:
Originally Posted by Pottus
Посмотреть сообщение
You just found your problem then. Saving anything other than immediately means running the risk of data loss.
So, I should not save the data when the user disconnects, if not in another way?


Re: SQLite data leak - Banditul18 - 06.03.2019

Update data when changes. User recived/lost money? Let the database know about it


Re: SQLite data leak - KaliDobrev - 06.03.2019

Thank you
+1