diff options
| author | Aokromes <aokromes@trinitycore.contrib> | 2011-07-05 22:24:21 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-07-05 22:24:21 +0100 |
| commit | e510c8fffb0d3ed3e9d705d19e7a9596bfecd48c (patch) | |
| tree | 876ba15215ac5d56ca25ff380b81890a37ef17e6 | |
| parent | c572adea154244ebcfdb0fd55270533f95ae6f39 (diff) | |
DB/Instances: Fix more instance portals orientation/position
| -rw-r--r-- | sql/updates/world/2011_07_05_04_world_areatrigger_teleport.sql | 13 |
1 files changed, 13 insertions, 0 deletions
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 |