diff options
| -rw-r--r-- | sql/updates/world/2013_11_27_03_world_sai.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2013_11_27_04_world_sai.sql | 25 |
2 files changed, 27 insertions, 2 deletions
diff --git a/sql/updates/world/2013_11_27_03_world_sai.sql b/sql/updates/world/2013_11_27_03_world_sai.sql index e5fe68df7ba..ca560cf8132 100644 --- a/sql/updates/world/2013_11_27_03_world_sai.sql +++ b/sql/updates/world/2013_11_27_03_world_sai.sql @@ -13,8 +13,8 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type (@ENTRY,0,6,7,9,1,100,0,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 25-80 Range - Allow Combat Movement (Phase 1)"), (@ENTRY,0,7,0,61,1,100,0,0,0,0,0,20,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 25-80 Range - Start Auto Attack (Phase 1)"), (@ENTRY,0,8,9,9,1,100,0,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-5 Range - Allow Combat Movement (Phase 1)"), -(@ENTRY,0,9,10,61,1,100,0,0,0,0,0,20,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-5 Range - Set Sheath Melee (Phase 1)"), -(@ENTRY,0,10,0,61,1,100,0,0,0,0,0,40,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-5 Range - Start Auto Attack (Phase 1)"), +(@ENTRY,0,9,10,61,1,100,0,0,0,0,0,40,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-5 Range - Set Sheath Melee (Phase 1)"), +(@ENTRY,0,10,0,61,1,100,0,0,0,0,0,20,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-5 Range - Start Auto Attack (Phase 1)"), (@ENTRY,0,11,12,9,1,100,0,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), (@ENTRY,0,12,0,61,1,100,0,0,0,0,0,20,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 5-15 Range - Stop Auto Attack (Phase 1)"), (@ENTRY,0,13,0,9,0,100,0,0,20,12000,15000,11,6533,1,0,0,0,0,2,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-20 Range - Cast 6533"), diff --git a/sql/updates/world/2013_11_27_04_world_sai.sql b/sql/updates/world/2013_11_27_04_world_sai.sql new file mode 100644 index 00000000000..9d8e6c19fd3 --- /dev/null +++ b/sql/updates/world/2013_11_27_04_world_sai.sql @@ -0,0 +1,25 @@ +-- Illiyana Moonblaze SAI +SET @ENTRY := 14753; +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,1,1,0,100,1,0,0,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Out Of Combat - Disallow Combat Movement"), +(@ENTRY,0,1,0,61,0,100,0,0,0,0,0,20,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Out Of Combat - Stop Auto Attack"), +(@ENTRY,0,2,3,4,0,100,1,0,0,0,0,11,22907,0,0,0,0,0,2,0,0,0,0,0,0,0,"Illiyana Moonblaze - On Aggro - Cast 22907"), +(@ENTRY,0,3,0,61,0,100,0,0,0,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - On Aggro - Increment Event Phase"), +(@ENTRY,0,4,5,9,1,100,0,5,30,2300,3900,11,22907,0,0,0,0,0,2,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 5-30 Range - Cast 22907 (Phase 1)"), +(@ENTRY,0,5,0,61,1,100,0,0,0,0,0,40,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 5-30 Range - Set Sheath Ranged (Phase 1)"), +(@ENTRY,0,6,7,9,1,100,0,25,80,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 25-80 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,7,0,61,1,100,0,0,0,0,0,20,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 25-80 Range - Start Auto Attack (Phase 1)"), +(@ENTRY,0,8,9,9,1,100,0,0,5,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-5 Range - Allow Combat Movement (Phase 1)"), +(@ENTRY,0,9,10,61,1,100,0,0,0,0,0,40,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-5 Range - Set Sheath Melee (Phase 1)"), +(@ENTRY,0,10,0,61,1,100,0,0,0,0,0,20,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-5 Range - Start Auto Attack (Phase 1)"), +(@ENTRY,0,11,12,9,1,100,0,5,15,0,0,21,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 5-15 Range - Disallow Combat Movement (Phase 1)"), +(@ENTRY,0,12,0,61,1,100,0,0,0,0,0,20,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 5-15 Range - Stop Auto Attack (Phase 1)"), +(@ENTRY,0,13,0,9,0,100,0,0,20,12000,15000,11,6533,1,0,0,0,0,2,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-20 Range - Cast 6533"), +(@ENTRY,0,14,0,2,0,100,0,0,30,40000,40000,11,3019,1,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-30% Health - Cast 3019"), +(@ENTRY,0,15,16,2,0,100,1,0,15,0,0,23,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-15% Health - Increment Event Phase"), +(@ENTRY,0,16,17,61,0,100,0,0,0,0,0,21,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-15% Health - Allow Combat Movement"), +(@ENTRY,0,17,0,61,0,100,0,0,0,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,0,0,"Illiyana Moonblaze - Between 0-15% Health - Flee For Assist"), +(@ENTRY,0,18,0,7,0,100,1,0,0,0,0,40,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Illiyana Moonblaze - On Evade - Set Sheath Melee"); |