diff options
| author | nelegalno <nelegalno@trinity.contrib> | 2012-01-07 13:40:41 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-01-07 13:40:41 +0100 |
| commit | 307ece42719e669dfabc6f9b2aaf5c4b2ca12b8d (patch) | |
| tree | 719363b82916e12c7e8364e082ab22adaac2138b | |
| parent | db70abdf2d4cdd8007ba4e3c49a8b646777f884d (diff) | |
DB/Loot: Narain's Scrying Goggles should drop 100% from all MC mobs if you are on the quest.
closes #4689
| -rw-r--r-- | sql/updates/world/2012_01_07_04_world_creature_loot_template.sql | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/sql/updates/world/2012_01_07_04_world_creature_loot_template.sql b/sql/updates/world/2012_01_07_04_world_creature_loot_template.sql new file mode 100644 index 00000000000..6855308ed82 --- /dev/null +++ b/sql/updates/world/2012_01_07_04_world_creature_loot_template.sql @@ -0,0 +1,29 @@ +-- Update Narain's Scrying Goggles +SET @Item := 20951; +DELETE FROM `creature_loot_template` WHERE `item`=@Item; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(11502,@Item,-100,1,0,1,1), -- Ragnaros +(11658,@Item,-100,1,0,1,1), -- Molten Giant +(11659,@Item,-100,1,0,1,1), -- Molten Destroyer +(11661,@Item,-100,1,0,1,1), -- Flamewaker +(11662,@Item,-100,1,0,1,1), -- Flamewaker Priest +(11663,@Item,-100,1,0,1,1), -- Flamewaker Healer +(11664,@Item,-100,1,0,1,1), -- Flamewaker Elite +(11665,@Item,-100,1,0,1,1), -- Lava Annihilator +(11666,@Item,-100,1,0,1,1), -- Firewalker +(11667,@Item,-100,1,0,1,1), -- Flameguard +(11669,@Item,-100,1,0,1,1), -- Flame Imp +(11673,@Item,-100,1,0,1,1), -- Ancient Core Hound +(11982,@Item,-100,1,0,1,1), -- Magmadar +(11988,@Item,-100,1,0,1,1), -- Golemagg the Incinerator +(12056,@Item,-100,1,0,1,1), -- Baron Geddon +(12057,@Item,-100,1,0,1,1), -- Garr +(12076,@Item,-100,1,0,1,1), -- Lava Elemental +(12098,@Item,-100,1,0,1,1), -- Sulfuron Harbinger +(12100,@Item,-100,1,0,1,1), -- Lava Reaver +(12101,@Item,-100,1,0,1,1), -- Lava Surger +(12118,@Item,-100,1,0,1,1), -- Lucifron +(12119,@Item,-100,1,0,1,1), -- Flamewaker Protector +(12231,@Item,-100,1,0,1,1), -- Firelord +(12259,@Item,-100,1,0,1,1), -- Gehennas +(12264,@Item,-100,1,0,1,1); -- Shazzrah |