[MySQL] Question... - Printable Version

[MySQL] 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: [MySQL] Question... (/showthread.php?tid=459710)

[MySQL] Question... - aLTeR - 24.08.2013

Should i remove users, from mysql database, if they not logging in for a long time?
If yes, how?

Re: [MySQL] Question... - Misiur - 24.08.2013

You could make them "inactive" so they aren't included in some bulk action on all active accounts. Deleting accounts isn't too good option, some players visit really rarely (but want to keep their stuff)

Re: [MySQL] Question... - Sinner - 24.08.2013

Even if these users don't visit they can be used for statistical calculations or other things later on. MySQL has absolutely no issue with some extra rows and your queries won't be any slower too. So, no. There's really no reason to.

Re: [MySQL] Question... - aLTeR - 24.08.2013

Thanks.

Re: [MySQL] Question... - Mean - 24.08.2013

Quote:

Originally Posted by Sinner

Even if these users don't visit they can be used for statistical calculations or other things later on. MySQL has absolutely no issue with some extra rows and your queries won't be any slower too. So, no. There's really no reason to.

Actually yes it will be slower. Many users just come ingame, register and never come again (like 30%+ of the accs).

You should set a field "laston", make it a unix timestamp. When a player connects, set this field to the current timestamp.

Then, when deleting users, if the current gettime() - their laston is larger than 31556926 (1 year), delete their user account. If a user does not login once a year, he probably doesn't care about the game that much.