From 7760e9a877f0f28f3c580197ee6c5037e5ab7f93 Mon Sep 17 00:00:00 2001 From: offl Date: Tue, 5 May 2020 00:46:21 +0200 Subject: DB/Loot: Petrified Band Closes #24558 (cherry picked from commit d46cc74f0051c0a776d19293ea758c5512eeaac0) --- .../world/master/2022_01_02_03_world_2020_05_04_03_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/master/2022_01_02_03_world_2020_05_04_03_world.sql (limited to 'sql') 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); -- cgit v1.2.3