[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
[email protected];
DELETE FROM creature_ai_scripts
WHERE creature_id
[email protected];
DELETE FROM smart_scripts
WHERE source_type
=0 AND entryorguid
[email protected];
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]