DB/Misc: Add correct teleport positions to some areatriggers and spells from sniffs

Closes #25190

1 files changed, 56 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_08_02_29_world_335.sql b/sql/updates/world/3.3.5/2020_08_02_29_world_335.sql
new file mode 100644
index 00000000000..3e50c0d0f7e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_08_02_29_world_335.sql
@@ -0,0 +1,56 @@
+-- Halls of Reflection (Entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 5239.46, `target_position_y` = 1932.99, `target_position_z` = 707.695, `target_orientation` = 0.78539824, `VerifiedBuild` = 12340 WHERE `ID` = 5636;
+-- Azjol-Nerub (entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 411.37, `target_position_y` = 794.947, `target_position_z` = 831.323, `target_orientation` = 5.4977875, `VerifiedBuild` = 12340 WHERE `ID` = 5117;
+-- Ahn'Kahet (entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 335.736, `target_position_y` = -1108.36, `target_position_z` = 68.5133, `target_orientation` = 0.64577186, `VerifiedBuild` = 12340 WHERE `ID` = 5215;
+-- Ulduar, Halls of Lightning (entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 1331.41, `target_position_y` = 241.904, `target_position_z` = 52.5046, `target_orientation` = 4.7123895, `VerifiedBuild` = 12340 WHERE `ID` = 5093;
+-- Chamber of Aspects, Obsidian Sanctum (entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 3228.34, `target_position_y` = 394.577, `target_position_z` = 62.1694, `target_orientation` = 1.5358899, `VerifiedBuild` = 12340 WHERE `ID` = 5243;
+-- Chamber of Aspects, Obsidian Sanctum (exit)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 3457.61, `target_position_y` = 262.714, `target_position_z` = -114.047, `target_orientation` = 0.122173056, `VerifiedBuild` = 12340 WHERE `ID` = 5241;
+-- Forge of Souls (Entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 4921.31, `target_position_y` = 2177.36, `target_position_z` = 638.733, `target_orientation` = 2.0594888, `VerifiedBuild` = 12340 WHERE `ID` = 5635;
+-- The Oculus (entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 1056.96, `target_position_y` = 986.421, `target_position_z` = 361.07, `target_orientation` = 5.8992133, `VerifiedBuild` = 12340 WHERE `ID` = 5246;
+-- Sethekk Halls (Entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 2.63209, `target_position_y` = -0.209401, `target_position_z` = 0.005755, `target_orientation` = 0, `VerifiedBuild` = 12340 WHERE `ID` = 4406;
+-- Sethekk Halls (Exit)
+UPDATE `areatrigger_teleport` SET `target_position_x` = -3362.1, `target_position_y` = 4668.9, `target_position_z` = -101.048, `target_orientation` = 1.5707965, `VerifiedBuild` = 12340 WHERE `ID` = 4399;
+-- Auchenai Crypts (Entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = -16.7899, `target_position_y` = -0.071496, `target_position_z` = -0.120559, `target_orientation` = 0, `VerifiedBuild` = 12340 WHERE `ID` = 4404;
+-- Mana Tombs (Entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = -4.81115, `target_position_y` = 1.00236, `target_position_z` = -0.954329, `target_orientation` = 3.141593, `VerifiedBuild` = 11159 WHERE `ID` = 4405;
+-- Ulduar Raid entrance
+UPDATE `areatrigger_teleport` SET `target_position_x` = -879.548, `target_position_y` = -148.966, `target_position_z` = 458.884, `target_orientation` = 0, `VerifiedBuild` = 12340 WHERE `ID` = 5379;
+-- Utgarde Pinnacle (entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 580.698, `target_position_y` = -327.796, `target_position_z` = 110.141, `target_orientation` = 3.141593, `VerifiedBuild` = 12340 WHERE `ID` = 4747;
+-- The Barrens - Wailing Caverns
+UPDATE `areatrigger_teleport` SET `target_position_x` = -158.441, `target_position_y` = 131.601, `target_position_z` = -74.2552, `target_orientation` = 5.8468537, `VerifiedBuild` = 11159 WHERE `ID` = 228;
+-- DeadMines Entrance
+UPDATE `areatrigger_teleport` SET `target_position_x` = -14.5732, `target_position_y` = -385.475, `target_position_z` = 62.4561, `target_orientation` = 1.5707965, `VerifiedBuild` = 11159 WHERE `ID` = 78;
+-- Gundrak (entrance north)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 1882.32, `target_position_y` = 631.027, `target_position_z` = 176.696, `target_orientation` = 3.141593, `VerifiedBuild` = 11723 WHERE `ID` = 5206;
+-- Zul'Aman (Entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 120.706, `target_position_y` = 1759.19, `target_position_z` = 42.7443, `target_orientation` = 4.7123895, `VerifiedBuild` = 11723 WHERE `ID` = 4738;
+-- Zul'Aman (Exit)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 6851.11, `target_position_y` = -7985.05, `target_position_z` = 186.421, `target_orientation` = 1.5707965, `VerifiedBuild` = 11723 WHERE `ID` = 4739;
+-- The Underbog (Entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 18.7435, `target_position_y` = -24.597, `target_position_z` = -2.75368, `target_orientation` = 5.4977874, `VerifiedBuild` = 14545 WHERE `ID` = 4363;
+-- Utgarde Keep (entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 157.878, `target_position_y` = -84.7025, `target_position_z` = 12.5537, `target_orientation` = 0, `VerifiedBuild` = 11159 WHERE `ID` = 4745;
+-- The Nexus (entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 152.213, `target_position_y` = -5.50178, `target_position_z` = -16.6367, `target_orientation` = 0, `VerifiedBuild` = 11159 WHERE `ID` = 4983;
+-- Stratholme - Eastern Plaguelands Instance
+UPDATE `areatrigger_teleport` SET `target_position_x` = 3392.92, `target_position_y` = -3395.03, `target_position_z` = 143.135, `target_orientation` = 1.5707965, `VerifiedBuild` = 11159 WHERE `ID` = 2216;
+-- Pit of Saron (Entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = 432.568, `target_position_y` = 212.344, `target_position_z` = 528.709, `target_orientation` = 0, `VerifiedBuild` = 12340 WHERE `ID` = 5637;
+-- Hellfire Ramparts (Entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = -1355.28, `target_position_y` = 1641.57, `target_position_z` = 68.274, `target_orientation` = 1.0471977, `VerifiedBuild` = 11159 WHERE `ID` = 4150;
+-- The Blood Furnace (Entrance)
+UPDATE `areatrigger_teleport` SET `target_position_x` = -2.73782, `target_position_y` = 19.8424, `target_position_z` = -44.7973, `target_orientation` = 4.3633237, `VerifiedBuild` = 11159 WHERE `ID` = 4152;
+
+UPDATE `spell_target_position` SET `PositionX` = -1824.32, `PositionY` = 5417.23, `PositionZ` = -12.4277, `Orientation` = 2.799037, `VerifiedBuild` = 12340 WHERE `ID` = 33728;
+UPDATE `spell_target_position` SET `PositionX` = -8998.14, `PositionY` = 861.254, `PositionZ` = 29.6206, `Orientation` = 2.25, `VerifiedBuild` = 12340 WHERE `ID` = 17334;
+UPDATE `spell_target_position` SET `PositionX` = -4613.71, `PositionY` = -915.287, `PositionZ` = 501.062, `Orientation` = 0, `VerifiedBuild` = 11159 WHERE `ID` = 44089;