diff options
| author | Aqua Deus <95978183+aquadeus@users.noreply.github.com> | 2022-10-11 22:16:02 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-10-11 22:16:02 +0200 |
| commit | 4772c4817f1b34553f1c697e2aedc0372af9aea2 (patch) | |
| tree | 9f7ed43aba6c4be3460e2de5097204ea0fbccf82 /src/server/database/Database/Implementation | |
| parent | 8262d6be23811eddfd280b7d9341e2cac01a6e83 (diff) | |
Core/Garrisons: Implement SMSG_GARRISON_OPEN_TALENT_NPC opcode (#28256)
Co-authored-by: ModoX <moardox@gmail.com>
Co-authored-by: Shauren <shauren.trinity@gmail.com>
Diffstat (limited to 'src/server/database/Database/Implementation')
| -rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.cpp | 7 | ||||
| -rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.h | 4 |
2 files changed, 11 insertions, 0 deletions
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, |