任务修复实例（9）

行云烈风
已于 2024-12-28 11:19:07 修改
阅读量1k
点赞数 1
CC 4.0 BY-SA版权
分类专栏： TrinityCore Quest 文章标签：开源
于 2024-05-09 18:42:59 首次发布
本文链接：https://blog.csdn.net/weixin_51122280/article/details/138626032
TrinityCore 同时被 2 个专栏收录
98 篇文章
订阅专栏
Quest
22 篇文章
订阅专栏
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  `unit_flags` = 33554432 WHERE `entry` IN (39244,39318,39319);
UPDATE `world`.`creature_template_difficulty` SET `TypeFlags` = 1048576 WHERE `Entry` IN (39244,39318,39319);
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);