-- Source: WoWArmory
-- Set Boss ids
SET @Lord_Marrowgar := 36612;
SET @Lady_Deathwhisper := 36855;
SET @Festergut := 36626;
SET @Rotface := 36627;
SET @Professor_Putricide := 36678;

SET @PriSar := 49908; -- Primordial Saronite

CALL `sp_get_npc_diffentry`(@Lord_Marrowgar,2,@Lord_Marrowgar10H);
CALL `sp_get_npc_diffentry`(@Lady_Deathwhisper,2,@Lady_Deathwhisper10H);
CALL `sp_get_npc_diffentry`(@Festergut,2,@Festergut10H);
CALL `sp_get_npc_diffentry`(@Rotface,2,@Rotface10H);
CALL `sp_get_npc_diffentry`(@Professor_Putricide,2,@Professor_Putricide10H);
-- Reference-loot ids
CALL `sp_get_ref_id`( 'RAID_CRE' ,@RefA10H);
SET @RefB10H := @RefA10H+1;
SET @RefC10H := @RefA10H+2;
SET @RefD10H := @RefA10H+3;
SET @RefE10H := @RefA10H+4;
SET @RefF10H := @RefA10H+5;
-- Set Proper Lootid to creature
CALL `sp_set_npc_lootid_bylist`(CONCAT(@Lord_Marrowgar10H,",",@Lady_Deathwhisper10H,",",@Festergut10H,",",@Rotface10H,",",@Professor_Putricide10H),NULL);
-- Delete previous loot if exists
DELETE FROM `creature_loot_template` WHERE `entry` IN (@Lord_Marrowgar10H,@Lady_Deathwhisper10H,@Festergut10H,@Rotface10H,@Professor_Putricide10H);
DELETE FROM `reference_loot_template` WHERE `entry`=@RefA10H,@RefB10H,@RefC10H,@RefD10H,@RefE10H;

-- Creature_loot_template for 10H
INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES
(@Lord_Marrowgar10H,1,100,0,-@RefA10H,2,0,0,0), -- Two from Marrowgar_10H Reference
(@Lord_Marrowgar10H,49426,100,0,1,1,0,0,0), -- Emblem of Frost
(@Lord_Marrowgar10H,@PriSar,38,0,1,1,0,0,0), -- Primordial Saronite
(@Lady_Deathwhisper10H,1,100,0,-@RefB10H,2,0,0,0), -- Two from Lady Deathwhisper_10H Reference
(@Lady_Deathwhisper10H,49426,100,0,1,1,0,0,0), -- Emblem of Frost
(@Lady_Deathwhisper10H,@PriSar,38,0,1,1,0,0,0), -- Primordial Saronite
(@Festergut10H,1,100,0,-@RefC10H,2,0,0,0), -- Two from Festergut_10H Reference
(@Festergut10H,49426,100,0,1,1,0,0,0), -- Emblem of Frost
(@Festergut10H,@PriSar,38,0,1,1,0,0,0), -- Primordial Saronite
(@Rotface10H,1,100,0,-@RefD10H,2,0,0,0), -- Two from Rotface Reference
(@Rotface10H,49426,100,0,1,1,0,0,0), -- Emblem of Frost
(@Rotface10H,@PriSar,38,0,1,1,0,0,0), -- Primordial Saronite
(@Professor_Putricide10H,1,100,0,-@RefE10H,2,0,0,0), -- Two from Professor_Putricide Reference
(@Professor_Putricide10H,49426,100,0,1,1,0,0,0), -- Emblem of Frost
(@Professor_Putricide10H,@PriSar,38,0,1,1,0,0,0), -- Primordial Saronite
(@Professor_Putricide10H,1,100,0,-@RefF10H,1,0,0,0); -- One of tokens drops

-- reference_loot_template for 10H
INSERT INTO `reference_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES
-- Tokens
(@RefF10H,52027,0,1,1,1,0,0,0), -- Conqueror's Mark of Sanctification
(@RefF10H,52026,0,1,1,1,0,0,0), -- Protector's Mark of Sanctification
(@RefF10H,52025,0,1,1,1,0,0,0); -- Vanquisher's Mark of Sanctification
-- Lord Marrowgar_10H Reference
(@RefA10H,50346,0,1,1,1,0,0,0), -- Sliver of Pure Ice (heroic)
(@RefA10H,51930,0,1,1,1,0,0,0), -- Cord of the Patronizing Practitioner(heroic)
(@RefA10H,51934,0,1,1,1,0,0,0), -- Marrowgar's Scratching Choker(heroic)
(@RefA10H,51933,0,1,1,1,0,0,0), -- Shawl of Nerubian Silk(heroic)
(@RefA10H,51932,0,1,1,1,0,0,0), -- Frost Needle(heroic)
(@RefA10H,51928,0,1,1,1,0,0,0), -- Corrupted Silverplate Leggings(heroic)
(@RefA10H,51937,0,1,1,1,0,0,0), -- Bonebreaker Scepter(heroic)
(@RefA10H,51929,0,1,1,1,0,0,0), -- Coldwraith Bracers(heroic)
(@RefA10H,51935,0,1,1,1,0,0,0), -- Linked Scourge Vertebrae(heroic)
(@RefA10H,51931,0,1,1,1,0,0,0), -- Ancient Skeletal Boots(heroic)
(@RefA10H,51936,0,1,1,1,0,0,0), -- Citadel Enforcer's Claymore(heroic)
(@RefA10H,51938,0,1,1,1,0,0,0), -- Bone Warden's Splitter(heroic)
-- Lady Deathwhisper_10H Reference
(@RefB10H,51922,0,1,1,1,0,0,0), -- Scourgelord's Baton(heroic)
(@RefB10H,50343,0,1,1,1,0,0,0), -- Whispering Fanged Skull(heroic)
(@RefB10H,51926,0,1,1,1,0,0,0), -- Handgrips of Frost and Sleet(heroic)
(@RefB10H,51921,0,1,1,1,0,0,0), -- Sister's Handshrouds(heroic)
(@RefB10H,51925,0,1,1,1,0,0,0), -- Soulthief's Braided Belt(heroic)
(@RefB10H,51927,0,1,1,1,0,0,0), -- Njorndar Bone Bow(heroic)
(@RefB10H,51920,0,1,1,1,0,0,0), -- Boots of the Frozen Seed(heroic)
(@RefB10H,51917,0,1,1,1,0,0,0), -- Ghoul Commander's Cuirass(heroic)
(@RefB10H,51924,0,1,1,1,0,0,0), -- Deathspeaker Zealot's Helm(heroic)
(@RefB10H,51923,0,1,1,1,0,0,0), -- Chestguard of the Frigid Noose(heroic)
(@RefB10H,51918,0,1,1,1,0,0,0), -- Bracers of Dark Blessings(heroic)
(@RefB10H,51919,0,1,1,1,0,0,0), -- Deathspeaker Disciple's Belt(heroic)
-- Festergut_10H Reference
(@RefC10H,51891,0,1,1,1,0,0,0), -- Taldron's Long Neglected Boots(heroic)
(@RefC10H,51882,0,1,1,1,0,0,0), -- Kilt of Untreated Wounds(heroic)
(@RefC10H,51892,0,1,1,1,0,0,0), -- Festering Fingerguards(heroic)
(@RefC10H,51889,0,1,1,1,0,0,0), -- Plague-Soaked Leather Leggings(heroic)
(@RefC10H,51890,0,1,1,1,0,0,0), -- Precious's Putrid Collar(heroic)
(@RefC10H,51888,0,1,1,1,0,0,0), -- Cloak of Many Skins(heroic)
(@RefC10H,51893,0,1,1,1,0,0,0), -- Gutbuster(heroic)
(@RefC10H,51884,0,1,1,1,0,0,0), -- Signet of Putrefaction(heroic)
(@RefC10H,51887,0,1,1,1,0,0,0), -- Abracadaver(heroic)
(@RefC10H,51886,0,1,1,1,0,0,0), -- Festergut's Gaseous Gloves(heroic)
(@RefC10H,51885,0,1,1,1,0,0,0), -- Wrists of Septic Shock(heroic)
(@RefC10H,51883,0,1,1,1,0,0,0), -- Bloodstained Surgeon's Shoulderguards(heroic)
-- Rotface_10H Reference
(@RefD10H,51878,0,1,1,1,0,0,0), -- Rotface's Rupturing Ring(heroic)
(@RefD10H,51871,0,1,1,1,0,0,0), -- Choker of Filthy Diamonds(heroic)
(@RefD10H,51875,0,1,1,1,0,0,0), -- Lockjaw(heroic)
(@RefD10H,51879,0,1,1,1,0,0,0), -- Flesh-Shaper's Gurney Strap(heroic)
(@RefD10H,51870,0,1,1,1,0,0,0), -- Chestguard of the Failed Experiment(heroic)
(@RefD10H,51872,0,1,1,1,0,0,0), -- Ether-Soaked Bracers(heroic)
(@RefD10H,51876,0,1,1,1,0,0,0), -- Abomination Knuckles(heroic)
(@RefD10H,51873,0,1,1,1,0,0,0), -- Shuffling Shoes(heroic)
(@RefD10H,51881,0,1,1,1,0,0,0), -- Shaft of Glacial Ice(heroic)
(@RefD10H,51877,0,1,1,1,0,0,0), -- Taldron's Short-Sighted Helm(heroic)
(@RefD10H,51874,0,1,1,1,0,0,0), -- Gloves of Broken Fingers(heroic)
(@RefD10H,51880,0,1,1,1,0,0,0), -- Gluth's Fetching Knife(heroic)
-- Professor_Putricide_10H Reference
(@RefE10H,51859,0,1,1,1,0,0,0), -- Shoulders of Ruinous Senility(heroic)
(@RefE10H,51864,0,1,1,1,0,0,0), -- Shoulderpads of the Morbid Ritual(heroic)
(@RefE10H,51860,0,1,1,1,0,0,0), -- Rippling Flesh Kilt(heroic)
(@RefE10H,51863,0,1,1,1,0,0,0), -- Pendant of Split Veins(heroic)
(@RefE10H,51869,0,1,1,1,0,0,0), -- The Facelifter(heroic)
(@RefE10H,51867,0,1,1,1,0,0,0), -- Infected Choker (heroic)
(@RefE10H,51866,0,1,1,1,0,0,0), -- Discarded Bag of Entrails (heroic)
(@RefE10H,51861,0,1,1,1,0,0,0), -- Chestplate of Septic Stitches( heroic)
(@RefE10H,51868,0,1,1,1,0,0,0), -- Flesh-Carving Scalpel (heroic)
(@RefE10H,50344,0,1,1,1,0,0,0), -- Unidentifiable Organ (heroic)
(@RefE10H,51865,0,1,1,1,0,0,0), -- Scalpel-Sharpening Shoulderguards (heroic)
(@RefE10H,51862,0,1,1,1,0,0,0); -- Cauterized Cord (heroic)