diff options
| author | Shauren <shauren.trinity@gmail.com> | 2021-06-06 19:06:08 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-06-06 19:06:08 +0200 |
| commit | 8d5356cdeaeaae7dc20bfca71ca24b8134a8e80c (patch) | |
| tree | a4986ef3b3e0061f5eb28965aa08ff59c780b593 /src/server/database/Database | |
| parent | b607bb0a93892734c6a2ce16afc5ea92ffb7fe50 (diff) | |
Core/DataStores: Load PvpTier.db2
Diffstat (limited to 'src/server/database/Database')
| -rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.cpp | 6 | ||||
| -rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.h | 4 |
2 files changed, 10 insertions, 0 deletions
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, |