diff options
| -rw-r--r-- | sql/updates/world/2015_07_19_01_world.sql | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_19_01_world.sql b/sql/updates/world/2015_07_19_01_world.sql new file mode 100644 index 00000000000..fc14961d089 --- /dev/null +++ b/sql/updates/world/2015_07_19_01_world.sql @@ -0,0 +1,49 @@ +-- Missing Emotes for Crystalline Ice Giant in Dragonblight +-- Crystalline Ice Giant SAI 1 +SET @GUID := -112879; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=26291; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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 +(@GUID,0,0,0,1,0,100,0,3000,5000,3000,5000,11,50298,0,0,0,0,0,19,26358,200,0,0,0,0,0,"Crystalline Ice Giant - Out of Combat - Cast 'Boulder Miss'"); + +-- Crystalline Ice Giant SAI 2 +SET @GUID := -112860; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=26291; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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 +(@GUID,0,0,0,1,0,100,0,3000,5000,3000,5000,11,50298,0,0,0,0,0,19,26358,200,0,0,0,0,0,"Crystalline Ice Giant - Out of Combat - Cast 'Boulder Miss'"); + +-- Crystalline Ice Giant SAI 3 +SET @GUID := -112853; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=26291; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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 +(@GUID,0,0,0,1,0,100,0,3000,5000,3000,5000,11,50298,0,0,0,0,0,19,26358,200,0,0,0,0,0,"Crystalline Ice Giant - Out of Combat - Cast 'Boulder Miss'"); + +-- Crystalline Ice Giant SAI 4 +SET @GUID := -112858; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=26291; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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 +(@GUID,0,0,0,1,0,100,0,3000,5000,3000,5000,11,50298,0,0,0,0,0,19,26358,200,0,0,0,0,0,"Crystalline Ice Giant - Out of Combat - Cast 'Boulder Miss'"); + +-- Crystalline Ice Giant SAI 5 +SET @GUID := -112874; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=26291; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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 +(@GUID,0,0,0,1,0,100,0,3000,5000,3000,5000,11,50298,0,0,0,0,0,19,26358,200,0,0,0,0,0,"Crystalline Ice Giant - Out of Combat - Cast 'Boulder Miss'"); + +-- Crystalline Ice Giant SAI 6 +SET @GUID := -112848; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=26291; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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 +(@GUID,0,0,0,1,0,100,0,3000,5000,3000,5000,11,50298,0,0,0,0,0,19,26358,200,0,0,0,0,0,"Crystalline Ice Giant - Out of Combat - Cast 'Boulder Miss'"); + +-- Crystalline Ice Giant SAI 7 +SET @GUID := -112854; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=26291; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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 +(@GUID,0,0,0,1,0,100,0,3000,5000,3000,5000,11,50298,0,0,0,0,0,19,26358,200,0,0,0,0,0,"Crystalline Ice Giant - Out of Combat - Cast 'Boulder Miss'"); |