-- == Bosses, normal ==

DELETE FROM `creature_loot_template` WHERE `entry` IN (26763, 26731, 26723, 26794);

-- Anomalus
INSERT 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 Telestra
INSERT 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

-- Keristrasza
INSERT 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-Shaper
INSERT 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 Reference
INSERT 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; -- Anomalus
UPDATE `creature_template` SET `lootid` = 30510 WHERE `entry` = 30510; -- Grand Magus Telestra
UPDATE `creature_template` SET `lootid` = 30540 WHERE `entry` = 30540; -- Keristrasza
UPDATE `creature_template` SET `lootid` = 30532 WHERE `entry` = 30532; -- Ormorok the Tree-Shaper
UPDATE `creature_template` SET `lootid` = 26798 WHERE `entry` = 26798; -- Commander Kolurg
UPDATE `creature_template` SET `lootid` = 26796 WHERE `entry` = 26796; -- Commander Stoutbeard

DELETE FROM `creature_loot_template` WHERE `entry` IN (30529, 30510, 30540, 30532, 26798, 26796);

-- Anomalus
INSERT 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 Telestra
INSERT 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

-- Keristrasza
INSERT 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-Shaper
INSERT 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 Kolurg
INSERT 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 Stoutbeard
INSERT 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 Heroic

INSERT 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