aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPolytrih <114613162+Polytrih@users.noreply.github.com>2023-09-08 13:41:36 +0200
committerModoX <moardox@gmail.com>2023-09-08 13:41:55 +0200
commit3bd1374b592859461e75462e845168816ab90d29 (patch)
tree1f93076944f31bfaf36b41bed3843cdb7fdfb0a1
parent7df34a631a0671109b8ad393646ef0eb361ae15e (diff)
DB/Tele: Added teleport locations for Isle Of Giants
Closes #29256
-rw-r--r--sql/updates/world/master/2023_09_08_04_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_09_08_04_world.sql b/sql/updates/world/master/2023_09_08_04_world.sql
new file mode 100644
index 00000000000..1d7574e5ce5
--- /dev/null
+++ b/sql/updates/world/master/2023_09_08_04_world.sql
@@ -0,0 +1,7 @@
+SET @TEL_ID := 1998;
+
+DELETE FROM `game_tele` WHERE `id` BETWEEN @TEL_ID+0 AND @TEL_ID+2;
+INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES
+(@TEL_ID+0,5970.37,1084.75,55.5392,0.483188,870,'IsleOfGiants'),
+(@TEL_ID+1,5749,1256.48,0.930707,5.76892,870,'BeeblesWreck'),
+(@TEL_ID+2,5793.35,1075.69,0.740553,0.479262,870,'BozzlesWreck');