DB/Creature: Add loot for some creatures

[CraftedRO]

Description

Added loot for creature mentioned below : https://github.com/TrinityCore/TrinityCore/issues/16051 Source: wowhead classic

SQL fix

-- Brittle Revenant
DELETE FROM `creature_loot_template` WHERE `Entry` = 30160;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(30160, 42246, 0, 78.38, 1, 1, 0, 1, 1, NULL),
(30160, 37701, 0, 34, 0, 1, 0, 1, 2, NULL),
(30160, 42780, 0, 34, 0, 1, 0, 1, 1, NULL),
(30160, 36379, 0, 0.7, 0, 1, 0, 1, 1, NULL),
(30160, 36150, 0, 0.7, 0, 1, 0, 1, 1, NULL),
(30160, 36281, 0, 0.7, 0, 1, 0, 1, 1, NULL),
(30160, 36274, 0, 0.7, 0, 1, 0, 1, 1, NULL),
(30160, 36162, 0, 0.7, 0, 1, 0, 1, 1, NULL),
(30160, 36428, 0, 0.7, 0, 1, 0, 1, 1, NULL),
(30160, 36681, 0, 0.7, 0, 1, 0, 1, 1, NULL),
(30160, 39512, 0, 73, 0, 1, 0, 1, 1, NULL),
(30160, 39513, 0, 17, 0, 1, 0, 1, 1, NULL),
(30160, 33430, 0, 1.4, 0, 1, 0, 1, 1, NULL),
(30160, 33382, 0, 1.4, 0, 1, 0, 1, 1, NULL);

-- Niffelem Forefather
DELETE FROM `creature_loot_template` WHERE `Entry` = 29974;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(29974, 42780, 0, 41, 0, 1, 0, 1, 1, NULL),
(29974, 36427, 0, 1.5, 0, 1, 0, 1, 1, NULL),
(29974, 36386, 0, 1.5, 0, 1, 0, 1, 1, NULL),
(29974, 36483, 0, 1.5, 0, 1, 0, 1, 1, NULL),
(29974, 36390, 0, 1.5, 0, 1, 0, 1, 1, NULL),
(29974, 33470, 0, 32, 0, 1, 0, 1, 4, NULL),
(29974, 33454, 0, 6, 0, 1, 0, 1, 1, NULL),
(29974, 45912, 0, 1.5, 0, 1, 0, 1, 1, NULL),
(29974, 43851, 0, 26, 0, 1, 0, 1, 1, NULL),
(29974, 43852, 0, 15, 0, 1, 0, 1, 1, NULL),
(29974, 33385, 0, 1.5, 0, 1, 0, 1, 1, NULL);

-- Restless Frostborn Warrior
DELETE FROM `creature_loot_template` WHERE `Entry` = 30135;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(30135, 42780, 0, 48, 0, 1, 0, 1, 1, NULL),
(30135, 36376, 0, 1.6, 0, 1, 0, 1, 1, NULL),
(30135, 36137, 0, 1.6, 0, 1, 0, 1, 1, NULL),
(30135, 33470, 0, 23, 0, 1, 0, 1, 4, NULL),
(30135, 35947, 0, 5, 0, 1, 0, 1, 1, NULL),
(30135, 33445, 0, 1.6, 0, 1, 0, 1, 1, NULL),
(30135, 43467, 0, 1.6, 0, 1, 0, 1, 1, NULL),
(30135, 37093, 0, 1.6, 0, 1, 0, 1, 1, NULL),
(30135, 45912, 0, 1.6, 0, 1, 0, 1, 1, NULL),
(30135, 43851, 0, 31, 0, 1, 0, 1, 1, NULL),
(30135, 43852, 0, 11, 0, 1, 0, 1, 1, NULL),
(30135, 33427, 0, 1.6, 0, 1, 0, 1, 1, NULL),
(30135, 33367, 0, 1.6, 0, 1, 0, 1, 1, NULL),
(30135, 33385, 0, 1.6, 0, 1, 0, 1, 1, NULL),
(30135, 33422, 0, 1.6, 0, 1, 0, 1, 1, NULL);

-- Restless Frostborn Ghost
DELETE FROM `creature_loot_template` WHERE `Entry` = 30144;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(30144, 42780, 0, 35, 0, 1, 0, 1, 1, NULL),
(30144, 36455, 0, 2, 0, 1, 0, 1, 1, NULL),
(30144, 33470, 0, 23, 0, 1, 0, 1, 4, NULL),
(30144, 35947, 0, 4, 0, 1, 0, 1, 1, NULL),
(30144, 33445, 0, 2, 0, 1, 0, 1, 1, NULL),
(30144, 43851, 0, 33, 0, 1, 0, 1, 1, NULL),
(30144, 43852, 0, 19, 0, 1, 0, 1, 1, NULL),
(30144, 33397, 0, 2, 0, 1, 0, 1, 1, NULL),
(30144, 33400, 0, 2, 0, 1, 0, 1, 1, NULL);

-- Ravenous Jormungar
DELETE FROM `creature_loot_template` WHERE `Entry` = 30291;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(30291, 44756, 0, 78, 0, 1, 0, 1, 1, NULL),
(30291, 43010, 0, 48, 0, 1, 0, 1, 1, NULL),
(30291, 44757, 0, 20, 0, 1, 0, 1, 1, NULL),
(30291, 36139, 0, 0.3, 0, 1, 0, 1, 1, NULL),
(30291, 36455, 0, 0.3, 0, 1, 0, 1, 1, NULL),
(30291, 43013, 0, 17, 0, 1, 0, 1, 1, NULL),
(30291, 36055, 0, 0.3, 0, 1, 0, 1, 1, NULL),
(30291, 33423, 0, 0.7, 0, 1, 0, 1, 1, NULL),
(30291, 33430, 0, 0.3, 0, 1, 0, 1, 1, NULL),
(30291, 33398, 0, 0.3, 0, 1, 0, 1, 1, NULL),
(30291, 33366, 0, 0.3, 0, 1, 0, 1, 1, NULL),
(30291, 33413, 0, 0.3, 0, 1, 0, 1, 1, NULL),
(30291, 33415, 0, 0.3, 0, 1, 0, 1, 1, NULL),
(30291, 33417, 0, 0.3, 0, 1, 0, 1, 1, NULL),
(30291, 33379, 0, 0.3, 0, 1, 0, 1, 1, NULL),
(30291, 33431, 0, 0.3, 0, 1, 0, 1, 1, NULL);

Branch

3.3.5

TC rev. hash/commit

18121ae24a8d