Thread: How to add AI scripts to Trintycore/SkyfireEMU

xD the names are every time in the header of the single sql parts :d

Code:

 -- Jack the Hammer 
 SET @ENTRY := 34877;
 UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
 DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY;
 INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_ty pe`,`event_phase_mask`,`event_chance`,`event_flags `,`event_param1`,`event_param2`,`event_param3`,`ev ent_param4`,`action_type`,`action_param1`,`action_ param2`,`action_param3`,`action_param4`,`action_pa ram5`,`action_param6`,`target_type`,`target_param1 `,`target_param2`,`target_param3`,`target_x`,`targ et_y`,`target_z`,`target_o`,`comment`) VALUES
 (@ENTRY,0,0,0,0,0,100,0,5000,7700,12300,16700,11,7 5986,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Knockback'),
 (@ENTRY,0,1,0,1,0,100,1,500,1000,0,0,11,76136,0,0, 0,0,0,1,0,0,0,0,0,0,0,'Cast Acidic Sweat on Spawn');