diff options
| -rw-r--r-- | sql/updates/world/2013_11_27_07_world_sai.sql | 267 |
1 files changed, 267 insertions, 0 deletions
diff --git a/sql/updates/world/2013_11_27_07_world_sai.sql b/sql/updates/world/2013_11_27_07_world_sai.sql new file mode 100644 index 00000000000..1073423e444 --- /dev/null +++ b/sql/updates/world/2013_11_27_07_world_sai.sql @@ -0,0 +1,267 @@ +-- Stormforged Amplifier SAI +SET @ENTRY := 30591; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stormforged Amplifier - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,9532,0,0,0,0,0,2,0,0,0,0,0,0,0,"Stormforged Amplifier - On Aggro - Cast 9532"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stormforged Amplifier - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,40,3400,4800,11,9532,0,0,0,0,0,2,0,0,0,0,0,0,0,"Stormforged Amplifier - Between 0-40 Range - Cast 9532 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stormforged Amplifier - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stormforged Amplifier - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,35,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stormforged Amplifier - Between 35-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stormforged Amplifier - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stormforged Amplifier - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Stormforged Amplifier - Between 15-100% Mana - Decrement Event Phase"); + +-- Halefnir the Windborn SAI +SET @ENTRY := 30376; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Halefnir the Windborn - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,20831,0,0,0,0,0,2,0,0,0,0,0,0,0,"Halefnir the Windborn - On Aggro - Cast 20831"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Halefnir the Windborn - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,30,6000,6000,11,20831,0,0,0,0,0,2,0,0,0,0,0,0,0,"Halefnir the Windborn - Between 0-30 Range - Cast 20831 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Halefnir the Windborn - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,1,0,7,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Halefnir the Windborn - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Halefnir the Windborn - Between 25-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Halefnir the Windborn - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Halefnir the Windborn - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Halefnir the Windborn - Between 15-100% Mana - Decrement Event Phase"); + +-- Iron Dwarf Magus SAI +SET @ENTRY := 29979; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Iron Dwarf Magus - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,12058,0,0,0,0,0,2,0,0,0,0,0,0,0,"Iron Dwarf Magus - On Aggro - Cast 12058"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Iron Dwarf Magus - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,30,3400,4800,11,12058,0,0,0,0,0,2,0,0,0,0,0,0,0,"Iron Dwarf Magus - Between 0-30 Range - Cast 12058 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Iron Dwarf Magus - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Iron Dwarf Magus - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Iron Dwarf Magus - Between 25-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Iron Dwarf Magus - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Iron Dwarf Magus - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Iron Dwarf Magus - Between 15-100% Mana - Decrement Event Phase"); + +-- Gnarlhide SAI +SET @ENTRY := 30003; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gnarlhide - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,38391,0,0,0,0,0,2,0,0,0,0,0,0,0,"Gnarlhide - On Aggro - Cast 38391"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gnarlhide - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,30,3400,4800,11,38391,0,0,0,0,0,2,0,0,0,0,0,0,0,"Gnarlhide - Between 0-30 Range - Cast 38391 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gnarlhide - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gnarlhide - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gnarlhide - Between 25-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gnarlhide - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Gnarlhide - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Gnarlhide - Between 15-100% Mana - Decrement Event Phase"), +(@ENTRY,0,10,0,0,0,100,0,3000,6000,20000,25000,11,60290,1,0,0,0,0,2,0,0,0,0,0,0,0,"Gnarlhide - In Combat - Cast 60290"), +(@ENTRY,0,11,0,0,0,100,0,9000,12000,19000,24000,11,35250,1,0,0,0,0,1,0,0,0,0,0,0,0,"Gnarlhide - In Combat - Cast 35250"), +(@ENTRY,0,12,0,0,0,100,0,5000,8000,9000,12000,11,20832,0,0,0,0,0,5,0,0,0,0,0,0,0,"Gnarlhide - In Combat - Cast 20832"); + +-- Mildred the Cruel SAI +SET @ENTRY := 29885; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mildred the Cruel - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,15587,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mildred the Cruel - On Aggro - Cast 15587"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mildred the Cruel - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,30,3400,4800,11,15587,0,0,0,0,0,2,0,0,0,0,0,0,0,"Mildred the Cruel - Between 0-30 Range - Cast 15587 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mildred the Cruel - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mildred the Cruel - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mildred the Cruel - Between 25-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mildred the Cruel - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mildred the Cruel - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Mildred the Cruel - Between 15-100% Mana - Decrement Event Phase"), +(@ENTRY,0,10,0,0,0,100,0,7000,11000,12000,15000,11,14032,0,0,0,0,0,5,0,0,0,0,0,0,0,"Mildred the Cruel - In Combat - Cast 14032"), +(@ENTRY,0,11,0,2,0,100,0,0,15,10000,15000,11,47697,1,0,0,0,0,5,0,0,0,0,0,0,0,"Mildred the Cruel - Between 0-15% Health - Cast 47697"); + +-- Anub'ar Necromancer SAI +SET @ENTRY := 29064; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,7,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Out Of Combat - Disallow Combat Movement (Dungeon Only)"), +(@ENTRY,0,1,2,4,0,100,7,0,0,0,0,11,53333,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anub'ar Necromancer - On Aggro - Cast 53333 (Dungeon Only)"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - On Aggro - Increment Event Phase (Dungeon Only)"), +(@ENTRY,0,3,0,9,1,100,6,0,40,4000,6000,11,53333,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 0-40 Range - Cast 53333 (Dungeon Only) (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,7,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 0-7% Mana - Allow Combat Movement (Dungeon Only) (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 0-7% Mana - Increment Event Phase (Dungeon Only) (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,7,35,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 35-80 Range - Allow Combat Movement (Dungeon Only) (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,7,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 5-15 Range - Disallow Combat Movement (Dungeon Only) (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,7,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 0-5 Range - Allow Combat Movement (Dungeon Only) (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,6,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 15-100% Mana - Decrement Event Phase (Dungeon Only)"), +(@ENTRY,0,10,0,0,0,100,6,14000,17000,23000,27000,11,53334,1,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - In Combat - Cast 53334 (Dungeon Only)"); + +-- Anub'ar Necromancer SAI +SET @ENTRY := 29098; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,7,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Out Of Combat - Disallow Combat Movement (Dungeon Only)"), +(@ENTRY,0,1,2,4,0,100,7,0,0,0,0,11,53333,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anub'ar Necromancer - On Aggro - Cast 53333 (Dungeon Only)"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - On Aggro - Increment Event Phase (Dungeon Only)"), +(@ENTRY,0,3,0,9,1,100,6,0,40,4000,6000,11,53333,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 0-40 Range - Cast 53333 (Dungeon Only) (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,7,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 0-7% Mana - Allow Combat Movement (Dungeon Only) (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 0-7% Mana - Increment Event Phase (Dungeon Only) (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,7,35,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 35-80 Range - Allow Combat Movement (Dungeon Only) (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,7,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 5-15 Range - Disallow Combat Movement (Dungeon Only) (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,7,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 0-5 Range - Allow Combat Movement (Dungeon Only) (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,6,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - Between 15-100% Mana - Decrement Event Phase (Dungeon Only)"), +(@ENTRY,0,10,0,0,0,100,6,14000,17000,23000,27000,11,53334,1,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Necromancer - In Combat - Cast 53334 (Dungeon Only)"); + +-- Hath'ar Broodmaster SAI +SET @ENTRY := 28412; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hath'ar Broodmaster - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,9613,0,0,0,0,0,2,0,0,0,0,0,0,0,"Hath'ar Broodmaster - On Aggro - Cast 9613"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hath'ar Broodmaster - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,40,2400,3800,11,9613,0,0,0,0,0,2,0,0,0,0,0,0,0,"Hath'ar Broodmaster - Between 0-40 Range - Cast 9613 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,15,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hath'ar Broodmaster - Between 0-15% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hath'ar Broodmaster - Between 0-15% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,35,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hath'ar Broodmaster - Between 35-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hath'ar Broodmaster - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Hath'ar Broodmaster - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,30,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Hath'ar Broodmaster - Between 30-100% Mana - Decrement Event Phase"), +(@ENTRY,0,10,0,0,0,100,0,3000,5000,15000,25000,11,54453,1,0,0,0,0,2,0,0,0,0,0,0,0,"Hath'ar Broodmaster - In Combat - Cast 54453"); + +-- Crystalline Frayer SAI +SET @ENTRY := 26793; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,7,0,0,0,0,11,48058,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crystalline Frayer - On Aggro - Cast 48058 (Dungeon Only)"), +(@ENTRY,0,1,0,0,0,100,6,3000,4000,9500,15000,11,48053,0,0,0,0,0,2,0,0,0,0,0,0,0,"Crystalline Frayer - In Combat - Cast 48053 (Dungeon Only)"), +(@ENTRY,0,2,3,2,0,100,2,0,100,3800,5000,11,52067,32,0,0,0,0,1,0,0,0,0,0,0,0,"Crystalline Frayer - Between 0-100% Health - Cast 52067 (Normal Dungeon)"), +(@ENTRY,0,3,0,61,0,100,0,0,0,0,0,11,57056,32,0,0,0,0,1,0,0,0,0,0,0,0,"Crystalline Frayer - Between 0-100% Health - Cast 57056 (Heroic Dungeon)"), +(@ENTRY,0,4,5,2,0,100,7,1,35,0,0,11,48082,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crystalline Frayer - Between 1-35% Health - Cast 48082 (Dungeon Only)"), +(@ENTRY,0,5,6,61,0,100,0,0,0,0,0,18,33554752,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crystalline Frayer - Between 1-35% Health - Set Immune To Players & Not Selectable Flag (Dungeon Only)"), +(@ENTRY,0,6,0,61,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crystalline Frayer - Between 1-35% Health - Set Event Phase 1 (Dungeon Only)"), +(@ENTRY,0,7,8,2,0,100,7,85,100,0,0,24,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crystalline Frayer - Between 85-100% Health - Evade (Dungeon Only)"), +(@ENTRY,0,8,9,61,0,100,0,0,0,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crystalline Frayer - Between 85-100% Health - Set Event Phase 0 (Dungeon Only)"), +(@ENTRY,0,9,0,61,0,100,0,0,0,0,0,19,33554752,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crystalline Frayer - Between 85-100% Health - Remove Immune To Players & Not Selectable Flag (Dungeon Only)"); + +-- Tivax the Breaker SAI +SET @ENTRY := 26770; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tivax the Breaker - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,13878,0,0,0,0,0,2,0,0,0,0,0,0,0,"Tivax the Breaker - On Aggro - Cast 13878"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tivax the Breaker - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,30,3400,4800,11,13878,0,0,0,0,0,2,0,0,0,0,0,0,0,"Tivax the Breaker - Between 0-30 Range - Cast 13878 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tivax the Breaker - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tivax the Breaker - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tivax the Breaker - Between 25-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tivax the Breaker - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Tivax the Breaker - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Tivax the Breaker - Between 15-100% Mana - Decrement Event Phase"), +(@ENTRY,0,10,0,0,0,100,0,5000,7000,9000,12000,11,20795,0,0,0,0,0,5,0,0,0,0,0,0,0,"Tivax the Breaker - In Combat - Cast 20795"); + +-- Anok'ra the Manipulator SAI +SET @ENTRY := 26769; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anok'ra the Manipulator - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,13860,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anok'ra the Manipulator - On Aggro - Cast 13860"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anok'ra the Manipulator - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,30,3400,4800,11,13860,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anok'ra the Manipulator - Between 0-30 Range - Cast 13860 (Phase 1)"), +(@ENTRY,0,4,0,9,1,100,0,0,20,8000,11000,11,16568,1,0,0,0,0,5,0,0,0,0,0,0,0,"Anok'ra the Manipulator - Between 0-20 Range - Cast 16568 (Phase 1)"), +(@ENTRY,0,5,6,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anok'ra the Manipulator - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,6,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anok'ra the Manipulator - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anok'ra the Manipulator - Between 25-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anok'ra the Manipulator - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anok'ra the Manipulator - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,10,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Anok'ra the Manipulator - Between 15-100% Mana - Decrement Event Phase"), +(@ENTRY,0,11,0,0,0,100,0,6000,9000,17000,20000,11,51676,1,0,0,0,0,5,0,0,0,0,0,0,0,"Anok'ra the Manipulator - In Combat - Cast 51676"); + +-- Anub'ar Blightbeast SAI +SET @ENTRY := 26607; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Blightbeast - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,21971,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anub'ar Blightbeast - On Aggro - Cast 21971"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Blightbeast - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,30,3400,4800,11,21971,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anub'ar Blightbeast - Between 0-30 Range - Cast 21971 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Blightbeast - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Blightbeast - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Blightbeast - Between 25-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Blightbeast - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Blightbeast - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Blightbeast - Between 15-100% Mana - Decrement Event Phase"), +(@ENTRY,0,10,0,0,0,100,0,9000,12000,20000,24000,11,47443,0,0,0,0,0,5,0,0,0,0,0,0,0,"Anub'ar Blightbeast - In Combat - Cast 47443"); + +-- Anub'ar Dreadweaver SAI +SET @ENTRY := 26413; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,9613,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - On Aggro - Cast 9613"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,40,3400,4800,11,9613,0,0,0,0,0,2,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - Between 0-40 Range - Cast 9613 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,35,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - Between 35-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - Between 15-100% Mana - Decrement Event Phase"), +(@ENTRY,0,10,0,0,0,100,0,6000,9000,9000,14000,11,32063,33,0,0,0,0,5,0,0,0,0,0,0,0,"Anub'ar Dreadweaver - In Combat - Cast 32063"); + +-- Indu'le Mystic SAI +SET @ENTRY := 26336; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Indu'le Mystic - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,51787,0,0,0,0,0,2,0,0,0,0,0,0,0,"Indu'le Mystic - On Aggro - Cast 51787"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Indu'le Mystic - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,30,7000,9000,11,51787,0,0,0,0,0,2,0,0,0,0,0,0,0,"Indu'le Mystic - Between 0-30 Range - Cast 51787 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Indu'le Mystic - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Indu'le Mystic - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Indu'le Mystic - Between 25-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Indu'le Mystic - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Indu'le Mystic - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Indu'le Mystic - Between 15-100% Mana - Decrement Event Phase"); + +-- Icestorm SAI +SET @ENTRY := 26287; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@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,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Icestorm - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,2,4,0,100,1,0,0,0,0,11,47425,0,0,0,0,0,2,0,0,0,0,0,0,0,"Icestorm - On Aggro - Cast 47425"), +(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Icestorm - On Aggro - Increment Event Phase"), +(@ENTRY,0,3,0,9,1,100,0,0,35,4000,6000,11,47425,0,0,0,0,0,2,0,0,0,0,0,0,0,"Icestorm - Between 0-35 Range - Cast 47425 (Phase 1)"), +(@ENTRY,0,4,5,3,1,100,1,0,7,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Icestorm - Between 0-7% Mana - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Icestorm - Between 0-7% Mana - Increment Event Phase (Phase 1)"), +(@ENTRY,0,6,0,9,1,100,1,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Icestorm - Between 25-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,9,1,100,1,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Icestorm - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,8,0,9,1,100,1,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Icestorm - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,0,3,0,100,0,15,100,100,100,23,0,1,0,0,0,0,1,0,0,0,0,0,0,0,"Icestorm - Between 15-100% Mana - Decrement Event Phase"); |