diff options
author | Ryan <roc13x@gmail.com> | 2017-09-15 20:23:41 +0100 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2017-09-15 21:23:41 +0200 |
commit | 115dffde983019acb1f167583b60f0ce1aaa90de (patch) | |
tree | 6713a964debd945ef472cdbe86320c330a1e6395 /src/server/database | |
parent | 6eb997394722fcd4b5248646b5abfa185a7ec58f (diff) |
Core/Items: Implement ItemLevelSelector.db2 (#20325)
ItemLevelSelector replaced ITEM_BONUS_ITEM_LEVEL_OVERRIDE in 7.2
Diffstat (limited to 'src/server/database')
-rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.cpp | 3 | ||||
-rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.h | 2 |
2 files changed, 5 insertions, 0 deletions
diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp index 930d215a354..425de74eda7 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.cpp +++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp @@ -490,6 +490,9 @@ void HotfixDatabaseConnection::DoPrepareStatements() "RequiredCurrency2, RequiredCurrency3, RequiredCurrency4, RequiredCurrency5, RequiredArenaSlot, RequiredFactionId, RequiredFactionStanding, " "RequirementFlags, RequiredAchievement FROM item_extended_cost ORDER BY ID DESC", CONNECTION_SYNCH); + // ItemLevelSelector.db2 + PrepareStatement(HOTFIX_SEL_ITEM_LEVEL_SELECTOR, "SELECT ID, ItemLevel FROM item_level_selector ORDER BY ID DESC", CONNECTION_SYNCH); + // ItemLimitCategory.db2 PrepareStatement(HOTFIX_SEL_ITEM_LIMIT_CATEGORY, "SELECT ID, Name, Quantity, Flags FROM item_limit_category ORDER BY ID DESC", CONNECTION_SYNCH); PREPARE_LOCALE_STMT(HOTFIX_SEL_ITEM_LIMIT_CATEGORY, "SELECT ID, Name_lang FROM item_limit_category_locale WHERE locale = ?", CONNECTION_SYNCH); diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h index 88d43f21476..6d987d0f1f2 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.h +++ b/src/server/database/Database/Implementation/HotfixDatabase.h @@ -274,6 +274,8 @@ enum HotfixDatabaseStatements : uint32 HOTFIX_SEL_ITEM_EXTENDED_COST, + HOTFIX_SEL_ITEM_LEVEL_SELECTOR, + HOTFIX_SEL_ITEM_LIMIT_CATEGORY, HOTFIX_SEL_ITEM_LIMIT_CATEGORY_LOCALE, |