aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorModoX <moardox@gmail.com>2022-12-23 22:50:00 +0100
committerModoX <moardox@gmail.com>2022-12-23 22:50:00 +0100
commit149681b0b41f1be0817171f9c8a66089b5755d57 (patch)
tree8ec771b59c26821ec216bd907138494cc97316d4 /sql
parenta3861214ddcfefd7afa516365ae0a254118453f7 (diff)
DB/Tele: Added zone teleports for 10.0.2
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_12_23_02_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_23_02_world.sql b/sql/updates/world/master/2022_12_23_02_world.sql
new file mode 100644
index 00000000000..7d479fc61ff
--- /dev/null
+++ b/sql/updates/world/master/2022_12_23_02_world.sql
@@ -0,0 +1,10 @@
+--
+SET @TELEID := 1959;
+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, -1365.67, -2966.95, 1174.7, 0.677586, 2444, 'Thaldraszus'),
+(@TELEID+1, 6510.56, -3318.14, 162.985, 5.60205, 2444, 'ForbiddenReach'),
+(@TELEID+2, -3817.34, 505.7, 647.829, 5.60991, 2444, 'AzureSpan'),
+(@TELEID+3, -620.498, 2198.33, 436.668, 1.7104, 2444, 'OhnahranPlains'),
+(@TELEID+4, 2934.35, 188.591, 498.596, 3.25371, 2444, 'WakingShores'),
+(@TELEID+5, 115.639, -939.723, 836.586, 1.60829, 2444, 'Valdrakken');