SET @ENTRY := 50047;
SET @SPELL_RENEWED_LIFE := 93097;
SET @SPELL_GET_BOYS_BACK := 93072;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
UPDATE `creature_template_addon` SET `emote`=0 WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=@ENTRY AND `source_type`=0 AND `id`=0 AND `link`=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
(@ENTRY,0,0,0,1,0,100,1,0,0,0,0,90,12,0,0,0,0,0,1,0,0,0,0,0,0,0,'Injured Stormwind Infantry - Out of Combat - Emote State Sleep'),
(@ENTRY,0,1,0,8,0,100,0,@SPELL_RENEWED_LIFE,0,0,0,80,@ENTRY*100,0,2,0,0,0,1,0,0,0,0,0,0,0,'Injured Stormwind Infantry - On Spellhit - Run Script'),
(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Injured Stormwind Infantry - On Script - Set Phase 1'),
(@ENTRY*100,9,1,0,0,0,100,0,0,0,0,0,90,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Injured Stormwind Infantry - On Script - Stop Sleeping'),
(@ENTRY*100,9,3,0,0,0,100,0,2000,2000,0,0,33,@ENTRY,0,0,0,0,0,7,0,0,0,0,0,0,0,'Injured Stormwind Infantry - On Script - Quest Credit'),
(@ENTRY*100,9,4,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Injured Stormwind Infantry - On Script - Say Line 0 (random)'),
(@ENTRY*100,9,5,0,0,0,100,0,500,500,0,0,69,0,0,0,0,0,0,8,0,0,0,-8776.936453,-128.619095,82.953384,5.691601,'Injured Stormwind Infantry - On Script - Move To Pos'),
(@ENTRY*100,9,5,0,0,0,100,0,4500,4500,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Injured Stormwind Infantry - On Script - Forced Despawn');
-- Texts
DELETE FROM `creature_text` WHERE `entry`=@ENTRY;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(@ENTRY,0,0,'Bless you, hero!',12,0,100,0,0,0,'Injured Stormwind Infantry'),
(@ENTRY,0,1,'I live to fight another day!',12,0,100,0,0,0,'Injured Stormwind Infantry'),
(@ENTRY,0,2,'I... I\'m ok! I\'m ok!',12,0,100,0,0,0,'Injured Stormwind Infantry'),
(@ENTRY,0,3,'I will fear no evil!',12,0,100,0,0,0,'Injured Stormwind Infantry'),
(@ENTRY,0,4,'You\'re $N! The hero that everyone has been talking about! Thank you!',12,0,100,0,0,0,'Injured Stormwind Infantry'),
(@ENTRY,0,5,'Thank the Light!',12,0,100,0,0,0,'Injured Stormwind Infantry');

-- Update quest_template from sniff
UPDATE `quest_template` SET `SkillOrClassMask`=-2,`MinLevel`=3,`QuestFlags`=524288,`PrevQuestId`=28785  WHERE `entry`=28809;
UPDATE `quest_template` SET `SkillOrClassMask`=-128,`MinLevel`=3,`QuestFlags`=524288,`PrevQuestId`=28784  WHERE `entry`=28810;
UPDATE `quest_template` SET `SkillOrClassMask`=-8,`MinLevel`=3,`QuestFlags`=524288,`PrevQuestId`=28787  WHERE `entry`=28811;
UPDATE `quest_template` SET `SkillOrClassMask`=-256,`MinLevel`=3,`QuestFlags`=524288,`PrevQuestId`=28788  WHERE `entry`=28812;
UPDATE `quest_template` SET `SkillOrClassMask`=-1,`MinLevel`=3,`QuestFlags`=524288,`PrevQuestId`=28789  WHERE `entry`=28813;
UPDATE `quest_template` SET `SkillOrClassMask`=-4,`MinLevel`=3,`QuestFlags`=524288,`PrevQuestId`=28780 WHERE `entry`=28806;
UPDATE `quest_template` SET `SkillOrClassMask`=-16,`MinLevel`=3,`QuestFlags`=524288,`PrevQuestId`=28786  WHERE `entry`=28808;

-- Spellclick
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=@ENTRY;
INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`cast_flags`) VALUES
(@ENTRY,@SPELL_GET_BOYS_BACK,28812,1,1),
(@ENTRY,@SPELL_GET_BOYS_BACK,28813,1,1),
(@ENTRY,@SPELL_GET_BOYS_BACK,29082,1,1),
(@ENTRY,@SPELL_GET_BOYS_BACK,28811,1,1),
(@ENTRY,@SPELL_GET_BOYS_BACK,28810,1,1),
(@ENTRY,@SPELL_GET_BOYS_BACK,28808,1,1),
(@ENTRY,@SPELL_GET_BOYS_BACK,28809,1,1),
(@ENTRY,@SPELL_GET_BOYS_BACK,28806,1,1);

-- Conditions for Get Our Boys Back Dummy
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceID`=13 AND `SourceEntry`=@SPELL_GET_BOYS_BACK;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ConditionTypeOrReference`,`elseGroup`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`Comment`) VALUES
(13,0,@SPELL_GET_BOYS_BACK,18,0,1,@ENTRY,1,0,'Get Our Boys Back Dummy targets Injured Stormwind Infantry');