任务修复实例（7）-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_51122280/article/details/138477825
Quest Name = 'King of Centaur Mountain' | '半人马山之王'
Quest ID = 13995
-- Adjust Creature States
UPDATE `world`.`creature_addon` SET `PathId` = 0 WHERE `guid` = 301943;
UPDATE `world`.`creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 34634;
INSERT INTO `world`.`gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES (10545, 14585, 0),(10545, 14586, 0);
-- Add Creature Texts
INSERT INTO `world`.`creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `SoundPlayType`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
(34634, 0, 0, 'Hah, yes $n! That\'s what I want to hear. Let\'s make some noise!', 12, 0, 100, 0, 0, 0, 0, 34877, 0, 'Gorgal Angerscar'),
(34634, 1, 0, 'Come get some, you horsefaced maggot farms!', 14, 0, 100, 0, 0, 0, 0, 34878, 0, 'Gorgal Angerscar'),
(34634, 2, 0, 'More.... More!', 12, 0, 100, 0, 0, 0, 0, 34879, 0, 'Gorgal Angerscar'),
(34634, 3, 0, 'Ah, there\'s our target. I can smell him from here.', 12, 0, 100, 0, 0, 0, 0, 34881, 0, 'Gorgal Angerscar'),
(34634, 4, 0, 'Victory!', 12, 0, 100, 0, 0, 0, 0, 34882, 0, 'Gorgal Angerscar'),
(34634, 5, 0, 'Wait \'til Shoe hears about THIS.', 12, 0, 100, 1, 0, 0, 0, 34893, 0, 'Gorgal Angerscar');
-- Add WP
INSERT INTO `world`.`waypoint_path` (`PathId`, `Comment`) VALUES (34634, 'Gorgal Angerscar');
INSERT INTO `world`.`waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES 
(34634, 1, -1188.55, -2959.6, 91.9011, NULL, 0),
(34634, 2, -1179.8, -2957.1, 93.4011, NULL, 0),
(34634, 3, -1171.05, -2952.1, 94.4011, NULL, 0),
(34634, 4, -1170.3, -2945.35, 95.6511, NULL, 0),
(34634, 5, -1174.8, -2939.85, 100.151, NULL, 0),
(34634, 6, -1181.55, -2931.85, 105.401, NULL, 0),
(34634, 7, -1186.3, -2923.6, 109.401, NULL, 0),
(34634, 8, -1189.8, -2918.6, 113.151, NULL, 0),
(34634, 9, -1192.7, -2915.51, 115.432, NULL, 0),
(34634, 10, -1196.3, -2912.93, 117.631, NULL, 0);
-- Add SAI
DELETE FROM `world`.`smart_scripts` WHERE `entryorguid` IN (3272,3273,34635);
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 
(3272, 0, 0, 0, '', 9, 0, 100, 0, 5, 30, 2000, 2000, 0, '', 11, 6660, 64, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Wrangler - In Range 5-30 yd - Cast \'Shoot\''),
(3272, 0, 1, 0, '', 9, 0, 100, 0, 0, 5, 2000, 2000, 0, '', 21, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Wrangler - In Range 0-5 yd - Enable Movement'),
(3272, 0, 2, 0, '', 9, 0, 100, 0, 8, 20, 11000, 16000, 0, '', 11, 12024, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Wrangler - In Range 8-20 yd - Cast \'Net\''),
(3272, 0, 3, 0, '', 2, 0, 100, 1, 0, 15, 0, 0, 0, '', 25, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Wrangler - At 15% HP - Flee For Assist'),
(3272, 0, 4, 0, '', 54, 0, 100, 0, 0, 0, 0, 0, 0, '', 49, 0, 0, 0, 0, 0, 0, 0, NULL, 10, 301943, 34634, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Wrangler - On Just Summoned - Attack Gorgal'),
(3273, 0, 0, 0, '', 0, 0, 100, 0, 2000, 3000, 3400, 4000, 0, '', 11, 9532, 64, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormer - IC - Cast \'Lightning Bolt\''),
(3273, 0, 1, 0, '', 0, 0, 100, 0, 0, 0, 22000, 26000, 0, '', 11, 6535, 1, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormer - IC -  Cast \'Lightning Cloud\''),
(3273, 0, 2, 0, '', 2, 0, 100, 1, 0, 15, 0, 0, 0, '', 25, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormer - At 15% HP - Flee For Assist'),
(3273, 0, 3, 0, '', 54, 0, 100, 0, 0, 0, 0, 0, 0, '', 49, 0, 0, 0, 0, 0, 0, 0, NULL, 10, 301943, 34634, 0, 0, NULL, 0, 0, 0, 0, 'Kolkar Stormer - On Just Summoned - Attack Gorgal'),
(34635, 0, 0, 0, '', 54, 0, 100, 0, 0, 0, 0, 0, 0, '', 49, 0, 0, 0, 0, 0, 0, 0, NULL, 10, 301943, 34634, 0, 0, NULL, 0, 0, 0, 0, 'Kurak - On Just Summoned - Attack Gorgal\r\n'),
(34635, 0, 1, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 45, 1, 1, 0, 0, 0, 0, 0, NULL, 10, 301943, 34634, 0, 0, NULL, 0, 0, 0, 0, 'Kurak - On Death - Set Data 1 1 To \'Gorgal Angerscar\''),
(34634, 0, 0, 1, '', 19, 0, 100, 0, 13995, 0, 0, 0, 0, '', 1, 0, 3000, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - On Quest Accept - Say Group 0'),
(34634, 0, 1, 2, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 81, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Link - Set NPC Flag'),
(34634, 0, 2, 3, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 48, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Link - Set Active'),
(34634, 0, 3, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 64, 1, 0, 0, 0, 0, 0, 0, NULL, 16, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Link - Store Target'),
(34634, 0, 4, 0, '', 52, 0, 100, 0, 0, 34634, 0, 0, 0, '', 53, 0, 34634, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - On Text_Over - Start WP'),
(34634, 0, 5, 0, '', 40, 0, 100, 0, 10, 34634, 0, 0, 0, '', 55, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - On Reached WP - WP Stop'),
(34634, 0, 6, 0, '', 40, 0, 100, 0, 10, 34634, 0, 0, 0, '', 80, 3463400, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - On Reached WP - Run Timed ActionList'),
(34634, 0, 7, 8, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 6, 13995, 0, 0, 0, 0, 0, 0, NULL, 12, 1, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - On Death - Fail Quest'),
(34634, 0, 8, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 78, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Link - Reset Script'),
(34634, 0, 9, 10, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 40, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Respawn - Set Sheath'),
(34634, 0, 10, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 59, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Link - Set Run'),
(34634, 0, 11, 12, '', 38, 0, 100, 0, 1, 1, 0, 0, 0, '', 15, 13995, 0, 0, 0, 0, 0, 0, NULL, 12, 1, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - On Data Set 1 1 - Quest Complete'),
(34634, 0, 12, 13, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 4, 3000, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Link - Say Group 4'),
(34634, 0, 13, 14, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 5, 4000, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Link - Say Group 5'),
(34634, 0, 14, 15, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 2000, 0, 0, 0, 0, 0, 0, NULL, 20, 195148, 40, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Link - Despawn \'Banner\''),
(34634, 0, 15, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 5000, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Link - Despawn Self'),
(3463400, 9, 0, 0, '', 0, 0, 100, 0, 500, 500, 0, 0, 0, '', 11, 65804, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Timed ActionList - Cast \'Plant Horde Banner\''),
(3463400, 9, 1, 0, '', 0, 0, 100, 0, 1000, 1000, 0, 0, 0, '', 66, 0, 0, 0, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, 0, 0, 0, 5.33, 'Gorgal Angerscar - Timed ActionList - Set Orientation'),
(3463400, 9, 2, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 101, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Timed ActionList - Set Home Position'),
(3463400, 9, 3, 0, '', 0, 0, 100, 0, 1000, 1000, 0, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Timed ActionList - Say Group 1'),
(3463400, 9, 4, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 40, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Timed ActionList - Set Sheath=1'),
(3463400, 9, 5, 0, '', 0, 0, 100, 0, 4000, 4000, 0, 0, 0, '', 12, 3272, 4, 20000, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, -1179.52, -2935.99, 104, 2.1327, 'Gorgal Angerscar - Timed ActionList - Summon \'Kolkar Wrangler\''),
(3463400, 9, 6, 0, '', 0, 0, 100, 0, 5000, 5000, 0, 0, 0, '', 12, 3272, 4, 20000, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, -1175.67, -2933.5, 102.608, 1.8233, 'Gorgal Angerscar - Timed ActionList - Summon \'Kolkar Wrangler\''),
(3463400, 9, 7, 0, '', 0, 0, 100, 0, 16000, 16000, 0, 0, 0, '', 1, 2, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Timed ActionList - Say Group 2'),
(3463400, 9, 8, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 12, 3272, 4, 20000, 1, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, -1179.42, -2940.34, 101.21, 1.8233, 'Gorgal Angerscar - Timed ActionList - Summon \'Kolkar Wrangler\''),
(3463400, 9, 9, 0, '', 0, 0, 100, 0, 5000, 5000, 0, 0, 0, '', 12, 3273, 4, 20000, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, -1176.78, -2939.98, 100.672, 1.8233, 'Gorgal Angerscar - Timed ActionList - Summon \'Kolkar Stormer\''),
(3463400, 9, 10, 0, '', 0, 0, 100, 0, 17000, 17000, 0, 0, 0, '', 1, 3, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorgal Angerscar - Timed ActionList - Say Group 3'),
(3463400, 9, 11, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 12, 34635, 4, 20000, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, -1179.42, -2940.34, 101.21, 1.8233, 'Gorgal Angerscar - Timed ActionList - Summon \'Kurak\'');