diff options
| -rw-r--r-- | sql/updates/world/master/2020_09_06_03_world_2017_09_19_10_world_335.sql | 70 |
1 files changed, 70 insertions, 0 deletions
diff --git a/sql/updates/world/master/2020_09_06_03_world_2017_09_19_10_world_335.sql b/sql/updates/world/master/2020_09_06_03_world_2017_09_19_10_world_335.sql new file mode 100644 index 00000000000..74ff47040ca --- /dev/null +++ b/sql/updates/world/master/2020_09_06_03_world_2017_09_19_10_world_335.sql @@ -0,0 +1,70 @@ +-- Murderous Blisterpaw +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=8208; +DELETE FROM `smart_scripts` WHERE `entryorguid`=8208 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 +(8208,0,0,0,0,0,100,0,8000,12000,15000,20000,11,3391,0,0,0,0,0,2,0,0,0,0,0,0,0,"Murderous Blisterpaw - In Combat - Cast Thrash"), +(8208,0,1,0,0,0,100,0,12000,18000,15000,22000,11,13445,0,0,0,0,0,2,0,0,0,0,0,0,0,"Murderous Blisterpaw - In Combat - Cast Rend"); + +-- Scorpid Hunter +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=5422; +DELETE FROM `smart_scripts` WHERE `entryorguid`=5422 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 +(5422,0,0,0,0,0,100,0,6000,12000,9000,15000,11,7992,32,0,0,0,0,2,0,0,0,0,0,0,0,"Scorpid Hunter - In Combat - Cast Slowing Poison"); + +-- Searing Roc +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=5430; +DELETE FROM `smart_scripts` WHERE `entryorguid`=5430 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 +(5430,0,0,0,0,0,100,0,6000,8000,18000,20000,11,16843,0,0,0,0,0,2,0,0,0,0,0,0,0,"Searing Roc - In Combat - Cast Crimson Fury"); + +-- Dune Smasher +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=5469; +DELETE FROM `smart_scripts` WHERE `entryorguid`=5469 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 +(5469,0,0,0,0,0,100,0,9000,19000,24000,36000,11,9791,0,0,0,0,0,2,0,0,0,0,0,0,0,"Dune Smasher - In Combat - Cast Head Crack"); + +-- Jin'Zallah the Sandbringer +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=8200; +DELETE FROM `smart_scripts` WHERE `entryorguid`=8200 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 +(8200,0,0,0,0,0,100,0,0,0,3400,4800,11,79884,64,0,0,0,0,2,0,0,0,0,0,0,0,"Jin\'Zallah the Sandbringer - In Combat - Cast Lightning Bolt"), +(8200,0,1,0,9,0,100,0,0,8,13600,14500,11,7272,1,0,0,0,0,1,0,0,0,0,0,0,0,"Jin\'Zallah the Sandbringer - Within 0-8 Range - Cast Dust Cloud"), +(8200,0,2,0,2,0,100,1,0,55,0,0,11,10132,1,0,0,0,0,1,0,0,0,0,0,0,0,"Jin\'Zallah the Sandbringer - Between 0-55% Health - Cast Sand Storms (No Repeat)"); + +-- Sand Storm (7226) +DELETE FROM `creature_template_addon` WHERE `entry`=7226; +INSERT INTO `creature_template_addon` (`entry`,`bytes2`,`auras`) VALUES +(7226, 0, "10092"); + +UPDATE `creature_template` SET `flags_extra`=128, `AIName`='SmartAI', `ScriptName`='' WHERE `entry`=7226; +DELETE FROM `smart_scripts` WHERE `entryorguid`=7226 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 +(7226, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 89, 12, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Sand Storm - just summoned - random movement'); + +-- Caliph Scorpidsting +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=7847; +DELETE FROM `smart_scripts` WHERE `entryorguid`=7847 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 +(7847,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,"Caliph Scorpidsting - Between 0-15% Health - Flee For Assist (No Repeat)"); + +-- Tick +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=8198; +DELETE FROM `smart_scripts` WHERE `entryorguid`=8198 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 +(8198,0,0,0,0,0,100,0,8000,16000,12000,18000,11,21073,0,0,0,0,0,2,0,0,0,0,0,0,0,"Tick - In Combat - Cast Arcane Explosion"), +(8198,0,1,0,0,0,100,0,12000,16000,14000,18000,11,20717,0,0,0,0,0,2,0,0,0,0,0,0,0,"Tick - In Combat - Cast Sand Breath"); + +-- Chronalis +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=8197; +DELETE FROM `smart_scripts` WHERE `entryorguid`=8197 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 +(8197,0,0,0,9,0,100,0,0,5,9000,16000,11,18144,0,0,0,0,0,2,0,0,0,0,0,0,0,"Chronalis - Within 0-5 Range - Cast Swoop"), +(8197,0,1,0,0,0,100,0,12000,16000,14000,18000,11,20717,0,0,0,0,0,2,0,0,0,0,0,0,0,"Chronalis - In Combat - Cast Sand Breath"); + +-- Occulus +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=8196; +DELETE FROM `smart_scripts` WHERE `entryorguid`=8196 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 +(8196,0,0,0,9,0,100,0,0,5,9000,14000,11,18144,0,0,0,0,0,2,0,0,0,0,0,0,0,"Occulus - Within 0-5 Range - Cast Swoop"), +(8196,0,1,0,0,0,100,0,12000,16000,14000,18000,11,20717,0,0,0,0,0,2,0,0,0,0,0,0,0,"Occulus - In Combat - Cast Sand Breath"), +(8196,0,2,0,0,0,100,0,9000,14000,11000,15000,11,10833,0,0,0,0,0,5,0,0,0,0,0,0,0,"Occulus - In Combat - Cast Arcane Blast"); |