diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-09-01 18:57:43 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-18 18:01:40 +0100 |
| commit | b47b9a2913a04048fae90eaacf4928398e4b92ea (patch) | |
| tree | 045df2786fef94c6b6d1615f8f778b00d6a50248 | |
| parent | 39a7a7149428a177cbcf8fec6089a7ed4b18708e (diff) | |
DB/Creature: More fixes for that poor Cabal Abjurist! Plus bonus content for Bleeding Hollow Darkcaster.
I feel like a DB dev now.
(cherry picked from commit f5cbc17387dcd8ac5d05436d3382053e8a0ab55f)
| -rw-r--r-- | sql/updates/world/master/2017_02_18_34_world_2016_09_01_01_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_18_34_world_2016_09_01_01_world.sql b/sql/updates/world/master/2017_02_18_34_world_2016_09_01_01_world.sql new file mode 100644 index 00000000000..a61022b2b27 --- /dev/null +++ b/sql/updates/world/master/2017_02_18_34_world_2016_09_01_01_world.sql @@ -0,0 +1,13 @@ +-- Fix Cabal Abjurist SAI even more +UPDATE `smart_scripts` SET `action_param1`=34446,`action_param2`=0x40,`event_param3`=5500,`event_param4`=6500 WHERE `entryorguid`=21660 AND `source_type`=0 AND `id`=0; + +-- Same treatment for Bleeding Hollow Darkcaster +DELETE FROM `smart_scripts` WHERE `entryorguid`=17269 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`event_type`,`event_chance`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`target_type`,`comment`) VALUES +(17269,0,0,0,100,300,450,1800,2100,11,15241,0x40,2,"Bleeding Hollow Darkcaster - In Combat - Cast 'Scorch' at Victim"), +(17269,0,1,0,100,11600,23300,22700,33400,11,20754,0x41,6,"Bleeding Hollow Darkcaster - In Combat - Cast 'Rain of Fire' at Random Hostile"); + +/*DELETE FROM `spelldifficulty_dbc` WHERE `id` IN (15241,20754); +INSERT INTO `spelldifficulty_dbc` (`id`,`spellid0`,`spellid1`) VALUES +(15241,15241,36807), +(20754,20754,36808);*/ |