Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- порталы на пике безмятежности
- DELETE FROM `gameobject` WHERE `id` IN (259031,210804) AND areaId = 6081;
- INSERT INTO `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `AiID`, `state`, `isActive`, `personal_size`, `realmMask`, `VerifiedBuild`, `Comment`, `LoadBuild`, `LoadExpansion`) VALUES
- (259031, 870, 5841, 6081, 1, 1, '', 3809.1, 1775.11, 950.993, 0.0603386, -0, -0, 0.0301647, 0.999545, 300, 0, 0, 1, 0, 0, 0, 1, 'Alliance portal Peak Of Serenity', 0, 6),
- (210804, 870, 5841, 6081, 1, 1, '', 3800.71, 1802.31, 950.993, 0.0603386, -0, -0, 0.0301647, 0.999545, 300, 0, 0, 1, 0, 0, 0, 1, 'Horde portal Peak Of Serenity', 0, 6);
- -- Портал в оплоте монаха на пик безмятежности
- DELETE FROM `spell_target_position` WHERE `ID`= 216029;
- INSERT INTO `spell_target_position` (`ID`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `PositionO`, `VerifiedBuild`, `LoadBuild`, `LoadExpansion`) VALUES
- (216029, 870, 3819.23, 1792.2, 950.35, 1.86141, 0, 0, 6);
- -- фикс всех порталов по фракциям Альянс/Орда
- UPDATE `gameobject_template` SET `faction` = 1735 WHERE `entry` IN (191009,183326,183323,183327,183324,215112,215113,215126,215124,215127,215125,246007,246001,246000,245999,246004,206595,207687,207690,207686,207688,207689,233600); -- Орда
- UPDATE `gameobject_template` SET `faction` = 1732 WHERE `entry` IN (190960,183317,183325,183322,183321,215121,215120,215116,215118,215119,215117,246002,245998,245997,246003,246006,206594,207693,207691,207695,207692,207694,243477); -- Альянс
- -- Фикс фазы у портала Орды
- UPDATE `gameobject` SET `PhaseId` = '' WHERE `guid` = 141032;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement