From 3ba563acce3afe8333c8601f9f1454bb5fade562 Mon Sep 17 00:00:00 2001 From: offl Date: Tue, 18 Aug 2020 02:52:42 +0300 Subject: DB/Areatrigger: Add correct teleport positions from world safe locs to more areatriggers Probably last part. 30 areatriggers requires updates (all without VerifiedBuild) but we can't use positions for most of them from WSL since they were changed in Cata. Positions for some of them can be found in 3.x.x sniffs --- .../world/3.3.5/2020_08_18_02_world_335.sql | 26 ++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_08_18_02_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_08_18_02_world_335.sql b/sql/updates/world/3.3.5/2020_08_18_02_world_335.sql new file mode 100644 index 00000000000..1734140c64c --- /dev/null +++ b/sql/updates/world/3.3.5/2020_08_18_02_world_335.sql @@ -0,0 +1,26 @@ +-- +UPDATE `areatrigger_teleport` SET `VerifiedBuild` = 15882 WHERE `ID` IN (2547,2548,2549); + +UPDATE `areatrigger_teleport` SET /*Zul'Gurub Exit*/ `target_position_x`=-11916.2, `target_position_y`=-1209.47, `target_position_z`=92.2873, `target_orientation`=1.57079, `VerifiedBuild`=15882 WHERE `ID`=3930; -- WSL 3995 +UPDATE `areatrigger_teleport` SET /*Deeprun Tram - Ironforge Instance (Inside)*/ `target_position_x`=-4839.51, `target_position_y`=-1317.74, `target_position_z`=501.868, `target_orientation`=1.48352, `VerifiedBuild`=15882 WHERE `ID`=2166; -- WSL 3648 +UPDATE `areatrigger_teleport` SET /*Deeprun Tram - Stormwind Instance*/ `target_position_x`=67.7607, `target_position_y`=2490.98, `target_position_z`=-4.29649, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `ID`=2173; -- WSL 3650 +UPDATE `areatrigger_teleport` SET /*Deeprun Tram - Stormwind Instance*/ `target_position_x`=69.2277, `target_position_y`=10.3932, `target_position_z`=-4.29665, `target_orientation`=3.14159, `VerifiedBuild`=15882 WHERE `ID`=2175; -- WSL 3651 +UPDATE `areatrigger_teleport` SET /*Stratholme - Eastern Plaguelands Instance*/ `target_position_x`=3590.87, `target_position_y`=-3643.22, `target_position_z`=138.491, `target_orientation`=5.49778, `VerifiedBuild`=15882 WHERE `ID`=2214; -- WSL 3652 +UPDATE `areatrigger_teleport` SET /*Stratholme - Eastern Plaguelands Instance*/ `target_position_x`=3233.06, `target_position_y`=-4048.3, `target_position_z`=108.442, `target_orientation`=2.00712, `VerifiedBuild`=15882 WHERE `ID`=2221; -- WSL 3655 +-- Sometimes Z position may look incorrect but it's correct https://youtu.be/2GxM9F192MA?t=18 +UPDATE `areatrigger_teleport` SET /*Blackrock Mountain - Searing Gorge Instance*/ `target_position_x`=456.929, `target_position_y`=34.0923, `target_position_z`=-68.0896, `target_orientation`=4.71238, `VerifiedBuild`=15882 WHERE `ID`=1466; -- WSL 3643 +UPDATE `areatrigger_teleport` SET /*Blackrock Spire - Searing Gorge Instance (Inside)*/ `target_position_x`=78.3534, `target_position_y`=-226.841, `target_position_z`=49.7662, `target_orientation`=4.71238, `VerifiedBuild`=15882 WHERE `ID`=1468; -- WSL 3644 +UPDATE `areatrigger_teleport` SET /*Blackrock Spire - Searing Gorge Instance*/ `target_position_x`=-7524.65, `target_position_y`=-1229.13, `target_position_z`=285.731, `target_orientation`=2.09439, `VerifiedBuild`=15882 WHERE `ID`=1470; -- WSL 3645 +UPDATE `areatrigger_teleport` SET /*Blackrock Dephts - Searing Gorge Instance*/ `target_position_x`=-7178.41, `target_position_y`=-922.152, `target_position_z`=166.092, `target_orientation`=2.00712, `VerifiedBuild`=15882 WHERE `ID`=1472; -- WSL 3646 +UPDATE `areatrigger_teleport` SET /*Razorfen Downs Entrance*/ `target_position_x`=2593.68, `target_position_y`=1111.23, `target_position_z`=50.9518, `target_orientation`=4.71238, `VerifiedBuild`=15882 WHERE `ID`=442; -- WSL 3614 +UPDATE `areatrigger_teleport` SET /*Gnomeregan Entrance*/ `target_position_x`=-329.484, `target_position_y`=-3.22991, `target_position_z`=-152.846, `target_orientation`=2.96705, `VerifiedBuild`=15882 WHERE `ID`=324; -- WSL 3613 +UPDATE `areatrigger_teleport` SET /*Blackphantom Deeps Entrance*/ `target_position_x`=-150.234, `target_position_y`=106.594, `target_position_z`=-39.779, `target_orientation`=4.45058, `VerifiedBuild`=15882 WHERE `ID`=257; -- WSL 3608 +UPDATE `areatrigger_teleport` SET /*Shadowfang Keep Entrance*/ `target_position_x`=-228.191, `target_position_y`=2111.41, `target_position_z`=76.8904, `target_orientation`=1.22173, `VerifiedBuild`=15882 WHERE `ID`=145; -- WSL 3602 +UPDATE `areatrigger_teleport` SET /*DeadMines Instance Start*/ `target_position_x`=-11208, `target_position_y`=1676.41, `target_position_z`=24.5716, `target_orientation`=4.71238, `VerifiedBuild`=15882 WHERE `ID`=119; -- WSL 3601 + +-- 6.28319 is value converted from 360 degree, actually 0 is used +UPDATE `areatrigger_teleport` SET `target_orientation` = 0 WHERE `ID` IN (924,2410,2411,2547,2548,2549,3133,3185,3190,4131,4364,4397,4416,4468,4469,4470,4598,4619); + +DELETE FROM `areatrigger_teleport` WHERE `ID` = 2068; +INSERT INTO `areatrigger_teleport` (`ID`,`Name`,`target_map`,`target_position_x`,`target_position_y`,`target_position_z`,`target_orientation`,`VerifiedBuild`) VALUES +(2068,"Blackrock Spire - Target - Shaft",0,-7558.39,-1309.43,248.454,1.57079,15882); -- cgit v1.2.3