diff options
author | kaelima <kaelima@live.se> | 2012-10-20 03:41:51 +0200 |
---|---|---|
committer | kaelima <kaelima@live.se> | 2012-10-20 03:42:15 +0200 |
commit | 2f4d7fc8e8e91f952c5176614a8ba131ec01a111 (patch) | |
tree | d6a850d2b72d77107e53bc7612f4b7fbe5ce2dd9 | |
parent | 38ca1531d8738141c742d9b7f892a75af3283edd (diff) |
DB: Update period timer for icecrown ship transports
-rw-r--r-- | sql/updates/world/2012_10_20_00_world_transports.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2012_10_20_00_world_transports.sql b/sql/updates/world/2012_10_20_00_world_transports.sql new file mode 100644 index 00000000000..8cc2bae4b47 --- /dev/null +++ b/sql/updates/world/2012_10_20_00_world_transports.sql @@ -0,0 +1,6 @@ +-- Update position for Koltira Deathweaver +UPDATE `creature_transport` SET `TransOffsetX`=45.50927,`TransOffsetY`=6.679555,`TransOffsetZ`=30.17881,`TransOffsetO`=5.445427 WHERE `guid`=36; + +-- Set proper name and period timers for icecrown ships +UPDATE `transports` SET `name`= 'Alliance gunship patrolling above Icecrown (\"The Skybreaker\")',`period`=1051388 WHERE `entry`=192242; +UPDATE `transports` SET `name`= 'Horde gunship patrolling above Icecrown (\"Orgrim''s Hammer\")',`period`=1431158 WHERE `entry`=192241; |