aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPolytrih <114613162+Polytrih@users.noreply.github.com>2023-09-08 14:19:55 +0200
committerModoX <moardox@gmail.com>2023-09-08 14:19:55 +0200
commit289b1164f990c4f08e1cd2cc07fa17587c9c2b97 (patch)
tree29a26efd8324a55e77ea830c56139342f0fbf09d
parentb6e5b617298c5df8fd4df968900ea106a3a70be1 (diff)
DB/Tele: Added teleport locations for The Maw
Closes #29271
-rw-r--r--sql/updates/world/master/2023_09_08_14_world.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_09_08_14_world.sql b/sql/updates/world/master/2023_09_08_14_world.sql
new file mode 100644
index 00000000000..af22ff7c8b8
--- /dev/null
+++ b/sql/updates/world/master/2023_09_08_14_world.sql
@@ -0,0 +1,14 @@
+SET @TEL_ID := 2116;
+
+DELETE FROM `game_tele` WHERE `id` BETWEEN @TEL_ID+0 AND @TEL_ID+9;
+INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES
+(@TEL_ID+0,4278.48,5853.6,4786.76,1.47456,2222,'Desmotaeron'),
+(@TEL_ID+1,5152.46,6913.03,4734.33,2.00863,2222,'GorgoaRiverOfSouls'),
+(@TEL_ID+2,5215.91,7504.09,4895.5,0.71115,2222,'TheTremaculum'),
+(@TEL_ID+3,4901.99,7416.4,4776.32,5.50208,2222,'PlanesOfTorment'),
+(@TEL_ID+4,4137.64,7879.74,4971.68,5.51228,2222,'CrucibleOfTheDamned'),
+(@TEL_ID+5,4837.19,7777.55,4840.77,2.63381,2222,'Calcis'),
+(@TEL_ID+6,3924.32,6546.86,4787.98,2.45551,2222,'TheBeastwarrens'),
+(@TEL_ID+7,4006.65,7468.58,4818.85,2.26468,2222,'PerditionHold'),
+(@TEL_ID+8,4414.25,6806.36,4878.59,0.623191,2222,'Cocyrus'),
+(@TEL_ID+9,4591.67,6761.2,4850.94,4.97665,2222,'VenarisRefuge');