From 2f4d7fc8e8e91f952c5176614a8ba131ec01a111 Mon Sep 17 00:00:00 2001 From: kaelima Date: Sat, 20 Oct 2012 03:41:51 +0200 Subject: DB: Update period timer for icecrown ship transports --- sql/updates/world/2012_10_20_00_world_transports.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2012_10_20_00_world_transports.sql (limited to 'sql') 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; -- cgit v1.2.3