aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorNaddley <NaddleyTC@gmail.com>2024-12-20 19:04:46 +0100
committerNaddley <NaddleyTC@gmail.com>2024-12-20 19:04:46 +0100
commit3f069d8f3b54ef46d0b8966b18f3d54351c18cda (patch)
tree12d3b0f0ea502fe92fe2f90c3129c9b673e229f0 /sql
parente112e11c1bad590ccab6f4f4bc9599b121f9eb89 (diff)
DB/Tele: Added teleport points for TWW zones
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2024_12_20_02_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_12_20_02_world.sql b/sql/updates/world/master/2024_12_20_02_world.sql
new file mode 100644
index 00000000000..5d9aa8e40b9
--- /dev/null
+++ b/sql/updates/world/master/2024_12_20_02_world.sql
@@ -0,0 +1,11 @@
+SET @TELEID := 2183;
+
+-- Add TWW Zone teleports
+DELETE FROM `game_tele` WHERE `id` BETWEEN @TELEID+0 AND @TELEID+5;
+INSERT INTO `game_tele` (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, `name`) VALUES
+(@TELEID+0, 2663.1, -2587.58, 219.653, 3.13936, 2552, 'Dornogal'),
+(@TELEID+1, 1934.17, -3084.21, 154.751, 0.787718, 2552, 'IsleOfDorn'),
+(@TELEID+2, 2064.52, -120.168, -156.296, 0.359316, 2601, 'Hallowfall'),
+(@TELEID+3, 1749.21, -3332.27, 316.996, 3.21586, 2601, 'TheRingingDeeps'),
+(@TELEID+4, 103.293, -1396.45, -1063.93, 1.43191, 2601, 'AzjKahet'),
+(@TELEID+5, 1944.88, 170.002, 88.6878, 5.36686, 2127, 'SirenIsle');