DB/Drustvar: Added creature loot for Glenbrook Homestead spawns

- Watchful Raven
- Darkmaw Prowler
- Cursed Game-Hawk

1 files changed, 26 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_09_15_02_world.sql b/sql/updates/world/master/2025_09_15_02_world.sql
new file mode 100644
index 00000000000..971def1d6d8
--- /dev/null
+++ b/sql/updates/world/master/2025_09_15_02_world.sql
@@ -0,0 +1,26 @@
+-- Difficulty (Watchful Raven)
+UPDATE `creature_template_difficulty` SET `LootID`=121610 WHERE `Entry`=121610;
+
+DELETE FROM `creature_loot_template` WHERE `Entry` = 121610;
+INSERT INTO `creature_loot_template` (`Entry`, `ItemType`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(121610, 1, 700005, 100, 0, 1, 1, 1, 1, 'Reference Junk loot'), -- Total Drop Chance = 99.696379%
+(121610, 0, 154897, 26, 0, 1, 0, 1, 4, 'Stringy Loins'), -- Chance = 26.139240%
+(121610, 1, 700000, 2, 0, 1, 1, 1, 1, 'Reference Uncommon loot');
+
+-- Difficulty (Darkmaw Prowler)
+UPDATE `creature_template_difficulty` SET `LootID`=121620 WHERE `Entry`=121620;
+
+DELETE FROM `creature_loot_template` WHERE `Entry` = 121620;
+INSERT INTO `creature_loot_template` (`Entry`, `ItemType`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(121620, 1, 700004, 100, 0, 1, 1, 1, 1, 'Reference Junk loot'), -- Total Drop Chance = 99.347084%
+(121620, 0, 154897, 26, 0, 1, 0, 1, 4, 'Stringy Loins'), -- Chance = 25.745299%
+(121620, 1, 700000, 2, 0, 1, 1, 1, 1, 'Reference Uncommon loot');
+
+-- Difficulty (Cursed Game-hawk)
+UPDATE `creature_template_difficulty` SET `LootID`=122961 WHERE `Entry`=122961;
+
+DELETE FROM `creature_loot_template` WHERE `Entry` = 122961;
+INSERT INTO `creature_loot_template` (`Entry`, `ItemType`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(122961, 1, 700007, 100, 0, 1, 1, 1, 1, 'Reference Junk loot'), -- Total Drop Chance = 99.475153%
+(122961, 0, 154897, 26, 0, 1, 0, 1, 4, 'Stringy Loins'), -- Chance = 26.362604%
+(122961, 1, 700000, 2, 0, 1, 1, 1, 1, 'Reference Uncommon loot');