diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2020-07-31 23:45:44 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-24 20:20:16 +0100 |
| commit | 7535be666702dea71fe8e0f34068ef767c0be6ce (patch) | |
| tree | 75fe4dd7baac2a98569951951885472ef42e4a0e | |
| parent | 95d50421daead01da1382558eb22b2355a885849 (diff) | |
DB/Creature: Remove gold and loot from some unlootable creatures
Closes #25070
(cherry picked from commit e3ceffdd1a41238c0242a7c271d9b84ea934ffbe)
| -rw-r--r-- | sql/updates/world/master/2022_01_24_22_world_2020_07_31_24_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_24_22_world_2020_07_31_24_world.sql b/sql/updates/world/master/2022_01_24_22_world_2020_07_31_24_world.sql new file mode 100644 index 00000000000..3b7fcbc1c1a --- /dev/null +++ b/sql/updates/world/master/2022_01_24_22_world_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); |