Support:Database Cleanup

This article suggests methods to determine accounts and characters that are candidates for deletion.

Inconsistent data

This was caused by a bug cause by storing gameEvents in an other thread before the database access was thread-safe. The bug was fixed in July 2009.

<source lang="sql"> SELECT * FROM characters WHERE NOT EXISTS (

   SELECT null FROM rpobject WHERE characters.object_id=rpobject.object_id

) ORDER BY timedate; </source>

<source lang="sql"> SELECT account.* FROM account WHERE NOT EXISTS (

   SELECT null FROM characters WHERE player_id=account.id

) AND status='active'; </source>

Must have no entries in gameEvents (2008-06-30, 2009-08-17), itemlog (2008-03-24), accountban
Remember to clean additional tables, character_stats, accountLink, ...
Criteria
- Level < 5
- Age < 5, if it exist
- no valuable items
- ~~No other characters on that account that are not candidates~~ Multi character support is younger than 2008-06-30.