diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2019-04-29 20:35:58 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-04-29 20:35:58 +0200 |
| commit | 801a78591a2a54f4d9140c7737d48577a61b7cb4 (patch) | |
| tree | a8572a29329c3ba83d0143ff2d4ba7fa12c775e9 | |
| parent | 6d3e20525cc6ec0ff3946fca18434651cb45d718 (diff) | |
typo fix
| -rw-r--r-- | sql/updates/world/master/2019_04_29_00_world.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/sql/updates/world/master/2019_04_29_00_world.sql b/sql/updates/world/master/2019_04_29_00_world.sql index 332e654f292..09af31fb895 100644 --- a/sql/updates/world/master/2019_04_29_00_world.sql +++ b/sql/updates/world/master/2019_04_29_00_world.sql @@ -4,10 +4,10 @@ UPDATE `creature` SET `MovementType`= 1, `spawndist`= 7 WHERE `ID` IN (51712, 45 SET @CGUID := 252516; DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+2; -INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES -(@CGUID+0, 47062, 1, 5034, 5666, 1, 169, 0, 0, 0, -9757.48, -918.474, 56.99433, 0.6457718, 120, 0, 0, 0, 0, 0, 0, 0, 0, 26654), -- Vir'Naal Priest (Area: Vir'naal Dam - Difficulty: 0) -(@CGUID+1, 47062, 1, 5034, 5666, 1, 169, 0, 0, 0, -9761.31, -912.45, 57.00123, 0.6457718, 120, 0, 0, 0, 0, 0, 0, 0, 0, 26654), -- Vir'Naal Priest (Area: Vir'naal Dam - Difficulty: 0) -(@CGUID+2, 46135, 1, 5034, 5666, 1, 169, 0, 0, 0, -9758.25, -914.427, 57.09123, 0.6457718, 120, 0, 0, 0, 0, 0, 0, 0, 0, 26654); -- High Priest Amet (Area: Vir'naal Dam - Difficulty: 0) +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 47062, 1, 5034, 5666, "0", 169, 0, 0, 0, -9757.48, -918.474, 56.99433, 0.6457718, 120, 0, 0, 0, 0, 0, 0, 0, 0, 26654), -- Vir'Naal Priest (Area: Vir'naal Dam - Difficulty: 0) +(@CGUID+1, 47062, 1, 5034, 5666, "0", 169, 0, 0, 0, -9761.31, -912.45, 57.00123, 0.6457718, 120, 0, 0, 0, 0, 0, 0, 0, 0, 26654), -- Vir'Naal Priest (Area: Vir'naal Dam - Difficulty: 0) +(@CGUID+2, 46135, 1, 5034, 5666, "0", 169, 0, 0, 0, -9758.25, -914.427, 57.09123, 0.6457718, 120, 0, 0, 0, 0, 0, 0, 0, 0, 26654); -- High Priest Amet (Area: Vir'naal Dam - Difficulty: 0) DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+2; INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES @@ -17,5 +17,5 @@ INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `e SET @OGUID := 200965; DELETE FROM `gameobject` WHERE `guid`= @OGUID+0; -INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES -(@OGUID+0, 205564, 1, 5034, 5599, 1, 169, 0, -10674.59, -1323.694, 15.63416, 3.647743, 0.004201889, 0.001173973, -0.9681377, 0.2503803, 120, 255, 1, 26654); -- Meeting Stone (Area: Lost City of the Tol'vir - Difficulty: 0) +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 205564, 1, 5034, 5599, "0", 169, 0, -10674.59, -1323.694, 15.63416, 3.647743, 0.004201889, 0.001173973, -0.9681377, 0.2503803, 120, 255, 1, 26654); -- Meeting Stone (Area: Lost City of the Tol'vir - Difficulty: 0) |