From de77f046a06182edb62a34b5468b174c478dbaa8 Mon Sep 17 00:00:00 2001 From: Matan Shukry Date: Wed, 24 Feb 2021 22:02:57 +0100 Subject: DB/Tele: Add some new expansion teleport locations Closes #26143 --- sql/updates/world/master/2021_02_24_00_world.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/master/2021_02_24_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_02_24_00_world.sql b/sql/updates/world/master/2021_02_24_00_world.sql new file mode 100644 index 00000000000..69a365ce2b9 --- /dev/null +++ b/sql/updates/world/master/2021_02_24_00_world.sql @@ -0,0 +1,11 @@ +-- Add SL maps to tele locations +SET @TELE_START_ID = 1683; + +DELETE FROM `game_tele` WHERE `id` BETWEEN @TELE_START_ID+0 AND @TELE_START_ID+5; +INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES +(@TELE_START_ID+0,2583,-2521,3308,0,2222,'Maldraxxus'), +(@TELE_START_ID+1,-2943,-4871,6705,0,2222,'Bastion'), +(@TELE_START_ID+2,-6926,883,5669,0,2222,'Ardenweald'), +(@TELE_START_ID+3,-2628,6036,4116,0,2222,'Revendreth'), +(@TELE_START_ID+4,4611,6796,4869,2,2222,'TheMaw'), +(@TELE_START_ID+5,-1834,1542,5275,4.712388,2222,'Oribos'); -- cgit v1.2.3