diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-02 17:51:05 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-02 00:22:09 +0100 |
| commit | 676a6449ee89d05e84799a01c6140802dea3e231 (patch) | |
| tree | ac7a9cd3e11129aacb8d83af619085c8052de9ff /sql | |
| parent | 7d49ee81583fc19b073d388b1665ff039f47bebb (diff) | |
DB/Loot: Remove incorrect skinning loot from some creatures
Closes #24538
(cherry picked from commit f7d385abf022b154c74120f83b5e3a11f2d19262)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_01_48_world_2020_05_02_04_world.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_01_48_world_2020_05_02_04_world.sql b/sql/updates/world/master/2022_01_01_48_world_2020_05_02_04_world.sql new file mode 100644 index 00000000000..d5cc5430062 --- /dev/null +++ b/sql/updates/world/master/2022_01_01_48_world_2020_05_02_04_world.sql @@ -0,0 +1,3 @@ +-- They are friendly, summoned pets, mini-pets or cosmetic +UPDATE `creature_template` SET `skinloot` = 0 WHERE `entry` IN (3568,3695,3888,3915,4068,4242,4243,4244,4534,5194,5195,5196,5197,5198,5409,6015,6139,6141,10979,10988,1749,5523,7903,7904,8023,8024,8025,9274,10204,10262,10340,10538,10636,11181,12723,12756,14864,14865,14866,14867,14868,15412,15416,2274,2983,7411,8276,8479,8662,8776,9036,10116,10296,10667,10740,10929,11024,11564,11710,11836,12148,12150,12151,12351,12353,12354,12355,12356,12357,14566,14568,14732,15172,15378,15379,15380,15381,15415,22054); +DELETE FROM `skinning_loot_template` WHERE `Entry` = 15415; |