diff options
| author | offl <offl@users.noreply.github.com> | 2020-05-05 00:46:21 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-02 13:50:18 +0100 |
| commit | 7760e9a877f0f28f3c580197ee6c5037e5ab7f93 (patch) | |
| tree | 6eccf323962a54956f01f35a167cc9b23f947b85 /sql | |
| parent | f466bf8b6a3fdd84b5f81814b7b8ccd3e913dca7 (diff) | |
DB/Loot: Petrified Band
Closes #24558
(cherry picked from commit d46cc74f0051c0a776d19293ea758c5512eeaac0)
Diffstat (limited to 'sql')
| -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); |