Support:Database Cleanup

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

Inconsistent data

Characters without rpobject

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.

SELECT * FROM characters WHERE NOT EXISTS (
    SELECT null FROM rpobject WHERE characters.object_id=rpobject.object_id
) ORDER BY timedate;

Accounts without characters

SELECT account.* FROM account WHERE NOT EXISTS (
    SELECT null FROM characters WHERE player_id=account.id
) AND status='active';

Metrics for discontinuted accounts

• Must have no entries in gameEvents (2008-06-30, 2009-08-17), itemlog (2008-03-24), accountban