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