/sql/old/ancient/3.3.5a/TDB49_to_TDB50_updates/world/2012_10_20_00_world_transports.sql

https://gitlab.com/trinitycore/TrinityCore_434 · SQL · 6 lines · 3 code · 1 blank · 2 comment · 0 complexity · bb5c4f6814b109daca0d90521bae2d64 MD5 · raw file

  1. -- Update position for Koltira Deathweaver
  2. UPDATE `creature_transport` SET `TransOffsetX`=45.50927,`TransOffsetY`=6.679555,`TransOffsetZ`=30.17881,`TransOffsetO`=5.445427 WHERE `guid`=36;
  3. -- Set proper name and period timers for icecrown ships
  4. UPDATE `transports` SET `name`= 'Alliance gunship patrolling above Icecrown (\"The Skybreaker\")',`period`=1051388 WHERE `entry`=192242;
  5. UPDATE `transports` SET `name`= 'Horde gunship patrolling above Icecrown (\"Orgrim''s Hammer\")',`period`=1431158 WHERE `entry`=192241;