aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <11556157+offl@users.noreply.github.com>2020-07-31 22:09:00 +0300
committerGitHub <noreply@github.com>2020-07-31 22:09:00 +0300
commit904e1fad6a376623c18a0722e42985b796fe92d9 (patch)
tree72db4c38bd7ddaff1206d518672d764ad5df4fbe
parent06f59caf3d974f25f3380d91e1aba9288c7df287 (diff)
DB: Fix teleport positions of Scarlet Monastery areatriggers
By @ipriver Closes #24982
-rw-r--r--sql/updates/world/3.3.5/2020_07_31_00_world.sql9
1 files changed, 9 insertions, 0 deletions
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;