aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPolytrih <114613162+Polytrih@users.noreply.github.com>2022-11-15 18:52:47 +0100
committerNaddley <NaddleyTC@gmail.com>2022-11-15 18:52:48 +0100
commitca8a7d6c01d87dcb2493ab7a33e3dfb2da909f64 (patch)
tree9eca5b1785cd991916b9863c799a9f99a30b32e2
parente26de2c8d489a5e86a3ced8dccea67bd70576ff8 (diff)
DB/Tele: Added teleport locations for the Kun-Lai Summit
Closes #28532
-rw-r--r--sql/updates/world/master/2022_11_15_06_world.sql25
1 files changed, 25 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_11_15_06_world.sql b/sql/updates/world/master/2022_11_15_06_world.sql
new file mode 100644
index 00000000000..fa594e5c736
--- /dev/null
+++ b/sql/updates/world/master/2022_11_15_06_world.sql
@@ -0,0 +1,25 @@
+SET @TEL_ID := 1919;
+
+DELETE FROM `game_tele` WHERE `id` BETWEEN @TEL_ID+0 AND @TEL_ID+20;
+INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES
+(@TEL_ID+0,1739.9,310.303,477.223,0.933948,870,'BinanVillage'),
+(@TEL_ID+1,2272.97,913.231,481.263,1.41461,870,'EastwindRest'),
+(@TEL_ID+2,1985.18,2122.19,454.644,0.242018,870,'FireboughNook'),
+(@TEL_ID+3,3302.08,1060.84,583.121,0.537358,870,'GarrosharAdvance'),
+(@TEL_ID+4,1809.09,1363.01,468.854,3.13071,870,'GateOfTheAugustCelestials'),
+(@TEL_ID+5,4838.3,53.769,4.94657,0.0166621,870,'IsleOfReckoning'),
+(@TEL_ID+6,2748.99,2151.36,591.273,2.25109,870,'KotaBasecamp'),
+(@TEL_ID+7,2640.53,1175.34,582.654,3.19118,870,'Mogujia'),
+(@TEL_ID+8,3997.27,1092.17,497.154,2.2527,870,'MogushanTerrace'),
+(@TEL_ID+9,3432.75,2120.46,1108.68,2.54802,870,'MountNeverest'),
+(@TEL_ID+10,3105.82,1239.14,654.065,3.93421,870,'OneKeg'),
+(@TEL_ID+11,3930.31,1836.63,904.335,3.58475,870,'PeakOfSerenity'),
+(@TEL_ID+12,1871.12,2055.68,455.691,3.0828,870,'ShadoPanFallback'),
+(@TEL_ID+13,3589.98,2552.52,767.683,6.0179,870,'ShadoPanMonastery'),
+(@TEL_ID+14,2877.51,1460.29,645.747,0.361414,870,'ShaOfAnger'),
+(@TEL_ID+15,2953.22,2976.82,411.916,2.43648,870,'TheOxGate'),
+(@TEL_ID+16,2868.39,538.333,524.107,5.59528,870,'TheYaungolAdvance'),
+(@TEL_ID+17,2152.38,1463.77,487.886,3.6687,870,'WestwindRest'),
+(@TEL_ID+18,3124.26,2623.89,574.748,0.602568,870,'WintersBlossom'),
+(@TEL_ID+19,2741.77,365.025,509.102,2.32094,870,'Yakwash'),
+(@TEL_ID+20,4342.96,930.105,110.593,5.62205,870,'ZouchinVillage');