diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-05 00:46:21 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-05-05 00:46:21 +0200 |
| commit | d46cc74f0051c0a776d19293ea758c5512eeaac0 (patch) | |
| tree | b0762f84093da7de1b1f3781360faab1a201050a | |
| parent | ec17750fe9ea9f198315bb0803d9b8e022c67769 (diff) | |
DB/Loot: Petrified Band
Closes #24558
| -rw-r--r-- | sql/updates/world/3.3.5/2020_05_04_03_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_05_04_03_world.sql b/sql/updates/world/3.3.5/2020_05_04_03_world.sql new file mode 100644 index 00000000000..248bc2e2c6b --- /dev/null +++ b/sql/updates/world/3.3.5/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); |