DB/Gameobject: Add loot for some gameobjects

By Malcrom

1 files changed, 112 insertions, 0 deletions

diff --git a/sql/updates/world/6.x/2016_07_31_02_world.sql b/sql/updates/world/6.x/2016_07_31_02_world.sql
new file mode 100644
index 00000000000..1697d307d02
--- /dev/null
+++ b/sql/updates/world/6.x/2016_07_31_02_world.sql
@@ -0,0 +1,112 @@
+-- Add items to gameobject_loot_template
+DELETE FROM `gameobject_loot_template` WHERE `Entry`=39720;
+INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(39720, 22832, 0, 50, 0, 0, 0, 1, 4, 'Gameobject Amani Treasure Box contains Super Mana Potion'),
+(39720, 33865, 0, 100, 0, 0, 0, 1, 1, 'Gameobject Amani Treasure Box contains Amani Hex Stick'),
+(39720, 68729, 0, 20, 0, 0, 0, 1, 1, 'Gameobject Amani Treasure Box contains Elementium Lockbox'),
+(39720, 33930, 0, 25, 0, 0, 1, 1, 1, 'Gameobject Amani Treasure Box contains Amani Charm of the Bloodletter'),
+(39720, 33931, 0, 25, 0, 0, 1, 1, 1, 'Gameobject Amani Treasure Box contains Amani Charm of Mighty Mojo'),
+(39720, 33932, 0, 25, 0, 0, 1, 1, 1, 'Gameobject Amani Treasure Box contains Amani Charm of the Witch Doctor'),
+(39720, 33933, 0, 25, 0, 0, 1, 1, 1, 'Gameobject Amani Treasure Box contains Amani Charm of the Raging Defender'),
+(39720, 24685, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Elementalist Belt'),
+(39720, 24686, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Elementalist Boots'),
+(39720, 24687, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Elementalist Tunic'),
+(39720, 24688, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Elementalist Gloves'),
+(39720, 24689, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Elementalist Skullcap'),
+(39720, 24690, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Elementalist Leggings'),
+(39720, 24691, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Elementalist Mantle'),
+(39720, 24692, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Elementalist Bracelets'),
+(39720, 24798, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Dragonhawk Belt'),
+(39720, 24799, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Dragonhawk Boots'),
+(39720, 24800, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Dragonhawk Tunic'),
+(39720, 24801, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Dragonhawk Gloves'),
+(39720, 24802, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Dragonhawk Hat'),
+(39720, 24803, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Dragonhawk Pants'),
+(39720, 24804, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Dragonhawk Shoulderguards'),
+(39720, 24805, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Dragonhawk Bands'),
+(39720, 24910, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Netherstorm Belt'),
+(39720, 24911, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Netherstorm Greaves'),
+(39720, 24912, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Netherstorm Chestpiece'),
+(39720, 24913, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Netherstorm Gauntlets'),
+(39720, 24914, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Netherstorm Helm'),
+(39720, 24915, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Netherstorm Legguards'),
+(39720, 24916, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Netherstorm Shoulderguards'),
+(39720, 24917, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Netherstorm Bracer'),
+(39720, 25022, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Warlord''s Iron-Girdle'),
+(39720, 25023, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Warlord''s Sabatons'),
+(39720, 25024, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Warlord''s Iron-Breastplate'),
+(39720, 25025, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Warlord''s Iron-Gauntlets'),
+(39720, 25026, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Warlord''s Iron-Helm'),
+(39720, 25027, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Warlord''s Iron-Legplates'),
+(39720, 25028, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Warlord''s Iron-Epaulets'),
+(39720, 25029, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Warlord''s Iron-Vambraces'),
+(39720, 25043, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Amber Cape'),
+(39720, 25057, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Amber Band'),
+(39720, 25071, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Tanzanite Pendant'),
+(39720, 25085, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Dragonscale Shield'),
+(39720, 25099, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Draenei Crystal Rod'),
+(39720, 25113, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Phantom Dagger'),
+(39720, 25127, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Knight''s War Hammer'),
+(39720, 25155, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Iron Skull Sword'),
+(39720, 25169, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Fel Orc Brute Sword'),
+(39720, 25183, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Voodoo Hex-Staff'),
+(39720, 25211, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Rockbiter Cutter'),
+(39720, 25225, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Deepforge Broadaxe'),
+(39720, 25295, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Flawless Wand'),
+(39720, 25309, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Warpdagger'),
+(39720, 25323, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Ascendant''s Scepter'),
+(39720, 55315, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Blackwolf Cloak'),
+(39720, 55369, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Blackwolf Scepter'),
+(39720, 55405, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Blackwolf Amulet'),
+(39720, 55423, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Blackwolf Ring'),
+(39720, 55432, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystalvein Shield'),
+(39720, 55441, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Blackwolf Spellblade'),
+(39720, 55486, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Blackwolf Wand'),
+(39720, 55495, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystalvein Vambraces'),
+(39720, 55504, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystalvein Breastplate'),
+(39720, 55513, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystalvein Sabatons'),
+(39720, 55522, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystalvein Gauntlets'),
+(39720, 55531, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystalvein Helm'),
+(39720, 55540, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystalvein Legplates'),
+(39720, 55549, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystalvein Pauldrons'),
+(39720, 55558, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystalvein Girdle'),
+(39720, 55567, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Talondeep Bracers'),
+(39720, 55576, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Talondeep Vest'),
+(39720, 55585, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Talondeep Greaves'),
+(39720, 55594, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Talondeep Gauntlets'),
+(39720, 55603, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Talondeep Helm'),
+(39720, 55612, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Talondeep Legguards'),
+(39720, 55621, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Talondeep Spaulders'),
+(39720, 55630, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Talondeep Belt'),
+(39720, 55639, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Ravenholdt Bindings'),
+(39720, 55648, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Ravenholdt Jerkin'),
+(39720, 55657, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Ravenholdt Boots'),
+(39720, 55666, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Ravenholdt Gloves'),
+(39720, 55675, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Ravenholdt Hood'),
+(39720, 55684, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Ravenholdt Britches'),
+(39720, 55693, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Ravenholdt Shoulders'),
+(39720, 55702, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Ravenholdt Waistband'),
+(39720, 55711, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Bluefen Wristwraps'),
+(39720, 55720, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Bluefen Robe'),
+(39720, 55729, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Bluefen Sandals'),
+(39720, 55738, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Bluefen Handwraps'),
+(39720, 55747, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Bluefen Cowl'),
+(39720, 55756, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Bluefen Leggings'),
+(39720, 55765, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Bluefen Shoulderpads'),
+(39720, 55774, 0, 1.05, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Bluefen Cord'),
+(39720, 31291, 0, 0.55, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystalforged War Axe'),
+(39720, 31292, 0, 0.55, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Crystal Pulse Shield'),
+(39720, 31293, 0, 0.55, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Girdle of Gale Force'),
+(39720, 31294, 0, 0.55, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Pauldrons of Surging Mana'),
+(39720, 31295, 0, 0.55, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Chestguard of the Dark Stalker'),
+(39720, 31297, 0, 0.55, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Robe of the Crimson Order'),
+(39720, 31298, 0, 0.55, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Legguards of the Shattered Hand'),
+(39720, 31303, 0, 0.55, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains Valanos'' Longbow'),
+(39720, 31304, 0, 0.55, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains The Essence Focuser'),
+(39720, 31308, 0, 0.55, 0, 0, 2, 1, 1, 'Gameobject Amani Treasure Box contains The Bringer of Death');
+
+-- Add items to gameobject_loot_template
+DELETE FROM `gameobject_loot_template` WHERE `Entry` IN (26358,26360);
+INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(26358, 33447, 0, 100, 0, 1, 0, 1, 1, 'Gameobject Sewer Healing Potion contains Loot item Runic Healing Potion'),
+(26360, 33448, 0, 100, 0, 1, 0, 1, 1, 'Gameobject Sewer Mana Potion contains Loot item Runic Mana Potion');