From 47cafa2ab6193774d930e39fac17b88eefcb7292 Mon Sep 17 00:00:00 2001 From: Ryan Turner Date: Sun, 25 May 2025 23:27:56 +0200 Subject: DB/BurningSteppes: Update Blackrock Mountain Instance enter/exit locs Closes #30978 --- sql/updates/world/master/2025_05_25_06_world.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/world/master/2025_05_25_06_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2025_05_25_06_world.sql b/sql/updates/world/master/2025_05_25_06_world.sql new file mode 100644 index 00000000000..41ed4728e7f --- /dev/null +++ b/sql/updates/world/master/2025_05_25_06_world.sql @@ -0,0 +1,15 @@ +-- Update Blackrock Mountain Instance enter/exit locs +UPDATE `world_safe_locs` SET `Facing` = 270.0 WHERE `ID` = 3643; +UPDATE `world_safe_locs` SET `Facing` = 180.0 WHERE `ID` IN (3676, 3695, 3696, 3697); +UPDATE `world_safe_locs` SET `Facing` = 220.0 WHERE `ID` = 3677; +UPDATE `world_safe_locs` SET `LocX` = -7508.32, `LocY` = -1039.74, `Facing` = 220.0 WHERE `ID`= 4178; +UPDATE `world_safe_locs` SET `LocX` = 112.21687, `LocY` = -318.9608, `LocZ` = 65.461716, `Facing` = 0.215 WHERE `ID` = 4501; +UPDATE `world_safe_locs` SET `Facing` = 185.69999 WHERE `ID` = 3645; +UPDATE `world_safe_locs` SET `Facing` = 178.60499 WHERE `ID` = 3644; +UPDATE `world_safe_locs` SET `Facing` = 7.27475 WHERE `ID` = 4920; +UPDATE `world_safe_locs` SET `Facing` = 267.99998 WHERE `ID` = 3955; +UPDATE `world_safe_locs` SET `Facing` = 96.0 WHERE `ID` = 3953; +UPDATE `world_safe_locs` SET `LocX` = -7571.14, `LocY` = -1324.96, `LocZ` = 245.538, `Facing` = 96.0 WHERE `ID` = 4223; +UPDATE `world_safe_locs` SET `Facing` = 45.0 WHERE `ID` IN (3700, 3702); +UPDATE `world_safe_locs` SET `LocX` = -7524.65, `LocY` = -1229.13, `LocZ` = 285.731, `Facing` = 120.00001 WHERE `ID` = 3701; +UPDATE `world_safe_locs` SET `LocX` = -7524.65, `LocY` = -1229.13, `LocZ` = 285.731, `Facing` = 120.00001 WHERE `ID` = 4168; -- cgit v1.2.3