diff options
author | cooler-SAI <cooler19860212@yahoo.com> | 2015-07-23 23:45:43 +0200 |
---|---|---|
committer | Rushor <PBienati@web.de> | 2015-07-23 23:45:50 +0200 |
commit | eb9d08b3d0eebfe3cc482614f6dff4d8c5b607a9 (patch) | |
tree | f4b450c78729389ee69729d9625bbb8299ee6110 | |
parent | 256f368efbe6cb879a1a501f2b6cdcba0597d27f (diff) |
DB/SAI: Update Mulgore
* updates #15127
-rw-r--r-- | sql/updates/world/2015_07_23_02_world.sql | 648 |
1 files changed, 648 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_23_02_world.sql b/sql/updates/world/2015_07_23_02_world.sql new file mode 100644 index 00000000000..02cf510e484 --- /dev/null +++ b/sql/updates/world/2015_07_23_02_world.sql @@ -0,0 +1,648 @@ +-- Update Mulgore + +-- 1. +-- "Pokey" Thornmantle SAI +SET @ENTRY := 43720; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,5000,8000,15000,24000,11,81691,0,0,0,0,0,2,0,0,0,0,0,0,0,"Pokey Thornmantle - In Combat - Cast 'Quillhorn'"); + +-- 2. +-- Adult Plainstrider SAI +SET @ENTRY := 2956; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,66060,0,0,0,0,0,1,0,0,0,0,0,0,0,"Adult Plainstrider - On Aggro - Cast 'Sprint' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,4000,6000,14000,18000,11,81678,0,0,0,0,0,2,0,0,0,0,0,0,0,"Adult Plainstrider - In Combat - Cast 'Eye Peck'"); + +-- 3. +-- Agitated Earth Spirit SAI +SET @ENTRY := 36845; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,4500,5500,18500,21500,11,81305,0,0,0,0,0,2,0,0,0,0,0,0,0,"Agitated Earth Spirit - In Combat - Cast 'Rock Barrage'"); + + +-- 4. +-- Ahab Wheathoof SAI +SET @ENTRY := 23618; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,10,0,100,0,1,10,120000,120000,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ahab Wheathoof - Within 1-10 Range Out of Combat LoS - Say Line 0"); + +-- NPC talk text insert +SET @ENTRY := 23618; +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES +(@ENTRY,0,0, 'Will you help me find my dog?',12,0,50,1,0,0, 'say Text',22167), +(@ENTRY,0,1, 'I miss my dog so much!',12,0,50,1,0,0, 'say Text',22168), +(@ENTRY,0,2, 'Where is that dog?',12,0,50,1,0,0, 'say Text',22166); + +-- 5. +-- Armored Battleboar SAI +SET @ENTRY := 36696; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,3385,0,0,0,0,0,1,0,0,0,0,0,0,0,"Armored Battleboar - On Aggro - Cast 'Boar Charge' (No Repeat)"); + +-- 6. +-- Arra'chea SAI +SET @ENTRY := 3058; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,6268,0,0,0,0,0,1,0,0,0,0,0,0,0,"Arra'chea - On Aggro - Cast 'Rushing Charge' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,5000,8000,17000,25000,11,81140,0,0,0,0,0,1,0,0,0,0,0,0,0,"Arra'chea - In Combat - Cast 'Thunderclap'"); + +-- 7. +-- Baine Bloodhoof SAI +SET @ENTRY := 37058; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,69879,0,0,0,0,0,2,0,0,0,0,0,0,0,"Baine Bloodhoof - On Aggro - Cast 'Charge' (No Repeat)"); + +-- 8. +-- Brave Darksky SAI +SET @ENTRY := 3220; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Darksky - In Combat - Cast 'Shoot'"); + +-- 9. +-- Brave Dawneagle SAI +SET @ENTRY := 3217; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Dawneagle - In Combat - Cast 'Shoot'"); + +-- 10. +-- Brave Greathoof SAI +SET @ENTRY := 3214; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Greathoof - In Combat - Cast 'Shoot'"); + +-- 11. +-- Brave Ironhorn SAI +SET @ENTRY := 3212; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Ironhorn - In Combat - Cast 'Shoot'"); + +-- 12. +-- Brave Leaping Deer SAI +SET @ENTRY := 3219; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Leaping Deer - In Combat - Cast 'Shoot'"); + +-- 13. +-- Brave Lightninghorn SAI +SET @ENTRY := 3211; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Lightninghorn - In Combat - Cast 'Shoot'"); + +-- 14. +-- Brave Proudsnout SAI +SET @ENTRY := 3210; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Proudsnout - In Combat - Cast 'Shoot'"); + +-- 15. +-- Brave Rainchaser SAI +SET @ENTRY := 3223; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Rainchaser - In Combat - Cast 'Shoot'"); + +-- 16. +-- Brave Rockhorn SAI +SET @ENTRY := 3221; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Rockhorn - In Combat - Cast 'Shoot'"); + +-- 17. +-- Brave Running Wolf SAI +SET @ENTRY := 3213; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Running Wolf - In Combat - Cast 'Shoot'"); + +-- 18. +-- Brave Wildrunner SAI +SET @ENTRY := 3222; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,95826,64,0,0,0,0,2,0,0,0,0,0,0,0,"Brave Wildrunner - In Combat - Cast 'Shoot'"); + +-- 19. +-- Bristleback Gun Thief SAI +SET @ENTRY := 36708; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,81655,64,0,0,0,0,2,0,0,0,0,0,0,0,"Bristleback Gun Thief - In Combat - Cast 'Shoot'"), +(@ENTRY,0,1,5,9,0,100,0,5,30,12000,18000,11,81654,1,0,0,0,0,2,0,0,0,0,0,0,0,"Bristleback Gun Thief - Within 5-30 Range - Cast 'Clumsy Shot'"), +(@ENTRY,0,2,0,11,0,100,1,0,0,0,0,11,81653,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bristleback Gun Thief - On Respawn - Cast 'Bristleback' (No Repeat)"); + +-- 20. +-- Bristleback Interloper SAI +SET @ENTRY := 3232; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,11,0,100,1,0,0,0,0,11,81653,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bristleback Interloper - On Respawn - Cast 'Bristleback' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,5000,8000,22000,24000,11,79584,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bristleback Interloper - In Combat - Cast 'Fan of Knives'"); + +-- 21. +-- Bristleback Invader SAI +SET @ENTRY := 36943; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,11,0,100,1,0,0,0,0,11,81653,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bristleback Invader - On Respawn - Cast 'Bristleback' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,2000,4000,25000,28000,11,11977,0,0,0,0,0,2,0,0,0,0,0,0,0,"Bristleback Invader - In Combat - Cast 'Rend'"); + +-- 22. +-- Bristleback Invaders SAI +SET @ENTRY := 2952; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,11,0,100,1,0,0,0,0,11,81653,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bristleback Invaders - On Respawn - Cast 'Bristleback' (No Repeat)"); + +-- 23. +-- Bristleback Thorncaller SAI +SET @ENTRY := 36697; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,11,0,100,1,0,0,0,0,11,81653,0,0,0,0,0,1,0,0,0,0,0,0,0,"Bristleback Thorncaller - On Respawn - Cast 'Bristleback' (No Repeat)"), +(@ENTRY,0,1,0,1,0,100,1,1000,1000,1000,1000,11,51733,2,0,0,0,0,1,0,0,0,0,0,0,0,"Bristleback Thorncaller - Out of Combat - Cast 'Shadow Channelling' (No Repeat)"), +(@ENTRY,0,2,0,9,0,100,0,0,30,14000,15000,11,31287,0,0,0,0,0,2,0,0,0,0,0,0,0,"Bristleback Thorncaller - Within 0-30 Range - Cast 'Entangling Roots'"); + +-- 24. +-- Chief Squealer Thornmantle SAI +SET @ENTRY := 36712; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Chief Squealer Thornmantle - On Aggro - Say Line 0 (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,5000,5000,12000,15000,11,81691,0,0,0,0,0,2,0,0,0,0,0,0,0,"Chief Squealer Thornmantle - In Combat - Cast 'Quillhorn'"), +(@ENTRY,0,2,0,0,0,100,0,4000,9000,18000,24000,11,81695,0,0,0,0,0,2,0,0,0,0,0,0,0,"Chief Squealer Thornmantle - In Combat - Cast 'Torch Toss'"); + +-- NPC talk text insert +SET @ENTRY := 36712; +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES +(@ENTRY,0,0, 'Squealer take this land! Tauren will burn!',12,0,100,0,0,0, 'on Aggro Text',38323); + +-- 25. +-- Doomsayer Wiserunner SAI +SET @ENTRY := 43613; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4700,11,79854,64,0,0,0,0,2,0,0,0,0,0,0,0,"Doomsayer Wiserunner - In Combat - Cast 'Fireball'"), +(@ENTRY,0,1,0,9,0,100,0,0,8,13600,14500,11,79857,1,0,0,0,0,1,0,0,0,0,0,0,0,"Doomsayer Wiserunner - Within 0-8 Range - Cast 'Blast Wave'"), +(@ENTRY,0,2,0,1,0,100,0,500,1000,600000,600000,11,79849,0,0,0,0,0,1,0,0,0,0,0,0,0,"Doomsayer Wiserunner - Out of Combat - Cast 'Molten Armor'"); + +-- 26. +-- Elder Plainstrider SAI +SET @ENTRY := 2957; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,66060,0,0,0,0,0,1,0,0,0,0,0,0,0,"Elder Plainstrider - On Aggro - Cast 'Sprint' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,5000,5500,19000,22000,11,7272,0,0,0,0,0,1,0,0,0,0,0,0,0,"Elder Plainstrider - In Combat - Cast 'Dust Cloud'"); + +-- 27. +-- Enforcer Emilgund SAI +SET @ENTRY := 5787; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,5000,9000,17000,24000,11,80182,0,0,0,0,0,2,0,0,0,0,0,0,0,"Enforcer Emilgund - In Combat - Cast 'Uppercut'"), +(@ENTRY,0,1,0,2,0,100,1,0,30,0,0,11,81173,0,0,0,0,0,1,0,0,0,0,0,0,0,"Enforcer Emilgund - Between 0-30% Health - Cast 'Frenzy' (No Repeat)"), +(@ENTRY,0,2,0,2,0,100,1,0,30,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Enforcer Emilgund - Between 0-30% Health - Say Line 0 (No Repeat)"); + +-- NPC talk text insert +SET @ENTRY := 5787; +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES +(@ENTRY,0,0, '%s goes into a frenzy!',16,0,100,0,0,0, 'combat Frenzy',2384); + +-- 28. +-- Flatland Prowler SAI +SET @ENTRY := 3566; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,11,0,100,1,0,0,0,0,11,81683,0,0,0,0,0,1,0,0,0,0,0,0,0,"Flatland Prowler - On Respawn - Cast 'Prowl' (No Repeat)"), +(@ENTRY,0,1,0,7,0,100,1,0,0,0,0,11,81683,0,0,0,0,0,1,0,0,0,0,0,0,0,"Flatland Prowler - On Evade - Cast 'Prowl' (No Repeat)"); + +-- 29. +-- Fledgling Brave SAI +SET @ENTRY := 36942; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,70092,64,0,0,0,0,2,0,0,0,0,0,0,0,"Fledgling Brave - In Combat - Cast 'Shoot Gun'"), +(@ENTRY,0,1,5,9,0,100,0,0,5,7000,9000,11,81502,0,0,0,0,0,2,0,0,0,0,0,0,0,"Fledgling Brave - Within 0-5 Range - Cast 'Cleave'"), +(@ENTRY,0,2,5,9,0,100,0,0,5,17000,22000,11,81500,0,0,0,0,0,1,0,0,0,0,0,0,0,"Fledgling Brave - Within 0-5 Range - Cast 'War Stomp'"); + +-- 30. +-- Ghost Howl SAI +SET @ENTRY := 3056; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,78837,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ghost Howl - On Aggro - Cast 'Ghostform' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,5000,6000,15000,20000,11,78832,0,0,0,0,0,2,0,0,0,0,0,0,0,"Ghost Howl - In Combat - Cast 'Arcane Blast'"), +(@ENTRY,0,2,0,2,0,100,1,0,30,0,0,11,8599,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ghost Howl - Between 0-30% Health - Cast 'Enrage' (No Repeat)"), +(@ENTRY,0,3,0,2,0,100,1,0,30,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Ghost Howl - Between 0-30% Health - Say Line 0 (No Repeat)"); +-- NPC talk text insert +SET @ENTRY := 3056; +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES +(@ENTRY,0,0, '%s becomes enraged!',16,0,100,0,0,0, 'combat Enrage',10677); + +-- 31. +-- Grimtotem Defender SAI +SET @ENTRY := 37178; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,2000,4500,17000,25000,11,77558,0,0,0,0,0,2,0,0,0,0,0,0,0,"Grimtotem Defender - In Combat - Cast 'Bloody Strike'"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimtotem Defender - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- 32. +-- Grimtotem Defiler SAI +SET @ENTRY := 36828; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,4000,5000,26000,29000,11,78705,0,0,0,0,0,2,0,0,0,0,0,0,0,"Grimtotem Defiler - In Combat - Cast 'Poison Bottle'"), +(@ENTRY,0,1,0,0,0,100,0,8000,9000,36000,48000,11,78648,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimtotem Defiler - In Combat - Cast 'Grim Totem'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimtotem Defiler - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- 33. +-- Grimtotem Straggler SAI +SET @ENTRY := 36825; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,2000,4200,15000,21000,11,80382,0,0,0,0,0,2,0,0,0,0,0,0,0,"Grimtotem Straggler - In Combat - Cast 'Dirt Toss'"), +(@ENTRY,0,1,0,0,0,100,0,8000,9000,36000,48000,11,78648,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimtotem Straggler - In Combat - Cast 'Grim Totem'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimtotem Straggler - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- 34. +-- Grimtotem Vagabond SAI +SET @ENTRY := 36827; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,2000,3500,16000,19800,11,80146,0,0,0,0,0,2,0,0,0,0,0,0,0,"Grimtotem Vagabond - In Combat - Cast 'Bonk'"), +(@ENTRY,0,1,0,0,0,100,0,8000,9000,36000,48000,11,78648,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimtotem Vagabond - In Combat - Cast 'Grim Totem'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimtotem Vagabond - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- 35. +-- Grimtotem Vandal SAI +SET @ENTRY := 36832; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,9,0,100,0,0,5,22000,25500,11,78828,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimtotem Vandal - Within 0-5 Range - Cast 'Bladestorm'"), +(@ENTRY,0,1,0,0,0,100,0,8000,9000,36000,48000,11,78648,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimtotem Vandal - In Combat - Cast 'Grim Totem'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Grimtotem Vandal - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- 36. +-- Hulfnar Stonetotem SAI +SET @ENTRY := 10599; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,5500,8000,18000,27000,11,16740,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hulfnar Stonetotem - In Combat - Cast 'War Stomp'"); + +-- 37. +-- Kodo Bull SAI +SET @ENTRY := 2973; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,9,0,100,0,0,8,9000,14000,11,5568,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kodo Bull - Within 0-8 Range - Cast 'Trample'"); + +-- 38. +-- Kodo Calf SAI +SET @ENTRY := 2972; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,6268,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kodo Calf - On Aggro - Cast 'Rushing Charge' (No Repeat)"); + +-- 39. +-- Kodo Matriarch SAI +SET @ENTRY := 2974; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,9,0,100,0,0,8,9000,14000,11,5568,0,0,0,0,0,1,0,0,0,0,0,0,0,"Kodo Matriarch - Within 0-8 Range - Cast 'Trample'"); + +-- 40. +-- Mazzranache SAI +SET @ENTRY := 3068; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,6268,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mazzranache - On Aggro - Cast 'Rushing Charge' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,2000,5000,15000,22000,11,3583,0,0,0,0,0,2,32,0,0,0,0,0,0,"Mazzranache - In Combat - Cast 'Deadly Poison'"); + +-- 41. +-- Orno Grimtotem SAI +SET @ENTRY := 36931; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,2000,4500,19000,25000,11,77558,0,0,0,0,0,2,0,0,0,0,0,0,0,"Orno Grimtotem - In Combat - Cast 'Bloody Strike'"); + +-- 42. +-- Palemane Poacher SAI +SET @ENTRY := 2951; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,2300,3900,11,6660,64,0,0,0,0,2,0,0,0,0,0,0,0,"Palemane Poacher - In Combat - Cast 'Shoot'"), +(@ENTRY,0,1,0,9,0,100,0,5,30,9000,14000,11,80009,1,0,0,0,0,2,0,0,0,0,0,0,0,"Palemane Poacher - Within 5-30 Range - Cast 'Serpent Sting'"), +(@ENTRY,0,2,0,4,0,20,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Palemane Poacher - On Aggro - Say Line 0 (No Repeat)"); +-- NPC talk text insert +SET @ENTRY := 2951; +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES +(@ENTRY,0,0, 'More bones to gnaw on...',12,0,50,0,0,0, 'on Aggro Text',46596), +(@ENTRY,0,1, 'Grrrr... fresh meat!',12,0,50,0,0,0, 'on Aggro Text',1870); + +-- 43. +-- Palemane Skinner SAI +SET @ENTRY := 2950; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,4000,5000,19000,22000,11,81705,0,0,0,0,0,2,0,0,0,0,0,0,0,"Palemane Skinner - In Combat - Cast 'Scalp Slash'"), +(@ENTRY,0,1,0,4,0,20,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Palemane Skinner - On Aggro - Say Line 0 (No Repeat)"); +-- NPC talk text insert +SET @ENTRY := 2950; +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES +(@ENTRY,0,0, 'More bones to gnaw on...',12,0,50,0,0,0, 'on Aggro Text',46596), +(@ENTRY,0,1, 'Grrrr... fresh meat!',12,0,50,0,0,0, 'on Aggro Text',1870); + +-- 44. +-- Palemane Tanner SAI +SET @ENTRY := 2949; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,20,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Palemane Tanner - On Aggro - Say Line 0 (No Repeat)"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Palemane Tanner - Between 0-15% Health - Flee For Assist (No Repeat)"); +-- NPC talk text insert +SET @ENTRY := 2949; +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES +(@ENTRY,0,0, 'More bones to gnaw on...',12,0,50,0,0,0, 'on Aggro Text',46596), +(@ENTRY,0,1, 'Grrrr... fresh meat!',12,0,50,0,0,0, 'on Aggro Text',1870); + +-- 45. +-- Plainstrider SAI +SET @ENTRY := 2955; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,66060,0,0,0,0,0,1,0,0,0,0,0,0,0,"Plainstrider - On Aggro - Cast 'Sprint' (No Repeat)"); + +-- 46. +-- Prairie Stalker SAI +SET @ENTRY := 2959; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,75002,0,0,0,0,0,2,0,0,0,0,0,0,0,"Prairie Stalker - On Aggro - Cast 'Leaping Rush' (No Repeat)"); + +-- 47. +-- Prairie Wolf SAI +SET @ENTRY := 2958; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,1,1,0,5,0,60000,60000,120000,600000,4,1018,0,0,0,0,0,1,0,0,0,0,0,0,0,"Prairie Wolf - Out of Combat - Play Sound 1018"), +(@ENTRY,0,1,0,61,0,5,0,60000,60000,120000,600000,5,393,0,0,0,0,0,1,0,0,0,0,0,0,0,"Prairie Wolf - Out of Combat - Play Emote 393"), +(@ENTRY,0,2,0,9,0,100,0,0,5,45000,45000,11,5781,0,0,0,0,0,2,0,0,0,0,0,0,0,"Prairie Wolf - Within 0-5 Range - Cast 'Threatening Growl'"); + +-- 48. +-- Prairie Wolf Alpha SAI +SET @ENTRY := 2960; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,1,1,0,5,0,60000,60000,120000,600000,4,1018,0,0,0,0,0,1,0,0,0,0,0,0,0,"Prairie Wolf Alpha - Out of Combat - Play Sound 1018"), +(@ENTRY,0,1,0,61,0,5,0,60000,60000,120000,600000,5,393,0,0,0,0,0,1,0,0,0,0,0,0,0,"Prairie Wolf Alpha - Out of Combat - Play Emote 393"), +(@ENTRY,0,2,0,9,0,100,0,0,5,45000,45000,11,5781,0,0,0,0,0,2,0,0,0,0,0,0,0,"Prairie Wolf Alpha - Within 0-5 Range - Cast 'Threatening Growl'"); + +-- 49. +-- Sister Hatelash SAI +SET @ENTRY := 5785; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4700,11,81181,64,0,0,0,0,2,0,0,0,0,0,0,0,"Sister Hatelash - In Combat - Cast 'Air Blast'"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sister Hatelash - Between 0-15% Health - Flee For Assist (No Repeat)"), +(@ENTRY,0,2,0,0,0,100,0,4000,9000,30000,45000,11,32914,1,0,0,0,0,2,0,0,0,0,0,0,0,"Sister Hatelash - In Combat - Cast 'Wing Buffet'"), +(@ENTRY,0,3,0,0,0,100,0,12000,15000,45000,55000,11,81707,1,0,0,0,0,1,0,0,0,0,0,0,0,"Sister Hatelash - In Combat - Cast 'Windfury'"); + +-- 50. +-- Snagglespear SAI +SET @ENTRY := 5786; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,2000,4500,18000,25000,11,81705,0,0,0,0,0,2,0,0,0,0,0,0,0,"Snagglespear - In Combat - Cast 'Scalp Slash'"), +(@ENTRY,0,1,0,2,0,100,1,0,30,0,0,11,8599,0,0,0,0,0,1,0,0,0,0,0,0,0,"Snagglespear - Between 0-30% Health - Cast 'Enrage' (No Repeat)"), +(@ENTRY,0,2,0,2,0,100,1,0,30,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Snagglespear - Between 0-30% Health - Say Line 0 (No Repeat)"); +-- NPC talk text insert +SET @ENTRY := 5786; +DELETE FROM `creature_text` WHERE `entry`=@ENTRY; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES +(@ENTRY,0,0, '%s becomes enraged!',16,0,100,0,0,0, 'combat Enrage',10677); + +-- 51. +-- Swoop SAI +SET @ENTRY := 2970; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,9,0,100,0,0,5,15000,21000,11,5708,0,0,0,0,0,2,0,0,0,0,0,0,0,"Swoop - Within 0-5 Range - Cast 'Swoop'"); + +-- 52. +-- Taloned Swoop SAI +SET @ENTRY := 2971; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,9,0,100,0,0,5,15000,21000,11,5708,0,0,0,0,0,2,0,0,0,0,0,0,0,"Taloned Swoop - Within 0-5 Range - Cast 'Swoop'"), +(@ENTRY,0,1,0,0,0,100,0,5000,8000,21000,25000,11,81680,0,0,0,0,0,1,0,0,0,0,0,0,0,"Taloned Swoop - In Combat - Cast 'Howling Screech'"); + +-- 53. +-- The Rake SAI +SET @ENTRY := 5807; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,75002,0,0,0,0,0,2,0,0,0,0,0,0,0,"The Rake - On Aggro - Cast 'Leaping Rush' (No Repeat)"); + +-- 54. +-- Thontek Rumblehoof SAI +SET @ENTRY := 10600; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,5500,8000,18000,27000,11,16740,0,0,0,0,0,1,0,0,0,0,0,0,0,"Thontek Rumblehoof - In Combat - Cast 'War Stomp'"); + +-- 55. +-- Supervisor Fizsprocket SAI +SET @ENTRY := 3051; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,4,0,100,1,0,0,0,0,11,7973,0,0,0,0,0,1,0,0,0,0,0,0,0,"Supervisor Fizsprocket - On Aggro - Cast 'Summon Deviate Viper' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,2000,4500,21000,25000,11,81767,0,0,0,0,0,1,0,0,0,0,0,0,0,"Supervisor Fizsprocket - In Combat - Cast 'Lantern Blaze'"), +(@ENTRY,0,2,0,0,0,100,0,8000,9000,15000,22000,11,81754,1,0,0,0,0,2,0,0,0,0,0,0,0,"Supervisor Fizsprocket - In Combat - Cast 'Motivate'"), +(@ENTRY,0,3,0,0,0,100,0,4000,15000,12000,33000,11,81764,0,0,0,0,0,2,0,0,0,0,0,0,0,"Supervisor Fizsprocket - In Combat - Cast 'Throw Lantern'"); + +-- 56. +-- Thornguard SAI +SET @ENTRY := 43599; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,11,0,100,1,0,0,0,0,11,81653,0,0,0,0,0,1,0,0,0,0,0,0,0,"Thornguard - On Respawn - Cast 'Bristleback' (No Repeat)"), +(@ENTRY,0,1,0,0,0,100,0,2000,4500,12000,18000,11,15496,0,0,0,0,0,2,0,0,0,0,0,0,0,"Thornguard - In Combat - Cast 'Cleave'"); + +-- 57. +-- Thunder Bluff Brave SAI +SET @ENTRY := 37175; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,5000,8000,17000,25000,11,81500,0,0,0,0,0,1,0,0,0,0,0,0,0,"Thunder Bluff Brave - In Combat - Cast 'War Stomp'"), +(@ENTRY,0,1,0,0,0,100,0,2000,4500,12000,18000,11,81502,0,0,0,0,0,2,0,0,0,0,0,0,0,"Thunder Bluff Brave - In Combat - Cast 'Cleave'"); + +-- 58. +-- Venture Co. Laborer SAI +SET @ENTRY := 2976; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Venture Co. Laborer - Between 0-15% Health - Flee For Assist (No Repeat)"), +(@ENTRY,0,1,0,2,0,100,0,0,40,16000,18000,11,81772,0,0,0,0,0,1,0,0,0,0,0,0,0,"Venture Co. Laborer - Between 0-40% Health - Cast 'Overtime'"); + +-- 59. +-- Venture Co. Supervisor SAI +SET @ENTRY := 2979; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,8000,9000,37000,42000,11,81753,0,0,0,0,0,1,0,0,0,0,0,0,0,"Venture Co. Supervisor - In Combat - Cast 'Threatening Shout'"), +(@ENTRY,0,1,0,0,0,100,0,4000,4000,15000,25000,11,81754,1,0,0,0,0,2,0,0,0,0,0,0,0,"Venture Co. Supervisor - In Combat - Cast 'Motivate'"), +(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Venture Co. Supervisor - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- 60. +-- Venture Co. Taskmaster SAI +SET @ENTRY := 2977; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Venture Co. Taskmaster - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- 61. +-- Venture Co. Worker SAI +SET @ENTRY := 2978; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Venture Co. Worker - Between 0-15% Health - Flee For Assist (No Repeat)"), +(@ENTRY,0,1,0,4,0,100,1,0,0,0,0,11,53824,0,0,0,0,0,2,0,0,0,0,0,0,0,"Venture Co. Worker - On Aggro - Cast 'Throw' (No Repeat)"), +(@ENTRY,0,2,0,0,0,100,0,2000,4500,22000,25000,11,46202,0,0,0,0,0,2,0,0,0,0,0,0,0,"Venture Co. Worker - In Combat - Cast 'Pierce Armor'"); + +-- 62. +-- Windfury Harpy SAI +SET @ENTRY := 2962; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,1,0,100,0,500,1000,600000,600000,11,19514,0,0,0,0,0,1,0,0,0,0,0,0,0,"Windfury Harpy - Out of Combat - Cast 'Lightning Shield'"), +(@ENTRY,0,1,0,16,0,100,0,19514,1,15000,30000,11,19514,0,0,0,0,0,1,0,0,0,0,0,0,0,"Windfury Harpy - On Friendly Unit Missing Buff 'Lightning Shield' - Cast 'Lightning Shield'"), +(@ENTRY,0,2,0,2,0,100,0,0,40,14000,21000,11,81707,0,0,0,0,0,1,0,0,0,0,0,0,0,"Windfury Harpy - Between 0-40% Health - Cast 'Windfury'"); + +-- 63. +-- Windfury Matriarch SAI +SET @ENTRY := 2965; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,2,0,100,0,0,40,14000,21000,11,81707,0,0,0,0,0,1,0,0,0,0,0,0,0,"Windfury Matriarch - Between 0-40% Health - Cast 'Windfury'"); + +-- 64. +-- Windfury Sorceress SAI +SET @ENTRY := 2964; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4700,11,79884,64,0,0,0,0,2,0,0,0,0,0,0,0,"Windfury Sorceress - In Combat - Cast 'Lightning Bolt'"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Windfury Sorceress - Between 0-15% Health - Flee For Assist (No Repeat)"), +(@ENTRY,0,2,0,2,0,100,0,0,40,14000,21000,11,81707,0,0,0,0,0,1,0,0,0,0,0,0,0,"Windfury Sorceress - Between 0-40% Health - Cast 'Windfury'"), +(@ENTRY,0,3,0,0,0,100,0,8000,8000,15000,25000,11,79913,1,0,0,0,0,2,0,0,0,0,0,0,0,"Windfury Sorceress - In Combat - Cast 'Chain Lightning'"); + +-- 65. +-- Windfury Wind Witch SAI +SET @ENTRY := 2963; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,0,0,3400,4700,11,81181,64,0,0,0,0,2,0,0,0,0,0,0,0,"Windfury Wind Witch - In Combat - Cast 'Air Blast'"), +(@ENTRY,0,1,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Windfury Wind Witch - Between 0-15% Health - Flee For Assist (No Repeat)"), +(@ENTRY,0,2,0,2,0,100,0,0,40,14000,21000,11,81707,0,0,0,0,0,1,0,0,0,0,0,0,0,"Windfury Wind Witch - Between 0-40% Health - Cast 'Windfury'"); + +-- 66. +-- Wiry Swoop SAI +SET @ENTRY := 2969; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,5000,6000,22000,28000,11,81680,0,0,0,0,0,1,0,0,0,0,0,0,0,"Wiry Swoop - In Combat - Cast 'Howling Screech'"); + +-- 67. +-- Young Battleboar SAI +SET @ENTRY := 2966; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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 +(@ENTRY,0,0,0,0,0,100,0,2000,4500,12000,15000,11,79581,0,0,0,0,0,2,0,0,0,0,0,0,0,"Young Battleboar - In Combat - Cast 'Angry Snort'"); |