+- For-rum 3server.cz (http://for-rum.3server.cz)
+-- Forum: TEAM ONLY (http://for-rum.3server.cz/forumdisplay.php?fid=4)
+--- Forum: SQL (http://for-rum.3server.cz/forumdisplay.php?fid=6)
+---- Forum: Solved (http://for-rum.3server.cz/forumdisplay.php?fid=10)
+---- Thread: Escape from the Staging Grounds - Bug fix (/showthread.php?tid=60)
Escape from the Staging Grounds - Bug fix - doktorblazen - 01-19-2019
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);
RE: Escape from the Staging Grounds - Bug fix - mirra - 01-19-2019
28 queries executed, 28 success, 0 errors, 0 warnings
Query: DELETE FROM waypoints WHERE entry=20763
18 row(s) affected
Execution Time : 0.034 sec
Transfer Time : 0 sec
Total Time : 0.034 sec
--------------------------------------------------
Query: DELETE FROM smart_scripts WHERE entryorguid=20763
12 row(s) affected
Execution Time : 0.070 sec
Transfer Time : 0 sec
Total Time : 0.070 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0.001 sec
Total Time : 0.018 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `even...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','1','4055...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','2','4057...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','3','4070...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0.001 sec
Total Time : 0.018 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','4','4086...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','5','4100...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','6','4123...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','7','4177...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.017 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','8','4239...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0.001 sec
Total Time : 0.018 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','9','4263...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','10','427...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','11','426...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','12','425...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','13','424...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec
--------------------------------------------------
Query: insert into `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) values('20763','14','425...
1 row(s) affected
Execution Time : 0.016 sec
Transfer Time : 0 sec
Total Time : 0.016 sec