From cd5a704fc1629d5f606535b3756195fb311b5ef2 Mon Sep 17 00:00:00 2001 From: Roc13x Date: Wed, 18 Apr 2018 16:41:23 +0100 Subject: Core/Items: Implemented ItemLimitCategoryCondition.db2 (#21835) --- src/server/database/Database/Implementation/HotfixDatabase.cpp | 4 ++++ src/server/database/Database/Implementation/HotfixDatabase.h | 2 ++ 2 files changed, 6 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 2eb4beb7a32..73f48f1285a 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.cpp +++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp @@ -513,6 +513,10 @@ void HotfixDatabaseConnection::DoPrepareStatements() 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); + // ItemLimitCategoryCondition.db2 + PrepareStatement(HOTFIX_SEL_ITEM_LIMIT_CATEGORY_CONDITION, "SELECT ID, AddQuantity, PlayerConditionID, ParentItemLimitCategoryID " + " FROM item_limit_category_condition ORDER BY ID DESC", CONNECTION_SYNCH); + // ItemModifiedAppearance.db2 PrepareStatement(HOTFIX_SEL_ITEM_MODIFIED_APPEARANCE, "SELECT ItemID, ID, ItemAppearanceModifierID, ItemAppearanceID, OrderIndex, " "TransmogSourceTypeEnum FROM item_modified_appearance ORDER BY ID DESC", CONNECTION_SYNCH); diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h index bb56844ddae..42e65d96261 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.h +++ b/src/server/database/Database/Implementation/HotfixDatabase.h @@ -281,6 +281,8 @@ enum HotfixDatabaseStatements : uint32 HOTFIX_SEL_ITEM_LIMIT_CATEGORY, HOTFIX_SEL_ITEM_LIMIT_CATEGORY_LOCALE, + HOTFIX_SEL_ITEM_LIMIT_CATEGORY_CONDITION, + HOTFIX_SEL_ITEM_MODIFIED_APPEARANCE, HOTFIX_SEL_ITEM_PRICE_BASE, -- cgit v1.2.3