aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2024_03_19_00_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_03_19_00_world.sql b/sql/updates/world/master/2024_03_19_00_world.sql
new file mode 100644
index 00000000000..3399f0c7547
--- /dev/null
+++ b/sql/updates/world/master/2024_03_19_00_world.sql
@@ -0,0 +1,7 @@
+DELETE FROM `creature_template_difficulty` WHERE `Entry` = 95226 AND `DifficultyID` = 1;
+
+UPDATE `creature_template_difficulty` SET `LootID` = 95226 WHERE `Entry` = 95226 AND `DifficultyID` = 0;
+
+DELETE FROM `creature_loot_template` WHERE `Entry` = 95226 AND `Item` = 128227;
+INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(95226, 128227, 0, 100, 1, 1, 0, 1, 1, 'Anguish Jailer - Soulwrought Key');