aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTQPS <66294837+TQPS@users.noreply.github.com>2025-04-12 12:02:18 +0200
committerNaddley <NaddleyTC@gmail.com>2025-04-12 12:02:32 +0200
commitbf681bfc2e8fe80ce3d86435f21679a35df0b290 (patch)
tree45c036f5083999bcc1c0543bbba69f384749c021
parente9297ec13e90b940eece4b15a17778351e52b4c8 (diff)
DB/Difficulty: Update some more duplicate data
Closes #30840 Closes #30842 Closes #30843
-rw-r--r--sql/updates/world/master/2025_04_12_01_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_04_12_01_world.sql b/sql/updates/world/master/2025_04_12_01_world.sql
new file mode 100644
index 00000000000..8aa2f74fbae
--- /dev/null
+++ b/sql/updates/world/master/2025_04_12_01_world.sql
@@ -0,0 +1,11 @@
+-- Update Horrorjaw
+DELETE FROM `creature_template_difficulty` WHERE (`Entry` = 41420 AND `DifficultyId` = 0 AND `VerifiedBuild` = 0);
+UPDATE `creature_template_difficulty` SET `DifficultyId` = 0 WHERE (`Entry` = 41420 AND `DifficultyId` = 1);
+
+-- Update Gobbler
+DELETE FROM `creature_template_difficulty` WHERE (`Entry` = 1259 AND `DifficultyId` = 0 AND `VerifiedBuild` = 0);
+UPDATE `creature_template_difficulty` SET `DifficultyId` = 0 WHERE (`Entry` = 1259 AND `DifficultyId` = 1);
+
+-- Update Kor'gresh
+DELETE FROM `creature_template_difficulty` WHERE (`Entry` = 2793 AND `DifficultyId` = 0 AND `VerifiedBuild` = 0);
+UPDATE `creature_template_difficulty` SET `DifficultyId` = 0 WHERE (`Entry` = 2793 AND `DifficultyId` = 1);