Untitled

-- 25-Man Boss loot from Obsidian Sanctrum (including Hard Modes)

-- Source: WoWhead

 

SET @Sartharion := 31311;

SET @Reference := 70010; -- didn't know what exact reference range I should use so I used static for test drops

SET @ReferenceD1 := 1+@Reference;

SET @ReferenceD2 := 2+@Reference;

SET @ReferenceD3 := 3+@Reference;

 

DELETE FROM 'creature_loot_template' WHERE 'entry'=@Sartharion;

DELETE FROM 'reference_loot_template' WHERE 'entry'=@Reference;

DELETE FROM 'reference_loot_template' WHERE 'entry'=@ReferenceD1;

DELETE FROM 'reference_loot_template' WHERE 'entry'=@ReferenceD2;

DELETE FROM 'reference_loot_template' WHERE 'entry'=@ReferenceD3;

 

UPDATE 'creature_template' SET 'lootid'='entry' WHERE 'entry'=@Sartharion;

 

-- generic loot (don't know whether tokens should be in generic - assume yes)

INSERT INTO 'creature_loot_template' (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES

(@Sartharion,1,100,1,0,-@Reference,2,0,0,0), -- 2 selections from gear loot

(@Sartharion,2,100,2,0,-@ReferenceD1,1,0,0,0), -- 1 selection from hard mode (1 Drake left alive)

(@Sartharion,3,100,4,0,-@ReferenceD2,1,0,0,0), -- 1 selection from hard mode (2 Drakes left alive)

(@Sartharion,4,100,8,0,-@ReferenceD3,1,0,0,0), -- 1 selection from hard mode (3 Drakes left alive)

(@Sartharion,43347,93,1,0,0,1,0,0,0), -- Satchel of Spoils

(@Sartharion,43345,90,1,0,0,1,0,0,0), -- Dragon Hide Bag

(@Sartharion,45624,100,1,0,1,1,0,0,0), -- Emblem of conquest

(@Sartharion,40630,68,1,0,0,1,0,0,0), -- Gauntlets of the Lost Vanquisher

(@Sartharion,40629,53,1,0,0,1,0,0,0), -- Gauntlets of the Lost Protector

(@Sartharion,40628,51,1,0,0,1,0,0,0); -- Gauntlets of the Lost Cunqueror

 

INSERT INTO `reference_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES

-- gear loot

(@Reference,40431,0,1,1,1,1,0,0,0), -- Fury of the Five Flights

(@Reference,40432,0,1,1,1,1,0,0,0), -- Illustration of the Dragon Soul

(@Reference,40451,0,1,1,1,1,0,0,0), -- Hyaline Helm of the Sniper

(@Reference,40437,0,1,1,1,1,0,0,0), -- Concealment Shoulderpads

(@Reference,40438,0,1,1,1,1,0,0,0), -- Council Chamber Epaulets

(@Reference,40439,0,1,1,1,1,0,0,0), -- Mantle of the Eternal Sentinel

(@Reference,40453,0,1,1,1,1,0,0,0), -- Chestplate of the Great Aspects

(@Reference,40446,0,1,1,1,1,0,0,0), -- Dragon Brood Legguards

(@Reference,40433,0,1,1,1,1,0,0,0), -- Wyrmrest Band

(@Reference,40455,0,1,1,1,1,0,0,0), -- Staff of Restraint

-- 1 drake left

(@ReferenceD1,44003,0,1,1,1,1,0,0,0), -- Upstanding Spaulders

(@ReferenceD1,44002,0,1,1,1,1,0,0,0), -- The Sanctum's Flowing Vestments

(@ReferenceD1,44000,0,1,1,1,1,0,0,0), -- Dragonstorm Breastplate

(@ReferenceD1,44000,0,1,1,1,1,0,0,0), -- Bountiful Gauntlets

-- 2 drakes left

(@ReferenceD2,44007,0,1,1,1,1,0,0,0), -- Headpiece of Reconciliation

(@ReferenceD2,44006,0,1,1,1,1,0,0,0), -- Obsidian Greathelm

(@ReferenceD2,44005,0,1,1,1,1,0,0,0), -- Pennant Cloak

(@ReferenceD2,44008,0,1,1,1,1,0,0,0), -- Unsullied Cuffs

(@ReferenceD2,44011,0,1,1,1,1,0,0,0), -- Leggings of the Honored

-- 3 drakes left

(@ReferenceD3,43954,0,1,1,1,1,0,0,0); -- Reins of the Twilight Drake