From 7f62aa2e0c8d13f6348a35a5644253968bfa8914 Mon Sep 17 00:00:00 2001 From: Naddley Date: Mon, 15 Sep 2025 18:26:29 +0200 Subject: DB/Drustvar: Added creature loot for Glenbrook Homestead spawns - Watchful Raven - Darkmaw Prowler - Cursed Game-Hawk --- sql/updates/world/master/2025_09_15_02_world.sql | 26 ++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 sql/updates/world/master/2025_09_15_02_world.sql 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'); -- cgit v1.2.3