Character deletion routine not fully functional

THIS ISSUE MAY APPLY CROSS-CORE (ONE,TWO ETC)

This issue is confirmed by Antz and myself, we mass marked 1600 accounts at covenant for deletion as part of a cleanup process, only the entries in the character table were removed and no other character data was removed.

Issue:

After marking characters as deleted (setting a unix date under "DeletedDate" in the Characters table in the Characters database the deletion routine does not remove character data from other character tables.

Data has been observed to not be removed from character_queststatus, Character_inventory

Character deletion commands - server console:
You can do "help character delete" to get more info.

• character delete list
  lists deleted characters
• character delete old
  deletes all characters marked for deletion, even if you have the setting at 0 to disable it, this command ignores that (use carefully).
• character deleted delete guid|charname
  Deletes a single character based on name or guid

Fix should include

• Remove all character data from all character tables on deletion or when the core starts and runs the check
• A startup task should check existing character data is correct. It should check:
  • All character tables  (character data entries) matches up to a VALID GUID entry in the character table, that exists and not marked for deletion.
  • If marked for deletion it should be kept and deleted when the normal deletion routine runs.