diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_08_02_24_world_335.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_08_02_24_world_335.sql b/sql/updates/world/3.3.5/2020_08_02_24_world_335.sql new file mode 100644 index 00000000000..845cd5e0c1a --- /dev/null +++ b/sql/updates/world/3.3.5/2020_08_02_24_world_335.sql @@ -0,0 +1,6 @@ +-- Remove loot from creatures with CREATURE_DIFFICULTYFLAGS_NO_LOOT +UPDATE `creature_template` SET `lootid` = 0, `mingold` = 0, `maxgold` = 0 WHERE `entry` IN (14874,15387,15467,16049,16050,16051,16052,16055,16058,16115,16506,29274,17256,17399,18614,17477,18606,17622,20578,17653,18620,17715,18369,19016,21646,19208,20660,19209,20661,19759,20424,20498,21044,21166,21195,22454,22910,24196,24954,25211,25284,25768,25802,12099,12340,12816,11142,11317,5907,6492,7050,7308,7310,7340,7787,7788,7789,7849,8876,8877,10161,10601,10602,10720); +DELETE FROM `creature_loot_template` WHERE `Entry` IN (14874,15387,15467,16049,16050,16051,16052,16055,16058,16115,16506,17715,18369,19208,19209,19759,20424,20498,21044,21166,21195,22454,22910,24196,24954,25211,25284,25768,25802,12099,12340,12816,11142,11317,5907,6492,7050,7308,7310,7340,7787,7788,7789,7849,8876,8877,10161,10601,10602,10720); + +-- Domesticated Felboar is no longer skinnable +UPDATE `creature_template` SET `skinloot` = 0 WHERE `entry` = 21195; |