From e3ceffdd1a41238c0242a7c271d9b84ea934ffbe Mon Sep 17 00:00:00 2001
From: offl <11556157+offl@users.noreply.github.com>
Date: Fri, 31 Jul 2020 23:45:44 +0300
Subject: DB/Creature: Remove gold and loot from some unlootable creatures

Closes #25070
---
 sql/updates/world/3.3.5/2020_07_31_24_world.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2020_07_31_24_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/3.3.5/2020_07_31_24_world.sql b/sql/updates/world/3.3.5/2020_07_31_24_world.sql
new file mode 100644
index 00000000000..3b7fcbc1c1a
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_07_31_24_world.sql
@@ -0,0 +1,6 @@
+-- Remove gold from unkillable, unused, trigger creatures or from summoned creatures (Imp Minion) or if creature should not drop gold
+UPDATE `creature_template` SET `mingold` = 0, `maxgold` = 0 WHERE `entry` IN (12922,1921,5671,39019,39092,37990,37558,27124,35074,36715,38211,38595,14242,17435,1262,14557,20157,4270,20002,24004,24003,12904,4449,4445,20157,19477,11669);
+-- Fleeing Dreghood Warrior & Fleeing Dreghood Geomancer cannot be killed, they just are friendly copies of killable creatures
+-- Flame Imp should not have loot table https://www.wowhead.com/npc=11669/flame-imp#comments https://classic.wowhead.com/npc=11669/flame-imp#comments
+UPDATE `creature_template` SET `lootid` = 0 WHERE `entry` IN (20157,19477,11669);
+DELETE FROM `creature_loot_template` WHERE `Entry` IN (20157,19477,11669);
-- 
cgit v1.2.3