diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_08_01_04_world.sql | 79 |
1 files changed, 79 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_08_01_04_world.sql b/sql/updates/world/6.x/2016_08_01_04_world.sql new file mode 100644 index 00000000000..6690de7ced0 --- /dev/null +++ b/sql/updates/world/6.x/2016_08_01_04_world.sql @@ -0,0 +1,79 @@ +-- Add items to gameobject_loot_template +DELETE FROM `gameobject_loot_template` WHERE `Entry`=41204; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(41204, 78919, 0, 1, 0, 1, 0, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Experiment 12-B'), +(41204, 77952, 0, 15, 0, 1, 0, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Elementium Gem Cluster'), +(41204, 71998, 0, 50, 0, 1, 0, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Essence of Destruction'), +(41204, 78847, 0, 33.4, 0, 1, 1, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Chest of the Corrupted Conqueror'), +(41204, 78848, 0, 33.3, 0, 1, 1, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Chest of the Corrupted Protector'), +(41204, 78849, 0, 33.3, 0, 1, 1, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Chest of the Corrupted Vanquisher'), +(41204, 78429, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Morningstar of Heroic Will'), +(41204, 78430, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Bracers of Looming Darkness'), +(41204, 78431, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Stillheart Warboots'), +(41204, 78432, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Curled Twilight Claw'), +(41204, 78433, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Ledger of Revolting Rituals'), +(41204, 78434, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Treads of Sordid Screams'), +(41204, 78435, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Imperfect Specimens 27 and 28'), +(41204, 78490, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Infinite Loop'), +(41204, 78493, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Hardheart Ring'), +(41204, 78000, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Cunning of the Cruel'), +(41204, 78001, 0, 5.9, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Windward Heart'), +(41204, 78002, 0, 5.85, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Bone-Link Fetish'), +(41204, 78003, 0, 5.85, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Indomitable Pride'), +(41204, 78491, 0, 5.85, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Signet of Suturing'), +(41204, 78492, 0, 5.85, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Breathstealer Band'), +(41204, 78489, 0, 5.85, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Seal of Primordial Shadow'), +(41204, 77999, 0, 5.85, 0, 1, 2, 1, 1, 'Gameobject Lesser Cache of the Aspects 10 man Heroic contains Vial of Shadows'); + +-- Add items to gameobject_loot_template +DELETE FROM `gameobject_loot_template` WHERE `Entry`=41206; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(41206, 77952, 0, 15, 0, 1, 0, 1, 3, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Elementium Gem Cluster'), +(41206, 71998, 0, 50, 0, 1, 0, 1, 3, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Essence of Destruction'), +(41206, 77974, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Wrath of Unchaining'), +(41206, 77975, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Will of Unbinding'), +(41206, 77976, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Heart of Unliving'), +(41206, 77977, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Eye of Unmaking'), +(41206, 77978, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Resolve of Undying'), +(41206, 77994, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Wrath of Unchaining'), +(41206, 77995, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Will of Unbinding'), +(41206, 77996, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Heart of Unliving'), +(41206, 77997, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Eye of Unmaking'), +(41206, 77998, 0, 10, 0, 1, 1, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Resolve of Undying'), +(41206, 77974, 0, 10, 0, 1, 2, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Wrath of Unchaining'), +(41206, 77975, 0, 10, 0, 1, 2, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Will of Unbinding'), +(41206, 77976, 0, 10, 0, 1, 2, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Heart of Unliving'), +(41206, 77977, 0, 10, 0, 1, 2, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Eye of Unmaking'), +(41206, 77978, 0, 10, 0, 1, 2, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Resolve of Undying'), +(41206, 77994, 0, 10, 0, 1, 2, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Wrath of Unchaining'), +(41206, 77995, 0, 10, 0, 1, 2, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Will of Unbinding'), +(41206, 77996, 0, 10, 0, 1, 2, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Heart of Unliving'), +(41206, 77997, 0, 10, 0, 1, 2, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Eye of Unmaking'), +(41206, 77998, 0, 10, 0, 1, 2, 1, 1, 'Gameobject Greater Cache of the Aspects 10 man Heroic contains Resolve of Undying'); + +-- Add items to gameobject_loot_template +DELETE FROM `gameobject_loot_template` WHERE `Entry`=41207; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(41207, 77067, 0, 1, 0, 1, 0, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Reins of the Blazing Drake'), +(41207, 77069, 0, 1, 0, 1, 0, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Life-Binder''s Handmaiden'), +(41207, 77952, 0, 15, 0, 1, 0, 1, 3, 'Gameobject Elementium Fragment 10 man Heroic contains Elementium Gem Cluster'), +(41207, 71998, 0, 50, 0, 1, 0, 1, 3, 'Gameobject Elementium Fragment 10 man Heroic contains Essence of Destruction'), +(41207, 78352, 0, 100, 1, 1, 0, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Fragment of Deathwing''s Jaw'), +(41207, 78485, 0, 11.20, 0, 1, 1, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Maw of the Dragonlord'), +(41207, 78484, 0, 11.10, 0, 1, 1, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Rathrak, the Poisonous Mind'), +(41207, 78487, 0, 11.10, 0, 1, 1, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Gurthalak, Voice of the Deeps'), +(41207, 78481, 0, 11.10, 0, 1, 1, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains No''Kaled, the Elements of Death'), +(41207, 78482, 0, 11.10, 0, 1, 1, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Kiril, Fury of Beasts'), +(41207, 78483, 0, 11.10, 0, 1, 1, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Blade of the Unmaker'), +(41207, 78480, 0, 11.10, 0, 1, 1, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Vishanka, Jaws of the Earth'), +(41207, 78488, 0, 11.10, 0, 1, 1, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Souldrinker'), +(41207, 78486, 0, 11.10, 0, 1, 1, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Ti''tahk, the Steps of Time'), +(41207, 78485, 0, 11.20, 0, 1, 2, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Maw of the Dragonlord'), +(41207, 78484, 0, 11.10, 0, 1, 2, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Rathrak, the Poisonous Mind'), +(41207, 78487, 0, 11.10, 0, 1, 2, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Gurthalak, Voice of the Deeps'), +(41207, 78481, 0, 11.10, 0, 1, 2, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains No''Kaled, the Elements of Death'), +(41207, 78482, 0, 11.10, 0, 1, 2, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Kiril, Fury of Beasts'), +(41207, 78483, 0, 11.10, 0, 1, 2, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Blade of the Unmaker'), +(41207, 78480, 0, 11.10, 0, 1, 2, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Vishanka, Jaws of the Earth'), +(41207, 78488, 0, 11.10, 0, 1, 2, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Souldrinker'), +(41207, 78486, 0, 11.10, 0, 1, 2, 1, 1, 'Gameobject Elementium Fragment 10 man Heroic contains Ti''tahk, the Steps of Time'); |