diff options
| author | dele <dele@trinity.contrib> | 2013-01-26 18:58:15 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2013-01-26 18:58:15 +0100 |
| commit | 9ae8a1e7cb1c212af1f57b0715ea6bd4efd64959 (patch) | |
| tree | db9a76debad6a9b6e8a06d241848464bf4ab67b6 | |
| parent | 18f5de77c3efb73a781e40a81d3a1438bc1f1b11 (diff) | |
DB/Loot: add missing items to Coren Direbrew
Closes #7297
| -rw-r--r-- | sql/updates/world/2013_01_26_01_world_creature_loot_template.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_26_01_world_creature_loot_template.sql b/sql/updates/world/2013_01_26_01_world_creature_loot_template.sql new file mode 100644 index 00000000000..5d667b99cb5 --- /dev/null +++ b/sql/updates/world/2013_01_26_01_world_creature_loot_template.sql @@ -0,0 +1,5 @@ +-- Coren Direbrew ( http://old.wowhead.com/npc=23872 ) loot fix by dele +DELETE FROM `creature_loot_template` WHERE `entry`=23872 AND `item` IN (38280,38281); +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(23872,38280,100,1,0,1,1), -- Direbrew's Dire Brew Alliance version +(23872,38281,100,1,0,1,1); -- Direbrew's Dire Brew Horde version |