diff options
| author | Nyeriah <sarah.trysan@live.com> | 2014-12-26 03:58:42 -0200 |
|---|---|---|
| committer | Nyeriah <sarah.trysan@live.com> | 2014-12-26 03:58:42 -0200 |
| commit | aff5229cd1777581bd85079d064037a57bf17799 (patch) | |
| tree | 22193863cb67c840eeb13eec021e5496f6363e07 /sql/updates | |
| parent | d13036442e82f4fe8140db09707eaa37e2392160 (diff) | |
Scripts/Naxxramas: Add script support for quarter teleporters and spawn missing ones
Updates #13255
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2014_12_26_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2014_12_26_00_world.sql b/sql/updates/world/2014_12_26_00_world.sql new file mode 100644 index 00000000000..101ed3c08be --- /dev/null +++ b/sql/updates/world/2014_12_26_00_world.sql @@ -0,0 +1,9 @@ +SET @OGUID := 6166; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+2; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0, 181575, 533, 3, 1, 3465.175, -3940.402, 308.79, 2.443457, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- 181575 (Area: 3456) +(@OGUID+1, 181578, 533, 3, 1, 2493.018, -2921.778, 241.1933, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- 181578 (Area: -1) +(@OGUID+2, 181576, 533, 3, 1, 3539.016, -2936.821, 302.4756, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1); -- 181576 (Area: 3456) + +-- These gameobjects have wrong flags at tdb 335, it's fine at 6.x. As seen on sniffs, they should have flags 16. Previous value was 6553616. +UPDATE `gameobject_template` SET `flags` = 16 WHERE `entry` IN (181575, 181576); |