Warpten/TrinityCore — Issue #2: [DB/Loot] Added normal loot to 3 mini bosses on 10 man Normal
Author: sonic3000
Created: 2012-02-04 13:51:22+00:00
State: open

I wrote this script which contains the loot for the three mini bosses. All values were taken off old.wowhead.com:

```SQL
-- Loot Template for Baltharus the Warborn (39751) for 10N only

DELETE from `creature_loot_template` where `entry` = 39947;
INSERT into `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`)
VALUES
(39947,49426,100,1,0,1,1),
(39947,33398,13,1,0,1,1),
(39947,36430,9,1,0,1,1),
(39947,33365,6,1,0,1,1),
(39947,38557,5,1,0,1,2),
(39947,36177,3,1,0,1,1),
(39947,36064,3,1,0,1,1),
(39947,36059,2,1,0,1,1),
(39947,33436,1.9,1,0,1,1),
(39947,33416,1.6,1,0,1,1),
(39947,33429,2,1,0,1,1),
(39947,36710,1.9,1,0,1,1),
(39947,36400,1.7,1,0,1,1),
(39947,33366,1.5,1,0,1,1),
(39947,33422,1.4,1,0,1,1),
(39947,36289,1.3,1,0,1,1),
(39947,36062,1.2,1,0,1,1),
(39947,36176,1.2,1,0,1,1),
(39947,33423,1,1,0,1,1);

-- Skin Loot Template for Baltharus the Warborn for 10N only

UPDATE `creature_template` SET `skinloot` = 39751 WHERE `entry` = 39751;
DELETE FROM `skinning_loot_template` where `entry` = 39751;
INSERT INTO `skinning_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`)
VALUES
(39751,33568,71,1,0,1,3),
(39751,38557,28,1,0,1,2);

-- Loot Template for General Zarithrian (39746) for 10N only

DELETE from `creature_loot_template` where `entry` = 39946;
INSERT into `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`)
VALUES
(39946,49426,100,1,0,1,1),
(39946,33568,20,1,0,1,3),
(39946,33412,13,1,0,1,1),
(39946,36059,4,1,0,1,1),
(39946,36395,4,1,0,1,1),
(39946,37794,3,1,0,1,1),
(39946,36444,3,1,0,1,1),
(39946,36598,3,1,0,1,1),
(39946,36682,3,1,0,1,1),
(39946,36430,2,1,0,1,1),
(39946,38557,2,1,0,1,2),
(39946,33424,2,1,0,1,1),
(39946,33422,2,1,0,1,1),
(39946,36063,1.8,1,0,1,1),
(39946,36171,1.8,1,0,1,1),
(39946,36061,1.6,1,0,1,1),
(39946,36398,1.6,1,0,1,1),
(39946,33419,1.6,1,0,1,1),
(39946,33380,1.6,1,0,1,1),
(39946,37761,1.3,1,0,1,1),
(39946,36060,1.3,1,0,1,1),
(39946,36397,1.3,1,0,1,1),
(39946,36640,1.3,1,0,1,1),
(39946,36283,1.3,1,0,1,1),
(39946,33433,1.3,1,0,1,1),
(39946,33427,1.3,1,0,1,1),
(39946,33369,1.3,1,0,1,1),
(39946,33429,1.3,1,0,1,1),
(39946,33423,1.3,1,0,1,1);

-- Skin Loot Template for General Zarithrian (39746) for 10N only

UPDATE `creature_template` SET `skinloot` = 39746 WHERE `entry` = 39746;
DELETE from `skinning_loot_template` where `entry` = 39746;
INSERT into `skinning_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`)
VALUES
(39746,33568,71,1,0,1,3),
(39746,38557,28,1,0,1,2);

-- Loot Template for Saviana Ragefire (39747) for 10N only

DELETE from `creature_loot_template` where `entry` = 39948;
INSERT into `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`)
VALUES
(39948,49426,100,1,0,1,1),
(39948,36290,11,1,0,1,1),
(39948,33382,8,1,0,1,1),
(39948,36401,5,1,0,1,1),
(39948,36064,4,1,0,1,1),
(39948,33428,4,1,0,1,1),
(39948,33400,4,1,0,1,1),
(39948,36060,3,1,0,1,1),
(39948,33433,3,1,0,1,1),
(39948,36458,2,1,0,1,1),
(39948,36668,2,1,0,1,1),
(39948,36430,2,1,0,1,1),
(39948,36289,2,1,0,1,1),
(39948,36283,2,1,0,1,1),
(39948,33426,2,1,0,1,1),
(39948,33436,2,1,0,1,1),
(39948,33429,2,1,0,1,1),
(39948,36066,1.8,1,0,1,1),
(39948,36062,1.5,1,0,1,1),
(39948,36059,1.5,1,0,1,1),
(39948,36178,1.5,1,0,1,1),
(39948,36398,1.5,1,0,1,1),
(39948,36416,1.5,1,0,1,1),
(39948,33380,1.5,1,0,1,1),
(39948,33425,1.5,1,0,1,1),
(39948,41777,1.3,1,0,1,1),
(39948,37781,1.3,1,0,1,1),
(39948,36176,1.3,1,0,1,1),
(39948,36395,1.3,1,0,1,1),
(39948,36285,1.3,1,0,1,1),
(39948,33424,1.3,1,0,1,1),
(39948,33431,1.3,1,0,1,1);

-- Skin Loot Template for Saviana Ragefire for 10N only

UPDATE `creature_template` SET `skinloot` = 39747 WHERE `entry` = 39747;
```