Core/CharacterDatabaseCleaner: Implement CLEANING_FLAG_QUESTSTATUS flag for queststatus cleaning (most of the deleted rows are abandoned quests)

--HG--
branch : trunk

2 files changed, 11 insertions, 1 deletions

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