diff options
| author | Shauren <shauren.trinity@gmail.com> | 2021-03-14 13:07:29 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-03-14 13:07:29 +0100 |
| commit | d0246e5835ea184b22896e6b354fb28c28890810 (patch) | |
| tree | 9631475374982307816ab5da5637168ef4975913 /src/server/database/Database/Implementation | |
| parent | c15cf8b424be0cf60150fbc7ddaf4574f78d72fd (diff) | |
Core/AdventureJournal: Check if player can access adventure journal with ChrClassUIDisplay.db2
Diffstat (limited to 'src/server/database/Database/Implementation')
| -rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.cpp | 5 | ||||
| -rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.h | 3 |
2 files changed, 8 insertions, 0 deletions
diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp index 9b354df9c84..ec64cfec926 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.cpp +++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp @@ -290,6 +290,11 @@ void HotfixDatabaseConnection::DoPrepareStatements() PREPARE_LOCALE_STMT(HOTFIX_SEL_CHAT_CHANNELS, "SELECT ID, Name_lang, Shortcut_lang FROM chat_channels_locale WHERE (`VerifiedBuild` > 0) = ?" " AND locale = ?", CONNECTION_SYNCH); + // ChrClassUiDisplay.db2 + PrepareStatement(HOTFIX_SEL_CHR_CLASS_UI_DISPLAY, "SELECT ID, ChrClassesID, AdvGuidePlayerConditionID, SplashPlayerConditionID" + " FROM chr_class_ui_display WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH); + PREPARE_MAX_ID_STMT(HOTFIX_SEL_CHR_CLASS_UI_DISPLAY, "SELECT MAX(ID) + 1 FROM chr_class_ui_display", CONNECTION_SYNCH); + // ChrClasses.db2 PrepareStatement(HOTFIX_SEL_CHR_CLASSES, "SELECT Name, Filename, NameMale, NameFemale, PetNameToken, Description, RoleInfoString, DisabledString, " "HyphenatedNameMale, HyphenatedNameFemale, ID, CreateScreenFileDataID, SelectScreenFileDataID, IconFileDataID, LowResScreenFileDataID, Flags, " diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h index ab10790569b..25578abe017 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.h +++ b/src/server/database/Database/Implementation/HotfixDatabase.h @@ -184,6 +184,9 @@ enum HotfixDatabaseStatements : uint32 HOTFIX_SEL_CHAT_CHANNELS_MAX_ID, HOTFIX_SEL_CHAT_CHANNELS_LOCALE, + HOTFIX_SEL_CHR_CLASS_UI_DISPLAY, + HOTFIX_SEL_CHR_CLASS_UI_DISPLAY_MAX_ID, + HOTFIX_SEL_CHR_CLASSES, HOTFIX_SEL_CHR_CLASSES_MAX_ID, HOTFIX_SEL_CHR_CLASSES_LOCALE, |