diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_03_26_00_world.sql | 145 |
1 files changed, 145 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_26_00_world.sql b/sql/updates/world/master/2017_03_26_00_world.sql new file mode 100644 index 00000000000..2c25bc52a47 --- /dev/null +++ b/sql/updates/world/master/2017_03_26_00_world.sql @@ -0,0 +1,145 @@ +-- Glintrok Greenhorn +SET @ENTRY := 61247; +SET @ENTRYTOTEM := 100099; +SET @TOTEMSPELL := 196942; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +UPDATE `creature_template` SET `AIName`='0' WHERE `entry`=@ENTRYTOTEM; +UPDATE `creature_template` SET `spell1`=@TOTEMSPELL WHERE `entry`=@ENTRYTOTEM; +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,25000,37000,11,202318,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Hexaustion'); + +-- Glintrok Hexxer +SET @ENTRY := 61216; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,12000,15000,11,118903,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Hex of Lethargy'); + +-- Glintrok Hexxer +SET @ENTRY := 61340; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,12000,15000,11,118903,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Hex of Lethargy'); + +-- Glintrok Ironhide +SET @ENTRY := 61337; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,22000,25000,11,118958,2,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Iron Protector at 40% HP'); + +-- Glintrok Ironhide +SET @ENTRY := 61242; +SET @ENTRYTOTEM := 100099; +SET @TOTEMSPELL := 196942; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +UPDATE `creature_template` SET `AIName`='0' WHERE `entry`=@ENTRYTOTEM; +UPDATE `creature_template` SET `spell1`=@TOTEMSPELL WHERE `entry`=@ENTRYTOTEM; +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,25000,37000,11,202318,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Hexaustion'), +(@ENTRY,0,1,0,2,0,100,0,0,40,22000,25000,11,118958,2,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Iron Protector at 40% HP'); + +-- Glintrok Oracle +SET @ENTRY := 61339; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,14,0,100,0,30000,40,15000,18000,11,118940,0,0,0,0,0,7,0,0,0,0,0,0,0,'Cast Cleansing Flame on Friendlies'); + +-- Glintrok Oracle +SET @ENTRY := 61239; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,14,0,100,0,30000,40,15000,18000,11,118940,0,0,0,0,0,7,0,0,0,0,0,0,0,'Cast Cleansing Flame on Friendlies'); + +-- Glintrok Pillager +SET @ENTRY := 61246; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,6,0,100,1,0,0,0,0,11,84369,3,0,0,0,0,0,1,0,0,0,0,0,0,'Cast Summon Gold Pile on Death'); + +-- Glintrok Skulker +SET @ENTRY := 61338; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,118969,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Stealth on Spawn'), +(@ENTRY,0,1,0,7,0,100,1,0,0,0,0,11,118969,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Stealth on Evade'), +(@ENTRY,0,2,0,0,0,100,0,5000,8000,12000,15000,11,118963,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Shank'); + +-- Glintrok Skulker +SET @ENTRY := 61240; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,118969,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Stealth on Spawn'), +(@ENTRY,0,1,0,7,0,100,1,0,0,0,0,11,118969,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Stealth on Evade'), +(@ENTRY,0,2,0,0,0,100,0,5000,8000,12000,15000,11,118963,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Shank'); + +-- Gurthan Swiftblade +SET @ENTRY := 65402; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,128239,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Blade Rush on Aggro'), +(@ENTRY,0,1,0,0,0,100,0,5000,8000,12000,15000,11,128238,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Swift Strike'); + +-- Harthak Flameseeker +SET @ENTRY := 61392; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,121165,64,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Fireball'), +(@ENTRY,0,1,0,0,0,100,0,10000,10000,16000,22000,11,121182,2,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Molten Barrage'), +(@ENTRY,0,2,0,0,0,100,0,5000,8000,12000,15000,11,121174,2,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Erupting Flame'); + +-- Harthak Stormcaller +SET @ENTRY := 61946; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,121601,64,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Lightning Bolt'), +(@ENTRY,0,1,0,9,0,100,0,0,20,15000,25000,11,123648,2,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Shock on Close'), +(@ENTRY,0,2,0,0,0,100,0,5000,8000,15000,18000,11,120562,0,0,0,0,0,4,0,0,0,0,0,0,0,'Cast Lightning Storm'); + +-- Kargesh Grunt +SET @ENTRY := 61450; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,12000,15000,11,120160,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Conflagrate'); + +-- Kargesh Grunt +SET @ENTRY := 61551; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,12000,15000,11,120160,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Conflagrate'); + +-- Kargesh Highguard +SET @ENTRY := 61389; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,12000,15000,11,121185,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Crunch Armor'), +(@ENTRY,0,1,0,9,0,100,0,5,45,15000,25000,11,121173,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Hurl Shield on Close'); + +-- Kargesh Ribcrusher +SET @ENTRY := 61947; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,25000,11,123652,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Whirlwind on Close'), +(@ENTRY,0,1,0,0,0,100,0,5000,8000,12000,15000,11,123649,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Mace Smash'); + +-- Mu'Shiba +SET @ENTRY := 61453; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_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,12000,15000,11,119948,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Ravage'); |