/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. 

  2. UPDATE `creature_transport` SET `TransOffsetX`=45.50927,`TransOffsetY`=6.679555,`TransOffsetZ`=30.17881,`TransOffsetO`=5.445427 WHERE `guid`=36;
    3. 

  3. 

  4. -- Set proper name and period timers for icecrown ships
    5. 

  5. UPDATE `transports` SET `name`= 'Alliance gunship patrolling above Icecrown (\"The Skybreaker\")',`period`=1051388 WHERE `entry`=192242;
    6. 

  6. UPDATE `transports` SET `name`= 'Horde gunship patrolling above Icecrown (\"Orgrim''s Hammer\")',`period`=1431158 WHERE `entry`=192241;
    7.