From 8d5356cdeaeaae7dc20bfca71ca24b8134a8e80c Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 6 Jun 2021 19:06:08 +0200 Subject: Core/DataStores: Load PvpTier.db2 --- src/server/database/Database/Implementation/HotfixDatabase.cpp | 6 ++++++ src/server/database/Database/Implementation/HotfixDatabase.h | 4 ++++ 2 files changed, 10 insertions(+) (limited to 'src/server/database/Database') diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp index 3a136952980..507f4f2f9d4 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.cpp +++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp @@ -1134,6 +1134,12 @@ void HotfixDatabaseConnection::DoPrepareStatements() " FROM pvp_talent_slot_unlock WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH); PREPARE_MAX_ID_STMT(HOTFIX_SEL_PVP_TALENT_SLOT_UNLOCK, "SELECT MAX(ID) + 1 FROM pvp_talent_slot_unlock", CONNECTION_SYNCH); + // PvpTier.db2 + PrepareStatement(HOTFIX_SEL_PVP_TIER, "SELECT Name, ID, MinRating, MaxRating, PrevTier, NextTier, BracketID, `Rank`, RankIconFileDataID" + " FROM pvp_tier WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH); + PREPARE_MAX_ID_STMT(HOTFIX_SEL_PVP_TIER, "SELECT MAX(ID) + 1 FROM pvp_tier", CONNECTION_SYNCH); + PREPARE_LOCALE_STMT(HOTFIX_SEL_PVP_TIER, "SELECT ID, Name_lang FROM pvp_tier_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?", CONNECTION_SYNCH); + // QuestFactionReward.db2 PrepareStatement(HOTFIX_SEL_QUEST_FACTION_REWARD, "SELECT ID, Difficulty1, Difficulty2, Difficulty3, Difficulty4, Difficulty5, Difficulty6, " "Difficulty7, Difficulty8, Difficulty9, Difficulty10 FROM quest_faction_reward WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH); diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h index 29f9ddb17a2..2535e79cef6 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.h +++ b/src/server/database/Database/Implementation/HotfixDatabase.h @@ -655,6 +655,10 @@ enum HotfixDatabaseStatements : uint32 HOTFIX_SEL_PVP_TALENT_SLOT_UNLOCK, HOTFIX_SEL_PVP_TALENT_SLOT_UNLOCK_MAX_ID, + HOTFIX_SEL_PVP_TIER, + HOTFIX_SEL_PVP_TIER_MAX_ID, + HOTFIX_SEL_PVP_TIER_LOCALE, + HOTFIX_SEL_QUEST_FACTION_REWARD, HOTFIX_SEL_QUEST_FACTION_REWARD_MAX_ID, -- cgit v1.2.3