Today (its running while i write this actualy) i deleted old inactive accounts.
I am sad to tell that it was a huge number of accounts removed, 121000 out of about 156000. I checked several times to make sure i am not deleting the wrong accounts.
The accounts along with the associated data, creatures, docs, messages, etc, were transfered to a backup table and they will remain there untill the next cleanup that will be probably done in two/three month or so.
Tehnicaly they can be recovered but i do not have a way yet to do that easily. I hope everything went right and then there is no need to recover anything, but if somehow i deleted IMPORTANT accounts, please post here and i will conduct an investigation and recove whatever i can from them. Do not bother me for alts that are 10-20 days old. Once i will finish a system to recover these accounts automaticaly, you will see this option when trying to register or login with such a disabled account, but untill then its dificult, but possible, to recover them if realy needed.
The rules used to determine the inactive accounts are these:
- More than 2 month since last login and less than 5 active days and no valid email confirmed
- More than 4 month since last login and less than 10 active days
- More than 6 month since last login and less than 40 active days
- More than 8 month since last login
- All rules filter out also NPC and RPC accounts (but not PWR)
Please let me know if you consider there is a problem with these rules.
Important note, the avatars of such disabled accounts will go back in the avatar gallery and will be available for anyone to get. There are over 400 avatars in game right now but in time many accounts become inactive so their avatars go wasted without good reason.
I will update you as soon as the process is finished, right now its still running and seems to be very very slow. I hope that after this the database will be much faster. The player table alone had over 1Gb in size.