[Core/Quest] Fixed Quest Escape from the Staging Grounds (10425) Escort missions. V14

[kuramajssken]

Escape from the Staging Grounds​

Escort the Captured Protectorate Vanguard back to Protectorate Watch Post in Netherstorm.

	Captured Protectorate Vanguard Escorted

Relevant Locations​

This quest starts and ends in Netherstorm.

Escape from the Staging Grounds

Escort the Captured Protectorate Vanguard back to Protectorate Watch Post in Netherstorm. A level 70 Netherstorm Quest. +250 reputation with The Consortium

tbc.wowhead.com

DELETE FROM `waypoint_data` WHERE id = 868330;
INSERT INTO `waypoint_data` VALUES (868330, 1, 4054.94, 2309.98, 112.835, 0, 6, 0, 0, 100, 0, 0);
INSERT INTO `waypoint_data` VALUES (868330, 2, 4055.63, 2288.98, 113.544, 0, 5, 0, 0, 100, 0, 0);
DELETE FROM smart_scripts WHERE entryorguid = 20763;
INSERT INTO `smart_scripts` VALUES (20763, 0, 0, 1, 19, 0, 100, 0, 10425, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 21, 10, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Say Line 0');
INSERT INTO `smart_scripts` VALUES (20763, 0, 1, 2, 61, 0, 100, 0, 10425, 0, 0, 0, 0, 53, 0, 20763, 0, 0, 0, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Start Waypoint');
INSERT INTO `smart_scripts` VALUES (20763, 0, 2, 14, 61, 0, 100, 0, 10425, 0, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 21, 10, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Quest \'Escape from the Staging Grounds\' Taken - Store Targetlist');
INSERT INTO `smart_scripts` VALUES (20763, 0, 7, 0, 40, 0, 100, 0, 16, 20763, 0, 0, 0, 54, 4000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Waypoint 16 Reached - Pause Waypoint');
INSERT INTO `smart_scripts` VALUES (20763, 0, 8, 10, 40, 0, 100, 0, 17, 20763, 0, 0, 0, 15, 10425, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Waypoint 17 Reached - Quest Credit \'Escape from the Staging Grounds\'');
INSERT INTO `smart_scripts` VALUES (20763, 0, 9, 0, 6, 0, 100, 0, 0, 0, 0, 0, 0, 6, 10425, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Just Died - Fail Quest \'Escape from the Staging Grounds\'');
INSERT INTO `smart_scripts` VALUES (20763, 0, 10, 0, 61, 0, 100, 0, 17, 20763, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Waypoint 17 Reached - Say Line 1');
INSERT INTO `smart_scripts` VALUES (20763, 0, 11, 12, 40, 0, 100, 0, 18, 20763, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Waypoint 18 Reached - Say Line 2');
INSERT INTO `smart_scripts` VALUES (20763, 0, 12, 13, 61, 0, 100, 0, 18, 20763, 0, 0, 0, 11, 35517, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Waypoint 18 Reached - Cast \'Teleport\'');
INSERT INTO `smart_scripts` VALUES (20763, 0, 13, 0, 61, 0, 100, 0, 18, 20763, 0, 0, 0, 41, 3000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Waypoint 18 Reached - Despawn In 3000 ms');
INSERT INTO `smart_scripts` VALUES (20763, 0, 14, 0, 61, 0, 100, 0, 10425, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 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` VALUES (20763, 0, 15, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 81, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Captured Protectorate Vanguard - On Respawn - Set Npc Flag Questgiver');
DELETE FROM waypoints WHERE entry = 20763;
INSERT INTO `waypoints` VALUES (20763, 1, 4081.3, 2296.6, 110.75, NULL);
INSERT INTO `waypoints` VALUES (20763, 2, 4095.3, 2296.37, 108.392, NULL);
INSERT INTO `waypoints` VALUES (20763, 3, 4123.42, 2297.51, 104.368, NULL);
INSERT INTO `waypoints` VALUES (20763, 4, 4146.48, 2298.85, 102.475, NULL);
INSERT INTO `waypoints` VALUES (20763, 5, 4169.75, 2301.11, 104.503, NULL);
INSERT INTO `waypoints` VALUES (20763, 6, 4181.37, 2301.19, 108.692, NULL);
INSERT INTO `waypoints` VALUES (20763, 7, 4195.51, 2301.28, 113.981, NULL);
INSERT INTO `waypoints` VALUES (20763, 8, 4215.69, 2295.79, 122.162, NULL);
INSERT INTO `waypoints` VALUES (20763, 9, 4229.79, 2295.09, 127.068, NULL);
INSERT INTO `waypoints` VALUES (20763, 10, 4250.86, 2293.49, 128.848, NULL);
INSERT INTO `waypoints` VALUES (20763, 11, 4271.72, 2290, 125.243, NULL);
INSERT INTO `waypoints` VALUES (20763, 12, 4277.21, 2276.97, 125.337, NULL);
INSERT INTO `waypoints` VALUES (20763, 13, 4269.13, 2262.97, 127.868, NULL);
INSERT INTO `waypoints` VALUES (20763, 14, 4262.07, 2250.73, 131.257, NULL);
INSERT INTO `waypoints` VALUES (20763, 15, 4253.95, 2236.66, 134.959, NULL);
INSERT INTO `waypoints` VALUES (20763, 16, 4249.61, 2220.86, 137.445, NULL);
INSERT INTO `waypoints` VALUES (20763, 17, 4251.74, 2186.12, 137.08, NULL);
INSERT INTO `waypoints` VALUES (20763, 18, 4252, 2172.27, 137.678, NULL);

 

[Blackvision]

 

[warcraftlife]

Thx!

 

[ExO]

Executed in V15, thanks