diff options
| author | megamage <none@none> | 2009-03-21 22:36:23 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-03-21 22:36:23 -0600 |
| commit | a81472ac08138c293918e7e6f7a6a25f238ec26a (patch) | |
| tree | 75423ba0b22a73a0c703818805490c29e2606815 /sql | |
| parent | a0298bc58d414fc30dddbf2dc7b441bff6c35161 (diff) | |
| parent | a52405a799d61d85fd2840e79c39887731c04d07 (diff) | |
*Skip 243 spell fixes.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/1234_world.sql | 31 | ||||
| -rw-r--r-- | sql/updates/1236_world.sql | 4 |
2 files changed, 35 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); + |