任务修复实例（6）

Quest Name = 'Gorat's Vengeance' | '高拉特的复仇'

Quest ID = 13621

-- Adjust Creature States
UPDATE `world`.`creature_template` SET `unit_flags` = 768 WHERE `entry` = 33304;
UPDATE `world`.`creature_template` SET `AIName` = 'SmartAI' WHERE `entry` IN (33304,33336);
INSERT INTO `world`.`creature_template_addon` (`entry`, `StandState`, `auras`) VALUES (33304, 3, '36725');
-- Adjust Spell Effect
UPDATE `world`.`spell_target_position` SET `Orientation` = 1.834 WHERE `ID` = 62814 AND `EffectIndex` = 0;
UPDATE `world`.`spell_target_position` SET `Orientation` = 4.83456 WHERE `ID` = 62772 AND `EffectIndex` = 0;
INSERT INTO `world`.`conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(13, 1, 62792, 0, 0, 31, 0, 3, 33336, 0, '', 0, 0, 0, '', 'Gorat\'s Bowshot - Implicit Target Available - Only On \'Gorat\'s Target Bunny\'');
-- Add Gameobject
INSERT INTO `world`.`gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `ScriptName`, `StringId`, `VerifiedBuild`) VALUES 
(56, 194290, 1, 0, 0, '0', 0, 0, 0, -1, 1424.95, -2000.05, 96.2866, 1.93206, -0, -0, -0.822634, -0.568572, 300, 255, 1, '', NULL, 0);
-- Add Creature Text
INSERT INTO `world`.`creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `SoundPlayType`, `BroadcastTextId`, `TextRange`, `comment`) VALUES 
(33304, 0, 0, 'Thank you, friend. I could not rest knowing that my mission had not been completed.', 12, 0, 100, 1, 0, 0, 0, 33440, 0, 'Spirit of Gorat\r\n'),
(33304, 1, 0, '...and that my mens\' sacrifice had not been avenged.', 12, 0, 100, 1, 0, 0, 0, 33441, 0, 'Spirit of Gorat\r\n'),
(33304, 2, 0, 'We must hurry, now. I sense that my time is short.', 12, 0, 100, 1, 0, 0, 0, 33442, 0, 'Spirit of Gorat\r\n'),
(33304, 3, 0, 'Follow me closely, and prepare for battle!', 12, 0, 100, 0, 0, 0, 0, 33443, 0, 'Spirit of Gorat\r\n'),
(33304, 4, 0, 'Captain Elendilad conceals himself on the island ahead, cowardly issuing orders to his underlings.', 12, 0, 100, 1, 0, 0, 0, 33444, 0, 'Spirit of Gorat\r\n'),
(33304, 5, 0, 'He must fall!', 12, 0, 100, 5, 0, 0, 0, 33445, 0, 'Spirit of Gorat\r\n'),
(33304, 6, 0, 'Show yourself, elf-coward! Face your death with honor!', 14, 0, 100, 0, 3000, 0, 0, 33449, 0, 'Spirit of Gorat\r\n'),
(33302, 0, 0, 'How many times must I have you killed, orc?!', 14, 0, 100, 0, 0, 0, 0, 33455, 0, 'Captain Elendilad - On Respawn'),
(33302, 1, 0, 'Curse you, $r vermin! This forest belongs to the Kaldorei...', 12, 0, 100, 0, 0, 0, 0, 33462, 0, 'Captain Elendilad - On Death');
-- Add SAI
DELETE FROM `world`.`smart_scripts` WHERE `entryorguid` = 33302;
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 
(33304, 0, 0, 0, '', 54, 0, 100, 0, 0, 0, 0, 0, 0, '', 80, 3330400, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - On Just Summoned - Run Timed ActionList'),
(33304, 0, 1, 0, '', 40, 0, 100, 0, 4, 33304, 0, 0, 0, '', 80, 3330401, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - On WP Reached - Run Timed ActionList'),
(3330400, 9, 0, 0, '', 0, 0, 100, 0, 2000, 2000, 0, 0, 0, '', 90, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Set Unit Field Bytes 1'),
(3330400, 9, 1, 0, '', 0, 0, 100, 0, 4000, 4000, 0, 0, 0, '', 66, 0, 0, 0, 0, 0, 0, 0, NULL, 21, 10, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Set Orientation'),
(3330400, 9, 2, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Say Group 0'),
(3330400, 9, 3, 0, '', 0, 0, 100, 0, 6000, 6000, 0, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Say Group 1'),
(3330400, 9, 4, 0, '', 0, 0, 100, 0, 6000, 6000, 0, 0, 0, '', 1, 2, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Say Group 2'),
(3330400, 9, 5, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 59, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Set Run Off'),
(3330400, 9, 6, 0, '', 0, 0, 100, 0, 4000, 4000, 0, 0, 0, '', 69, 0, 0, 0, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, 1468.15, -2055.13, 92.9, 5.22, 'Spirit of Gorat - Timed ActionList - Move to Position'),
(3330400, 9, 7, 0, '', 0, 0, 100, 0, 3000, 3000, 0, 0, 0, '', 1, 3, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Say Group 3'),
(3330400, 9, 8, 0, '', 0, 0, 100, 0, 8000, 8000, 0, 0, 0, '', 1, 4, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Say Group 4'),
(3330400, 9, 9, 0, '', 0, 0, 100, 0, 17000, 17000, 0, 0, 0, '', 1, 5, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Say Group 5'),
(3330400, 9, 10, 0, '', 0, 0, 100, 0, 3000, 3000, 0, 0, 0, '', 53, 0, 33304, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Start WP'),
(3330401, 9, 0, 0, '', 0, 0, 100, 0, 2000, 2000, 0, 0, 0, '', 1, 6, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Say Group 6'),
(3330401, 9, 1, 0, '', 0, 0, 100, 0, 3000, 3000, 0, 0, 0, '', 11, 62792, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Cast \'Gorat\'s Bowshot\''),
(3330401, 9, 2, 0, '', 0, 0, 100, 0, 6000, 6000, 0, 0, 0, '', 45, 1, 1, 0, 0, 0, 0, 0, NULL, 10, 270379, 33336, 0, 0, NULL, 0, 0, 0, 0, 'Spirit of Gorat - Timed ActionList - Set Data 1 1 To \'Gorat\'s Target Bunny\''),
(33336, 0, 0, 0, '', 38, 0, 100, 0, 1, 1, 0, 0, 0, '', 80, 3333600, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorat\'s Target Bunny - On Data Set 1 1 - Run Timed ActionList'),
(3333600, 9, 0, 0, '', 0, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 62811, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorat\'s Target Bunny - Timed ActionList- Cast \'Bowshot Impact Flame Patch\''),
(3333600, 9, 1, 0, '', 0, 0, 100, 0, 4000, 4000, 0, 0, 0, '', 11, 62814, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Gorat\'s Target Bunny - Timed ActionList- Cast \'Summon Elendilad\''),
(33302, 0, 0, 0, '', 54, 0, 100, 0, 0, 0, 0, 0, 0, '', 80, 3330200, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Captain Elendilad - On Just Summoned - Run Timed ActionList'),
(33302, 0, 1, 3, '', 4, 0, 100, 0, 0, 0, 0, 0, 0, '', 11, 78823, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Captain Elendilad - On Aggro - Cast \'Commanding Shout\''),
(33302, 0, 2, 0, '', 9, 0, 100, 0, 0, 5, 13600, 14500, 0, '', 11, 78828, 2, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Captain Elendilad - Within 0-5 Range - Cast \'Bladestorm\''),
(33302, 0, 3, 0, '', 61, 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, 'Captain Elendilad - Link - Set Home Position'),
(33302, 0, 4, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 1, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Captain Elendilad - On Death - Say Group 1'),
(33302, 0, 5, 0, '', 6, 0, 100, 0, 0, 0, 0, 0, 0, '', 41, 3000, 0, 0, 0, 0, 0, 0, NULL, 19, 33304, 30, 0, 0, NULL, 0, 0, 0, 0, 'Captain Elendilad - On Death - Despawn  \'Spirit of Gorat\''),
(3330200, 9, 0, 0, '', 0, 0, 100, 0, 2000, 2000, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Captain Elendilad - Timed ActionList - Say Group 0'),
(3330200, 9, 1, 0, '', 0, 0, 100, 0, 3000, 3000, 0, 0, 0, '', 97, 25, 25, 0, 0, 0, 0, 0, NULL, 8, 0, 0, 0, 0, NULL, 1511.13, -2092.15, 89.114, 1.31, 'Captain Elendilad - Timed ActionList - Jump To Position'),
(3330200, 9, 2, 0, '', 0, 0, 100, 0, 3000, 3000, 0, 0, 0, '', 49, 0, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'Captain Elendilad - Timed ActionList - Attack Player');
-- Add WP
INSERT INTO `world`.`waypoint_path` (`PathId`, `Comment`) VALUES (33304, 'Spirit of Gorat');
INSERT INTO `world`.`waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES 
(33304, 1, 1468.15, -2055.13, 92.91, 5.375, 0),
(33304, 2, 1485.96, -2079.9, 93.3431, 6.146, 0),
(33304, 3, 1494.65, -2082.31, 92.296, 5.18, 0),
(33304, 4, 1497.04, -2089.99, 90.141, 5.054, 0);