diff options
| -rw-r--r-- | doc/CharacterDBCleanup.txt | 1 | ||||
| -rw-r--r-- | src/server/game/Tools/CharacterDatabaseCleaner.cpp | 8 | ||||
| -rw-r--r-- | src/server/game/Tools/CharacterDatabaseCleaner.h | 4 |
3 files changed, 12 insertions, 1 deletions
diff --git a/doc/CharacterDBCleanup.txt b/doc/CharacterDBCleanup.txt index bcf1f380f4e..490243c70f7 100644 --- a/doc/CharacterDBCleanup.txt +++ b/doc/CharacterDBCleanup.txt @@ -9,6 +9,7 @@ from characters in the database. CLEANING_FLAG_SKILLS = 0x2 CLEANING_FLAG_SPELLS = 0x4 CLEANING_FLAG_TALENTS = 0x8 + CLEANING_FLAG_QUESTSTATUS = 0x10 Example: We want to clean up old talents, spells and skills, but leave diff --git a/src/server/game/Tools/CharacterDatabaseCleaner.cpp b/src/server/game/Tools/CharacterDatabaseCleaner.cpp index fff3fce0ad6..75fe2fb18fd 100644 --- a/src/server/game/Tools/CharacterDatabaseCleaner.cpp +++ b/src/server/game/Tools/CharacterDatabaseCleaner.cpp @@ -52,6 +52,9 @@ void CharacterDatabaseCleaner::CleanDatabase() if (flags & CLEANING_FLAG_TALENTS) CleanCharacterTalent(); + if (flags & CLEANING_FLAG_QUESTSTATUS) + CleanCharacterQuestStatus(); + CharacterDatabase.DirectExecute("UPDATE worldstates SET value = 0 WHERE entry = 20004"); sLog->outString(">> Cleaned character database in %u ms", GetMSTimeDiffToNow(oldMSTime)); @@ -143,3 +146,8 @@ void CharacterDatabaseCleaner::CleanCharacterTalent() CheckUnique("spell", "character_talent", &TalentCheck); } +void CharacterDatabaseCleaner::CleanCharacterQuestStatus() +{ + CharacterDatabase.DirectExecute("DELETE FROM character_queststatus WHERE status = 0"); +} + diff --git a/src/server/game/Tools/CharacterDatabaseCleaner.h b/src/server/game/Tools/CharacterDatabaseCleaner.h index b874d188a7a..1be471e5e2a 100644 --- a/src/server/game/Tools/CharacterDatabaseCleaner.h +++ b/src/server/game/Tools/CharacterDatabaseCleaner.h @@ -26,7 +26,8 @@ namespace CharacterDatabaseCleaner CLEANING_FLAG_ACHIEVEMENT_PROGRESS = 0x1, CLEANING_FLAG_SKILLS = 0x2, CLEANING_FLAG_SPELLS = 0x4, - CLEANING_FLAG_TALENTS = 0x8 + CLEANING_FLAG_TALENTS = 0x8, + CLEANING_FLAG_QUESTSTATUS = 0x10 }; void CleanDatabase(); @@ -42,6 +43,7 @@ namespace CharacterDatabaseCleaner void CleanCharacterSkills(); void CleanCharacterSpell(); void CleanCharacterTalent(); + void CleanCharacterQuestStatus(); } #endif |