From c562d0c13a0508437b815594763a07e8a848d7b1 Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Wed, 15 Nov 2023 17:15:21 +0100 Subject: Core/DataStores: load TalentTab.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/Implementation') diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp index 422ede2bf7a..389015f59ae 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.cpp +++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp @@ -1619,6 +1619,12 @@ void HotfixDatabaseConnection::DoPrepareStatements() PREPARE_MAX_ID_STMT(HOTFIX_SEL_TALENT, "SELECT MAX(ID) + 1 FROM talent", CONNECTION_SYNCH); PREPARE_LOCALE_STMT(HOTFIX_SEL_TALENT, "SELECT ID, Description_lang FROM talent_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?", CONNECTION_SYNCH); + // TalentTab.db2 + PrepareStatement(HOTFIX_SEL_TALENT_TAB, "SELECT ID, Name, BackgroundFile, OrderIndex, RaceMask, ClassMask, PetTalentMask, SpellIconID" + " FROM talent_tab WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH); + PREPARE_MAX_ID_STMT(HOTFIX_SEL_TALENT_TAB, "SELECT MAX(ID) + 1 FROM talent_tab", CONNECTION_SYNCH); + PREPARE_LOCALE_STMT(HOTFIX_SEL_TALENT_TAB, "SELECT ID, Name_lang FROM talent_tab_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?", CONNECTION_SYNCH); + // TaxiNodes.db2 PrepareStatement(HOTFIX_SEL_TAXI_NODES, "SELECT Name, PosX, PosY, PosZ, MapOffsetX, MapOffsetY, FlightMapOffsetX, FlightMapOffsetY, ID, " "ContinentID, ConditionID, CharacterBitNumber, Flags, UiTextureKitID, Facing, SpecialIconConditionID, VisibilityConditionID, " diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h index 524216c81e8..0496323703e 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.h +++ b/src/server/database/Database/Implementation/HotfixDatabase.h @@ -932,6 +932,10 @@ enum HotfixDatabaseStatements : uint32 HOTFIX_SEL_TALENT_MAX_ID, HOTFIX_SEL_TALENT_LOCALE, + HOTFIX_SEL_TALENT_TAB, + HOTFIX_SEL_TALENT_TAB_MAX_ID, + HOTFIX_SEL_TALENT_TAB_LOCALE, + HOTFIX_SEL_TAXI_NODES, HOTFIX_SEL_TAXI_NODES_MAX_ID, HOTFIX_SEL_TAXI_NODES_LOCALE, -- cgit v1.2.3