DB/Tele: Added teleport locations for Nazjatar

Closes #29266

1 files changed, 23 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_09_08_07_world.sql b/sql/updates/world/master/2023_09_08_07_world.sql
new file mode 100644
index 00000000000..0124e0a21b5
--- /dev/null
+++ b/sql/updates/world/master/2023_09_08_07_world.sql
@@ -0,0 +1,23 @@
+SET @TEL_ID := 2012;
+
+DELETE FROM `game_tele` WHERE `id` BETWEEN @TEL_ID+0 AND @TEL_ID+18;
+INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES
+(@TEL_ID+0,1596.1,328.452,-370.547,5.60477,1718,'AshenStrand'),
+(@TEL_ID+1,2187.28,116.261,-512.821,4.71021,1718,'ZanjirTerrace'),
+(@TEL_ID+2,2315.07,-551.341,-643.224,6.26922,1718,'GateOfTheQueen'),
+(@TEL_ID+3,1898.6,-983.473,-529.211,0.594719,1718,'AzshariTerrace'),
+(@TEL_ID+4,1543.86,-1194.84,-412.983,4.80602,1718,'Kalmethir'),
+(@TEL_ID+5,1530.13,-1538.05,-401.376,3.43546,1718,'TheDrownedMarket'),
+(@TEL_ID+6,1767.83,-1734.6,-425.612,1.58035,1718,'ElunalorTemple'),
+(@TEL_ID+7,1846.45,-1958.25,-376.557,4.16272,1718,'ZinAzshari'),
+(@TEL_ID+8,2124.66,-1291.47,-553.092,4.10147,1718,'DeepcoilTunnels'),
+(@TEL_ID+9,1537.84,-1157,-416.205,4.82879,1718,'Nazjatar'),
+(@TEL_ID+10,1461.38,-333.616,-492.131,3.0224,1718,'DragonsTeethBasin'),
+(@TEL_ID+11,1061.47,-189.614,-301.734,0.611219,1718,'TheHangingReef'),
+(@TEL_ID+12,1286.99,-109.97,-330.624,2.46476,1718,'Mezzamere'),
+(@TEL_ID+13,1170.54,-1076,-329.076,0.985848,1718,'CoralForest'),
+(@TEL_ID+14,1028.73,-423.325,-281.329,4.08896,1718,'NewHome'),
+(@TEL_ID+15,621.425,-233.204,-183.583,3.03258,1718,'SpearsOfAzshara'),
+(@TEL_ID+16,104.167,0.774432,-30.1898,1.09186,1718,'TidesFallHorde'),
+(@TEL_ID+17,115.267,-486.092,-0.737922,5.79639,1718,'TidesFallAlliance'),
+(@TEL_ID+18,353.518,-287.681,-191.393,5.67072,1718,'WreckOfTheOldBlanchy');