diff options
| -rw-r--r-- | sql/updates/world/2012_12_02_00_world_spell_group_misc_434.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/sql/updates/world/2012_12_02_00_world_spell_group_misc_434.sql b/sql/updates/world/2012_12_02_00_world_spell_group_misc_434.sql new file mode 100644 index 00000000000..52e6a041f2e --- /dev/null +++ b/sql/updates/world/2012_12_02_00_world_spell_group_misc_434.sql @@ -0,0 +1,22 @@ +SET @GROUP = 1121; +DELETE FROM `spell_group_stack_rules` WHERE `group_id`=@GROUP; +INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES +(@GROUP, 1); -- SPEL_GROUP_STACK_RULE_EXCLUSIVE + +DELETE FROM `spell_group` WHERE `id`=@GROUP; +INSERT INTO `spell_group` (`id`,`spell_id`) VALUES +(@GROUP, 73413), -- Inner will +(@GROUP, 588); -- Inner fire + +-- Adding missing proc event for Fingers of Frost (Rank 3) +DELETE FROM `spell_proc_event` WHERE `entry`=83074; +INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFamilyMask0`,`SpellFamilyMask1`,`SpellFamilyMask2`,`procFlags`,`procEx`,`ppmRate`,`CustomChance`,`Cooldown`) VALUES +(83074, 0, 3, 1049120, 4096, 0, 65536, 0, 0, 20, 0); + +-- Updating spell_learn_spell's spell IDs range... +ALTER TABLE `spell_learn_spell` MODIFY `entry` MEDIUMINT(8) NOT NULL; +ALTER TABLE `spell_learn_spell` MODIFY `SpellID` MEDIUMINT(8) NOT NULL; +-- ...So we can have sinister strike's combo point enabler. +DELETE FROM `spell_learn_spell` WHERE `SpellID`=79327 AND `entry`=2098; +INSERT INTO `spell_learn_spell` (`entry`,`SpellID`,`Active`) VALUES +(2098, 79327, 0); |