wod [FIX] Quest Critical Condition (29552)

[MENZ411]

-- Fixed Quest Critical Condition (29552)
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `IconName`='openhandglow', `npcflag`=16777216 WHERE `entry` IN (61492, 66564, 66565, 66567);

DELETE FROM `creature_template_addon` WHERE `entry` IN (61492, 66564, 66565, 66567);
INSERT INTO `creature_template_addon` 
(`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES 
(61492, 0, 0, 7, 1, 0, '130851'), -- state dead, aura Wounded
(66564, 0, 0, 7, 1, 0, '130852'), -- state dead, aura Terribly Wounded
(66565, 0, 0, 7, 1, 0, '130854'), -- state dead, aura Critically Wounded
(66567, 0, 0, 7, 1, 0, '130855'); -- state dead, aura Mortally Wounded
DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (61492, 66564, 66565, 66567));
UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `id` IN (61492, 66564, 66565, 66567);

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (61492, 66564, 66565, 66567);
INSERT INTO `npc_spellclick_spells` 
(`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES 
(61492, 131845, 1, 0), -- First Aid
(66564, 131845, 1, 0),
(66565, 131845, 1, 0),
(66567, 131845, 1, 0);

-- Wounded Pilot SAI
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (61492, 66564, 66565, 66567) AND `source_type`=0 OR `entryorguid`=6149200 AND `source_type`=9;
INSERT INTO `smart_scripts` 
(`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(61492, 0, 0, 1, 8, 0, 100, 0, 131845, 0, 1000, 1000, 80, 6149200, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wounded Pilot - On spellhit - Run script'),
(61492, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 28, 130851, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wounded Pilot - On link - Remove Wounded'),
(61492, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 83, 16777216, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wounded Pilot - On link - Remove spellclick flag'),
(66564, 0, 0, 1, 8, 0, 100, 0, 131845, 0, 1000, 1000, 80, 6149200, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Terribly Wounded Pilot - On spellhit - Run script'),
(66564, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 28, 130852, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Terribly Wounded Pilot - On link - Remove Terribly Wounded'),
(66564, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 83, 16777216, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Terribly Wounded Pilot - On link - Remove spellclick flag'),
(66565, 0, 0, 1, 8, 0, 100, 0, 131845, 0, 1000, 1000, 80, 6149200, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Critically Wounded Pilot - On spellhit - Run script'),
(66565, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 28, 130854, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Critically Wounded Pilot - On link - Remove Critically Wounded'),
(66565, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 83, 16777216, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Critically Wounded Pilot - On link - Remove spellclick flag'),
(66567, 0, 0, 1, 8, 0, 100, 0, 131845, 0, 1000, 1000, 80, 6149200, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mortally Wounded Pilot - On spellhit - Run script'),
(66567, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 28, 130855, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mortally Wounded Pilot - On link - Remove Mortally Wounded'),
(66567, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 83, 16777216, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Mortally Wounded Pilot - On link - Remove spellclick flag'),
(6149200, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 86, 102537, 0, 0, 7, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wounded Pilot - Script - Cast CPR: Kill Credit'), -- 33, 54929
(6149200, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 91, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wounded Pilot - Script - Remove state dead'),
(6149200, 9, 2, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wounded Pilot - Script - Say line random'),
(6149200, 9, 3, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wounded Pilot - Script - Set run'),
(6149200, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 69, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, -366.709, -1651.05, 41.8674, 5.31633, 'Wounded Pilot - Script - Move to pos'),
(6149200, 9, 5, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 81, 16777216, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wounded Pilot - Script - Reset npcflag'),
(6149200, 9, 6, 0, 0, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wounded Pilot - Script - Force despawn');

DELETE FROM `conditions` WHERE `SourceGroup` IN (61492, 66564, 66565, 66567) AND `SourceTypeOrReferenceId`=18;
INSERT INTO `conditions` 
(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(18, 61492, 131845, 0, 0, 9, 0, 29552, 0, 0, 0, 0, '', 'Show spellclick if quest 29552 taken'),
(18, 66564, 131845, 0, 0, 9, 0, 29552, 0, 0, 0, 0, '', 'Show spellclick if quest 29552 taken'),
(18, 66565, 131845, 0, 0, 9, 0, 29552, 0, 0, 0, 0, '', 'Show spellclick if quest 29552 taken'),
(18, 66567, 131845, 0, 0, 9, 0, 29552, 0, 0, 0, 0, '', 'Show spellclick if quest 29552 taken');

DELETE FROM `creature_text` WHERE `entry` IN (61492, 66564, 66565, 66567);
INSERT INTO `creature_text` 
(`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES 
(61492, 0, 0, 'I thought I was a goner. I owe you my life.', 12, 0, 100, 0, 0, 0, 'Wounded Pilot'),
(61492, 0, 1, 'I''m alive? Ha! That''s more than I can say for those Horde at Garrosh''ar Point. We tore them up good.', 12, 0, 100, 0, 0, 0, 'Wounded Pilot'),
(61492, 0, 2, 'Nice seeing another Alliance face! I thought I was going to die out here.', 12, 0, 100, 0, 0, 0, 'Wounded Pilot'),
(61492, 0, 3, 'Thank you for rescuing me. For the Alliance!', 12, 0, 100, 0, 0, 0, 'Wounded Pilot'),
(61492, 0, 4, 'Thank you, friend. Don''t worry, it was just a scratch. Now I feel good as new!', 12, 0, 100, 0, 0, 0, 'Wounded Pilot'),
(61492, 0, 5, 'Thank you. Time to lick my wounds and get back to the fight!', 12, 0, 100, 0, 0, 0, 'Wounded Pilot'),
(61492, 0, 6, 'Thanks for saving me. It was rough up there.', 12, 0, 100, 0, 0, 0, 'Wounded Pilot'),
(61492, 0, 7, 'Thanks, friend. That was some firefight, but I knew that blue would pull through!', 12, 0, 100, 0, 0, 0, 'Wounded Pilot'),
(66564, 0, 0, 'I thought I was a goner. I owe you my life.', 12, 0, 100, 0, 0, 0, 'Terribly Wounded Pilot'),
(66564, 0, 1, 'I''m alive? Ha! That''s more than I can say for those Horde at Garrosh''ar Point. We tore them up good.', 12, 0, 100, 0, 0, 0, 'Terribly Wounded Pilot'),
(66564, 0, 2, 'Nice seeing another Alliance face! I thought I was going to die out here.', 12, 0, 100, 0, 0, 0, 'Terribly Wounded Pilot'),
(66564, 0, 3, 'Thank you for rescuing me. For the Alliance!', 12, 0, 100, 0, 0, 0, 'Terribly Wounded Pilot'),
(66564, 0, 4, 'Thank you, friend. Don''t worry, it was just a scratch. Now I feel good as new!', 12, 0, 100, 0, 0, 0, 'Terribly Wounded Pilot'),
(66564, 0, 5, 'Thank you. Time to lick my wounds and get back to the fight!', 12, 0, 100, 0, 0, 0, 'Terribly Wounded Pilot'),
(66564, 0, 6, 'Thanks for saving me. It was rough up there.', 12, 0, 100, 0, 0, 0, 'Terribly Wounded Pilot'),
(66564, 0, 7, 'Thanks, friend. That was some firefight, but I knew that blue would pull through!', 12, 0, 100, 0, 0, 0, 'Terribly Wounded Pilot'),
(66565, 0, 0, 'I thought I was a goner. I owe you my life.', 12, 0, 100, 0, 0, 0, 'Critically Wounded Pilot'),
(66565, 0, 1, 'I''m alive? Ha! That''s more than I can say for those Horde at Garrosh''ar Point. We tore them up good.', 12, 0, 100, 0, 0, 0, 'Critically Wounded Pilot'),
(66565, 0, 2, 'Nice seeing another Alliance face! I thought I was going to die out here.', 12, 0, 100, 0, 0, 0, 'Critically Wounded Pilot'),
(66565, 0, 3, 'Thank you for rescuing me. For the Alliance!', 12, 0, 100, 0, 0, 0, 'Critically Wounded Pilot'),
(66565, 0, 4, 'Thank you, friend. Don''t worry, it was just a scratch. Now I feel good as new!', 12, 0, 100, 0, 0, 0, 'Critically Wounded Pilot'),
(66565, 0, 5, 'Thank you. Time to lick my wounds and get back to the fight!', 12, 0, 100, 0, 0, 0, 'Critically Wounded Pilot'),
(66565, 0, 6, 'Thanks for saving me. It was rough up there.', 12, 0, 100, 0, 0, 0, 'Critically Wounded Pilot'),
(66565, 0, 7, 'Thanks, friend. That was some firefight, but I knew that blue would pull through!', 12, 0, 100, 0, 0, 0, 'Critically Wounded Pilot'),
(66567, 0, 0, 'I thought I was a goner. I owe you my life.', 12, 0, 100, 0, 0, 0, 'Mortally Wounded Pilot'),
(66567, 0, 1, 'I''m alive? Ha! That''s more than I can say for those Horde at Garrosh''ar Point. We tore them up good.', 12, 0, 100, 0, 0, 0, 'Mortally Wounded Pilot'),
(66567, 0, 2, 'Nice seeing another Alliance face! I thought I was going to die out here.', 12, 0, 100, 0, 0, 0, 'Mortally Wounded Pilot'),
(66567, 0, 3, 'Thank you for rescuing me. For the Alliance!', 12, 0, 100, 0, 0, 0, 'Mortally Wounded Pilot'),
(66567, 0, 4, 'Thank you, friend. Don''t worry, it was just a scratch. Now I feel good as new!', 12, 0, 100, 0, 0, 0, 'Mortally Wounded Pilot'),
(66567, 0, 5, 'Thank you. Time to lick my wounds and get back to the fight!', 12, 0, 100, 0, 0, 0, 'Mortally Wounded Pilot'),
(66567, 0, 6, 'Thanks for saving me. It was rough up there.', 12, 0, 100, 0, 0, 0, 'Mortally Wounded Pilot'),
(66567, 0, 7, 'Thanks, friend. That was some firefight, but I knew that blue would pull through!', 12, 0, 100, 0, 0, 0, 'Mortally Wounded Pilot');