diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2020-07-31 23:45:44 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-07-31 23:45:44 +0300 |
| commit | e3ceffdd1a41238c0242a7c271d9b84ea934ffbe (patch) | |
| tree | 649f95780563109daf58a86a1300e7ec0e7862d8 | |
| parent | cf21b4a745b3b21c7b2a17403380fc0f9e14acc3 (diff) | |
DB/Creature: Remove gold and loot from some unlootable creatures
Closes #25070
| -rw-r--r-- | sql/updates/world/3.3.5/2020_07_31_24_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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); |