任务修复实例(3)

时间:2024-04-18 10:28:01

Quest entry = 24812

Quest name = 'No More Mercy' | '不再怜悯'

-- Add AIName Field
UPDATE `world`.`creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (38442,38560,38932);
-- Add aura for 'Zuni'
INSERT INTO `world`.`creature_template_addon` (`entry`, `auras`) VALUES (38932, '73132');
-- Add Conditions
INSERT INTO `world`.`conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(22, 6, 38932, 0, 0, 23, 1, 4913, 0, 0, '', 1, 0, 0, '', 'Zuni - SAI(38932id5) unavailable in area 4913'),
(22, 6, 38932, 0, 0, 23, 1, 4867, 0, 0, '', 1, 0, 0, '', 'Zuni - SAI(38932id5) unavailable in area 4867'),
(17, 0, 72070, 0, 0, 30, 0, 202113, 5, 0, '', 0, 37, 45, '', 'Spitescale Flag Bunny - Must be Close to the Object to use Spell 72070');
-- 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`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(38442, 0, 0, 0, '', 19, 0, 100, 512, 24812, 0, 0, 0, 0, '', 11, 73571, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Morakki - On Quest \'No More Mercy\' Taken - Cast \'Summon Zuni (Lvl 4) Forcecast\''), 
(38442, 0, 1, 0, '', 19, 0, 100, 512, 24814, 0, 0, 0, 0, '', 41, 1000, 0, 0, 0, 0, 0, 0, 19, 38932, 25, 0, 0, 0, 0, 0, 0, 'Morakki - On Quest \'An Ancient Enemy\' Taken - Set Zuni Despawn'),
(38932, 0, 0, 0, '', 54, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Zuni - On Just Summoned - Self Say Group 0'),
(38932, 0, 1, 0, '', 4, 0, 40, 512, 0, 0, 0, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Zuni - On Aggro - Self Say Group 1'),
(38932, 0, 2, 0, '', 0, 0, 100, 0, 2500, 3000, 2500, 3000, 0, '', 11, 73254, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Zuni - In Combat - Cast \'Lightning Bolt\' to Victim'),
(38932, 0, 3, 0, '', 13, 0, 100, 0, 10000, 10000, 79810, 0, 0, '', 11, 73255, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 'Zuni - On Victim Casting \'Frost Cleave\' - Cast \'Earth Shock\' to Victim'),
(38932, 0, 4, 0, '', 2, 0, 100, 0, 0, 50, 10000, 12000, 0, '', 11, 73253, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Zuni - On 0-50% Health - Cast \'Healing Wave\' To Self'),
(38932, 0, 5, 0, '', 1, 0, 100, 512, 2000, 2000, 0, 0, 0, '', 41, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Zuni - OOC (Conditions) - Despawn'),
(38560, 0, 0, 0, '', 8, 0, 100, 0, 72070, 0, 0, 0, 0, '', 11, 72072, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Spitescale Flag Bunny - On SpellHit - Cast \'Territorial Fetish\''),
(38560, 0, 1, 0, '', 8, 0, 100, 0, 72070, 0, 0, 0, 0, '', 80, 385600, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Spitescale Flag Bunny - On SpellHit - Run Timed ActionList'),
(3856000, 9, 0, 0, '', 0, 0, 100, 0, 60000, 60000, 0, 0, 0, '', 28, 72072, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Spitescale Flag Bunny - On Timed ActionList - Remove Aura \'Territorial Fetish\'');
-- Add Waypoints
INSERT INTO `world`.`creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `SoundPlayType`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
(38932, 0, 0, '', 12, 0, 100, 1, 0, 21387, 0, 39070, 0, ''),
(38932, 1, 0, '', 12, 0, 100, 0, 0, 21379, 0, 38258, 0, ''),
(38932, 1, 1, '', 12, 0, 100, 0, 0, 21376, 0, 38256, 0, ''),
(38932, 1, 2, '', 12, 0, 100, 0, 0, 21378, 0, 38257, 0, ''),
(38932, 1, 3, '', 12, 0, 100, 0, 0, 21375, 0, 38255, 0, ''),
(38932, 1, 4, '', 12, 0, 100, 0, 0, 21376, 0, 38256, 0, ''),
(38932, 1, 5, '', 12, 0, 100, 0, 0, 21385, 0, 38262, 0, ''),
(38932, 1, 6, '', 12, 0, 100, 0, 0, 21384, 0, 38261, 0, ''),
(38932, 1, 7, '', 12, 0, 100, 0, 0, 21382, 0, 38260, 0, ''),
(38932, 1, 8, '', 12, 0, 100, 0, 0, 21380, 0, 38259, 0, '');