aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPolytrih <114613162+Polytrih@users.noreply.github.com>2023-09-08 13:49:10 +0200
committerModoX <moardox@gmail.com>2023-09-08 13:49:10 +0200
commit4d3243ba210d9eb63c3397de3ad07faede2d5e82 (patch)
tree881650128817c9ed5ceccbda07d18f989189e281
parent8e8625d0055ecb2f9a0e71cfa6a32caad6c9d63e (diff)
DB/Tele: Added teleport locations for Krokuun
Closes #29270
-rw-r--r--sql/updates/world/master/2023_09_08_06_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_09_08_06_world.sql b/sql/updates/world/master/2023_09_08_06_world.sql
new file mode 100644
index 00000000000..a2389289cc1
--- /dev/null
+++ b/sql/updates/world/master/2023_09_08_06_world.sql
@@ -0,0 +1,10 @@
+SET @TEL_ID := 2006;
+
+DELETE FROM `game_tele` WHERE `id` BETWEEN @TEL_ID+0 AND @TEL_ID+5;
+INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES
+(@TEL_ID+0,969.152,1615.3,535.568,1.38247,1669,'KrokulHovel'),
+(@TEL_ID+1,890.549,2562.48,389.29,5.56236,1669,'ShatteredFields'),
+(@TEL_ID+2,1240.26,2363,451.079,0.282137,1669,'TheXenedar'),
+(@TEL_ID+3,1069.35,1126.49,490.827,6.08936,1669,'PetrifiedForest'),
+(@TEL_ID+4,1246.06,1712.26,515.311,6.26608,1669,'AnnihilanPits'),
+(@TEL_ID+5,1949.59,1653.62,353.151,0.732167,1669,'NathraxasHold');