DB/Creature: Add loot for some creatures

Closes #28265

1 files changed, 84 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2022_10_31_01_world.sql b/sql/updates/world/3.3.5/2022_10_31_01_world.sql
new file mode 100644
index 00000000000..c8ecca5761e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2022_10_31_01_world.sql
@@ -0,0 +1,84 @@
+-- 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);