DB/Loot: Remove Motes of Shadow from nearly all demons and fix db errors

Closes #24563

1 files changed, 4 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_05_04_05_world.sql b/sql/updates/world/3.3.5/2020_05_04_05_world.sql
new file mode 100644
index 00000000000..44285fc9935
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_04_05_world.sql
@@ -0,0 +1,4 @@
+-- Patch 2.1.0 (2007-05-22): Motes of Shadow now primarily drop from void creatures and have been removed from nearly all demons.
+-- http://web.archive.org/web/20101104070527/www.wowhead.com/item=22577
+DELETE FROM `creature_loot_template` WHERE `Item` = 22577 AND `Entry` IN (16461,16539,16943,16944,16945,16952,17151,17152,17400,18033,18535,18536,18567,18660,18661,18695,18796,18848,19231,19511,19512,19712,19713,19716,19738,19740,19744,19747,19754,19755,19756,19757,19759,19760,19799,19800,19801,19802,19843,19847,19852,19853,19960,19961,19963,19971,19973,19978,19979,19980,20052,20138,20141,20215,20326,20394,20404,20427,20557,20680,20683,20800,20801,20803,20867,20868,20881,20882,20883,20887,20901,20902,20905,20928,20929,20930,21021,21102,21108,21287,21300,21309,21314,21337,21499,21500,21501,21506,21519,21520,21656,21808,21827,21923,21963,22195,22201,22202,22204,22283,22289,22291,22295,22297,22301,22302,22303,22325,22327,22357,22392);
+UPDATE `creature_template` SET `lootid` = 0 WHERE `entry` IN (14122,14826,14884,14965,14986,15067,15068,15101);