rendered paste body-- == Bosses, normal ==DELETE FROM `creature_loot_template` WHERE `entry` IN (26763, 26731, 26723, 26794);-- AnomalusINSERT INTO `creature_loot_template` VALUES(26763, 35598, 29, 0, 1, 1, 0, 0, 0), -- Tome of the Lore Keepers(26763, 35599, 31, 0, 1, 1, 0, 0, 0), -- Gauntlets of Serpent Scales(26763, 35600, 29, 0, 1, 1, 0, 0, 0), -- Cleated Ice Boots(26763, 50001, 100, 1, -50001, 1, 0, 0, 0); -- The Nexus Boss Reference-- Grand Magus TelestraINSERT INTO `creature_loot_template` VALUES(26731, 35604, 29, 0, 1, 1, 0, 0, 0), -- Insulating Bindings(26731, 35605, 29, 0, 1, 1, 0, 0, 0), -- Belt of Draconic Runes(26731, 35617, 29, 0, 1, 1, 0, 0, 0), -- Wand of Shimmering Scales(26731, 21524, 16, 0, 1, 1, 0, 0, 0), -- Red Winter Hat(26731, 50001, 100, 1, -50001, 1, 0, 0, 0); -- The Nexus Boss Reference-- KeristraszaINSERT INTO `creature_loot_template` VALUES(26723, 35595, 30, 0, 1, 1, 0, 0, 0), -- Glacier Sharpened Vileblade(26723, 35596, 30, 0, 1, 1, 0, 0, 0), -- Attuned Crystalline Boots(26723, 35597, 30, 0, 1, 1, 0, 0, 0), -- Band of Glittering Permafrost(26723, 50001, 100, 1, -50001, 1, 0, 0, 0); -- The Nexus Boss Reference-- Ormorok the Tree-ShaperINSERT INTO `creature_loot_template` VALUES(26794, 43228, 17, 0, 1, 1, 0, 0, 0), -- Stone Keeper's Shard(26794, 35601, 33, 0, 1, 1, 0, 0, 0), -- Drakonid Arm Blade(26794, 35602, 30, 0, 1, 1, 0, 0, 0), -- Chiseled Stalagmite Pauldrons(26794, 35603, 32, 0, 1, 1, 0, 0, 0), -- Greaves of the Blue Flight(26794, 37701, 7, 0, 1, 8, 0, 0, 0); -- Crystallized Earth-- The Nexus Boss ReferenceINSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES(50001, 43228, 44, 0, 1, 1, 0, 0, 0), -- Stone Keeper's Shard(50001, 33454, 1.5, 0, 1, 1, 0, 0, 0), -- Salted Venison(50001, 33470, 6, 0, 1, 7, 0, 0, 0), -- Frostweave Cloth(50001, 43852, 1.8, 0, 1, 1, 0, 0, 0); -- Thick Fur Clothing Scraps-- == Bosses, heroic ==UPDATE `creature_template` SET `lootid` = 30529 WHERE `entry` = 30529; -- AnomalusUPDATE `creature_template` SET `lootid` = 30510 WHERE `entry` = 30510; -- Grand Magus TelestraUPDATE `creature_template` SET `lootid` = 30540 WHERE `entry` = 30540; -- KeristraszaUPDATE `creature_template` SET `lootid` = 30532 WHERE `entry` = 30532; -- Ormorok the Tree-ShaperUPDATE `creature_template` SET `lootid` = 26798 WHERE `entry` = 26798; -- Commander KolurgUPDATE `creature_template` SET `lootid` = 26796 WHERE `entry` = 26796; -- Commander StoutbeardDELETE FROM `creature_loot_template` WHERE `entry` IN (30529, 30510, 30540, 30532, 26798, 26796);-- AnomalusINSERT INTO `creature_loot_template` VALUES(30529, 37150, 23, 0, 1, 1, 0, 0, 0), -- Rift Striders(30529, 37144, 22, 0, 1, 1, 0, 0, 0), -- Hauberk of the Arcane Wraith(30529, 37141, 22, 0, 1, 1, 0, 0, 0), -- Amulet of Dazzling Light(30529, 37149, 22, 0, 1, 1, 0, 0, 0), -- Helm of Anomalus(30529, 50002, 100, 1, -50002, 1, 0, 0, 0); -- The Nexus Boss Reference Heroic-- Grand Magus TelestraINSERT INTO `creature_loot_template` VALUES(30510, 21524, 12, 0, 1, 1, 0, 0, 0), -- Red Winter Hat(30510, 37135, 22, 0, 1, 1, 0, 0, 0), -- Arcane-Shielded Helm(30510, 37138, 22, 0, 1, 1, 0, 0, 0), -- Bands of Channeled Energy(30510, 37139, 21, 0, 1, 1, 0, 0, 0), -- Spaulders of the Careless Thief(30510, 37134, 21, 0, 1, 1, 0, 0, 0), -- Telestra's Journal(30510, 50002, 100, 1, -50002, 1, 0, 0, 0); -- The Nexus Boss Reference Heroic-- KeristraszaINSERT INTO `creature_loot_template` VALUES(30540, 43665, 26, 3, 1, 1, 9, 13246, 0), -- Keristrasza's Broken Heart(30540, 43102, 64, 2, 1, 1, 0, 0, 0), -- Frozen Orb(30540, 37162, 20, 4, 1, 1, 0, 0, 0), -- Bulwark of the Noble Protector(30540, 37167, 20, 4, 1, 1, 0, 0, 0), -- Dragon Slayer's Sabatons(30540, 37165, 20, 4, 1, 1, 0, 0, 0), -- Crystal-Infused Tunic(30540, 37166, 20, 4, 1, 1, 0, 0, 0), -- Sphere of Red Dragon's Blood(30540, 37170, 20, 0, 1, 1, 0, 0, 0), -- Interwoven Scale Bracers(30540, 37171, 19, 0, 1, 1, 0, 0, 0), -- Flame-Bathed Steel Girdle(30540, 37172, 19, 0, 1, 1, 0, 0, 0), -- Gloves of Glistening Runes(30540, 37169, 19, 0, 1, 1, 0, 0, 0), -- War Mace of Unrequited Love(30540, 41794, 10, 0, 1, 1, 0, 0, 0), -- Design: Deadly Monarch Topaz(30540, 50002, 100, 1, -50002, 1, 0, 0, 0); -- The Nexus Boss Reference Heroic-- Ormorok the Tree-ShaperINSERT INTO `creature_loot_template` VALUES(30532, 37151, 22, 0, 1, 1, 0, 0, 0), -- Band of Frosted Thorns(30532, 37153, 22, 0, 1, 1, 0, 0, 0), -- Gloves of the Crystal Gardener(30532, 37152, 22, 0, 1, 1, 0, 0, 0), -- Girdle of Ice(30532, 37155, 22, 0, 1, 1, 0, 0, 0), -- Frozen Forest Kilt(30532, 50002, 100, 1, -50002, 1, 0, 0, 0); -- The Nexus Boss Reference Heroic-- Commander KolurgINSERT INTO `creature_loot_template` VALUES(26798, 37728, 21, 0, 1, 1, 0, 0, 0), -- Cloak of the Enemy(26798, 37730, 21, 0, 1, 1, 0, 0, 0), -- Cleric's Linen Shoes(26798, 37731, 20, 0, 1, 1, 0, 0, 0), -- Opposed Stasis Leggings(26798, 37729, 21, 0, 1, 1, 0, 0, 0), -- Grips of Sculptured Icicles(26798, 50002, 100, 1, -50002, 1, 0, 0, 0); -- The Nexus Boss Reference Heroic-- Commander StoutbeardINSERT INTO `creature_loot_template` VALUES(26796, 37728, 21, 0, 1, 1, 0, 0, 0), -- Cloak of the Enemy(26796, 37730, 21, 0, 1, 1, 0, 0, 0), -- Cleric's Linen Shoes(26796, 37731, 20, 0, 1, 1, 0, 0, 0), -- Opposed Stasis Leggings(26796, 37729, 21, 0, 1, 1, 0, 0, 0), -- Grips of Sculptured Icicles(26796, 50002, 100, 1, -50002, 1, 0, 0, 0); -- The Nexus Boss Reference Heroic-- The Nexus Boss Reference HeroicINSERT INTO `reference_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES(50002, 40752, 92, 0, 1, 1, 0, 0, 0), -- Emblem of Heroism(50002, 43228, 45, 1, 4, 4, 0, 0, 0), -- Stone Keeper's Shard(50002, 33454, 1.1, 2, 1, 1, 0, 0, 0), -- Salted Venison(50002, 33470, 4.5, 2, 2, 7, 0, 0, 0), -- Frostweave Cloth(50002, 43852, 2, 0, 2, 1, 0, 0, 0); -- Thick Fur Clothing Scrap