diff options
| -rw-r--r-- | sql/updates/1234_world.sql | 31 | ||||
| -rw-r--r-- | sql/updates/1236_world.sql | 4 | ||||
| -rw-r--r-- | src/game/SpellMgr.cpp | 1 |
3 files changed, 36 insertions, 0 deletions
diff --git a/sql/updates/1234_world.sql b/sql/updates/1234_world.sql new file mode 100644 index 00000000000..be2a0eaaef7 --- /dev/null +++ b/sql/updates/1234_world.sql @@ -0,0 +1,31 @@ +DELETE FROM `spell_affect` WHERE `entry`='14177' AND `effectId`='0'; +INSERT INTO `spell_affect` VALUES ('14177', '0', '61741335326'); + +DELETE FROM `spell_affect` WHERE `entry`='13733' AND `effectId`='1'; +DELETE FROM `spell_affect` WHERE `entry`='13865' AND `effectId`='1'; +DELETE FROM `spell_affect` WHERE `entry`='13866' AND `effectId`='1'; +INSERT INTO `spell_affect` VALUES ('13733', '1', '25769803776'); +INSERT INTO `spell_affect` VALUES ('13865', '1', '25769803776'); +INSERT INTO `spell_affect` VALUES ('13866', '1', '25769803776'); + +DELETE FROM `spell_affect` WHERE `entry`='31234' AND `effectId`='0'; +DELETE FROM `spell_affect` WHERE `entry`='31235' AND `effectId`='0'; +DELETE FROM `spell_affect` WHERE `entry`='31236' AND `effectId`='0'; +DELETE FROM `spell_affect` WHERE `entry`='31237' AND `effectId`='0'; +DELETE FROM `spell_affect` WHERE `entry`='31238' AND `effectId`='0'; +INSERT INTO `spell_affect` VALUES ('31234', '0', '1125920146191'); +INSERT INTO `spell_affect` VALUES ('31235', '0', '1125920146191'); +INSERT INTO `spell_affect` VALUES ('31236', '0', '1125920146191'); +INSERT INTO `spell_affect` VALUES ('31237', '0', '1125920146191'); +INSERT INTO `spell_affect` VALUES ('31238', '0', '1125920146191'); + +DELETE FROM `spell_proc_event` WHERE `entry`='14186'; +DELETE FROM `spell_proc_event` WHERE `entry`='14190'; +DELETE FROM `spell_proc_event` WHERE `entry`='14193'; +DELETE FROM `spell_proc_event` WHERE `entry`='14194'; +DELETE FROM `spell_proc_event` WHERE `entry`='14195'; +INSERT INTO `spell_proc_event` VALUES ('14186', '0', '8', '26851935496', '0', '2', '0', '0', '1'); +INSERT INTO `spell_proc_event` VALUES ('14190', '0', '8', '26851935496', '0', '2', '0', '0', '1'); +INSERT INTO `spell_proc_event` VALUES ('14193', '0', '8', '26851935496', '0', '2', '0', '0', '1'); +INSERT INTO `spell_proc_event` VALUES ('14194', '0', '8', '26851935496', '0', '2', '0', '0', '1'); +INSERT INTO `spell_proc_event` VALUES ('14195', '0', '8', '26851935496', '0', '2', '0', '0', '1'); diff --git a/sql/updates/1236_world.sql b/sql/updates/1236_world.sql new file mode 100644 index 00000000000..43d7d58d588 --- /dev/null +++ b/sql/updates/1236_world.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_proc_event` WHERE `entry` = 36070; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(36070, 0x00, 0, 0x00000000, 0x00000008, 0x00000000, 0.000000, 0.000000, 0); + diff --git a/src/game/SpellMgr.cpp b/src/game/SpellMgr.cpp index be236dbc83b..6b036445394 100644 --- a/src/game/SpellMgr.cpp +++ b/src/game/SpellMgr.cpp @@ -2346,6 +2346,7 @@ void SpellMgr::LoadSpellCustomAttr() case 45027: // Revitalize case 45976: // Muru Portal Channel case 39365: // Thundering Storm + case 41071: // Raise Dead spellInfo->MaxAffectedTargets = 1; break; case 41376: // Spite |