The Nexus Normal + Heroic + Tras

-- HP AND LVL FIX-- Anomalus - 26763UPDATE `creature_template` SET `maxlevel` = '72', `maxhealth` = '192200' WHERE `entry` =26763;-- Grand Magus Telestra - 26731UPDATE `creature_template` SET `maxlevel` = '72', `maxhealth` = '120125' WHERE `entry` =26731;-- Keristrasza - 26723UPDATE `creature_template` SET `maxlevel` = '73', `maxhealth` = '248500' WHERE `entry` =26723;-- Ormorok the Tree-Shaper - 26794UPDATE `creature_template` SET `maxlevel` = '72', `maxhealth` = '192200' WHERE `entry` =26794;-- CLEANUPDELETE FROM `creature_loot_template` WHERE `entry` IN (50006,50007,50008,50009,50010,50011,50012,50013);-- Grand Magus TelestraUPDATE `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);-- AnomalusUPDATE `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-ShaperUPDATE `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);-- KeristraszaUPDATE `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);-- CLEANUPDELETE 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-- TrashINSERT 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 PotionDELETE 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-- NormalUPDATE `creature_template` SET `LootID`= 50000 WHERE `entry` = 26716;-- HeroicSET @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;-- NormalUPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26722;-- HeroicSET @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; -- NormalUPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26727;-- HeroicSET @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;-- NormalUPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26728;-- HeroicSET @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;-- NormalUPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26729;-- HeroicSET @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;-- NormalUPDATE `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-- HeroicSET @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-- NormalUPDATE `creature_template` SET `LootID`= 50004 WHERE `entry` = 26734;-- HeroicSET @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;-- NormalUPDATE `creature_template` SET `LootID`= 50004 WHERE `entry` = 26735;-- HeroicSET @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;-- HeroicUPDATE `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-- HeroicSET @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-- NormalUPDATE `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-- HeroicSET @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-- NormalUPDATE `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-- HeroicSET @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-- NormalUPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26799;-- HeroicSET @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;-- NormalUPDATE `creature_template` SET `LootID`= 50005 WHERE `entry` = 26800;-- HeroicSET @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;-- NormalUPDATE `creature_template` SET `LootID`= 50002 WHERE `entry` = 26802;-- HeroicSET @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;-- NormalUPDATE `creature_template` SET `LootID`= 50005 WHERE `entry` = 26803;-- HeroicSET @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;-- NormalUPDATE `creature_template` SET `LootID`= 50005 WHERE `entry` = 26805;-- HeroicSET @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;-- NormalUPDATE `creature_template` SET `LootID`= 50005 WHERE `entry` = 27947;-- HeroicSET @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;-- NormalUPDATE `creature_template` SET `LootID`= 50005 WHERE `entry` = 27949;-- NormalUPDATE `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-- HeroicSET @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-- CLEANUPDELETE 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 -- CLEANUPDELETE 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-- CLEANUPDELETE 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;