35 TC_LOG_INFO(
"misc",
"Cleaning character database...");
77 std::ostringstream ss;
80 Field* fields = result->Fetch();
88 ss <<
"DELETE FROM " << table <<
" WHERE " << column <<
" IN (";
97 while (result->NextRow());
154 CharacterDatabase.DirectExecute(
"DELETE FROM character_queststatus WHERE status = 0");
DB2Storage< SkillLineEntry > sSkillLineStore("SkillLine.db2", &SkillLineLoadInfo::Instance)
DB2Storage< ChrSpecializationEntry > sChrSpecializationStore("ChrSpecialization.db2", &ChrSpecializationLoadInfo::Instance)
DB2Storage< TalentEntry > sTalentStore("Talent.db2", &TalentLoadInfo::Instance)
std::shared_ptr< ResultSet > QueryResult
DatabaseWorkerPool< CharacterDatabaseConnection > CharacterDatabase
Accessor to the character database.
#define TC_LOG_INFO(filterType__,...)
#define MAX_SPECIALIZATIONS
@ SPELL_ATTR0_CU_IS_TALENT
uint32 GetMSTimeDiffToNow(uint32 oldMSTime)
Class used to access individual fields of database query result.
bool HasAttribute(SpellAttr0 attribute) const
static PersistentWorldVariable const CharacterDatabaseCleaningFlagsVarId
@ CONFIG_PERSISTENT_CHARACTER_CLEAN_FLAGS
@ CONFIG_CLEAN_CHARACTER_DB
TC_GAME_API bool SpellCheck(uint32 spell_id)
TC_GAME_API bool SkillCheck(uint32 skill)
TC_GAME_API void CleanCharacterTalent()
TC_GAME_API void CleanDatabase()
TC_GAME_API void CheckUnique(char const *column, char const *table, bool(*check)(uint32))
TC_GAME_API void CleanCharacterQuestStatus()
TC_GAME_API bool TalentCheck(uint32 talent_id)
TC_GAME_API void CleanCharacterSpell()
@ CLEANING_FLAG_QUESTSTATUS
@ CLEANING_FLAG_ACHIEVEMENT_PROGRESS
TC_GAME_API void CleanCharacterAchievementProgress()
TC_GAME_API void CleanCharacterSkills()
TC_GAME_API bool AchievementProgressCheck(uint32 criteria)