From e510c8fffb0d3ed3e9d705d19e7a9596bfecd48c Mon Sep 17 00:00:00 2001 From: Aokromes Date: Tue, 5 Jul 2011 22:24:21 +0100 Subject: DB/Instances: Fix more instance portals orientation/position --- .../world/2011_07_05_04_world_areatrigger_teleport.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/2011_07_05_04_world_areatrigger_teleport.sql diff --git a/sql/updates/world/2011_07_05_04_world_areatrigger_teleport.sql b/sql/updates/world/2011_07_05_04_world_areatrigger_teleport.sql new file mode 100644 index 00000000000..2e9ecda4ba8 --- /dev/null +++ b/sql/updates/world/2011_07_05_04_world_areatrigger_teleport.sql @@ -0,0 +1,13 @@ +-- More areatriggers rotations and some Z coordinates fixed +UPDATE `areatrigger_teleport` SET `target_orientation`=4.582802 WHERE `id`=259; -- Blackfathom deeps +UPDATE `areatrigger_teleport` SET `target_orientation`=3.147877 WHERE `id`=3186; -- Dire Maul, Capital Gardens, south +UPDATE `areatrigger_teleport` SET `target_orientation`=1.784425 WHERE `id`=3126; -- Maraudon, north +UPDATE `areatrigger_teleport` SET `target_position_z`=81.491974, `target_orientation`='1.259779' WHERE `id`=444; -- Razorfen Downs +UPDATE `areatrigger_teleport` SET `target_orientation`=1.840974 WHERE `id`=1472; -- Blackrock Dephts +UPDATE `areatrigger_teleport` SET `target_orientation`=2.095443 WHERE `id`=1470; -- Blackrock Spire +UPDATE `areatrigger_teleport` SET `target_orientation`=3.663096 WHERE `id`=2568; -- Scholomance +UPDATE `areatrigger_teleport` SET `target_position_z`=108.449623, `target_orientation`=1.935219 WHERE `id`=2221; -- Stratholme +UPDATE `areatrigger_teleport` SET `target_orientation`=4.55217 WHERE `id`=119; -- Deadmines +UPDATE `areatrigger_teleport` SET `target_orientation`=3.20443 WHERE `id`=288; -- Uldaman, north +UPDATE `areatrigger_teleport` SET `target_position_z`=266.22583, `target_orientation`=3.135308 WHERE `id`=882; -- Uldaman, south +UPDATE `areatrigger_teleport` SET `target_orientation`=2.959382 WHERE `id`=448; -- Altar of Atal'Hakkar -- cgit v1.2.3