Leave No Man Behind! (Quest=25809)

UPDATE creature_template SET npcflag = 16777216, unit_flags = unit_flags&~33554432 WHERE entry = 41283;

DELETE FROM npc_spellclick_spells WHERE npc_entry = 41283;
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`) VALUES
(41283, 77412, 2);

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 18 AND `ConditionTypeOrReference` = 9 AND `SourceGroup` = 41283 AND `SourceEntry` = 77412;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`, `ErrorType`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES
(18, 41283, 77412, 0, 0, 9, 0, 25809, 0, 0, 0, 0, 0, '', 'On SpellClick Eent - Only if quest accepted');

UPDATE creature_template SET AIName = 'SmartAI' WHERE entry = 41283;
DELETE FROM `smart_scripts` WHERE entryorguid = 41283 AND source_type = 0;
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
(41283, 0, 0, 1, 73, 0, 100, 0, 0, 0, 0, 0, 11, 77408, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On SpellClick - cast spell - Target Invoker'),
(41283, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Link - Say Text'),
(41283, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On Link - Set Orientation - Target Invoker'),
(41283, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Link - Clear emote state - Target Self'),
(41283, 0, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 41, 4500, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Link - despawn'),
(41283, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Link - Clear npcflag'),
(41283, 0, 6, 0, 25, 0, 100, 0, 0, 0, 0, 0, 81, 16777216, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Reset/Spawn - set npcflag');

DELETE FROM creature_text WHERE creatureId = 41283;
INSERT INTO `creature_text` (`creatureId`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
(41283, 0, 0, 'Are... Are they dead? The assassins?', 12, 0, 100, 1, 0, 0, ''),
(41283, 0, 1, 'Is it safe?', 12, 0, 100, 1, 0, 0, ''),
(41283, 0, 2, 'Thank the Light! I\'m saved!', 12, 0, 100, 1, 0, 0, '');

DELETE FROM creature_template_addon WHERE entry = 41283;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
(41283, 0, 0, 0, 1, 431, NULL);