From 4d3243ba210d9eb63c3397de3ad07faede2d5e82 Mon Sep 17 00:00:00 2001 From: Polytrih <114613162+Polytrih@users.noreply.github.com> Date: Fri, 8 Sep 2023 13:49:10 +0200 Subject: DB/Tele: Added teleport locations for Krokuun Closes #29270 --- sql/updates/world/master/2023_09_08_06_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/master/2023_09_08_06_world.sql (limited to 'sql') 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'); -- cgit v1.2.3