aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorkaelima <kaelima@live.se>2012-04-12 02:12:07 +0200
committerkaelima <kaelima@live.se>2012-04-12 02:12:07 +0200
commit2b2ebfaac0c3250954745e1d993f2b4fbcf5c7ed (patch)
tree7c8f84d1c62b8cefe09a52dc6616b38ad9bc3b2d
parent40309110acae2e621db67dc221fb03a145cf84a0 (diff)
DB/Spell Bonus Data: Fix more spell power stacking exploits (items & enchants)
Thanks Hitplusone, amort and SignFinder for the list Closes #1701
-rw-r--r--sql/updates/world/2012_04_12_02_world_spell_bonus_data.sql2
-rw-r--r--sql/updates/world/2012_04_12_03_world_spell_bonus_data.sql8
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');