aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorNaddley <NaddleyTC@gmail.com>2025-02-07 00:55:20 +0100
committerNaddley <NaddleyTC@gmail.com>2025-02-07 00:55:20 +0100
commita332d04e6bb175605706c18b155e49a51eae5431 (patch)
tree769eadfd6a1d4a08458223fafaf533a35fe4ab3a /sql
parent25d0e2c6a6dd4dc5b3799a4686b13ff53f3021f4 (diff)
DB/WanderingIsle: Added Stolen Training Supplies to loot for Amberleaf Scamp
Closes #30670
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2025_02_07_00_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_02_07_00_world.sql b/sql/updates/world/master/2025_02_07_00_world.sql
new file mode 100644
index 00000000000..1abcea95a7a
--- /dev/null
+++ b/sql/updates/world/master/2025_02_07_00_world.sql
@@ -0,0 +1,7 @@
+-- Update Difficulty
+UPDATE `creature_template_difficulty` SET `LootID` = 54130 WHERE `entry` = 54130;
+
+-- Add loot
+DELETE FROM `creature_loot_template` WHERE `Entry` = 54130;
+INSERT INTO `creature_loot_template` (`Entry`, `ItemType`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(54130, 0, 72071, 85, 1, 1, 0, 1, 1, 'Stolen Training Supplies');