From ab7c789678877515503771badf669e6aaba0c5ae Mon Sep 17 00:00:00 2001 From: Malcrom Date: Sun, 23 Dec 2012 22:49:38 -0330 Subject: DB/Creature: Malygos 25 mode fix. Also fix file extention on previous push. Closes #8658 --- sql/updates/world/2012_12_24_03_sai | 6 ------ sql/updates/world/2012_12_24_03_sai.sql | 6 ++++++ sql/updates/world/2012_12_24_04_creature.sql | 3 +++ 3 files changed, 9 insertions(+), 6 deletions(-) delete mode 100644 sql/updates/world/2012_12_24_03_sai create mode 100644 sql/updates/world/2012_12_24_03_sai.sql create mode 100644 sql/updates/world/2012_12_24_04_creature.sql (limited to 'sql') diff --git a/sql/updates/world/2012_12_24_03_sai b/sql/updates/world/2012_12_24_03_sai deleted file mode 100644 index f89f3c968aa..00000000000 --- a/sql/updates/world/2012_12_24_03_sai +++ /dev/null @@ -1,6 +0,0 @@ --- SAI for Val'kyr Taskmistress -SET @ENTRY := 31396; -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,5000,10000,11,57547,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Val''kyr Taskmistress - Combat - Cast Touch of the Val''kyr'); diff --git a/sql/updates/world/2012_12_24_03_sai.sql b/sql/updates/world/2012_12_24_03_sai.sql new file mode 100644 index 00000000000..f89f3c968aa --- /dev/null +++ b/sql/updates/world/2012_12_24_03_sai.sql @@ -0,0 +1,6 @@ +-- SAI for Val'kyr Taskmistress +SET @ENTRY := 31396; +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,5000,10000,11,57547,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Val''kyr Taskmistress - Combat - Cast Touch of the Val''kyr'); diff --git a/sql/updates/world/2012_12_24_04_creature.sql b/sql/updates/world/2012_12_24_04_creature.sql new file mode 100644 index 00000000000..42f69d97a9e --- /dev/null +++ b/sql/updates/world/2012_12_24_04_creature.sql @@ -0,0 +1,3 @@ +-- Malygos 25 mode +UPDATE `creature_template` SET `difficulty_entry_1`=31734 WHERE `entry`=28859; +UPDATE `creature_template` SET `speed_walk`=4, `speed_run`=2.85714, `unit_class`=2, `InhabitType`=5, `flags_extra`=`flags_extra`|1 WHERE `entry`=31734; -- cgit v1.2.3