DB/Tele: Add teleport locations for The Wandering Isle

Closes #29954

1 files changed, 20 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_10_22_05_world.sql b/sql/updates/world/master/2024_10_22_05_world.sql
new file mode 100644
index 00000000000..c89040aecc3
--- /dev/null
+++ b/sql/updates/world/master/2024_10_22_05_world.sql
@@ -0,0 +1,20 @@
+SET @TEL_ID := 2167;
+
+DELETE FROM `game_tele` WHERE `id` BETWEEN @TEL_ID+0 AND @TEL_ID+15;
+INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES
+(@TEL_ID+0,1003.15,3602.38,192.193,3.10705,860,'TheWanderingIsle'),
+(@TEL_ID+1,739.462,3637.39,142.631,4.49721,860,'MandoriVillage'),
+(@TEL_ID+2,1351.5,3374.61,125.649,1.97375,860,'TheDawningValley'),
+(@TEL_ID+3,844.872,4401.16,237.269,1.60542,860,'TheWoodOfStaves'),
+(@TEL_ID+4,1206.6,4263.88,222.736,0.105327,860,'FeFengVillage'),
+(@TEL_ID+5,1043.43,4195.44,205.269,4.7117,860,'MorningBreezeVillage'),
+(@TEL_ID+6,628.728,3922.98,81.7556,0.124933,860,'PoolOfThePaw'),
+(@TEL_ID+7,321.424,3971.64,99.421,2.6877,860,'WreckOfTheSkyseeker'),
+(@TEL_ID+8,403.316,3672.92,81.4312,0.845975,860,'PeiWuForest'),
+(@TEL_ID+9,407.516,3284.52,73.2091,0.597012,860,'KiHanBrewery'),
+(@TEL_ID+10,394.809,3072.58,75.579,0.151689,860,'TheRows'),
+(@TEL_ID+11,623.996,3149.55,87.817,4.45175,860,'TheDaiLoFarmstead'),
+(@TEL_ID+12,971.564,3015.68,105.719,6.06806,860,'TheSingingPools'),
+(@TEL_ID+13,981.351,3603.05,193.114,3.11109,860,'TempleOfFiveDawns'),
+(@TEL_ID+14,1416.67,3687.3,83.6041,4.62298,860,'WuSongVillage'),
+(@TEL_ID+15,1469.91,3464.64,181.788,2.72073,860,'ShangXiTrainingGrounds');