diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_02_03_world_2020_05_04_03_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_02_03_world_2020_05_04_03_world.sql b/sql/updates/world/master/2022_01_02_03_world_2020_05_04_03_world.sql new file mode 100644 index 00000000000..248bc2e2c6b --- /dev/null +++ b/sql/updates/world/master/2022_01_02_03_world_2020_05_04_03_world.sql @@ -0,0 +1,8 @@ +-- Wiki: This item is a zone drop from the following mobs in Dire Maul: Ironbark Protector, Petrified Guardian, Petrified Treant +-- Chance: http://web.archive.org/web/20100429225237/www.wowhead.com/item=18343 +DELETE FROM `reference_loot_template` WHERE `Entry` = 24016 AND `Item` = 18343; +DELETE FROM `creature_loot_template` WHERE `Item` = 18343; +INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES +(11458,18343,0,0.5,0,1,0,1,1), +(11459,18343,0,0.5,0,1,0,1,1), +(14303,18343,0,0.5,0,1,0,1,1); |