Untitled

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

-- Source: WoWhead

 

SET @Sartharion := 28860;

SET @Reference := 70000; -- 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,94,1,0,0,1,0,0,0), -- Satchel of Spoils

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

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

(@Sartharion,40615,37,1,0,0,1,0,0,0), -- Gloves of the Lost Vanquisher

(@Sartharion,40614,29,1,0,0,1,0,0,0), -- Gloves of the Lost Protector

(@Sartharion,40613,28,1,0,0,1,0,0,0); -- Gloves 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,40430,0,1,1,1,1,0,0,0), -- Majestic Dragon Figurine

(@Reference,40428,0,1,1,1,1,0,0,0), -- Titan's Outlook

(@Reference,40427,0,1,1,1,1,0,0,0), -- Circle of Arcane Streams

(@Reference,40426,0,1,1,1,1,0,0,0), -- Signet of the Accord

(@Reference,45429,0,1,1,1,1,0,0,0), -- Crimson Steel

-- 1 drake left

(@ReferenceD1,43992,0,1,1,1,1,0,0,0), -- Volitant Amulet

(@ReferenceD1,43988,0,1,1,1,1,0,0,0), -- Gale-Proof Cloak

(@ReferenceD1,43990,0,1,1,1,1,0,0,0), -- Blade_Scarred Tunic

(@ReferenceD1,43989,0,1,1,1,1,0,0,0), -- Remembrance Girdle

(@ReferenceD1,43991,0,1,1,1,1,0,0,0), -- Legguards of Composure

-- 2 drakes left

(@ReferenceD2,43995,0,1,1,1,1,0,0,0), -- Enamored Cowl

(@ReferenceD2,43998,0,1,1,1,1,0,0,0), -- Chestguard of Flagrant Prowess

(@ReferenceD2,43994,0,1,1,1,1,0,0,0), -- Belabored Legplates

(@ReferenceD2,43996,0,1,1,1,1,0,0,0), -- Sabatons of Firmament

(@ReferenceD2,43993,0,1,1,1,1,0,0,0), -- Greatring of Collision

-- 3 drakes left

(@ReferenceD3,43986,0,1,1,1,1,0,0,0); -- Reins of the Black Drake