diff options
| author | Jason Dove <1695733+jasongdove@users.noreply.github.com> | 2025-06-28 15:09:30 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-06-28 22:09:30 +0200 |
| commit | 8892fc071e55ef5c2ab6f5f1c085a1dd99a9393e (patch) | |
| tree | febb656dc8f5d9878d372c7ca0692af4bf325b7b /sql | |
| parent | 68588dbb25d2cb45757764db187d5e66b7726305 (diff) | |
DB/Dungeons: Fix some classic LFG dungeon entrances (#31103)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2025_06_28_03_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_06_28_03_world.sql b/sql/updates/world/master/2025_06_28_03_world.sql new file mode 100644 index 00000000000..a7e595147e3 --- /dev/null +++ b/sql/updates/world/master/2025_06_28_03_world.sql @@ -0,0 +1,12 @@ +-- LFGDungeonsEntry changed from "Scarlet Monastery - Armory" in 4.x to "Scarlet Halls" in 5.x, coords are invalid on new map +DELETE FROM `lfg_dungeon_template` WHERE `dungeonId` = 163; + +-- LFGDungeonsEntry changed from "Scarlet Monastery - Cathedral" to "Scarlet Monastery" in 5.x, coords are invalid on new map +DELETE FROM `lfg_dungeon_template` WHERE `dungeonId` = 164; + +-- Fix LFG entrance for dungeons that have multiple entrances +DELETE FROM `lfg_dungeon_template` WHERE `dungeonId` IN (14, 22, 276); +INSERT INTO `lfg_dungeon_template` (`dungeonId`, `name`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES +(14, 'Gnomeregan', -329.484, -3.22991, -152.846, 2.9670597284), +(22, 'Uldaman', -228.859, 46.1018, -46.0186, 1.5707963268), +(276, 'Blackrock Depths - Upper City', 926.904, -288.134, -49.9401, 1.1140925308); |