aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorkaelima <kaelima@live.se>2012-10-20 03:41:51 +0200
committerkaelima <kaelima@live.se>2012-10-20 03:42:15 +0200
commit2f4d7fc8e8e91f952c5176614a8ba131ec01a111 (patch)
treed6a850d2b72d77107e53bc7612f4b7fbe5ce2dd9
parent38ca1531d8738141c742d9b7f892a75af3283edd (diff)
DB: Update period timer for icecrown ship transports
-rw-r--r--sql/updates/world/2012_10_20_00_world_transports.sql6
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;