[aLTeR]

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

[Misiur]

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)

[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.

[aLTeR]

Thanks.

[Mean]

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.