Support:Database Cleanup: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
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 No edit summary |
||
| Line 13: | Line 13: | ||
</source> |
</source> |
||
== Accounts without characters == |
=== Accounts without characters === |
||
<source lang="sql"> |
<source lang="sql"> |
||
| Line 24: | Line 24: | ||
* Must have no entries in gameEvents (2008-06-30, 2009-08-17), itemlog (2008-03-24), accountban |
* 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 |
|||
** <del>No other characters on that account that are not candidates</del> Multi character support is younger than 2008-06-30. |
|||