Support:Database Cleanup: Difference between revisions
Jump to navigation
Jump to search
imported>Hendrik Brummermann Created page with "This article suggests methods to determine accounts and characters that are candidates for deletion. == Inconsistent data == === Characters without rpobject === This was cause..." |
imported>Hendrik Brummermann Created page with "This article suggests methods to determine accounts and characters that are candidates for deletion. == Inconsistent data == === Characters without rpobject === This was cause..." |
(No difference)
| |
Revision as of 09:46, 17 March 2012
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.
<source lang="sql"> SELECT * FROM characters WHERE NOT EXISTS (
SELECT null FROM rpobject WHERE characters.object_id=rpobject.object_id
) ORDER BY timedate; </source>
Accounts without characters
<source lang="sql"> SELECT account.* FROM account WHERE NOT EXISTS (
SELECT null FROM characters WHERE player_id=account.id
) AND status='active'; </source>
Metrics for discontinuted accounts
- Must have no entries in gameEvents (2008-06-30, 2009-08-17), itemlog (2008-03-24), accountban