From a310e11ab69cd5b005f3cd522b2467331cfa9f28 Mon Sep 17 00:00:00 2001 From: click Date: Sat, 2 Jul 2011 19:15:52 +0200 Subject: DB: Add teleportlocations for the following locations: The Frozen Halls, The Shadow Vault, Chamber Of Aspects (thanks to Aokromes) --- sql/updates/world/2011_07_02_01_world_game_tele.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2011_07_02_01_world_game_tele.sql (limited to 'sql') diff --git a/sql/updates/world/2011_07_02_01_world_game_tele.sql b/sql/updates/world/2011_07_02_01_world_game_tele.sql new file mode 100644 index 00000000000..d464f59fb29 --- /dev/null +++ b/sql/updates/world/2011_07_02_01_world_game_tele.sql @@ -0,0 +1,7 @@ +-- GAME_TELE: Some missing areas +SET @id := 1419; +DELETE FROM `game_tele` WHERE `id` IN(@id,@id+1,@id+2) +INSERT INTO `game_tele` (`id`,`position_x`,`position_y`,`position_z`,`orientation`,`map`,`name`) VALUES +(@id,5690.97,2141.074,798.0541,4.4344,571, 'TheFrozenHalls'), +(@id+1,8427.875,2706.33,655.095,5.743,571, 'TheShadowVault'), +(@id+2,3641.45,282.75,-120.145,3.325,571, 'ChamberOfAspects'); -- cgit v1.2.3