任务修复实例（11）-CSDN博客

本文链接：https://blog.csdn.net/weixin_51122280/article/details/145538707
Quest ID : 10231
Quest Name : What Book? I Don't See Any Book.
SQL :
DELETE FROM `world`.`conditions` WHERE `SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 8033;
INSERT INTO `world`.`conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(15, 8033, 0, 0, 0, 47, 0, 10231, 8, 0, '', 0, 0, 0, '', '\"Dirty\" Larry - On Quest State - Gossip Menu Option Available');

DELETE FROM `world`.`smart_scripts` WHERE `source_type` = 0 AND `entryorguid` IN (19720,19725，19726);
DELETE FROM `world`.`smart_scripts` WHERE `source_type` = 9 AND `entryorguid` IN (1972000,1972001);
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 
(19720, 0, 0, 0, '', 11, 0, 100, 0, 0, 0, 0, 0, 0, '', 42, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - On Respawn - Set Invincibility On'),
(19720, 0, 1, 2, '', 25, 0, 100, 0, 0, 0, 0, 0, 0, '', 144, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - On Reset - Set Immune PC On'),
(19720, 0, 2, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 82, 3, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - On Reset - Add NPC Flags (Gossip & Questgiver)'),
(19720, 0, 3, 0, '', 62, 0, 100, 0, 8033, 0, 0, 0, 0, '', 80, 1972000, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - On Gossip Menu Option Select - Run Timed ActionList (0)'),
(19720, 0, 4, 0, '', 2, 0, 100, 1, 0, 1, 0, 0, 0, '', 80, 1972001, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - On HP - Run Timed ActionList (1)'),
(1972000, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 72, 0, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Close Gossip'),
(1972000, 9, 1, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 64, 1, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Store Target List (Invoker)'),
(1972000, 9, 2, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 83, 3, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Remove NPC Flags (Gossip & Questgiver)'),
(1972000, 9, 3, 0, '', 0, 0, 100, 0, 1000, 1000, 0, 0, 0, '', 66, 0, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Set Orientation to Invoker'),
(1972000, 9, 4, 0, '', 0, 0, 100, 0, 1000, 1000, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Say Group 0'),
(1972000, 9, 5, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 100, 1, 0, 0, 0, 0, 0, 0, NULL, 19, 19725, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Send Target List to \"Epic\" Malone'),
(1972000, 9, 6, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 100, 1, 0, 0, 0, 0, 0, 0, NULL, 19, 19726, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Send Target List to \"Creepjack\"'),
(1972000, 9, 7, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 45, 1, 1, 0, 0, 0, 0, 0, NULL, 19, 19725, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Set Data 1 1 to \"Epic\" Malone'),
(1972000, 9, 8, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 45, 1, 1, 0, 0, 0, 0, 0, NULL, 19, 19726, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Set Data 1 1 to \"Creepjack\"'),
(1972000, 9, 9, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 91, 3, 0, 0, 0, 0, 0, 0, NULL, 19, 19725, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Remove Unit Field Bytes 1 (\"Epic\" Malone)'),
(1972000, 9, 10, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 91, 3, 0, 0, 0, 0, 0, 0, NULL, 19, 19726, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Remove Unit Field Bytes 1 (\"Creepjack\")'),
(1972000, 9, 11, 0, '', 0, 0, 100, 0, 2000, 2000, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, NULL, 19, 19725, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Say Group 0 (\"Epic\" Malone)'),
(1972000, 9, 12, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, NULL, 19, 19726, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Say Group 0 (\"Creepjack\")'),
(1972000, 9, 13, 0, '', 0, 0, 100, 0, 2000, 2000, 0, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Say Group 1'),
(1972000, 9, 14, 0, '', 0, 0, 100, 0, 5000, 5000, 0, 0, 0, '', 1, 2, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Say Group 2'),
(1972000, 9, 15, 0, '', 0, 0, 100, 0, 1000, 1000, 0, 0, 0, '', 1, 3, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Say Group 3'),
(1972000, 9, 16, 0, '', 0, 0, 100, 0, 1000, 1000, 0, 0, 0, '', 1, 4, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Say Group 4'),
(1972000, 9, 17, 0, '', 0, 0, 100, 0, 1000, 1000, 0, 0, 0, '', 144, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Set Immune PC Off'),
(1972000, 9, 18, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 144, 0, 0, 0, 0, 0, 0, 0, NULL, 19, 19725, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Set Immune PC Off (\"Epic\" Malone)'),
(1972000, 9, 19, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 144, 0, 0, 0, 0, 0, 0, 0, NULL, 19, 19726, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Set Immune PC Off (\"Creepjack\")'),
(1972000, 9, 20, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 49, 0, 0, 0, 0, 0, 0, 0, NULL, 12, 1, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Start Attack Stored Target List'),
(1972000, 9, 21, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 45, 1, 2, 0, 0, 0, 0, 0, NULL, 19, 19725, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Set Data 1 2 to \'\"Epic\" Malone\''),
(1972000, 9, 22, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 45, 1, 2, 0, 0, 0, 0, 0, NULL, 19, 19726, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Set Data 1 2 to \'\"Creepjack\"\''),
(1972001, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 34549, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Cast \'Dirty Larry Submits\''),
(1972001, 9, 1, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 5, 0, 0, 0, 0, 0, 0, NULL, 12, 1, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Say Group 5'),
(1972001, 9, 2, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 45, 1, 3, 0, 0, 0, 0, 0, NULL, 19, 19725, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Set Data 1 3 to \'\"Epic\" Malone\''),
(1972001, 9, 3, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 45, 1, 3, 0, 0, 0, 0, 0, NULL, 19, 19726, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Set Data 1 3 to \'\"Creepjack\"\''),
(1972001, 9, 4, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 24, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Dirty\" Larry - Timed ActionList - Evade'),

(19725, 0, 0, 0, '', 37, 0, 100, 0, 0, 0, 0, 0, 0, '', 116, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Epic\" Malone - On AI Init - Set Corpse Delay'),
(19725, 0, 1, 0, '', 25, 0, 100, 0, 0, 0, 0, 0, 0, '', 144, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Epic\" Malone - On Reset - Set Immune PC On'),
(19725, 0, 2, 0, '', 38, 0, 100, 0, 1, 1, 0, 0, 0, '', 66, 0, 0, 0, 0, 0, 0, 0, NULL, 12, 1, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Epic\" Malone - On Data Set 1 1 - Set Orientation to Stored Target List'),
(19725, 0, 3, 0, '', 38, 0, 100, 0, 1, 2, 0, 0, 0, '', 49, 0, 0, 0, 0, 0, 0, 0, NULL, 12, 1, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Epic\" Malone - On Data Set 1 2 - Start Attack Stored Target List'),
(19725, 0, 4, 0, '', 38, 0, 100, 0, 1, 3, 0, 0, 0, '', 24, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Epic\" Malone - On Data Set 1 3 - Evade'),

(19726, 0, 0, 0, '', 37, 0, 100, 0, 0, 0, 0, 0, 0, '', 116, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Creepjack\" - On AI Init - Set Corpse Delay'),
(19726, 0, 1, 0, '', 25, 0, 100, 0, 0, 0, 0, 0, 0, '', 144, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Creepjack\" - On Reset - Set Immune PC On'),
(19726, 0, 2, 0, '', 38, 0, 100, 0, 1, 1, 0, 0, 0, '', 66, 0, 0, 0, 0, 0, 0, 0, NULL, 12, 1, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Creepjack\" - On Data Set 1 1 - Set Orientation to Stored Target List'),
(19726, 0, 3, 0, '', 38, 0, 100, 0, 1, 2, 0, 0, 0, '', 49, 0, 0, 0, 0, 0, 0, 0, NULL, 12, 1, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Creepjack\" - On Data Set 1 2 - Start Attack Stored Target List'),
(19726, 0, 4, 0, '', 38, 0, 100, 0, 1, 3, 0, 0, 0, '', 24, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, '\"Creepjack\" - On Data Set 1 3 - Evade');