diff options
| author | Shauren <shauren.trinity@gmail.com> | 2024-08-26 16:09:55 +0200 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2024-08-27 17:21:13 +0200 |
| commit | d451defc22b09ee70e3f96c8443d9afe3e7ec09d (patch) | |
| tree | ee5c7c1d231eab55046c38e7bba4ae57f57fb44e /src/server/game/AuctionHouseBot/AuctionHouseBotSeller.cpp | |
| parent | 51fdfa60554ad597dc91a48718b4ad4aca2e3912 (diff) | |
Core/AHBot: Fix loot query
(cherry picked from commit fbadeeae39891c24cadf62e48ce4ba57b810c1d2)
Diffstat (limited to 'src/server/game/AuctionHouseBot/AuctionHouseBotSeller.cpp')
| -rw-r--r-- | src/server/game/AuctionHouseBot/AuctionHouseBotSeller.cpp | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/src/server/game/AuctionHouseBot/AuctionHouseBotSeller.cpp b/src/server/game/AuctionHouseBot/AuctionHouseBotSeller.cpp index 2d7023cdac9..478e7e19b55 100644 --- a/src/server/game/AuctionHouseBot/AuctionHouseBotSeller.cpp +++ b/src/server/game/AuctionHouseBot/AuctionHouseBotSeller.cpp @@ -75,17 +75,17 @@ bool AuctionBotSeller::Initialize() TC_LOG_DEBUG("ahbot", "Loading loot items for filter.."); QueryResult result = WorldDatabase.PQuery( - "SELECT `item` FROM `creature_loot_template` WHERE `Reference` = 0 UNION " - "SELECT `item` FROM `disenchant_loot_template` WHERE `Reference` = 0 UNION " - "SELECT `item` FROM `fishing_loot_template` WHERE `Reference` = 0 UNION " - "SELECT `item` FROM `gameobject_loot_template` WHERE `Reference` = 0 UNION " - "SELECT `item` FROM `item_loot_template` WHERE `Reference` = 0 UNION " - "SELECT `item` FROM `milling_loot_template` WHERE `Reference` = 0 UNION " - "SELECT `item` FROM `pickpocketing_loot_template` WHERE `Reference` = 0 UNION " - "SELECT `item` FROM `prospecting_loot_template` WHERE `Reference` = 0 UNION " - "SELECT `item` FROM `reference_loot_template` WHERE `Reference` = 0 UNION " - "SELECT `item` FROM `skinning_loot_template` WHERE `Reference` = 0 UNION " - "SELECT `item` FROM `spell_loot_template` WHERE `Reference` = 0"); + "SELECT `item` FROM `creature_loot_template` WHERE `ItemType` = 0 UNION " + "SELECT `item` FROM `disenchant_loot_template` WHERE `ItemType` = 0 UNION " + "SELECT `item` FROM `fishing_loot_template` WHERE `ItemType` = 0 UNION " + "SELECT `item` FROM `gameobject_loot_template` WHERE `ItemType` = 0 UNION " + "SELECT `item` FROM `item_loot_template` WHERE `ItemType` = 0 UNION " + "SELECT `item` FROM `milling_loot_template` WHERE `ItemType` = 0 UNION " + "SELECT `item` FROM `pickpocketing_loot_template` WHERE `ItemType` = 0 UNION " + "SELECT `item` FROM `prospecting_loot_template` WHERE `ItemType` = 0 UNION " + "SELECT `item` FROM `reference_loot_template` WHERE `ItemType` = 0 UNION " + "SELECT `item` FROM `skinning_loot_template` WHERE `ItemType` = 0 UNION " + "SELECT `item` FROM `spell_loot_template` WHERE `ItemType` = 0"); if (result) { |