-- HP AND LVL FIX
-- Anomalus - 26763
UPDATE `creature_template` SET `maxlevel` = '72', `maxhealth` = '192200' WHERE `entry` =26763;

-- Grand Magus Telestra - 26731
UPDATE `creature_template` SET `maxlevel` = '72', `maxhealth` = '120125' WHERE `entry` =26731;

-- Keristrasza - 26723
UPDATE `creature_template` SET `maxlevel` = '73', `maxhealth` = '248500' WHERE `entry` =26723;

-- Ormorok the Tree-Shaper - 26794
UPDATE `creature_template` SET `maxlevel` = '72', `maxhealth` = '192200' WHERE `entry` =26794;

-- CLEANUP
DELETE FROM `creature_loot_template` WHERE `entry` IN (50006,50007,50008,50009,50010,50011,50012,50013);

-- Grand Magus Telestra
UPDATE `creature_template` SET `LootID`= 50006 WHERE `entry` = 26731;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
-- Normal
(50006, 21524, 9, 0, 0, 1, 0, 0, 0), -- Red Winter Hat
(50006, 35604, 0, 1, 1, 1, 0, 0, 0),
(50006, 35605, 0, 1, 1, 1, 0, 0, 0),
(50006, 35617, 0, 1, 1, 1, 0, 0, 0),
(50006, 200000, 100, 0, -70000, 1, 0, 0, 0);
SET @N_id = 26731;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50010 WHERE `entry` = @H_id;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
-- Heroic
(50010, 21524, 9, 0, 1, 1, 0, 0, 0), -- Red Winter Hat 
/*(50010, 45624, 100, 0, 1, 1, 0, 0, 0), -- Emblem of Conques - P 3.2*/
(50010, 40752, 100, 0, 1, 1, 0, 0, 0), -- Emblem of Heroism - P 3.1.3
(50010, 37138, 0, 1, 1, 1, 0, 0, 0),
(50010, 37139, 0, 1, 1, 1, 0, 0, 0),
(50010, 37135, 0, 1, 1, 1, 0, 0, 0),
(50010, 37134, 0, 1, 1, 1, 0, 0, 0),
(50010, 200001, 100, 0, -70001, 1, 0, 0, 0);

-- Anomalus
UPDATE `creature_template` SET `LootID`= 50007 WHERE `entry` = 26763;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
-- Normal
(50007, 35599, 0, 1, 1, 1, 0, 0, 0),
(50007, 35600, 0, 1, 1, 1, 0, 0, 0),
(50007, 35598, 0, 1, 1, 1, 0, 0, 0),
(50007, 200002, 100, 0, -70000, 1, 0, 0, 0);
SET @N_id = 26763;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50011 WHERE `entry` = @H_id;
DELETE FROM `creature_loot_template` WHERE `entry` = @H_id;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
-- Heroic
/*(50011, 45624, 100, 0, 1, 1, 0, 0, 0), -- Emblem of Conques - P 3.2*/
(50011, 40752, 100, 0, 1, 1, 0, 0, 0), -- Emblem of Heroism - P 3.1.3
(50011, 37150, 0, 1, 1, 1, 0, 0, 0),
(50011, 37144, 0, 1, 1, 1, 0, 0, 0),
(50011, 37149, 0, 1, 1, 1, 0, 0, 0),
(50011, 37141, 0, 1, 1, 1, 0, 0, 0),
(50011, 200003, 100, 2, -70001, 1, 0, 0, 0);

-- Ormorok the Tree-Shaper
UPDATE `creature_template` SET `LootID`= 50008 WHERE `entry` = 26794;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
-- Normal
(50008, 37701, 10, 0, 2, 8, 0, 0, 0),
(50008, 35601, 0, 1, 1, 1, 0, 0, 0),
(50008, 35603, 0, 1, 1, 1, 0, 0, 0),
(50008, 35602, 0, 1, 1, 1, 0, 0, 0),
(50008, 43228, 30, 2, 1, 1, 0, 0, 0);
SET @N_id = 26794;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50012 WHERE `entry` = @H_id;
DELETE FROM `creature_loot_template` WHERE `entry` = @H_id;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
-- Heroic
/*(50012, 45624, 100, 0, 1, 1, 0, 0, 0), -- Emblem of Conquest - P 3.2*/
(50012, 40752, 100, 0, 1, 1, 0, 0, 0), -- Emblem of Heroism - P 3.1.3
(50012, 37151, 0, 1, 1, 1, 0, 0, 0),
(50012, 37153, 0, 1, 1, 1, 0, 0, 0),
(50012, 37152, 0, 1, 1, 1, 0, 0, 0),
(50012, 37155, 0, 1, 1, 1, 0, 0, 0),
(50012, 200004, 100, 2, -70001, 1, 0, 0, 0);

-- Keristrasza
UPDATE `creature_template` SET `LootID`= 50009 WHERE `entry` = 26723;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
-- Normal
(50009, 35595, 0, 1, 1, 1, 0, 0, 0),
(50009, 35596, 0, 1, 1, 1, 0, 0, 0),
(50009, 35597, 0, 1, 1, 1, 0, 0, 0),
(50009, 200005, 100, 0, -70000, 1, 0, 0, 0);
SET @N_id = 26723;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50013 WHERE `entry` = @H_id;
DELETE FROM `creature_loot_template` WHERE `entry` = @H_id;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
-- Heroic
/*(50013, 45624, 100, 0, 1, 1, 0, 0, 0), -- Emblem of Conquest - P 3.2*/
(50013, 40752, 100, 0, 1, 1, 0, 0, 0), -- Emblem of Heroism - P 3.1.3
(50013, 43665, -100, 0, 1, 1, 0, 0, 0),
(50013, 43102, 100, 0, 1, 1, 0, 0, 0),
(50013, 41794, 10, 2, 1, 1, 7, 755, 1),
(50013, 37162, 0, 3, 1, 1, 0, 0, 0),
(50013, 37167, 0, 3, 1, 1, 0, 0, 0),
(50013, 37165, 0, 3, 1, 1, 0, 0, 0),
(50013, 37166, 0, 3, 1, 1, 0, 0, 0),
(50013, 37170, 0, 4, 1, 1, 0, 0, 0),
(50013, 37171, 0, 4, 1, 1, 0, 0, 0),
(50013, 37172, 0, 4, 1, 1, 0, 0, 0),
(50013, 37169, 0, 4, 1, 1, 0, 0, 0),
(50013, 200006, 100, 1, -70001, 1, 0, 0, 0);

-- CLEANUP
DELETE FROM `reference_loot_template` WHERE `entry` IN (70000,70001,70002,70003,70004);

INSERT INTO `reference_loot_template`  (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`) VALUES 
-- Normal
(70000, 33470, 0, 1, 1, 7), -- Frostweave Cloth
(70000, 33454, 0, 1, 1, 1), -- Salted Venison
(70000, 43228, 30, 2, 1, 1),-- Stone Keeper\'s Shard
(70000, 43852, 0, 1, 1, 1), -- Thick Fur Clothing Scraps
-- Heroic
(70001, 33470, 0, 1, 1, 7),  -- Frostweave Cloth
(70001, 43228, 30, 2, 1, 4), -- Stone Keeper\'s Shard
(70001, 43852, 0, 1, 1, 1);  -- Thick Fur Clothing Scraps

-- Trash
INSERT INTO `reference_loot_template`  (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`) VALUES 
-- Normal
(70002, 33470, 0, 1, 1, 7), -- Frostweave Cloth
(70002, 33454, 0, 1, 1, 1), -- Salted Venison
(70002, 33444, 0, 1, 1, 1), -- Pungent Seal Whey
(70002, 22829, 0, 1, 1, 1), -- Super Healing Potion
(70002, 22832, 0, 1, 1, 1), -- Super Mana Potion
-- Heroic
(70003, 33470, 0, 1, 1, 7), -- Frostweave Cloth
(70003, 33454, 0, 1, 1, 1), -- Salted Venison
(70003, 33445, 0, 2, 1, 1), -- Honeymint Tea
(70003, 33447, 0, 2, 1, 1); -- Runic Healing Potion

DELETE FROM `creature_loot_template` WHERE `entry` IN (50000,50001,50002,50003,50004,50005,50014,50015,50016,50017,50018,50019,50020);
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
-- Normal
(50000, 200007, 100, 1, -70002, 1, 0, 0, 0), -- Frostweave Cloth, Salted Venison, Pungent Seal Whey, Super Healing Potion, Super Mana Potion
(50000, 43622, 1, 2, 1, 1, 0, 0, 0), -- Froststeel Lockbox
(50000, 33568, 3, 3, 1, 2, 0, 0, 0), -- Borean Leather
(50000, 43852, 20, 0, 1, 1, 0, 0, 0), -- Thick Fur Clothing Scraps
(50002, 200008, 100, 1, -70002, 1, 0, 0, 0), -- Frostweave Cloth, Salted Venison, Pungent Seal Whey, Super Healing Potion, Super Mana Potion
(50002, 43852, 20, 0, 1, 1, 0, 0, 0), -- Thick Fur Clothing Scraps
(50002, 43622, 1, 0, 1, 1, 0, 0, 0), -- Froststeel Lockbox
(50004, 200009, 100, 1, -70002, 1, 0, 0, 0), -- Frostweave Cloth, Salted Venison, Pungent Seal Whey, Super Healing Potion, Super Mana Potion
(50004, 43852, 20, 0, 1, 1, 0, 0, 0), -- Thick Fur Clothing Scraps
(50004, 33568, 3, 0, 1, 2, 0, 0, 0), -- Borean Leather
(50005, 200010, 100, 1, -70002, 1, 0, 0, 0), -- Frostweave Cloth, Salted Venison, Pungent Seal Whey, Super Healing Potion, Super Mana Potion
(50005, 43852, 20, 0, 1, 1, 0, 0, 0), -- Thick Fur Clothing Scraps
-- Heroic
(50001, 2000011, 100, 1, -70003, 1, 0, 0, 0), -- Frostweave Cloth, Salted Venison, Honeymint Tea, Runic Healing Potion
(50001, 43852, 20, 0, 1, 1, 0, 0, 0), -- Thick Fur Clothing Scraps
(50001, 33568, 3, 2, 1, 2, 0, 0, 0), -- Borean Leather
(50003, 2000012, 100, 1, -70003, 1, 0, 0, 0), -- Frostweave Cloth, Salted Venison, Honeymint Tea, Runic Healing Potion
(50003, 43852, 90, 0, 1, 1, 0, 0, 0); -- Thick Fur Clothing Scraps

-- Normal
UPDATE `creature_template` SET `LootID`= 50000 WHERE `entry` = 26716;
-- Heroic
SET @N_id = 26716;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50001 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26722;
-- Heroic
SET @N_id = 26722;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50003 WHERE `entry` = @H_id; 
-- Normal
UPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26727;
-- Heroic
SET @N_id = 26727;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50003 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26728;
-- Heroic
SET @N_id = 26728;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50003 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26729;
-- Heroic
SET @N_id = 26729;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50003 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50014 WHERE `entry` = 26730;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
(50014, 33546, 0, 1, 1, 4, 0, 0, 0), -- Vicious Fang
(50014, 33547, 0, 1, 1, 5, 0, 0, 0); -- Hardened Claw
-- Heroic
SET @N_id = 26730;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50015 WHERE `entry` = @H_id;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
(50015, 39211, 0, 1, 3, 5, 0, 0, 0), -- Serrated Fang
(50015, 39212, 0, 1, 2, 4, 0, 0, 0); -- Indurate Claw
-- Normal
UPDATE `creature_template` SET `LootID`= 50004 WHERE `entry` = 26734;
-- Heroic
SET @N_id = 26734;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50001 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50004 WHERE `entry` = 26735;
-- Heroic
SET @N_id = 26735;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50001 WHERE `entry` = @H_id;
-- Heroic
UPDATE `creature_template` SET `LootID`= 26737 WHERE `entry` = 26737;
DELETE FROM `creature_loot_template` WHERE `entry` = 26737;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
(26737, 36810, 0, 0, 2, 4, 0, 0, 0), -- Primordial Infusion
(26737, 36809, 0, 0, 2, 4, 0, 0, 0); -- Elemental Husk
-- Heroic
SET @N_id = 26737;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50015 WHERE `entry` = @H_id;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
(50015, 39512, 0, 1, 2, 4, 0, 0, 0), -- Hoary Crystals
(50015, 39513, 0, 1, 2, 4, 0, 0, 0); -- Efflorescing Shards
-- Normal
UPDATE `creature_template` SET `LootID`= 26782 WHERE `entry` = 26782;
DELETE FROM `creature_loot_template` WHERE `entry` = 26782;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
(26782, 39516, 0, 1, 1, 1, 0, 0, 0), -- Frosty Mushroom
(26782, 33452, 0, 2, 1, 1, 0, 0, 0), -- Honey-Spiced Lichen
(26782, 33376, 0, 1, 1, 1, 0, 0, 0), -- Fur-Lined Gloves
(26782, 33378, 0, 1, 1, 1, 0, 0, 0), -- Fur-Lined Shoulderpads
(26782, 33393, 0, 1, 1, 1, 0, 0, 0), -- Icy Mail Bracers
(26782, 33358, 0, 1, 1, 1, 0, 0, 0), -- Thread-Bare Cloth Belt
(26782, 43622, 1, 0, 1, 1, 0, 0, 0); -- Froststeel Lockbox
-- Heroic
SET @N_id = 26782;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50016 WHERE `entry` = @H_id;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
(50016, 39516, 0, 1, 1, 1, 0, 0, 0), -- Frosty Mushroom
(50016, 33452, 1, 0, 1, 1, 0, 0, 0), -- Honey-Spiced Lichen
(50016, 33429, 0, 1, 1, 1, 0, 0, 0), -- Ice Cleaver
(50016, 33427, 0, 1, 1, 1, 0, 0, 0), -- Frost-Encrusted Rifle
(50016, 33422, 0, 1, 1, 1, 0, 0, 0), -- Shattered Bow
(50016, 33423, 0, 1, 1, 1, 0, 0, 0), -- Rime-Covered Mace
(50016, 33430, 0, 1, 1, 1, 0, 0, 0); -- Abandoned Greatsword
-- Normal
UPDATE `creature_template` SET `LootID`= 50017 WHERE `entry` = 26792;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
(50017, 35490, -100, 0, 1, 2, 0, 0, 0); -- Quest Item, Arcane Splinter
-- Heroic
SET @N_id = 26792;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50018 WHERE `entry` = @H_id;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES 
(50018, 35490, -100, 0, 1, 2, 0, 0, 0), -- Quest Item, Arcane Splinter
(50018, 39516, 1, 1, 1, 1, 0, 0, 0), -- Frosty Mushroom
(50018, 35947, 1, 0, 1, 1, 0, 0, 0); -- Sparkling Frostcap
-- Normal
UPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26799;
-- Heroic
SET @N_id = 26799;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50003 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50005 WHERE `entry` = 26800;
-- Heroic
SET @N_id = 26800;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50003 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26802;
-- Heroic
SET @N_id = 26802;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50003 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50005 WHERE `entry` = 26803;
-- Heroic
SET @N_id = 26803;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50003 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50005 WHERE `entry` = 26805;
-- Heroic
SET @N_id = 26805;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50003 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50005 WHERE `entry` = 27947;
-- Heroic
SET @N_id = 27947;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50003 WHERE `entry` = @H_id;
-- Normal
UPDATE `creature_template` SET `LootID`= 50005 WHERE `entry` = 27949;
-- Normal
UPDATE `creature_template` SET `LootID`= 50019 WHERE `entry` = 28231;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`) VALUES 
(50019, 43622, 1, 0, 1, 1), -- Froststeel Lockbox
(50019, 33364, 0, 1, 1, 1), -- Thread-Bare Cloth Vest
(50019, 33404, 0, 1, 1, 1), -- Ice-Bound Plate Belt
(50019, 33363, 0, 1, 1, 1), -- Thread-Bare Cloth Shoulderpads
(50019, 33375, 0, 1, 1, 1), -- Fur-Lined Bracers
(50019, 33439, 0, 1, 1, 1), -- Fur-Lined Leather Helmet
(50019, 33406, 0, 1, 1, 1), -- Ice-Bound Plate Bracers
(50019, 33362, 0, 1, 1, 1), -- Thread-Bare Cloth Pants
(50019, 33359, 0, 1, 1, 1), -- Thread-Bare Cloth Boots
(50019, 33407, 0, 1, 1, 1), -- Ice-Bound Plate Chestpiece
(50019, 33396, 0, 1, 1, 1), -- Icy Mail Shoulderpads
(50019, 33408, 0, 1, 1, 1); -- Ice-Bound Plate Gloves
-- Heroic
SET @N_id = 28231;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `LootID`= 50020 WHERE `entry` = @H_id;
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`Groupid`,`mincountOrRef`,`maxcount`) VALUES 
(50020, 33425, 0, 1, 1, 1), -- Ice-Pitted Blade
(50020, 33427, 0, 1, 1, 1), -- Frost-Encrusted Rifle
(50020, 33426, 0, 1, 1, 1), -- Chipped Timber Axe
(50020, 33428, 0, 1, 1, 1), -- Dulled Shiv
(50020, 33430, 0, 1, 1, 1), -- Abandoned Greatsword
(50020, 33429, 0, 1, 1, 1), -- Ice Cleaver
(50020, 33423, 0, 1, 1, 1), -- Rime-Covered Mace
(50020, 33424, 0, 1, 1, 1), -- Cracked Iron Staff
(50020, 33431, 0, 1, 1, 1); -- Icesmashing Mace

-- PICKPOCKETING LOT
-- CLEANUP
DELETE FROM `reference_loot_template` WHERE `entry` IN (70005,70006,70007);
INSERT INTO `reference_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`) VALUES 
(70005, 43575, 0, 2, 1, 1), -- Reinforced Junkbox
(70005, 33449, 0, 2, 1, 1), -- Crusty Flatbread
(70005, 29448, 0, 2, 1, 1), -- Mag\'har Mild Cheese
(70005, 38261, 0, 1, 1, 1), -- Bent House Key
(70005, 33447, 0, 2, 1, 1), -- Runic Healing Potion
(70006, 29450, 50, 0, 1, 1), -- Telaari Grapes
(70006, 37467, 50, 0, 1, 1), -- A Steamy Romance Novel: Forbidden Love
(70007, 33454, 50, 0, 1, 1), -- Salted Venison
(70007, 38268, 50, 0, 1, 1); -- Empty Tobacco Pouch
 
-- CLEANUP
DELETE FROM `pickpocketing_loot_template` WHERE `entry` IN (40000,40001,40002,40003);
INSERT INTO `pickpocketing_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`) VALUES 
(40000, 200013, 100, 0, -70005, 1),
(40000, 200014, 100, 1, -70006, 1),
(40001, 200015, 100, 0, -70005, 1),
(40001, 200016, 100, 1, -70006, 1),
(40001, 36863, 1, 2, 1, 1), -- Decahedral Dwarven Dice
(40002, 200017, 100, 0, -70005, 1), 
(40002, 200018, 100, 1, -70007, 1),
(40002, 36862, 1, 2, 1, 1), -- Worn Troll Dice
(40003, 200019, 100, 0, -70005, 1),
(40003, 200020, 100, 1, -70007, 1);
-- 
UPDATE `creature_template` SET `pickpocketloot`= 40000 WHERE `entry` = 26800;
SET @N_id = 26800;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `pickpocketloot`= 40000 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `pickpocketloot`= 40000 WHERE `entry` = 26802;
SET @N_id = 26802;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `pickpocketloot`= 40000 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `pickpocketloot`= 40001 WHERE `entry` = 26799;
SET @N_id = 26799;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `pickpocketloot`= 40001 WHERE `entry` = @H_id;
--
UPDATE `creature_template` SET `pickpocketloot`= 40002 WHERE `entry` = 26803;
SET @N_id = 26803;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `pickpocketloot`= 40002 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `pickpocketloot`= 40000 WHERE `entry` = 26801;
SET @N_id = 26801;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `pickpocketloot`= 40000 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `pickpocketloot`= 40003 WHERE `entry` = 26727;
SET @N_id = 26727;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `pickpocketloot`= 40003 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `pickpocketloot`= 40002 WHERE `entry` = 26728;
SET @N_id = 26728;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `pickpocketloot`= 40002 WHERE `entry` = @H_id;

-- SKINNING
-- CLEANUP
DELETE FROM `skinning_loot_template` WHERE `entry` IN (150000,150001,150002);
INSERT INTO `skinning_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`) VALUES 
(150000, 33568, 98, 0, 1, 2), -- Borean Leather
(150000, 44128, 2, 0, 1, 1), -- Arctic Fur
(150001, 39516, 0, 1, 1, 1), -- Frosty Mushroom
(150001, 33452, 0, 2, 1, 1), -- Honey-Spiced Lichen
(150001, 36906, 0, 2, 1, 1), -- Icethorn
(150001, 37704, 0, 2, 2, 2), -- Crystallized Life
(150001, 36907, 0, 2, 1, 1), -- Talandra\'s Rose
(150001, 36904, 0, 2, 1, 1), -- Tiger Lily
(150001, 36902, 0, 1, 1, 1), -- Constrictor Grass
(150002, 35947, 0, 2, 1, 1), -- Sparkling Frostcap
(150002, 39516, 0, 1, 1, 1), -- Frosty Mushroom
(150002, 36903, 0, 2, 1, 1), -- Adder\'s Tongue
(150002, 36901, 0, 2, 1, 1), -- Goldclover
(150002, 36904, 0, 2, 1, 1), -- Tiger Lily
(150002, 37704, 0, 2, 1, 1), -- Crystallized Life
(150002, 36905, 0, 2, 1, 1), -- Lichbloom
(150002, 36902, 0, 1, 1, 1); -- Constrictor Grass
-- 
UPDATE `creature_template` SET `skinloot`= 150000 WHERE `entry` = 26734;
SET @N_id = 26734;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `skinloot`= 150000 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `skinloot`= 150000 WHERE `entry` = 26722;
SET @N_id = 26722;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `skinloot`= 150000 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `skinloot`= 150000 WHERE `entry` = 26735;
SET @N_id = 26735;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `skinloot`= 150000 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `skinloot`= 150000 WHERE `entry` = 26716;
SET @N_id = 26716;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `skinloot`= 150000 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `skinloot`= 150001 WHERE `entry` = 26782;
SET @N_id = 26782;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `skinloot`= 150001 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `skinloot`= 150002 WHERE `entry` = 26792;
SET @N_id = 26792;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `skinloot`= 150002 WHERE `entry` = @H_id;
-- 
UPDATE `creature_template` SET `skinloot`= 150000 WHERE `entry` = 26730;
SET @N_id = 26730;
SET @H_id := (SELECT `heroic_entry` FROM `creature_template` WHERE `entry` = @N_id);
UPDATE `creature_template` SET `skinloot`= 150000 WHERE `entry` = @H_id;