[WIP] move spell Capture Worg Pup from db spell script to SAI

[CODE]-- Bloodaxe Worg Pup SAI
SET @ENTRY := 10221; – NPC entry
SET @SPELL1 := 15998; – Capture Worg Pup
UPDATE creature_template SET AIName=‘SmartAI’,ScriptName=‘’ WHERE entry=@ENTRY;
DELETE FROM creature_ai_scripts WHERE creature_id=@ENTRY;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@ENTRY;
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,8,0,100,0,@SPELL1,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Bloodaxe Worg Pup - On Spellhit - Despawn’);
– Fix Spell condition for Spell 15998 to only target Worg Pup
DELETE FROM conditions WHERE SourceTypeOrReferenceId=13 AND SourceEntry=15998;
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ElseGroup,ConditionTypeOrReference,ConditionValue1,ConditionValue2,ConditionValue3,ErrorTextId,ScriptName,Comment) VALUES
(13,0,15998,0,18,1,10221,0,0,‘’,‘Spell Capture Worg Pup targets only Worg Pup’);
– Remove old spell script
DELETE FROM spell_scripts WHERE id=15998;[/sql]

Needs testing

[/CODE]