From 4772c4817f1b34553f1c697e2aedc0372af9aea2 Mon Sep 17 00:00:00 2001 From: Aqua Deus <95978183+aquadeus@users.noreply.github.com> Date: Tue, 11 Oct 2022 22:16:02 +0200 Subject: Core/Garrisons: Implement SMSG_GARRISON_OPEN_TALENT_NPC opcode (#28256) Co-authored-by: ModoX Co-authored-by: Shauren --- src/server/database/Database/Implementation/HotfixDatabase.cpp | 7 +++++++ src/server/database/Database/Implementation/HotfixDatabase.h | 4 ++++ 2 files changed, 11 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 4e2fce8cec3..3af206c0644 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.cpp +++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp @@ -688,6 +688,13 @@ void HotfixDatabaseConnection::DoPrepareStatements() " FROM garr_site_level_plot_inst WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH); PREPARE_MAX_ID_STMT(HOTFIX_SEL_GARR_SITE_LEVEL_PLOT_INST, "SELECT MAX(ID) + 1 FROM garr_site_level_plot_inst", CONNECTION_SYNCH); + // GarrTalentTree.db2 + PrepareStatement(HOTFIX_SEL_GARR_TALENT_TREE, "SELECT ID, Name, GarrTypeID, ClassID, MaxTiers, UiOrder, Flags, UiTextureKitID, " + "GarrTalentTreeType, PlayerConditionID, FeatureTypeIndex, FeatureSubtypeIndex, CurrencyID FROM garr_talent_tree" + " WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH); + PREPARE_MAX_ID_STMT(HOTFIX_SEL_GARR_TALENT_TREE, "SELECT MAX(ID) + 1 FROM garr_talent_tree", CONNECTION_SYNCH); + PREPARE_LOCALE_STMT(HOTFIX_SEL_GARR_TALENT_TREE, "SELECT ID, Name_lang FROM garr_talent_tree_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?", CONNECTION_SYNCH); + // GemProperties.db2 PrepareStatement(HOTFIX_SEL_GEM_PROPERTIES, "SELECT ID, EnchantId, Type FROM gem_properties WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH); PREPARE_MAX_ID_STMT(HOTFIX_SEL_GEM_PROPERTIES, "SELECT MAX(ID) + 1 FROM gem_properties", CONNECTION_SYNCH); diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h index befc2fbfbd5..2bc899c79c7 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.h +++ b/src/server/database/Database/Implementation/HotfixDatabase.h @@ -393,6 +393,10 @@ enum HotfixDatabaseStatements : uint32 HOTFIX_SEL_GARR_SITE_LEVEL_PLOT_INST, HOTFIX_SEL_GARR_SITE_LEVEL_PLOT_INST_MAX_ID, + HOTFIX_SEL_GARR_TALENT_TREE, + HOTFIX_SEL_GARR_TALENT_TREE_MAX_ID, + HOTFIX_SEL_GARR_TALENT_TREE_LOCALE, + HOTFIX_SEL_GEM_PROPERTIES, HOTFIX_SEL_GEM_PROPERTIES_MAX_ID, -- cgit v1.2.3