DB/Tele: Added teleport locations for Revendreth

Closes #29262

1 files changed, 20 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_09_08_13_world.sql b/sql/updates/world/master/2023_09_08_13_world.sql
new file mode 100644
index 00000000000..e577a493585
--- /dev/null
+++ b/sql/updates/world/master/2023_09_08_13_world.sql
@@ -0,0 +1,20 @@
+SET @TEL_ID := 2100;
+
+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,-1423.22,7956.27,4033.56,4.61343,2222,'DominanceKeep'),
+(@TEL_ID+1,-1867.85,7599.76,4193.72,2.01925,2222,'Sinfall'),
+(@TEL_ID+2,-2642.87,7613.73,4021.14,5.67214,2222,'EmberWard'),
+(@TEL_ID+3,-2172.83,7695.64,4096.11,1.76792,2222,'SanctuaryOfTheMad'),
+(@TEL_ID+4,-2190.45,7225.37,4240.09,5.7334,2222,'CharredRamparts'),
+(@TEL_ID+5,-1518.34,6581.07,4228.82,3.92618,2222,'MenagerieOfTheMaster'),
+(@TEL_ID+6,-1738.65,5998,4117.93,4.66838,2222,'OldGate'),
+(@TEL_ID+7,-1865.22,5058.7,4087.08,5.70196,2222,'Archivam'),
+(@TEL_ID+8,-2561.38,6273.17,3944.25,4.66603,2222,'TheEndmire'),
+(@TEL_ID+9,-2781,6649.56,3995.92,0.770451,2222,'TheBanewood'),
+(@TEL_ID+10,-3458.5,6505.14,4015.48,3.54761,2222,'TheNightMarket'),
+(@TEL_ID+11,-3301.72,7138.86,4071.52,5.7216,2222,'Dreadhollow'),
+(@TEL_ID+12,-2966.91,6711.35,4038.64,2.14803,2222,'WanecryptHill'),
+(@TEL_ID+13,-2596.26,5963.08,4115.58,3.50049,2222,'Darkhaven'),
+(@TEL_ID+14,-2800.58,5148.82,4142.62,4.71391,2222,'CaretakersManor'),
+(@TEL_ID+15,-3370.91,5468.52,4274.84,2.28783,2222,'PridefallHamlet');