*Move coefficients from Spell::SpellDamageSchoolDmg to spell_bonus_data.

--HG--
branch : trunk

3 files changed, 61 insertions, 3 deletions

diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index 8ab471850e1..cde8cd16655 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -1763,7 +1763,35 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
 (57970, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 9($AP*0.12 / number of ticks)'),
 (48628, -1, -1, -1, 0.15, 'Druid - Lock Jaw'),
 (1822, -1, -1, -1, 0.06, 'Druid - Rake ($AP*0.18 / number of ticks)'),
-(33745, -1, -1, -1, 0.01, 'Druid - Lacerate($AP*0.05 / number of ticks)');
+(33745, -1, -1, -1, 0.01, 'Druid - Lacerate($AP*0.05 / number of ticks)'),
+(6572, -1, -1, 0.207, -1, 'Warrior - Revenge'),
+(57755, -1, -1, 0.5, -1, 'Warrior - Heroic Throw'),
+(6343, -1, -1, 0.12, -1, 'Warrior - Thunder Clap'),
+(50256, -1, -1, 0.08, -1, 'Druid - Swipe'),
+(1776, -1, -1, 0.21, -1, 'Rogue - Gouge'),
+(8680, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 1'),
+(8685, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 2'),
+(8689, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 3'),
+(11335, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 4'),
+(11336, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 5'),
+(11337, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 6'),
+(26890, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 7'),
+(57964, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 8'),
+(57965, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 9'),
+(13218, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 1'),
+(13222, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 2'),
+(13223, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 3'),
+(13224, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 4'),
+(27189, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 5'),
+(57974, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 6'),
+(57975, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 7'),
+(1495, -1, -1, 0.2, -1, 'Hunter - Mongoose Bite'),
+(19306, -1, -1, 0.2, -1, 'Hunter - Counterattack'),
+(3044, -1, -1, 0.15, -1, 'Hunter - Arcane Shot'),
+(56641, -1, -1, 0.1, -1, 'Hunter - Steady Shot'),
+(13812, -1, -1, 0.1, -1, 'Hunter - Explosive Trap Effect'),
+(20253, -1, -1, 0.12, -1, 'Warrior - Intercept'),
+(61491, -1, -1, 0.12, -1, 'Warrior - Intercept');
 
 -- --------
 -- SPELL AFFECT
diff --git a/sql/updates/4500_world_spell_bonus_data.sql b/sql/updates/4500_world_spell_bonus_data.sql
index e871a0e2705..2b8084e8cc7 100644
--- a/sql/updates/4500_world_spell_bonus_data.sql
+++ b/sql/updates/4500_world_spell_bonus_data.sql
@@ -8,7 +8,6 @@ CREATE TABLE `spell_bonus_data` (
   `comments` varchar(255) default NULL,
   PRIMARY KEY  (`entry`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-TRUNCATE TABLE `spell_bonus_data`;
 INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES
 (49941, -1, -1, 0.04, -1, 'Death Knight - Blood Boil'),
 (48721, -1, -1, 0.04, -1, 'Death Knight - Blood Boil'),
@@ -242,6 +241,6 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`
 (57969, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 8($AP*0.12 / number of ticks)'),
 (57970, -1, -1, -1, 0.03, 'Rogue - Deadly Poison Rank 9($AP*0.12 / number of ticks)'),
 (48628, -1, -1, -1, 0.15, 'Druid - Lock Jaw'),
-(1822, -1, -1, -1, 0.06, 'Druid - Rake ($AP*0.18 / number of ticks)'),
+(1822, -1, -1, 0.01, 0.06, 'Druid - Rake ($AP*0.18 / number of ticks)'),
 (33745, -1, -1, -1, 0.01, 'Druid - Lacerate($AP*0.05 / number of ticks)');
 
diff --git a/sql/updates/4501_world_spell_bonus_data.sql b/sql/updates/4501_world_spell_bonus_data.sql
new file mode 100644
index 00000000000..337b293e62e
--- /dev/null
+++ b/sql/updates/4501_world_spell_bonus_data.sql
@@ -0,0 +1,31 @@
+DELETE FROM `spell_bonus_data` where `entry` IN(6572, 57755, 6343, 50256, 1776, 8680, 8685, 8689, 11335, 11336, 11337, 26890, 57964, 57965, 13218, 13222
+, 13223, 13224, 27189, 57974, 57975, 1495, 19306, 3044, 56641, 13812, 20253, 61491);
+INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES
+(6572, -1, -1, 0.207, -1, 'Warrior - Revenge'),
+(57755, -1, -1, 0.5, -1, 'Warrior - Heroic Throw'),
+(6343, -1, -1, 0.12, -1, 'Warrior - Thunder Clap'),
+(50256, -1, -1, 0.08, -1, 'Druid - Swipe'),
+(1776, -1, -1, 0.21, -1, 'Rogue - Gouge'),
+(8680, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 1'),
+(8685, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 2'),
+(8689, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 3'),
+(11335, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 4'),
+(11336, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 5'),
+(11337, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 6'),
+(26890, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 7'),
+(57964, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 8'),
+(57965, -1, -1, 0.1, -1, 'Rogue - Instant Poison Rank 9'),
+(13218, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 1'),
+(13222, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 2'),
+(13223, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 3'),
+(13224, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 4'),
+(27189, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 5'),
+(57974, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 6'),
+(57975, -1, -1, 0.04, -1, 'Rogue - Wound Poison Rank 7'),
+(1495, -1, -1, 0.2, -1, 'Hunter - Mongoose Bite'),
+(19306, -1, -1, 0.2, -1, 'Hunter - Counterattack'),
+(3044, -1, -1, 0.15, -1, 'Hunter - Arcane Shot'),
+(56641, -1, -1, 0.1, -1, 'Hunter - Steady Shot'),
+(13812, -1, -1, 0.1, -1, 'Hunter - Explosive Trap Effect'),
+(20253, -1, -1, 0.12, -1, 'Warrior - Intercept'),
+(61491, -1, -1, 0.12, -1, 'Warrior - Intercept');