diff options
| author | jackpoz <giacomopoz@gmail.com> | 2014-10-20 21:18:39 +0200 |
|---|---|---|
| committer | jackpoz <giacomopoz@gmail.com> | 2014-10-20 19:59:27 +0000 |
| commit | 25d8b493139b0ab0860b5f2640a07ac1bfae0d13 (patch) | |
| tree | 8d2f27486db4d392a4ef02c5b8d3b0f4607627b2 | |
| parent | 26c9d4dc418524c327d0754bb32c6c14375ba527 (diff) | |
Core/AHBot: Filter out from AHBot items that can't be looted
(cherry picked from commit 361d285ba3d42f0b5ec60bbb646d500ef6940488)
| -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 d6626e625a0..3a8292ac495 100644 --- a/src/server/game/AuctionHouseBot/AuctionHouseBotSeller.cpp +++ b/src/server/game/AuctionHouseBot/AuctionHouseBotSeller.cpp @@ -76,17 +76,17 @@ bool AuctionBotSeller::Initialize() TC_LOG_DEBUG("ahbot", "Loading loot items for filter.."); QueryResult result = WorldDatabase.PQuery( - "SELECT `item` FROM `creature_loot_template` UNION " - "SELECT `item` FROM `disenchant_loot_template` UNION " - "SELECT `item` FROM `fishing_loot_template` UNION " - "SELECT `item` FROM `gameobject_loot_template` UNION " - "SELECT `item` FROM `item_loot_template` UNION " - "SELECT `item` FROM `milling_loot_template` UNION " - "SELECT `item` FROM `pickpocketing_loot_template` UNION " - "SELECT `item` FROM `prospecting_loot_template` UNION " - "SELECT `item` FROM `reference_loot_template` UNION " - "SELECT `item` FROM `skinning_loot_template` UNION " - "SELECT `item` FROM `spell_loot_template`"); + "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"); if (result) { |