diff options
| -rw-r--r-- | sql/updates/world/2012_04_12_02_world_spell_bonus_data.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2012_04_12_03_world_spell_bonus_data.sql | 8 |
2 files changed, 9 insertions, 1 deletions
diff --git a/sql/updates/world/2012_04_12_02_world_spell_bonus_data.sql b/sql/updates/world/2012_04_12_02_world_spell_bonus_data.sql index a6386c4285d..db35f5d97ee 100644 --- a/sql/updates/world/2012_04_12_02_world_spell_bonus_data.sql +++ b/sql/updates/world/2012_04_12_02_world_spell_bonus_data.sql @@ -1,7 +1,7 @@ -- Druid UPDATE `spell_bonus_data` SET `direct_bonus`=0,`dot_bonus`=0 WHERE `entry` IN (779,1822,60089); DELETE FROM `spell_bonus_data` WHERE `entry` IN (1079,9007,22568); -INSERT INTO `spell_bonus_data` VALUES +INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES (1079,0,0,-1,-1, 'Druid - Rip'), (9007,0,0,-1,-1, 'Druid - Pounce Bleed'), (22568,0,0,-1,-1, 'Druid - Ferocious Bite'); diff --git a/sql/updates/world/2012_04_12_03_world_spell_bonus_data.sql b/sql/updates/world/2012_04_12_03_world_spell_bonus_data.sql new file mode 100644 index 00000000000..d2262e52e98 --- /dev/null +++ b/sql/updates/world/2012_04_12_03_world_spell_bonus_data.sql @@ -0,0 +1,8 @@ +-- Fixes some spell power stacking exploits +DELETE FROM `spell_bonus_data` WHERE `entry` IN (44525,18798,16614,7712,13897); +INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES +(44525,0,0,-1,-1, 'Enchant Weapon - Icebreaker'), +(18798,0,0,-1,-1, 'Item - Freezing Band'), +(16614,0,0,-1,-1, 'Item - Storm Gauntlets'), +(7712,0,0,-1,-1, 'Item - Fiery Retributer | Blazefury Medallion'), +(13897,0,0,-1,-1, 'Enchant Weapon - Fiery Weapon'); |