01-19-2019, 06:58 PM
Opraveno, waypointy jsem udělal sám a smart_script zkopírované z https://github.com/TrinityCore/TrinityCore/issues/3724.
Vyzkoušeno na Chudákovi - funkční.
Věci na import:
DELETE FROM waypoints WHERE entry=20763;
DELETE FROM smart_scripts WHERE entryorguid=20763;
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','0','1','19','0','100','0','10425','0','0','0','1','0','0','0','0','0','0','21','10','0','0','0','0','0','0','Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Say Line 0');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','1','2','61','0','100','0','10425','0','0','0','53','0','20763','0','0','0','2','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Start Waypoint');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','2','14','61','0','100','0','10425','0','0','0','64','1','0','0','0','0','0','21','10','0','0','0','0','0','0','Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Store Targetlist');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','7','0','40','0','100','0','14','20763','0','0','54','4000','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 121 Reached - Pause Waypoint');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','8','10','40','0','100','0','14','20763','0','0','15','10425','0','0','0','0','0','12','1','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 123 Reached - Quest Credit \'Escape from the Staging Grounds\'');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','9','0','6','0','100','0','0','0','0','0','6','10425','0','0','0','0','0','12','1','0','0','0','0','0','0','Captured Protectorate Vanguard - On Just Died - Fail Quest \'Escape from the Staging Grounds\'');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','10','0','61','0','100','0','13','20763','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 123 Reached - Say Line 1');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','11','12','40','0','100','0','15','20763','0','0','1','2','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 125 Reached - Say Line 2');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','12','13','61','0','100','0','15','20763','0','0','11','35517','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 125 Reached - Cast \'Teleport\'');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','13','0','61','0','100','0','15','20763','0','0','41','3000','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 125 Reached - Despawn In 3000 ms');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','14','0','61','0','100','0','10425','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Set Npc Flag ');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','15','0','11','0','100','0','0','0','0','0','81','2','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Respawn - Set Npc Flag Questgiver');
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','1','4055','2293','113',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','2','4057','2301','112',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','3','4070','2302','111',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','4','4086','2296','109',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','5','4100','2298','107',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','6','4123','2294','104',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','7','4177','2303','107',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','8','4239','2292','129',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','9','4263','2291','126',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','10','4270','2284','125',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','11','4269','2264','127',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','12','4253','2235','135',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','13','4248','2213','137',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','14','4251','2172','137',NULL);
Vyzkoušeno na Chudákovi - funkční.
Věci na import:
DELETE FROM waypoints WHERE entry=20763;
DELETE FROM smart_scripts WHERE entryorguid=20763;
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','0','1','19','0','100','0','10425','0','0','0','1','0','0','0','0','0','0','21','10','0','0','0','0','0','0','Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Say Line 0');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','1','2','61','0','100','0','10425','0','0','0','53','0','20763','0','0','0','2','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Start Waypoint');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','2','14','61','0','100','0','10425','0','0','0','64','1','0','0','0','0','0','21','10','0','0','0','0','0','0','Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Store Targetlist');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','7','0','40','0','100','0','14','20763','0','0','54','4000','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 121 Reached - Pause Waypoint');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','8','10','40','0','100','0','14','20763','0','0','15','10425','0','0','0','0','0','12','1','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 123 Reached - Quest Credit \'Escape from the Staging Grounds\'');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','9','0','6','0','100','0','0','0','0','0','6','10425','0','0','0','0','0','12','1','0','0','0','0','0','0','Captured Protectorate Vanguard - On Just Died - Fail Quest \'Escape from the Staging Grounds\'');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','10','0','61','0','100','0','13','20763','0','0','1','1','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 123 Reached - Say Line 1');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','11','12','40','0','100','0','15','20763','0','0','1','2','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 125 Reached - Say Line 2');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','12','13','61','0','100','0','15','20763','0','0','11','35517','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 125 Reached - Cast \'Teleport\'');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','13','0','61','0','100','0','15','20763','0','0','41','3000','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Waypoint 125 Reached - Despawn In 3000 ms');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','14','0','61','0','100','0','10425','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Set Npc Flag ');
insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) values('20763','0','15','0','11','0','100','0','0','0','0','0','81','2','0','0','0','0','0','1','0','0','0','0','0','0','0','Captured Protectorate Vanguard - On Respawn - Set Npc Flag Questgiver');
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','1','4055','2293','113',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','2','4057','2301','112',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','3','4070','2302','111',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','4','4086','2296','109',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','5','4100','2298','107',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','6','4123','2294','104',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','7','4177','2303','107',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','8','4239','2292','129',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','9','4263','2291','126',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','10','4270','2284','125',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','11','4269','2264','127',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','12','4253','2235','135',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','13','4248','2213','137',NULL);
insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','14','4251','2172','137',NULL);
