Quest Name = 'Breaking the Chain' | '斩断链条'
Quest ID = 25167
-- Delete Creature Spawned
DELETE FROM `world`.`creature` WHERE `id` IN (39251,39245,39249);
-- Adjust Creature States
UPDATE `world`.`creature_template` SET `npcflag` = 16777216, `AIName` = 'SmartAI' WHERE `entry` IN (39244,39318,39319,39251,39255);
UPDATE `world`.`creature_template` SET `VehicleId` = 680 WHERE `entry` = 39244;
UPDATE `world`.`creature_template` SET `VehicleId` = 684 WHERE `entry` = 39318;
UPDATE `world`.`creature_template` SET `VehicleId` = 685 WHERE `entry` = 39319;
UPDATE `world`.`creature_template` SET `flags_extra` = 128 WHERE `entry` = 39255;
UPDATE `world`.`creature_template` SET `flags_extra` = 2 WHERE `entry` = 39251;
--Add Npc Spellclick Spells
INSERT INTO `world`.`npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
(39244, 46598, 0, 0),(39318, 46598, 0, 0),(39319, 46598, 0, 0);
-- Add Vehicle Template Accessory
INSERT INTO `world`.`vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES
(39244, 39249, 0, 0, 'Northwatch Lug to Northwatch Caravan A', 8, 300000),
(39244, 39245, 1, 0, 'Northwatch Lug to Northwatch Caravan A', 8, 300000),
(39244, 39251, 2, 0, 'Northwatch Supply Crate mounted to Northwatch Caravan A', 8, 300000),
(39244, 39249, 3, 0, 'Northwatch Lug to Northwatch Caravan A', 8, 300000),
(39318, 39249, 0, 0, 'Northwatch Lug to Northwatch Caravan B', 8, 300000),
(39318, 39251, 1, 0, 'Northwatch Supply Crate mounted to Northwatch Caravan B', 8, 300000),
(39319, 39245, 0, 0, 'Northwatch Lug to Northwatch Caravan C', 8, 300000),
(39319, 39245, 1, 0, 'Northwatch Lug to Northwatch Caravan C', 8, 300000),
(39319, 39251, 2, 0, 'Northwatch Supply Crate mounted to Northwatch Caravan ', 8, 300000);
-- Add SAI
INSERT INTO `world`.`smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(-309482, 0, 0, 0, '', 1, 0, 100, 0, 1000, 20000, 40000, 55000, 0, '', 11, 73736, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan Spawner A - Out of Combat - Cast \'Summon Northwatch Caravan B\''),
(-309481, 0, 0, 0, '', 1, 0, 100, 0, 1000, 20000, 40000, 55000, 0, '', 11, 73737, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan Spawner A - Out of Combat - Cast \'Summon Northwatch Caravan C\''),
(-309479, 0, 0, 0, '', 1, 0, 100, 0, 1000, 20000, 40000, 55000, 0, '', 11, 73691, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan Spawner A - Out of Combat - Cast \'Summon Northwatch Caravan A\''),
(39244, 0, 0, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 53, 0, 39244, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan A - On Respawn - Start Waypoint'),
(39244, 0, 1, 0, '', 28, 0, 100, 0, 0, 0, 0, 0, 0, '', 8, 2, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan A - On Passenger Removed - Set React State'),
(39244, 0, 2, 0, '', 40, 0, 100, 0, 44, 39244, 0, 0, 0, '', 41, 0, 0, 0, 0, 0, 0, 0, NULL, 29, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan A - On Waypoint Reached - Despawn Passenger 0'),
(39244, 0, 3, 0, '', 40, 0, 100, 0, 44, 39244, 0, 0, 0, '', 41, 0, 0, 0, 0, 0, 0, 0, NULL, 29, 1, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan A - On Waypoint Reached - Despawn Passenger 1'),
(39244, 0, 4, 0, '', 40, 0, 100, 0, 44, 39244, 0, 0, 0, '', 41, 0, 0, 0, 0, 0, 0, 0, NULL, 29, 2, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan A - On Waypoint Reached - Despawn Passenger 2'),
(39244, 0, 5, 0, '', 40, 0, 100, 0, 44, 39244, 0, 0, 0, '', 41, 0, 0, 0, 0, 0, 0, 0, NULL, 29, 3, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan A - On Waypoint Reached - Despawn Passenger 3'),
(39244, 0, 6, 0, '', 28, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 30000, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan A - On Passenger Removed - Supply Crate'),
(39318, 0, 0, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 53, 0, 39318, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan B - On Respawn - Start Waypoint'),
(39318, 0, 1, 0, '', 28, 0, 100, 0, 0, 0, 0, 0, 0, '', 8, 2, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan B - On Passenger Removed - Set React State'),
(39318, 0, 2, 0, '', 40, 0, 100, 0, 37, 39318, 0, 0, 0, '', 41, 0, 0, 0, 0, 0, 0, 0, NULL, 29, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan B - On Waypoint 37 Reached - Despawn Passenger 0'),
(39318, 0, 3, 0, '', 40, 0, 100, 0, 37, 39318, 0, 0, 0, '', 41, 0, 0, 0, 0, 0, 0, 0, NULL, 29, 1, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan B - On Waypoint 37 Reached - Despawn Passenger 1'),
(39318, 0, 4, 0, '', 28, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 30000, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan B - On Passenger Removed - Supply Crate'),
(39319, 0, 0, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 53, 0, 39319, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan C - On Respawn - Start Waypoint'),
(39319, 0, 1, 0, '', 28, 0, 100, 0, 0, 0, 0, 0, 0, '', 8, 2, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan C - On Passenger Removed - Set React State'),
(39319, 0, 2, 0, '', 40, 0, 100, 0, 41, 39319, 0, 0, 0, '', 41, 0, 0, 0, 0, 0, 0, 0, NULL, 29, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan C - On Waypoint 41 Reached - Despawn Passenger 0'),
(39319, 0, 3, 0, '', 40, 0, 100, 0, 41, 39319, 0, 0, 0, '', 41, 0, 0, 0, 0, 0, 0, 0, NULL, 29, 1, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan C - On Waypoint 41 Reached - Despawn Passenger 1'),
(39319, 0, 4, 0, '', 40, 0, 100, 0, 41, 39319, 0, 0, 0, '', 41, 0, 0, 0, 0, 0, 0, 0, NULL, 29, 2, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan C - On Waypoint 41 Reached - Despawn Passenger 2'),
(39319, 0, 5, 0, '', 28, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 30000, 30000, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Caravan C - On Passenger Removed - Supply Crate'),
(39251, 0, 0, 0, '', 4, 0, 100, 0, 0, 0, 0, 0, 0, '', 28, 0, 0, 0, 0, 0, 0, 0, NULL, 23, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Supply Crate - On Aggro - Remove Aura'),
(39251, 0, 1, 2, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 28, 0, 0, 0, 0, 0, 0, 0, NULL, 23, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Supply Crate - On Death - Remove Aura'),
(39251, 0, 2, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 1000, 0, 0, 0, 0, 0, 0, NULL, 23, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Supply Crate - Link - Despawn Vehicle'),
(39251, 0, 3, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 60081, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Supply Crate - On Death - Cast \'Cosmetic - Explosion\''),
(39249, 0, 1, 0, '', 4, 0, 100, 0, 0, 0, 0, 0, 0, '', 28, 0, 0, 0, 0, 0, 0, 0, NULL, 23, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Lug - On Aggro - Remove Aura'),
(39249, 0, 2, 3, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 28, 0, 0, 0, 0, 0, 0, 0, NULL, 23, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Lug - On Death - Remove Aura'),
(39249, 0, 3, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 1000, 0, 0, 0, 0, 0, 0, NULL, 23, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Lug - Link - Despawn Vehicle'),
(39249, 0, 4, 0, '', 7, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 1000, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Lug - On Evade - Despawn Self'),
(39245, 0, 1, 0, '', 4, 0, 100, 0, 0, 0, 0, 0, 0, '', 28, 0, 0, 0, 0, 0, 0, 0, NULL, 23, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Lug - On Aggro - Remove Aura'),
(39245, 0, 2, 3, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 28, 0, 0, 0, 0, 0, 0, 0, NULL, 23, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Lug - On Death - Remove Aura'),
(39245, 0, 3, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 1000, 0, 0, 0, 0, 0, 0, NULL, 23, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Lug - Link - Despawn Vehicle'),
(39245, 0, 4, 0, '', 7, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 1000, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Northwatch Lug - On Evade - Despawn Self');
-- Add WP
INSERT INTO `world`.`waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES
(39244, 0, 0, 'Northwatch Caravan A'),
(39318, 0, 0, 'Northwatch Caravan B'),
(39319, 0, 0, 'Northwatch Caravan C');
INSERT INTO `world`.`waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`) VALUES
(39244, 1, -1022.05, -4721.35, 15.5244),
(39244, 2, -1017.8, -4717.35, 16.0244),
(39244, 3, -1013.55, -4713.6, 16.5244),
(39244, 4, -1008.71, -4708.95, 17.4209),
(39244, 5, -1006.46, -4705.7, 18.1709),
(39244, 6, -1003.96, -4702.45, 18.9209),
(39244, 7, -1002.21, -4699.95, 19.4209),
(39244, 8, -1001.46, -4698.7, 20.1709),
(39244, 9, -999.458, -4696.2, 20.4209),
(39244, 10, -998.458, -4694.7, 21.1709),
(39244, 11, -996.708, -4692.2, 22.1709),
(39244, 12, -995.458, -4690.7, 22.9209),
(39244, 13, -993.708, -4688.2, 23.6709),
(39244, 14, -992.164, -4686.13, 24.5971),
(39244, 15, -991.164, -4683.13, 25.3471),
(39244, 16, -990.414, -4681.38, 26.0971),
(39244, 17, -989.414, -4678.63, 26.5971),
(39244, 18, -988.664, -4675.63, 27.0971),
(39244, 19, -986.914, -4671.13, 27.8471),
(39244, 20, -985.164, -4666.63, 28.3471),
(39244, 21, -983.464, -4661.77, 28.8857),
(39244, 22, -982.714, -4657.02, 29.6357),
(39244, 23, -982.214, -4653.27, 30.3857),
(39244, 24, -980.268, -4642.01, 29.6635),
(39244, 25, -980.768, -4640.26, 28.4135),
(39244, 26, -981.018, -4639.26, 27.6635),
(39244, 27, -981.268, -4638.26, 26.6635),
(39244, 28, -981.768, -4636.26, 25.9135),
(39244, 29, -987.185, -4615.56, 25.8365),
(39244, 30, -989.54, -4590.44, 26.1577),
(39244, 31, -990.29, -4587.44, 27.1577),
(39244, 32, -992.54, -4577.69, 26.4077),
(39244, 33, -992.79, -4576.69, 25.9077),
(39244, 34, -996.872, -4559.61, 26.0756),
(39244, 35, -999.435, -4529, 26.1058),
(39244, 36, -1009.18, -4516.75, 25.8558),
(39244, 37, -1020.76, -4501.75, 25.964),
(39244, 38, -1038.87, -4481.47, 25.9956),
(39244, 39, -1041.37, -4453.72, 26.2456),
(39244, 40, -1041.91, -4446.81, 26.3986),
(39244, 41, -1012.16, -4419.93, 26.9046),
(39244, 42, -1001.41, -4419.93, 27.9046),
(39244, 43, -999.405, -4419.93, 28.6546),
(39244, 44, -997.405, -4419.93, 29.1546),
(39318, 1, -1071.05, -4697.46, 17.1713),
(39318, 2, -1068.55, -4696.46, 17.1713),
(39318, 3, -1067.55, -4696.46, 17.1713),
(39318, 4, -1066.3, -4696.46, 17.1713),
(39318, 5, -1065.3, -4696.46, 17.4213),
(39318, 6, -1064.3, -4696.46, 17.4213),
(39318, 7, -1062.8, -4697.96, 17.4213),
(39318, 8, -1062.8, -4698.96, 17.4213),
(39318, 9, -1062.8, -4699.71, 17.4213),
(39318, 10, -1058.05, -4701.96, 17.9213),
(39318, 11, -1050.05, -4703.96, 17.9213),
(39318, 12, -1040.58, -4699.79, 17.838),
(39318, 13, -1034.58, -4699.29, 18.338),
(39318, 14, -1032.58, -4699.29, 19.088),
(39318, 15, -1030.58, -4699.04, 19.588),
(39318, 16, -1028.83, -4698.79, 20.588),
(39318, 17, -1026.83, -4698.79, 21.088),
(39318, 18, -1022.09, -4698.29, 21.838),
(39318, 19, -1016.8, -4697.38, 22.0407),
(39318, 20, -1014.55, -4695.38, 22.7907),
(39318, 21, -1012.3, -4693.38, 23.5407),
(39318, 22, -1009.05, -4690.13, 24.0407),
(39318, 23, -1006.8, -4688.13, 24.5407),
(39318, 24, -1002.3, -4684.13, 25.5407),
(39318, 25, -1000.92, -4682.66, 25.8197),
(39318, 26, -998.672, -4679.41, 26.8197),
(39318, 27, -997.172, -4676.91, 27.0697),
(39318, 28, -994.672, -4672.91, 27.8197),
(39318, 29, -991.613, -4667.79, 28.7482),
(39318, 30, -988.363, -4661.54, 29.2482),
(39318, 31, -987.113, -4659.29, 29.7482),
(39318, 32, -985.113, -4655.79, 30.4982),
(39318, 33, -993.841, -4613.15, 26.0235),
(39318, 34, -1010.96, -4603.13, 26.0351),
(39318, 35, -1022.01, -4600.63, 25.8669),
(39318, 36, -1037.29, -4598.32, 26.1709),
(39318, 37, -1061.4, -4597.82, 25.8209),
(39319, 1, -1059.6, -4714.33, 17.4981),
(39319, 2, -1024.35, -4708.33, 18.2481),
(39319, 3, -998.951, -4703.61, 18.5824),
(39319, 4, -996.951, -4701.11, 19.3324),
(39319, 5, -995.951, -4699.61, 19.8324),
(39319, 6, -993.951, -4697.11, 20.5824),
(39319, 7, -992.451, -4694.86, 21.5824),
(39319, 8, -991.201, -4693.36, 22.0824),
(39319, 9, -989.451, -4691.11, 22.8324),
(39319, 10, -988.201, -4689.36, 23.5824),
(39319, 11, -986.451, -4687.11, 24.5824),
(39319, 12, -986.345, -4686.92, 24.7569),
(39319, 13, -985.095, -4685.17, 25.2569),
(39319, 14, -984.595, -4682.42, 26.2569),
(39319, 15, -983.845, -4679.42, 26.7569),
(39319, 16, -983.345, -4675.42, 27.2569),
(39319, 17, -982.595, -4671.42, 28.0069),
(39319, 18, -981.345, -4664.92, 28.5069),
(39319, 19, -980.345, -4658.92, 29.2569),
(39319, 20, -979.845, -4655.92, 30.0069),
(39319, 21, -979.345, -4653.17, 30.5069),
(39319, 22, -977.368, -4642.06, 30.0437),
(39319, 23, -977.368, -4641.06, 29.2937),
(39319, 24, -977.368, -4640.06, 28.2937),
(39319, 25, -977.618, -4639.06, 27.5437),
(39319, 26, -977.618, -4638.06, 26.5437),
(39319, 27, -978.118, -4632.31, 26.0437),
(39319, 28, -980.773, -4605.15, 25.6948),
(39319, 29, -983.023, -4584.4, 27.1948),
(39319, 30, -984.023, -4576.65, 26.4448),
(39319, 31, -984.273, -4574.65, 25.9448),
(39319, 32, -985.427, -4566.4, 26.0959),
(39319, 33, -986.969, -4536.23, 26.0134),
(39319, 34, -967.237, -4510.54, 26.02),
(39319, 35, -954.987, -4500.79, 26.52),
(39319, 36, -954.615, -4500.54, 26.8159),
(39319, 37, -954.115, -4500.04, 26.8159),
(39319, 38, -952.365, -4499.29, 27.3159),
(39319, 39, -949.865, -4498.04, 27.8159),
(39319, 40, -947.365, -4496.79, 28.5659),
(39319, 41, -944.615, -4495.29, 29.3159);