/sql/old/4.3.4/TDB01_to_TDB02_updates/world/207_gameobject_template.sql

https://gitlab.com/Lbniese/TrinityCore_434 · SQL · 38 lines · 35 code · 2 blank · 1 comment · 0 complexity · 2ca157c668ee1927ea2ac409682dde59 MD5 · raw file 

    

  1. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=206608; -- Elevator
    2. 

  2. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=206610; -- Elevator
    3. 

  3. UPDATE `gameobject_template` SET `flags`=40,`faction`=114 WHERE `entry`=208471; -- Doodad_org_arena_ivory_pillar01
    4. 

  4. UPDATE `gameobject_template` SET `flags`=40,`faction`=114 WHERE `entry`=208470; -- Doodad_org_arena_lightning_pillar01
    5. 

  5. UPDATE `gameobject_template` SET `flags`=40,`faction`=114 WHERE `entry`=208469; -- Doodad_org_arena_pillar01
    6. 

  6. UPDATE `gameobject_template` SET `flags`=40,`faction`=114 WHERE `entry`=208468; -- Doodad_org_arena_axe_pillar01
    7. 

  7. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=208001; -- The Blightbringer
    8. 

  8. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=208000; -- The Graceful Maiden
    9. 

  9. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=207889; -- Doodad_Goblin_elevator01
    10. 

  10. UPDATE `gameobject_template` SET `flags`=40,`faction`=1375 WHERE `entry`=207547; -- Lift of the Makers
    11. 

  11. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=207209; -- Doodad_Abyssal_Jellyfish_Elevator01
    12. 

  12. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=206609; -- Elevator
    13. 

  13. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=205080; -- Doodad_GnomeElevatorCar02
    14. 

  14. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=205079; -- Doodad_GnomeElevatorCar04
    15. 

  15. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=204246; -- Doodad_Goblin_elevator01
    16. 

  16. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=204245; -- Doodad_Goblin_elevator01
    17. 

  17. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=204244; -- Doodad_Goblin_elevator01
    18. 

  18. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=204243; -- Doodad_Goblin_elevator01
    19. 

  19. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=204423; -- Orc Gunship
    20. 

  20. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=4170; -- Mesa Elevator
    21. 

  21. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=4171; -- Mesa Elevator
    22. 

  22. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=11898; -- Mesa Elevator
    23. 

  23. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=11899; -- Mesa Elevator
    24. 

  24. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=203716; -- Blackwing Descent Elevator
    25. 

  25. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=207834; -- Doodad_BlackWingV2_Elevator_Onyxia01
    26. 

  26. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=196838; -- Doodad_Goblin_PoolElevator01
    27. 

  27. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=196837; -- Doodad_Goblin_PoolElevator01
    28. 

  28. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=152614; -- Elevator
    29. 

  29. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=47297; -- Mesa Elevator
    30. 

  30. UPDATE `gameobject_template` SET `flags`=40 WHERE `entry`=47296; -- Mesa Elevator
    31. 

  31. 

  32. -- Remove double spawn
    33. 

  33. SET @OGUID :=76;
    34. 

  34. 

  35. DELETE FROM `gameobject` WHERE `Id` IN (206608,206610);
    36. 

  36. INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
    37. 

  37. (@OGUID, 206608, 1, 1, 1, 1704.782, -4265.96, 34.88367, 3.976283, 0, 0, 0.9563048, -0.2923717, 120, 255, 24), -- Elevator
    38. 

  38. (@OGUID+1, 206610, 1, 1, 1, 1755.314, -4396.597, 42.34779, 3.744939, 0, 0, 0.9563048, -0.2923717, 120, 255, 24); -- Elevator
    39.