From 904e1fad6a376623c18a0722e42985b796fe92d9 Mon Sep 17 00:00:00 2001 From: offl <11556157+offl@users.noreply.github.com> Date: Fri, 31 Jul 2020 22:09:00 +0300 Subject: DB: Fix teleport positions of Scarlet Monastery areatriggers By @ipriver Closes #24982 --- sql/updates/world/3.3.5/2020_07_31_00_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_07_31_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2020_07_31_00_world.sql b/sql/updates/world/3.3.5/2020_07_31_00_world.sql new file mode 100644 index 00000000000..7082637e9ae --- /dev/null +++ b/sql/updates/world/3.3.5/2020_07_31_00_world.sql @@ -0,0 +1,9 @@ +-- +UPDATE `areatrigger_teleport` SET `target_position_x` = 1687.303, `target_position_y` = 1049.928, `target_position_z` = 18.677, `target_orientation` = 1.596 WHERE `ID` = 45; +UPDATE `areatrigger_teleport` SET `target_position_x` = 2915.691, `target_position_y` = -801.529, `target_position_z` = 160.332, `target_orientation` = 3.507 WHERE `ID` = 602; +UPDATE `areatrigger_teleport` SET `target_position_x` = 253.679, `target_position_y` = -206.363, `target_position_z` = 18.677, `target_orientation` = 4.729 WHERE `ID` = 614; +UPDATE `areatrigger_teleport` SET `target_position_x` = 2869.237, `target_position_y` = -820.888, `target_position_z` = 160.332, `target_orientation` = 0.387 WHERE `ID` = 608; +UPDATE `areatrigger_teleport` SET `target_position_x` = 1608.047, `target_position_y` = -318.794, `target_position_z` = 18.672, `target_orientation` = 4.723 WHERE `ID` = 612; +UPDATE `areatrigger_teleport` SET `target_position_x` = 2885.994, `target_position_y` = -835.933, `target_position_z` = 160.326, `target_orientation` = 0.381 WHERE `ID` = 606; +UPDATE `areatrigger_teleport` SET `target_position_x` = 853.079, `target_position_y` = 1319.082, `target_position_z` = 18.671, `target_orientation` = 1.533 WHERE `ID` = 610; +UPDATE `areatrigger_teleport` SET `target_position_x` = 2915.175, `target_position_y` = -823.601, `target_position_z` = 160.327, `target_orientation` = 3.488 WHERE `ID` = 604; -- cgit v1.2.3