PageRenderTime 27ms CodeModel.GetById 18ms app.highlight 5ms RepoModel.GetById 1ms app.codeStats 0ms

/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
2UPDATE `creature_transport` SET `TransOffsetX`=45.50927,`TransOffsetY`=6.679555,`TransOffsetZ`=30.17881,`TransOffsetO`=5.445427 WHERE `guid`=36;
3
4-- Set proper name and period timers for icecrown ships
5UPDATE `transports` SET `name`= 'Alliance gunship patrolling above Icecrown (\"The Skybreaker\")',`period`=1051388 WHERE `entry`=192242;
6UPDATE `transports` SET `name`= 'Horde gunship patrolling above Icecrown (\"Orgrim''s Hammer\")',`period`=1431158 WHERE `entry`=192241;