DB/WorldSafeLocs: Fixed facing for BfA dungeon entrance/exits (should use degrees instead of radians)

1 files changed, 26 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_09_09_02_world.sql b/sql/updates/world/master/2024_09_09_02_world.sql
new file mode 100644
index 00000000000..1bab8e08a71
--- /dev/null
+++ b/sql/updates/world/master/2024_09_09_02_world.sql
@@ -0,0 +1,26 @@
+SET @WORLDSAFELOCID := 100042;
+
+UPDATE `world_safe_locs` SET `Facing`=0.42834568/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+0;  -- 8.x Dungeon - Siege of Boralus - Entrance
+UPDATE `world_safe_locs` SET `Facing`=4.4846063/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+1;  -- 8.x Dungeon - Siege of Boralus - Exit
+UPDATE `world_safe_locs` SET `Facing`=2.866721/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+2;  -- 8.x Dungeon - Freehold - Entrance
+UPDATE `world_safe_locs` SET `Facing`=5.385859/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+3;  -- 8.x Dungeon - Freehold - Exit
+UPDATE `world_safe_locs` SET `Facing`=1.3391021/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+4;  -- 8.x Dungeon - Tol Dagor - Entrance
+UPDATE `world_safe_locs` SET `Facing`=2.5878694/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+5;  -- 8.x Dungeon - Tol Dagor - Exit
+UPDATE `world_safe_locs` SET `Facing`=0.072306424/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+6;  -- 8.x Dungeon - Waycrest Manor - Entrance
+UPDATE `world_safe_locs` SET `Facing`=3.067398/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+7;  -- 8.x Dungeon - Waycrest Manor - Exit
+UPDATE `world_safe_locs` SET `Facing`=4.73095/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+8;  -- 8.x Dungeon - Shrine of Storms - Entrance
+UPDATE `world_safe_locs` SET `Facing`=1.7824349/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+9;  -- 8.x Dungeon - Shrine of Storms - Exit
+UPDATE `world_safe_locs` SET `Facing`=6.0063233/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+10; -- 8.x Dungeon - Motherlode (Alliance) - Entrance
+UPDATE `world_safe_locs` SET `Facing`=3.607927/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+11; -- 8.x Dungeon - Motherlode (Alliance) - Exit
+UPDATE `world_safe_locs` SET `Facing`=1.5707964/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+12; -- 8.x Dungeon - Atal Dazar - Entrance
+UPDATE `world_safe_locs` SET `Facing`=4.7006083/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+13; -- 8.x Dungeon - Atal Dazar - Exit
+UPDATE `world_safe_locs` SET `Facing`=1.578214/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+14; -- 8.x Dungeon - KingsRest - Entrance
+UPDATE `world_safe_locs` SET `Facing`=4.752863/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+15; -- 8.x Dungeon - KingsRest - Exit
+UPDATE `world_safe_locs` SET `Facing`=6.232135/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+16; -- 8.x Dungeon - Underrot - Entrance
+UPDATE `world_safe_locs` SET `Facing`=3.843372/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+17; -- 8.x Dungeon - Underrot - Exit
+UPDATE `world_safe_locs` SET `Facing`=6.275331/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+18; -- 8.x Dungeon - Temple of Sethraliss - Entrance
+UPDATE `world_safe_locs` SET `Facing`=3.1415577/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+19; -- 8.x Dungeon - Temple of Sethraliss - Exit
+UPDATE `world_safe_locs` SET `Facing`=6.0063233/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+20; -- 8.x Dungeon - Motherlode (H) - Entrance
+UPDATE `world_safe_locs` SET `Facing`=4.740838/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+21; -- 8.x Dungeon - Motherlode (H) - Exit
+UPDATE `world_safe_locs` SET `Facing`=4.8422937/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+22; -- 8.x Dungeon - Siege of Boralus (H) - Entrance
+UPDATE `world_safe_locs` SET `Facing`=0.7578639/(2 * PI() / 360) WHERE `ID`=@WORLDSAFELOCID+23; -- 8.x Dungeon - Siege of Boralus (H) - Exit');