diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2016-07-30 17:16:24 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-07-30 17:16:24 +0200 |
| commit | 132d4c5b3788f9fd3b3cb17d8748a30e5486add9 (patch) | |
| tree | 45fb9c2766b3414e0063272461a8ca3758d53334 | |
| parent | 2e0dd7a38cb1cc02f87449c2b9f945ffcc622c02 (diff) | |
DB/Gameobject: Add missing loot for a lot of gameobjects
By Malcrom
| -rw-r--r-- | sql/updates/world/6.x/2016_07_30_02_world.sql | 924 |
1 files changed, 924 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_07_30_02_world.sql b/sql/updates/world/6.x/2016_07_30_02_world.sql new file mode 100644 index 00000000000..8a27e2eab01 --- /dev/null +++ b/sql/updates/world/6.x/2016_07_30_02_world.sql @@ -0,0 +1,924 @@ +-- Add items to gameobject_loot_template for Level 1 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39334; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39334, 774, 0, 15, 0, 1, 1, 1, 2, 'Level 1 Treasure Chest contains Loot item Malachite'), +(39334, 818, 0, 15, 0, 1, 1, 1, 2, 'Level 1 Treasure Chest contains Loot item Tigerseye'), +(39334, 1206, 0, 14, 0, 1, 1, 1, 2, 'Level 1 Treasure Chest contains Loot item Moss Agate'), +(39334, 118, 0, 14, 0, 1, 1, 1, 2, 'Level 1 Treasure Chest contains Loot item Minor Healing Potion'), +(39334, 2454, 0, 14, 0, 1, 1, 1, 2, 'Level 1 Treasure Chest contains Loot item Elixir of Lion''s Strength'), +(39334, 3382, 0, 14, 0, 1, 1, 1, 2, 'Level 1 Treasure Chest contains Loot item Weak Troll''s Blood Elixir'), +(39334, 5997, 0, 14, 0, 1, 1, 1, 2, 'Level 1 Treasure Chest contains Loot item Elixir of Minor Defense'), +(39334, 766, 0, 7, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Flanged Mace'), +(39334, 3189, 0, 7, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Wood Chopper'), +(39334, 3190, 0, 7, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Beatstick'), +(39334, 4560, 0, 7, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Fine Scimitar'), +(39334, 4563, 0, 7, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Billy Club'), +(39334, 4565, 0, 7, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Simple Dagger'), +(39334, 4662, 0, 7, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Journeyman''s Cloak'), +(39334, 4671, 0, 6.5, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Ancestral Cloak'), +(39334, 6509, 0, 6.5, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Infantry Belt'), +(39334, 8177, 0, 6.5, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Practice Sword'), +(39334, 8179, 0, 6.5, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Cadet''s Bow'), +(39334, 8181, 0, 6.5, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Hunting Rifle'), +(39334, 8182, 0, 6.5, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Pellet Rifle'), +(39334, 14087, 0, 6.5, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Beaded Cuffs'), +(39334, 15003, 0, 6.5, 0, 1, 2, 1, 1, 'Level 1 Treasure Chest contains Loot item Primal Belt'); + +-- Add items to gameobject_loot_template for Level 10 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39335; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39335, 774, 0, 8.5, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Malachite'), +(39335, 818, 0, 8.5, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Tigerseye'), +(39335, 1206, 0, 8.5, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Moss Agate'), +(39335, 1210, 0, 8.5, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Shadowgem'), +(39335, 858, 0, 8.25, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Lesser Healing Potion'), +(39335, 2455, 0, 8.25, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Minor Mana Potion'), +(39335, 2456, 0, 8.25, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Minor Rejuvenation Potion'), +(39335, 2459, 0, 8.25, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Swiftness Potion'), +(39335, 4596, 0, 8.25, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Discolored Healing Potion'), +(39335, 5631, 0, 8.25, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Rage Potion'), +(39335, 6051, 0, 8.25, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Holy Protection Potion'), +(39335, 6372, 0, 8.25, 0, 0, 1, 1, 3, 'Level 10 Treasure Chest contains Swim Speed Potion'), +(39335, 2972, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Spellbinder Gloves'), +(39335, 2975, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Hunting Boots'), +(39335, 2979, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Veteran Boots'), +(39335, 3207, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Hunting Bracers'), +(39335, 3213, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Veteran Bracers'), +(39335, 3279, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Battle Chain Boots'), +(39335, 3281, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Battle Chain Gloves'), +(39335, 3284, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Tribal Boots'), +(39335, 3286, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Tribal Gloves'), +(39335, 3289, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Ancestral Boots'), +(39335, 3290, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Ancestral Gloves'), +(39335, 3304, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Brackwater Gauntlets'), +(39335, 3311, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Ceremonial Leather Ankleguards'), +(39335, 3312, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Ceremonial Leather Bracers'), +(39335, 3643, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Spellbinder Bracers'), +(39335, 3644, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Barbaric Cloth Bracers'), +(39335, 4677, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Veteran Cloak'), +(39335, 4678, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Veteran Girdle'), +(39335, 4680, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Brackwater Cloak'), +(39335, 4681, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Brackwater Girdle'), +(39335, 4683, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Spellbinder Cloak'), +(39335, 4686, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Barbaric Cloth Cloak'), +(39335, 4687, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Barbaric Cloth Belt'), +(39335, 4689, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Hunting Cloak'), +(39335, 4690, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Hunting Belt'), +(39335, 4692, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Ceremonial Cloak'), +(39335, 4693, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Ceremonial Leather Belt'), +(39335, 6506, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Infantry Boots'), +(39335, 6510, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Infantry Gauntlets'), +(39335, 6515, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Disciple''s Gloves'), +(39335, 6518, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Pioneer Boots'), +(39335, 6549, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Soldier''s Cloak'), +(39335, 6555, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Bard''s Cloak'), +(39335, 7351, 0, 1.75, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Disciple''s Boots'), +(39335, 9742, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Simple Cord'), +(39335, 9743, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Simple Shoes'), +(39335, 9744, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Simple Bands'), +(39335, 9745, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Simple Cape'), +(39335, 9746, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Simple Gloves'), +(39335, 9750, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Gypsy Sash'), +(39335, 9751, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Gypsy Sandals'), +(39335, 9752, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Gypsy Bands'), +(39335, 9754, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Gypsy Cloak'), +(39335, 9755, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Gypsy Gloves'), +(39335, 9760, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Cadet Bracers'), +(39335, 9761, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Cadet Cloak'), +(39335, 9762, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Cadet Gauntlets'), +(39335, 14095, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Native Bands'), +(39335, 14099, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Native Sash'), +(39335, 14102, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Native Handwraps'), +(39335, 14110, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Native Sandals'), +(39335, 14115, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Aboriginal Bands'), +(39335, 14116, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Aboriginal Cape'), +(39335, 15013, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Lupine Cuffs'), +(39335, 15015, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Lupine Cloak'), +(39335, 15297, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Grizzly Bracers'), +(39335, 15300, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Grizzly Gloves'), +(39335, 15301, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Grizzly Slippers'), +(39335, 15302, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Grizzly Belt'), +(39335, 15484, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains War Torn Handgrips'), +(39335, 15490, 0, 1.5, 0, 0, 2, 1, 1, 'Level 10 Treasure Chest contains Bloodspattered Cloak'), +(39335, 2073, 0, 1, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Dwarven Hatchet'), +(39335, 2075, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Heavy Mace'), +(39335, 2078, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Northern Shortsword'), +(39335, 2079, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Sergeant''s Warhammer'), +(39335, 2140, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Carving Knife'), +(39335, 2632, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Curved Dagger'), +(39335, 2961, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Burnt Leather Vest'), +(39335, 2965, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Warrior''s Tunic'), +(39335, 2969, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Spellbinder Vest'), +(39335, 2970, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Spellbinder Pants'), +(39335, 2973, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Hunting Tunic'), +(39335, 2974, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Hunting Pants'), +(39335, 2976, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Hunting Gloves'), +(39335, 2977, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Veteran Armor'), +(39335, 2978, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Veteran Leggings'), +(39335, 2980, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Veteran Gloves'), +(39335, 2982, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Seer''s Pants'), +(39335, 2983, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Seer''s Boots'), +(39335, 2984, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Seer''s Gloves'), +(39335, 2986, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Inscribed Leather Pants'), +(39335, 2987, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Inscribed Leather Boots'), +(39335, 2988, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Inscribed Leather Gloves'), +(39335, 2992, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Burnished Gloves'), +(39335, 3036, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Heavy Shortbow'), +(39335, 3040, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Hunter''s Muzzle Loader'), +(39335, 3184, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Hook Dagger'), +(39335, 3192, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Short Bastard Sword'), +(39335, 3195, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Barbaric Battle Axe'), +(39335, 3196, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Edged Bastard Sword'), +(39335, 3211, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Burnished Bracers'), +(39335, 3282, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Battle Chain Pants'), +(39335, 3283, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Battle Chain Tunic'), +(39335, 3287, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Tribal Pants'), +(39335, 3288, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Tribal Vest'), +(39335, 3291, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ancestral Woollies'), +(39335, 3292, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ancestral Tunic'), +(39335, 3302, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Brackwater Boots'), +(39335, 3307, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Barbaric Cloth Boots'), +(39335, 3308, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Barbaric Cloth Gloves'), +(39335, 3309, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Barbaric Loincloth'), +(39335, 3310, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Barbaric Cloth Vest'), +(39335, 3313, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ceremonial Leather Harness'), +(39335, 3314, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ceremonial Leather Gloves'), +(39335, 3315, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ceremonial Leather Loincloth'), +(39335, 3645, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Seer''s Cuffs'), +(39335, 3651, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Veteran Shield'), +(39335, 3652, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Hunting Buckler'), +(39335, 3653, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ceremonial Buckler'), +(39335, 3654, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Brackwater Shield'), +(39335, 4561, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Scalping Tomahawk'), +(39335, 4564, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Spiked Club'), +(39335, 4566, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Sturdy Quarterstaff'), +(39335, 4567, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Merc Sword'), +(39335, 4569, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Staunch Hammer'), +(39335, 4570, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Birchwood Maul'), +(39335, 4571, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains War Knife'), +(39335, 4575, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Medicine Staff'), +(39335, 4577, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Compact Shotgun'), +(39335, 4695, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Burnished Cloak'), +(39335, 4697, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Burnished Girdle'), +(39335, 4699, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Seer''s Belt'), +(39335, 4701, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Inscribed Cloak'), +(39335, 5069, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Fire Wand'), +(39335, 5071, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Shadow Wand'), +(39335, 5207, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Opaque Wand'), +(39335, 5212, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Blazing Wand'), +(39335, 6266, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Disciple''s Vest'), +(39335, 6267, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Disciple''s Pants'), +(39335, 6268, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Pioneer Tunic'), +(39335, 6269, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Pioneer Trousers'), +(39335, 6336, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Infantry Tunic'), +(39335, 6337, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Infantry Leggings'), +(39335, 6378, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Seer''s Cape'), +(39335, 6379, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Inscribed Leather Belt'), +(39335, 6380, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Inscribed Buckler'), +(39335, 6511, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Journeyman''s Robe'), +(39335, 6512, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Disciple''s Robe'), +(39335, 6531, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Barbaric Cloth Robe'), +(39335, 6537, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Willow Boots'), +(39335, 6539, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Willow Belt'), +(39335, 6540, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Willow Pants'), +(39335, 6541, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Willow Gloves'), +(39335, 6542, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Willow Cape'), +(39335, 6543, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Willow Bracers'), +(39335, 6545, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Soldier''s Armor'), +(39335, 6546, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Soldier''s Leggings'), +(39335, 6548, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Soldier''s Girdle'), +(39335, 6550, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Soldier''s Wristguards'), +(39335, 6551, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Soldier''s Boots'), +(39335, 6553, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bard''s Trousers'), +(39335, 6554, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bard''s Gloves'), +(39335, 6556, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bard''s Bracers'), +(39335, 6557, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bard''s Boots'), +(39335, 6558, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bard''s Belt'), +(39335, 6560, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Soldier''s Shield'), +(39335, 6563, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Shimmering Bracers'), +(39335, 6575, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Defender Cloak'), +(39335, 6585, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Scouting Cloak'), +(39335, 7554, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Willow Branch'), +(39335, 8180, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Hunting Bow'), +(39335, 9747, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Simple Britches'), +(39335, 9749, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Simple Blouse'), +(39335, 9756, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Gypsy Trousers'), +(39335, 9757, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Gypsy Tunic'), +(39335, 9763, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Cadet Leggings'), +(39335, 9764, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Cadet Shield'), +(39335, 9765, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Cadet Vest'), +(39335, 9770, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Greenweave Cloak'), +(39335, 9775, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bandit Cinch'), +(39335, 9776, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bandit Boots'), +(39335, 9777, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bandit Bracers'), +(39335, 9778, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bandit Buckler'), +(39335, 9779, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bandit Cloak'), +(39335, 9780, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bandit Gloves'), +(39335, 9783, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Raider''s Chestpiece'), +(39335, 9784, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Raider''s Boots'), +(39335, 9786, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Raider''s Cloak'), +(39335, 9787, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Raider''s Gauntlets'), +(39335, 9788, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Raider''s Belt'), +(39335, 9789, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Raider''s Legguards'), +(39335, 11965, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Quartz Ring'), +(39335, 14025, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Mystic''s Belt'), +(39335, 14090, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Beaded Britches'), +(39335, 14091, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Beaded Robe'), +(39335, 14094, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Beaded Wraps'), +(39335, 14096, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Native Vest'), +(39335, 14097, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Native Pants'), +(39335, 14113, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Aboriginal Sash'), +(39335, 14114, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Aboriginal Footwraps'), +(39335, 14117, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Aboriginal Gloves'), +(39335, 14119, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Aboriginal Loincloth'), +(39335, 14122, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ritual Bands'), +(39335, 14123, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ritual Cape'), +(39335, 14124, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ritual Gloves'), +(39335, 14129, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ritual Sandals'), +(39335, 14131, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ritual Belt'), +(39335, 14160, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Pagan Bands'), +(39335, 14161, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Pagan Cape'), +(39335, 14166, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Buccaneer''s Bracers'), +(39335, 14167, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Buccaneer''s Cape'), +(39335, 14168, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Buccaneer''s Gloves'), +(39335, 14173, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Buccaneer''s Cord'), +(39335, 14174, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Buccaneer''s Boots'), +(39335, 14364, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Mystic''s Slippers'), +(39335, 14365, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Mystic''s Cape'), +(39335, 14366, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Mystic''s Bracelets'), +(39335, 14367, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Mystic''s Gloves'), +(39335, 14370, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Mystic''s Woolies'), +(39335, 14559, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Prospector''s Sash'), +(39335, 14560, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Prospector''s Boots'), +(39335, 14561, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Prospector''s Cuffs'), +(39335, 14563, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Prospector''s Cloak'), +(39335, 14564, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Prospector''s Mitts'), +(39335, 14722, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains War Paint Anklewraps'), +(39335, 14723, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains War Paint Bindings'), +(39335, 14725, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains War Paint Waistband'), +(39335, 14726, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains War Paint Gloves'), +(39335, 14727, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains War Paint Legguards'), +(39335, 14729, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains War Paint Shield'), +(39335, 14745, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Hulking Cloak'), +(39335, 15010, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Primal Wraps'), +(39335, 15011, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Lupine Cord'), +(39335, 15016, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Lupine Handwraps'), +(39335, 15017, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Lupine Leggings'), +(39335, 15018, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Lupine Vest'), +(39335, 15110, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Rigid Belt'), +(39335, 15112, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Rigid Bracelets'), +(39335, 15114, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Rigid Cape'), +(39335, 15210, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Raider Shortsword'), +(39335, 15222, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Barbed Club'), +(39335, 15248, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Gleaming Claymore'), +(39335, 15268, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Twin-Bladed Axe'), +(39335, 15298, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Grizzly Buckler'), +(39335, 15303, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Grizzly Pants'), +(39335, 15305, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Feral Shoes'), +(39335, 15306, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Feral Bindings'), +(39335, 15310, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Feral Gloves'), +(39335, 15312, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Feral Leggings'), +(39335, 15477, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Charger''s Pants'), +(39335, 15479, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Charger''s Armor'), +(39335, 15485, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains War Torn Pants'), +(39335, 15491, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bloodspattered Gloves'), +(39335, 15492, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bloodspattered Sash'), +(39335, 15493, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bloodspattered Loincloth'), +(39335, 15494, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bloodspattered Shield'), +(39335, 15495, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Bloodspattered Wristbands'), +(39335, 15498, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Outrunner''s Slippers'), +(39335, 15499, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Outrunner''s Cuffs'), +(39335, 15501, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Outrunner''s Cloak'), +(39335, 15502, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Outrunner''s Gloves'), +(39335, 15507, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Grunt''s Bracers'), +(39335, 15508, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Grunt''s Cape'), +(39335, 15510, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Grunt''s Belt'), +(39335, 15925, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Journeyman''s Stave'), +(39335, 15926, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Spellbinder Orb'), +(39335, 15932, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Disciple''s Stein'), +(39335, 15944, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Ancestral Orb'), +(39335, 15945, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Runic Stave'), +(39335, 15970, 0, 0.5, 0, 0, 3, 1, 1, 'Level 10 Treasure Chest contains Native Branch'); + +-- Add items to gameobject_loot_template for Level 20 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39336; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39336, 929, 0, 15, 0, 0, 1, 1, 3, 'Level 20 Treasure Chest contains Healing Potion'), +(39336, 3385, 0, 15, 0, 0, 1, 1, 3, 'Level 20 Treasure Chest contains Lesser Mana Potion'), +(39336, 6048, 0, 14, 0, 0, 1, 1, 3, 'Level 20 Treasure Chest contains Shadow Protection Potion'), +(39336, 1206, 0, 14, 0, 0, 1, 1, 3, 'Level 20 Treasure Chest contains Moss Agate'), +(39336, 1210, 0, 14, 0, 0, 1, 1, 3, 'Level 20 Treasure Chest contains Shadowgem'), +(39336, 1529, 0, 14, 0, 0, 1, 1, 3, 'Level 20 Treasure Chest contains Jade'), +(39336, 1705, 0, 14, 0, 0, 1, 1, 3, 'Level 20 Treasure Chest contains Lesser Moonstone'), +(39336, 720, 0, 3, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Brawler Gloves'), +(39336, 890, 0, 3, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Twisted Chanter''s Staff'), +(39336, 1121, 0, 3, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Feet of the Lynx'), +(39336, 1717, 0, 3, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Double Link Tunic'), +(39336, 2011, 0, 3, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Twisted Sabre'), +(39336, 2059, 0, 3, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Sentry Cloak'), +(39336, 2098, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Double-Barreled Shotgun'), +(39336, 2194, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Diamond Hammer'), +(39336, 2236, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Blackfang'), +(39336, 2800, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Black Velvet Robes'), +(39336, 2878, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Bearded Boneaxe'), +(39336, 2879, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Antipodean Rod'), +(39336, 2911, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Keller''s Girdle'), +(39336, 3021, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Ranger Bow'), +(39336, 3203, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Dense Triangle Mace'), +(39336, 12979, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Firebane Cloak'), +(39336, 12982, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Silver-Linked Footguards'), +(39336, 12983, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Rakzur Club'), +(39336, 12984, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Skycaller'), +(39336, 12985, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Ring of Defense'), +(39336, 12988, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Starsight Tunic'), +(39336, 12989, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Gargoyle''s Bite'), +(39336, 12990, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Razor''s Edge'), +(39336, 12992, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Searing Blade'), +(39336, 12994, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Thorbia''s Gauntlets'), +(39336, 12996, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Band of Purification'), +(39336, 12998, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Magician''s Mantle'), +(39336, 12999, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Drakewing Bands'), +(39336, 13005, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Amy''s Blanket'), +(39336, 13010, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Dreamsinger Legguards'), +(39336, 13011, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Silver-Lined Belt'), +(39336, 13012, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Yorgen Bracers'), +(39336, 13016, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Killmaim'), +(39336, 13024, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Beazel''s Basher'), +(39336, 13031, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Orb of Mistmantle'), +(39336, 13032, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Sword of Corruption'), +(39336, 13041, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Guardian Blade'), +(39336, 13049, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Deanship Claymore'), +(39336, 13057, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Bloodpike'), +(39336, 13062, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Thunderwood'), +(39336, 13079, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Shield of Thorsen'), +(39336, 13094, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains The Queen''s Jewel'), +(39336, 13097, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Thunderbrow Ring'), +(39336, 13099, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Moccasins of the White Hare'), +(39336, 13114, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Troll''s Bane Leggings'), +(39336, 13131, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Sparkleshell Mantle'), +(39336, 13136, 0, 2, 0, 0, 2, 1, 1, 'Level 20 Treasure Chest contains Lil Timmy''s Peashooter'); + +-- Add items to gameobject_loot_template for Level 30 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39337; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39337, 3827, 0, 17, 0, 0, 1, 1, 3, 'Level 30 Treasure Chest contains Mana Potion'), +(39337, 6050, 0, 17, 0, 0, 1, 1, 3, 'Level 30 Treasure Chest contains Frost Protection Potion'), +(39337, 6052, 0, 17, 0, 0, 1, 1, 3, 'Level 30 Treasure Chest contains Nature Protection Potion'), +(39337, 1529, 0, 17, 0, 0, 1, 1, 3, 'Level 30 Treasure Chest contains Jade'), +(39337, 3864, 0, 16, 0, 0, 1, 1, 3, 'Level 30 Treasure Chest contains Citrine'), +(39337, 7909, 0, 16, 0, 0, 1, 1, 3, 'Level 30 Treasure Chest contains Aquamarine'), +(39337, 934, 0, 3, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Stalvan''s Reaper'), +(39337, 936, 0, 3, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Midnight Mace'), +(39337, 1716, 0, 3, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Robe of the Magi'), +(39337, 1726, 0, 3, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Poison-Tipped Bone Spear'), +(39337, 2276, 0, 3, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Swampwalker Boots'), +(39337, 2277, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Necromancer Leggings'), +(39337, 2278, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Forest Tracker Epaulets'), +(39337, 2299, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Burning War Axe'), +(39337, 2877, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Combatant Claymore'), +(39337, 2912, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Claw of the Shadowmancer'), +(39337, 2951, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Ring of the Underwood'), +(39337, 3020, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Enduring Cap'), +(39337, 9395, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Gloves of Old'), +(39337, 9435, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Reticulated Bone Gauntlets'), +(39337, 12974, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains The Black Knight'), +(39337, 13017, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Hellslayer Battle Axe'), +(39337, 13019, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Harpyclaw Short Bow'), +(39337, 13020, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Skystriker Bow'), +(39337, 13025, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Deadwood Sledge'), +(39337, 13037, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Crystalpine Stinger'), +(39337, 13038, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Swiftwind'), +(39337, 13045, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Viscous Hammer'), +(39337, 13048, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Looming Gavel'), +(39337, 13063, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Starfaller'), +(39337, 13081, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Skullance Shield'), +(39337, 13084, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Kaleidoscope Chain'), +(39337, 13087, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains River Pride Choker'), +(39337, 13103, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Pads of the Venom Spider'), +(39337, 13105, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Sutarn''s Ring'), +(39337, 13106, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Glowing Magical Bracelets'), +(39337, 13108, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Tigerstrike Mantle'), +(39337, 13110, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Wolffear Harness'), +(39337, 13119, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Enchanted Kodo Bracers'), +(39337, 13121, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Wing of the Whelpling'), +(39337, 13124, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Ravasaur Scale Boots'), +(39337, 13127, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Frostreaver Crown'), +(39337, 13129, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Firemane Leggings'), +(39337, 13137, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Ironweaver'), +(39337, 13145, 0, 2.5, 0, 0, 2, 1, 1, 'Level 30 Treasure Chest contains Enormous Ogre Belt'); + +-- Add items to gameobject_loot_template for Level 40 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39338; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39338, 3387, 0, 13, 0, 0, 1, 1, 3, 'Level 40 Treasure Chest contains Limited Invulnerability Potion'), +(39338, 9030, 0, 13, 0, 0, 1, 1, 3, 'Level 40 Treasure Chest contains Restorative Potion'), +(39338, 9088, 0, 13, 0, 0, 1, 1, 3, 'Level 40 Treasure Chest contains Gift of Arthas'), +(39338, 9144, 0, 13, 0, 0, 1, 1, 3, 'Level 40 Treasure Chest contains Wildvine Potion'), +(39338, 12190, 0, 12, 0, 0, 1, 1, 3, 'Level 40 Treasure Chest contains Dreamless Sleep Potion'), +(39338, 17349, 0, 12, 0, 0, 1, 1, 3, 'Level 40 Treasure Chest contains Superior Healing Draught'), +(39338, 7909, 0, 12, 0, 0, 1, 1, 3, 'Level 40 Treasure Chest contains Aquamarine'), +(39338, 7910, 0, 12, 0, 0, 1, 1, 3, 'Level 40 Treasure Chest contains Star Ruby'), +(39338, 754, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Shortsword of Vengeance'), +(39338, 1713, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Ankh of Life'), +(39338, 1714, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Necklace of Calisea'), +(39338, 1715, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Polished Jazeraint Armor'), +(39338, 1718, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Basilisk Hide Pants'), +(39338, 1722, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Thornstone Sledgehammer'), +(39338, 2564, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Elven Spirit Claws'), +(39338, 2802, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Blazing Emblem'), +(39338, 2815, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Curve-Bladed Ripper'), +(39338, 4090, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Mug O'' Hurt'), +(39338, 4091, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Widowmaker'), +(39338, 9433, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Forgotten Wraps'), +(39338, 9434, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Elemental Raiment'), +(39338, 13018, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Executioner''s Cleaver'), +(39338, 13026, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Heaven''s Light'), +(39338, 13029, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Umbral Crystal'), +(39338, 13034, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Speedsteel Rapier'), +(39338, 13035, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Serpent Slicer'), +(39338, 13039, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Skull Splitting Crossbow'), +(39338, 13042, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Sword of the Magistrate'), +(39338, 13043, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Blade of the Titans'), +(39338, 13046, 0, 2.5, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Blanchard''s Stout'), +(39338, 13051, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Witchfury'), +(39338, 13058, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Khoo''s Point'), +(39338, 13064, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Jaina''s Firestarter'), +(39338, 13065, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Wand of Allistarj'), +(39338, 13074, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Golem Shard Leggings'), +(39338, 13076, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Giantslayer Bracers'), +(39338, 13082, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Mountainside Buckler'), +(39338, 13088, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Gazlowe''s Charm'), +(39338, 13089, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Skibi''s Pendant'), +(39338, 13095, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Assault Band'), +(39338, 13102, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Cassandra''s Grace'), +(39338, 13112, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Winged Helm'), +(39338, 13115, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Sheepshear Mantle'), +(39338, 13117, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Ogron''s Sash'), +(39338, 13128, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains High Bergg Helm'), +(39338, 13132, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Skeletal Shoulders'), +(39338, 13134, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Belt of the Gladiator'), +(39338, 13138, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains The Silencer'), +(39338, 13139, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Guttbuster'), +(39338, 13199, 0, 2.25, 0, 0, 2, 1, 1, 'Level 40 Treasure Chest contains Crushridge Bindings'); + +-- Add items to gameobject_loot_template for Level 50 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39339; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39339, 7909, 0, 10, 0, 1, 1, 1, 3, 'Level 50 Treasure Chest contains Loot item Aquamarine'), +(39339, 7910, 0, 10, 0, 1, 1, 1, 3, 'Level 50 Treasure Chest contains Loot item Star Ruby'), +(39339, 13443, 0, 10, 0, 1, 1, 1, 3, 'Level 50 Treasure Chest contains Loot item Superior Mana Potion'), +(39339, 13456, 0, 10, 0, 1, 1, 1, 3, 'Level 50 Treasure Chest contains Loot item Greater Frost Protection Potion'), +(39339, 13458, 0, 10, 0, 1, 1, 1, 3, 'Level 50 Treasure Chest contains Loot item Greater Nature Protection Potion'), +(39339, 13459, 0, 10, 0, 1, 1, 1, 3, 'Level 50 Treasure Chest contains Loot item Greater Shadow Protection Potion'), +(39339, 13460, 0, 10, 0, 1, 1, 1, 3, 'Level 50 Treasure Chest contains Loot item Greater Holy Protection Potion'), +(39339, 13462, 0, 10, 0, 1, 1, 1, 3, 'Level 50 Treasure Chest contains Loot item Purification Potion'), +(39339, 17348, 0, 10, 0, 1, 1, 1, 3, 'Level 50 Treasure Chest contains Loot item Major Healing Draught'), +(39339, 20002, 0, 10, 0, 1, 1, 1, 3, 'Level 50 Treasure Chest contains Loot item Greater Dreamless Sleep Potion'), +(39339, 1203, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Aegis of Stormwind'), +(39339, 1607, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Soulkeeper'), +(39339, 1721, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Viking Warhammer'), +(39339, 1973, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Orb of Deception'), +(39339, 4696, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Lapidis Tankard of Tidesippe'), +(39339, 5266, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Eye of Adaegus'), +(39339, 6660, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Julie''s Dagger'), +(39339, 7734, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Six Demon Bag'), +(39339, 8190, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Hanzo Sword'), +(39339, 9402, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Earthborn Kilt'), +(39339, 11302, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Uther''s Strength'), +(39339, 13002, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Lady Alizabeth''s Pendant'), +(39339, 13003, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Lord Alexander''s Battle Axe'), +(39339, 13004, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Torch of Austen'), +(39339, 13007, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Mageflame Cloak'), +(39339, 13008, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Dalewind Trousers'), +(39339, 13009, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Cow King''s Hide'), +(39339, 13013, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Elder Wizard''s Mantle'), +(39339, 13014, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Axe of Rin''ji'), +(39339, 13022, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Gryphonwing Long Bow'), +(39339, 13027, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Bonesnapper'), +(39339, 13030, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Basilisk Bone'), +(39339, 13036, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Assassination Blade'), +(39339, 13040, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Heartseeking Crossbow'), +(39339, 13044, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Demonslayer'), +(39339, 13047, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Twig of the World Tree'), +(39339, 13052, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Warmonger'), +(39339, 13053, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Doombringer'), +(39339, 13056, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Frenzied Striker'), +(39339, 13059, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Stoneraven'), +(39339, 13060, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item The Needler'), +(39339, 13066, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Wyrmslayer Spaulders'), +(39339, 13067, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Hydralick Armor'), +(39339, 13070, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Sapphiron''s Scale Boots'), +(39339, 13072, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Stonegrip Gauntlets'), +(39339, 13073, 0, 2, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Mugthol''s Helm'), +(39339, 13077, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Girdle of Uther'), +(39339, 13085, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Horizon Choker'), +(39339, 13091, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Medallion of Grand Marshal Morris'), +(39339, 13096, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Band of the Hierophant'), +(39339, 13101, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Wolfrunner Shoes'), +(39339, 13111, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Sandals of the Insurgent'), +(39339, 13118, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Serpentine Sash'), +(39339, 13120, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Deepfury Bracers'), +(39339, 13122, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Dark Phantom Cape'), +(39339, 13126, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Battlecaller Gauntlets'), +(39339, 13130, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Windrunner Legguards'), +(39339, 13135, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Lordly Armguards'), +(39339, 13144, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Serenity Belt'), +(39339, 13146, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Shell Launcher Shotgun'), +(39339, 17050, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item Chan''s Imperial Robes'), +(39339, 24222, 0, 1.75, 0, 1, 2, 1, 1, 'Level 50 Treasure Chest contains Loot item The Shadowfoot Stabber'); + +-- Add items to gameobject_loot_template for Level 60 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39340; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39340, 22826, 0, 12.5, 0, 0, 1, 1, 3, 'Level 60 Treasure Chest contains Sneaking Potion'), +(39340, 28101, 0, 12.5, 0, 0, 1, 1, 3, 'Level 60 Treasure Chest contains Unstable Mana Potion'), +(39340, 21929, 0, 12.5, 0, 0, 1, 1, 3, 'Level 60 Treasure Chest contains Flame Spessarite'), +(39340, 23077, 0, 12.5, 0, 0, 1, 1, 3, 'Level 60 Treasure Chest contains Blood Garnet'), +(39340, 23079, 0, 12.5, 0, 0, 1, 1, 3, 'Level 60 Treasure Chest contains Deep Peridot'), +(39340, 23107, 0, 12.5, 0, 0, 1, 1, 3, 'Level 60 Treasure Chest contains Shadow Draenite'), +(39340, 23112, 0, 12.5, 0, 0, 1, 1, 3, 'Level 60 Treasure Chest contains Golden Draenite'), +(39340, 23117, 0, 12.5, 0, 0, 1, 1, 3, 'Level 60 Treasure Chest contains Azure Moonstone'), +(39340, 4696, 0, 3, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Lapidis Tankard of Tidesippe'), +(39340, 5267, 0, 3, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Scarlet Kris'), +(39340, 6622, 0, 3, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Sword of Zeal'), +(39340, 13000, 0, 3, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Staff of Hale Magefire'), +(39340, 13001, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Maiden''s Circle'), +(39340, 13006, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Mass of McGowan'), +(39340, 13013, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Elder Wizard''s Mantle'), +(39340, 13015, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Serathil'), +(39340, 13023, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Eaglehorn Long Bow'), +(39340, 13028, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Bludstone Hammer'), +(39340, 13036, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Assassination Blade'), +(39340, 13075, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Direwing Legguards'), +(39340, 13091, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Medallion of Grand Marshal Morris'), +(39340, 13107, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Magiskull Cuffs'), +(39340, 13113, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Feathermoon Headdress'), +(39340, 13116, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Spaulders of the Unseen'), +(39340, 13123, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Dreamwalker Armor'), +(39340, 13133, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Drakesfire Epaulets'), +(39340, 31136, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Breastplate of Blade Turning'), +(39340, 31137, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Gauntlets of Purification'), +(39340, 31138, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Storm Lord''s Girdle'), +(39340, 31139, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Fist of Reckoning'), +(39340, 31140, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Cloak of Entropy'), +(39340, 31142, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Blade of Trapped Knowledge'), +(39340, 31143, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Shroud of Frenzy'), +(39340, 31145, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Headdress of the Sleeper'), +(39340, 31147, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Pendant of Cunning'), +(39340, 31148, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Demon Hide Spaulders'), +(39340, 31149, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Gloves of Pandemonium'), +(39340, 31150, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Gloves of Piety'), +(39340, 31151, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Girdle of Siege'), +(39340, 31152, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Chestguard of Illumination'), +(39340, 31153, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Axe of the Legion'), +(39340, 31173, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Boots of Savagery'), +(39340, 31175, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Blade Dancer''s Wristguards'), +(39340, 31178, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Amulet of Unstable Power'), +(39340, 31180, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Gauntlets of the Skullsplitter'), +(39340, 31186, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Braxxis'' Staff of Slumber'), +(39340, 31187, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Boots of the Pathfinder'), +(39340, 31190, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains The Dreamer''s Shoulderpads'), +(39340, 31193, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Blade of Unquenched Thirst'), +(39340, 31196, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Amulet of Sanctification'), +(39340, 31200, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Shield of the Wayward Footman'), +(39340, 31202, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Girdle of Divine Blessing'), +(39340, 31204, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains The Gunblade'), +(39340, 31222, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Headdress of Inner Rage'), +(39340, 31226, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Leggings of the Sly'), +(39340, 31230, 0, 2, 0, 0, 2, 1, 1, 'Level 60 Treasure Chest contains Abyss Walker''s Boots'); + +-- Add items to gameobject_loot_template for Level 65 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39341; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39341, 22826, 0, 12.5, 0, 0, 1, 1, 3, 'Level 65 Treasure Chest contains Sneaking Potion'), +(39341, 28101, 0, 12.5, 0, 0, 1, 1, 3, 'Level 65 Treasure Chest contains Unstable Mana Potion'), +(39341, 21929, 0, 12.5, 0, 0, 1, 1, 3, 'Level 65 Treasure Chest contains Flame Spessarite'), +(39341, 23077, 0, 12.5, 0, 0, 1, 1, 3, 'Level 65 Treasure Chest contains Blood Garnet'), +(39341, 23079, 0, 12.5, 0, 0, 1, 1, 3, 'Level 65 Treasure Chest contains Deep Peridot'), +(39341, 23107, 0, 12.5, 0, 0, 1, 1, 3, 'Level 65 Treasure Chest contains Shadow Draenite'), +(39341, 23112, 0, 12.5, 0, 0, 1, 1, 3, 'Level 65 Treasure Chest contains Golden Draenite'), +(39341, 23117, 0, 12.5, 0, 0, 1, 1, 3, 'Level 65 Treasure Chest contains Azure Moonstone'), +(39341, 4696, 0, 3, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Lapidis Tankard of Tidesippe'), +(39341, 5267, 0, 3, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Scarlet Kris'), +(39341, 6622, 0, 3, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Sword of Zeal'), +(39341, 13000, 0, 3, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Staff of Hale Magefire'), +(39341, 13001, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Maiden''s Circle'), +(39341, 13006, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Mass of McGowan'), +(39341, 13013, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Elder Wizard''s Mantle'), +(39341, 13015, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Serathil'), +(39341, 13023, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Eaglehorn Long Bow'), +(39341, 13028, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Bludstone Hammer'), +(39341, 13036, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Assassination Blade'), +(39341, 13075, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Direwing Legguards'), +(39341, 13091, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Medallion of Grand Marshal Morris'), +(39341, 13107, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Magiskull Cuffs'), +(39341, 13113, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Feathermoon Headdress'), +(39341, 13116, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Spaulders of the Unseen'), +(39341, 13123, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Dreamwalker Armor'), +(39341, 13133, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Drakesfire Epaulets'), +(39341, 31136, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Breastplate of Blade Turning'), +(39341, 31137, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Gauntlets of Purification'), +(39341, 31138, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Storm Lord''s Girdle'), +(39341, 31139, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Fist of Reckoning'), +(39341, 31140, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Cloak of Entropy'), +(39341, 31142, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Blade of Trapped Knowledge'), +(39341, 31143, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Shroud of Frenzy'), +(39341, 31145, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Headdress of the Sleeper'), +(39341, 31147, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Pendant of Cunning'), +(39341, 31148, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Demon Hide Spaulders'), +(39341, 31149, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Gloves of Pandemonium'), +(39341, 31150, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Gloves of Piety'), +(39341, 31151, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Girdle of Siege'), +(39341, 31152, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Chestguard of Illumination'), +(39341, 31153, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Axe of the Legion'), +(39341, 31173, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Boots of Savagery'), +(39341, 31175, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Blade Dancer''s Wristguards'), +(39341, 31178, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Amulet of Unstable Power'), +(39341, 31180, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Gauntlets of the Skullsplitter'), +(39341, 31186, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Braxxis'' Staff of Slumber'), +(39341, 31187, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Boots of the Pathfinder'), +(39341, 31190, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains The Dreamer''s Shoulderpads'), +(39341, 31193, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Blade of Unquenched Thirst'), +(39341, 31196, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Amulet of Sanctification'), +(39341, 31200, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Shield of the Wayward Footman'), +(39341, 31202, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Girdle of Divine Blessing'), +(39341, 31204, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains The Gunblade'), +(39341, 31222, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Headdress of Inner Rage'), +(39341, 31226, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Leggings of the Sly'), +(39341, 31230, 0, 2, 0, 0, 2, 1, 1, 'Level 65 Treasure Chest contains Abyss Walker''s Boots'); + +-- Add items to gameobject_loot_template for Level 70 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39342; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39342, 37743, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Legguards of Brutalization'), +(39342, 37744, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Horrorblood Treads'), +(39342, 37745, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Greenhealer''s Garb'), +(39342, 37746, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Helm of the Burning Soul'), +(39342, 37747, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Beneficent Bulwark'), +(39342, 37748, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Winterfall''s Frozen Necklace'), +(39342, 37749, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Shocking Claws'), +(39342, 37751, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Tooga''s Lost Toenail'), +(39342, 37752, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Sandals of Broken Dreams'), +(39342, 37753, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Mendicant''s Robe of Mendacity'), +(39342, 37754, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Shimmersteel Hood'), +(39342, 37755, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Leggings of the Icy Heart'), +(39342, 37756, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Zoe''s Comforting Cape'), +(39342, 37757, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Charlotte''s Chastizing Pauldrons'), +(39342, 37762, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Many-Pocketed Belt'), +(39342, 37763, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Treads of the Purifier'), +(39342, 37764, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Corehound Fang Shoulderpads'), +(39342, 37765, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Leggings of the Water Moccasin'), +(39342, 37766, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Bracers of Unmitigated Larceny'), +(39342, 37772, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Wub''s Electrospike Spaulders'), +(39342, 37773, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Shock-Inducing Girdle'), +(39342, 37774, 0, 2.5, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Leggings of Aqueous Dissolution'), +(39342, 37775, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Helm of the Broken Ram'), +(39342, 37776, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Bracers of Accurate Fire'), +(39342, 37777, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Bracers of Sizzling Heat'), +(39342, 37782, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Gauntlets of the Cheerful Hearth'), +(39342, 37783, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Blood-Tempered Spaulders'), +(39342, 37785, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Girdle of the Howling Berserker'), +(39342, 37786, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Legguards of the Forlorn Seas'), +(39342, 37787, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Greathelm of the Unyielding Bull'), +(39342, 37795, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Grips of the Valiant Champion'), +(39342, 37796, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Earthbound Cape'), +(39342, 37802, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Elanor''s Edge'), +(39342, 37803, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Lola''s Lifegiving Branch'), +(39342, 37805, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Melia''s Magnificent Scepter'), +(39342, 37807, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Lydia''s Sharpened Swordbreaker'), +(39342, 37811, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Captain Carver''s Persuader'), +(39342, 37813, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Banner Slicer'), +(39342, 37817, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Branch of Sinful Reprieve'), +(39342, 37819, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Milan''s Mastercraft Band'), +(39342, 37820, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Worgen''s Ring of Revitalization'), +(39342, 37821, 0, 2.25, 0, 0, 1, 1, 1, 'Level 70 Treasure Chest contains Raine''s Signet of Blasting'), +(39342, 39671, 0, 50, 0, 0, 2, 1, 3, 'Level 70 Treasure Chest contains Resurgent Healing Potion'), +(39342, 40067, 0, 50, 0, 0, 2, 1, 3, 'Level 70 Treasure Chest contains Icy Mana Potion'), +(39342, 41777, 0, 17, 0, 0, 3, 1, 1, 'Level 70 Treasure Chest contains Design: Etched Twilight Opal'), +(39342, 41780, 0, 17, 0, 0, 3, 1, 1, 'Level 70 Treasure Chest contains Design: Champion''s Monarch Topaz'), +(39342, 41784, 0, 17, 0, 0, 3, 1, 1, 'Level 70 Treasure Chest contains Design: Sovereign Twilight Opal'), +(39342, 41786, 0, 17, 0, 0, 3, 1, 1, 'Level 70 Treasure Chest contains Design: Destructive Skyflare Diamond'), +(39342, 41788, 0, 16, 0, 0, 3, 1, 1, 'Level 70 Treasure Chest contains Design: Beaming Earthsiege Diamond'), +(39342, 41789, 0, 16, 0, 0, 3, 1, 1, 'Level 70 Treasure Chest contains Design: Inscribed Monarch Topaz'); + +-- Add items to gameobject_loot_template for Level 75 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39343; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39343, 45912, 0, 10, 0, 0, 0, 1, 1, 'Level 75 Treasure Chest contains Book of Glyph Mastery'), +(39343, 40081, 0, 12, 0, 0, 1, 1, 3, 'Level 75 Treasure Chest contains Potion of Nightmares'), +(39343, 40087, 0, 11, 0, 0, 1, 1, 3, 'Level 75 Treasure Chest contains Powerful Rejuvenation Potion'), +(39343, 40211, 0, 11, 0, 0, 1, 1, 3, 'Level 75 Treasure Chest contains Potion of Speed'), +(39343, 40212, 0, 11, 0, 0, 1, 1, 3, 'Level 75 Treasure Chest contains Potion of Wild Magic'), +(39343, 40213, 0, 11, 0, 0, 1, 1, 3, 'Level 75 Treasure Chest contains Mighty Arcane Protection Potion'), +(39343, 40214, 0, 11, 0, 0, 1, 1, 3, 'Level 75 Treasure Chest contains Mighty Fire Protection Potion'), +(39343, 40215, 0, 11, 0, 0, 1, 1, 3, 'Level 75 Treasure Chest contains Mighty Frost Protection Potion'), +(39343, 40216, 0, 11, 0, 0, 1, 1, 3, 'Level 75 Treasure Chest contains Mighty Nature Protection Potion'), +(39343, 40217, 0, 11, 0, 0, 1, 1, 3, 'Level 75 Treasure Chest contains Mighty Shadow Protection Potion'), +(39343, 41777, 0, 12, 0, 0, 2, 1, 1, 'Level 75 Treasure Chest contains Design: Etched Twilight Opal'), +(39343, 41778, 0, 11, 0, 0, 2, 1, 1, 'Level 75 Treasure Chest contains Design: Resolute Monarch Topaz'), +(39343, 41780, 0, 11, 0, 0, 2, 1, 1, 'Level 75 Treasure Chest contains Design: Champion''s Monarch Topaz'), +(39343, 41783, 0, 11, 0, 0, 2, 1, 1, 'Level 75 Treasure Chest contains Design: Purified Twilight Opal'), +(39343, 41784, 0, 11, 0, 0, 2, 1, 1, 'Level 75 Treasure Chest contains Design: Sovereign Twilight Opal'), +(39343, 41786, 0, 11, 0, 0, 2, 1, 1, 'Level 75 Treasure Chest contains Design: Destructive Skyflare Diamond'), +(39343, 41787, 0, 11, 0, 0, 2, 1, 1, 'Level 75 Treasure Chest contains Design: Thundering Skyflare Diamond'), +(39343, 41788, 0, 11, 0, 0, 2, 1, 1, 'Level 75 Treasure Chest contains Design: Beaming Earthsiege Diamond'), +(39343, 41789, 0, 11, 0, 0, 2, 1, 1, 'Level 75 Treasure Chest contains Design: Inscribed Monarch Topaz'), +(39343, 37758, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Raine''s Choker of Combustion'), +(39343, 37759, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Rhie-Ay''s Clutching Gauntlets'), +(39343, 37760, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Cracklefire Wristguards'), +(39343, 37761, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Shimmerthread Girdle'), +(39343, 37767, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Ryft''s Deathgaze'), +(39343, 37768, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Leggings of Violent Exsanguination'), +(39343, 37769, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Gnarled Shovelhorn Spaulders'), +(39343, 37770, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Bulge-Concealing Breastplate'), +(39343, 37771, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Wristguards of Verdant Recovery'), +(39343, 37778, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Girdle of Unerring Flight'), +(39343, 37779, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Nixod''s Chain-Threshed Spaulders'), +(39343, 37780, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Condor-Bone Chestguard'), +(39343, 37781, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Grips of the Warming Heart'), +(39343, 37789, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Gauntlets of Disembowelment'), +(39343, 37790, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Belt of Crystalline Tears'), +(39343, 37792, 0, 4, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Agin''s Crushing Carapace'), +(39343, 37793, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Skullcage of Eternal Terror'), +(39343, 37794, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Torta''s Oversized Choker'), +(39343, 37797, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Cloak of the Agile Mind'), +(39343, 37804, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Bloodwood Greatstaff'), +(39343, 37806, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Zabra''s Misplaced Staff'), +(39343, 37808, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Dragonjaw Mauler'), +(39343, 37809, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Roc-Feather Longbow'), +(39343, 37810, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Blade-Binding Bulwark'), +(39343, 37812, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Petrified Ironwood Smasher'), +(39343, 37822, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Twisted Puzzle-Ring'), +(39343, 37823, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Draconic Choker of Ferocity'), +(39343, 37824, 0, 3, 0, 0, 3, 1, 1, 'Level 75 Treasure Chest contains Gwyneth''s Runed Dragonwand'); + +-- Add items to gameobject_loot_template for Level 80 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39344; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39344, 66641, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Vonica''s Gauntlets'), +(39344, 66879, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Bottled Lightning'), +(39344, 66880, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Potentate''s Letter Opener'), +(39344, 66882, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Skeletalized Shoulderpads'), +(39344, 66883, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Vertigo Cloak'), +(39344, 66895, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Don Gonzales'' Shiny Shield'), +(39344, 66904, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Gartic''s Resplendent Leggings'), +(39344, 66916, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Delicate Blade of Meaning'), +(39344, 66952, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Belmont''s Vampire Hacker'), +(39344, 66953, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Snub-Nosed Pistol'), +(39344, 66956, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Trek''s Shiv'), +(39344, 66957, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Poison Vial Ring'), +(39344, 66959, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Toraelian Spaulders'), +(39344, 66960, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Dirk''s Command'), +(39344, 66962, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Shadowskulk Leggings'), +(39344, 66963, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Treads of the Wyrmhunter'), +(39344, 66977, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Pauldrons of Toil'), +(39344, 66978, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Rage-Possessed Greatsword'), +(39344, 66979, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Bracers of Bloody Business'), +(39344, 66980, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Girdle of Heated Deeds'), +(39344, 66981, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Axe of the Deadly Price'), +(39344, 66982, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Greaves of the Outcast Knight'), +(39344, 66983, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Helm of Fatal Vision'), +(39344, 66984, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Eye of Heaven'), +(39344, 67024, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Breastplate of Solemn Vows'), +(39344, 67027, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Ring of Cursed Fate'), +(39344, 67029, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Death Pyre Mace'), +(39344, 67032, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Firm-Set Treads'), +(39344, 67037, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Binding Promise'), +(39344, 67040, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Amulet of the Howling Watch'), +(39344, 67043, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Greaves of Sullen Earth'), +(39344, 67045, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Abatement Cannon'), +(39344, 67047, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Band of Pleasant Pain'), +(39344, 67098, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Sealing Heartstaff'), +(39344, 67103, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Belt of Redeemed Fate'), +(39344, 67104, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Torchlight Wand'), +(39344, 67105, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Elementbinder Grips'), +(39344, 67109, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Gauntlets of Chattering Valves'), +(39344, 67111, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Soulsurge Necklace'), +(39344, 67114, 0, 2.5, 0, 0, 1, 1, 1, 'Level 80 Treasure Chest contains Girdle of Chained Thunder'); + +-- Add items to gameobject_loot_template for Level 83 Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=39345; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(39345, 66919, 0, 3, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Robes of Whispering Sands'), +(39345, 66920, 0, 3, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Cyu''s Ornate Wand'), +(39345, 66924, 0, 3, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Petrified Camel Haunch'), +(39345, 66931, 0, 3, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Mercury-Coated Hood'), +(39345, 66932, 0, 3, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Kuang''s Locket of Secrets'), +(39345, 66940, 0, 3, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Staff of Solemn Secrecy'), +(39345, 66941, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Triple-Loop Belt'), +(39345, 66942, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Immaculate Br''etc Signet'), +(39345, 66964, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Sand Tracker''s Spear'), +(39345, 66965, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Drape of Fiery Dreams'), +(39345, 66966, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Elekk-Horn Waistguard'), +(39345, 66967, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Camelhide Treads'), +(39345, 66968, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Lhakaz''s Swiftblade'), +(39345, 66969, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Heart of the Vile'), +(39345, 66970, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Safecracker''s Gloves'), +(39345, 66971, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Highland Padded Leggings'), +(39345, 66973, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Ravenheart Longbow'), +(39345, 66974, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Nightrend Choker'), +(39345, 66975, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Hood of the Crying Rogue'), +(39345, 66976, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Spaulders of the Savage Beast'), +(39345, 66987, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Band of the Virtuous'), +(39345, 66989, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Endwyn''s Flickering Gauntlets'), +(39345, 66990, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Downfall Hammer'), +(39345, 66991, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Cloak of Rich Anger'), +(39345, 66992, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Harbinger''s Breastplate'), +(39345, 66994, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Soul''s Anguish'), +(39345, 67050, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Ben-Son''s Royal Crown'), +(39345, 67051, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Blood Gout Amulet'), +(39345, 67052, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Loyal Blade'), +(39345, 67057, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Oath-Bound Gauntlets'), +(39345, 67061, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Bulwark of the Scorned Man'), +(39345, 67067, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Belt of Guardianship'), +(39345, 67069, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Shade of Death'), +(39345, 67071, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Staff of Old Woes'), +(39345, 67115, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Soulheart Bindings'), +(39345, 67116, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Heartbinder Ring'), +(39345, 67117, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Woundsealer Spaulders'), +(39345, 67118, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Electrospark Heartstarter'), +(39345, 67119, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Thousand Bandage Drape'), +(39345, 67120, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Mace of Apotheosis'), +(39345, 67121, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Chestguard of the Caring Ursine'), +(39345, 67122, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Helm of Holy Visions'), +(39345, 67123, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Sinman''s Helm of Succor'), +(39345, 67124, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Zulian Swirling Shield'), +(39345, 67125, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Bone-Inlaid Sarcophagus Key'), +(39345, 67126, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Roffle''s Ruffly Gloves'), +(39345, 67127, 0, 2, 0, 0, 1, 1, 1, 'Level 83 Treasure Chest contains Bracers of Caustic Purification'); + +-- Add items to gameobject_loot_template for Darkmoon Treasure Chest +DELETE FROM `gameobject_loot_template` WHERE `Entry`=40419; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(40419, 74034, 0, 95, 0, 0, 2, 1, 1, 'Darkmoon Treasure Chest contains Pit Fighter'), +(40419, 126949, 0, 5, 0, 0, 2, 1, 1, 'Darkmoon Treasure Chest contains Returning Champion'), +(40419, 57191, 0, 18, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Mythical Healing Potion'), +(40419, 57192, 0, 18, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Mythical Mana Potion'), +(40419, 124642, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Draught of Supremacy'), +(40419, 124645, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Draught of Precision'), +(40419, 124646, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Draught of Flexibility'), +(40419, 124647, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Draught of Alacrity'), +(40419, 124648, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Draught of Divergence'), +(40419, 124649, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Draught of Defense'), +(40419, 124650, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Draught of Deftness'), +(40419, 124651, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Draught of Deflection'), +(40419, 124652, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Tincture of Deflection'), +(40419, 124653, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Tincture of Deftness'), +(40419, 124654, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Tincture of Defense'), +(40419, 124655, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Tincture of Divergence'), +(40419, 124656, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Tincture of Alacrity'), +(40419, 124657, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Tincture of Precision'), +(40419, 124658, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Tincture of Flexibility'), +(40419, 124659, 0, 3, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Tincture of Supremacy'), +(40419, 124660, 0, 16, 0, 0, 1, 1, 3, 'Darkmoon Treasure Chest contains Darkmoon Healing Tonic'); + +-- Add items to gameobject_loot_template +DELETE FROM `gameobject_loot_template` WHERE `Entry`=40354; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(40354, 52078, 0, 100, 0, 1, 0, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Chaos Orb'), +(40354, 72839, 0, 8.5, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Cowl of Highborne Sorcerors'), +(40354, 72840, 0, 8.5, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Spaulders of Eternity'), +(40354, 72841, 0, 8.5, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Demonsbane Chestguard'), +(40354, 72842, 0, 8.5, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Annihilan Helm'), +(40354, 72843, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Helm of Power'), +(40354, 72844, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Pit Lord''s Destroyer'), +(40354, 72845, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Mannoroth''s Signet'), +(40354, 72846, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Thornwood Staff'), +(40354, 72847, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Helm of Thorns'), +(40354, 72848, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Legguards of the Legion'), +(40354, 72898, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Foul Gift of the Demon Lord'), +(40354, 72899, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Minor Cache of the Aspects contains Loot item Varo''then''s Brooch'); + +-- Add items to gameobject_loot_template +DELETE FROM `gameobject_loot_template` WHERE `Entry`=34868; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(34868, 785, 0, 33.4, 0, 1, 1, 1, 3, 'Gameobject Frozen Herb contains Loot item Mageroyal'), +(34868, 2450, 0, 33.35, 0, 1, 1, 1, 3, 'Gameobject Frozen Herb contains Loot item Briarthorn'), +(34868, 2453, 0, 33.35, 0, 1, 1, 1, 3, 'Gameobject Frozen Herb contains Loot item Bruiseweed'); + +-- Add items to gameobject_loot_template +DELETE FROM `gameobject_loot_template` WHERE `Entry`=40346; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(40346, 52078, 0, 100, 0, 1, 0, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Chaos Orb'), +(40346, 72816, 0, 8.5, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Distortion Greaves'), +(40346, 72817, 0, 8.5, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Time Altered Legguards'), +(40346, 72818, 0, 8.5, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Breastplate of Tarnished Bronze'), +(40346, 72819, 0, 8.5, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Chrono Boots'), +(40346, 72820, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Crown of Epochs'), +(40346, 72821, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Temporal Pauldrons'), +(40346, 72822, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Jagged Edge of Time'), +(40346, 72823, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Timeway Headgear'), +(40346, 72824, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Time Twisted Tunic'), +(40346, 72825, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Mantle of Time'), +(40346, 72826, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Robes of Fate'), +(40346, 72897, 0, 8.25, 0, 1, 1, 1, 1, 'Gameobject Murozond''s Temporal Cache contains Loot item Arrow of Time'); + +-- Add items to gameobject_loot_template for Gameobject Royal Cache +DELETE FROM `gameobject_loot_template` WHERE `Entry`=40353; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(40353, 72833, 0, 16.75, 0, 1, 1, 1, 1, 'Gameobject Royal Cache contains Loot item Scepter of Azshara'), +(40353, 72834, 0, 16.65, 0, 1, 1, 1, 1, 'Gameobject Royal Cache contains Loot item Breastplate of the Queen''s Guard'), +(40353, 72835, 0, 16.65, 0, 1, 1, 1, 1, 'Gameobject Royal Cache contains Loot item Puppeteer''s Pantaloons'), +(40353, 72836, 0, 16.65, 0, 1, 1, 1, 1, 'Gameobject Royal Cache contains Loot item Slippers of Wizardry'), +(40353, 72837, 0, 16.65, 0, 1, 1, 1, 1, 'Gameobject Royal Cache contains Loot item Queen''s Boon'), +(40353, 72838, 0, 16.65, 0, 1, 1, 1, 1, 'Gameobject Royal Cache contains Loot item Cloak of the Royal Protector'); |