Core/Spells: Fix damage scaling of mages Water Elementals.

- Water Elemental scales with 33% of mages spell power.
- Waterbolt scales with 83.33% of elementals spell power.

2 files changed, 4 insertions, 0 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 59ed9f9e201..823c52e8808 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -16956,6 +16956,7 @@ INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`a
 (2948, 0.4286, -1, -1, -1, 'Mage - Scorch'),
 (59638, 0.3, -1, 0, -1, 'Mage - Mirror Image Frostbolt'),
 (59637, 0.15, -1, 0, -1, 'Mage - Mirror Image Fire Blast'),
+(31707, 0.8333, 0, 0, 0, 'Mage - Water Elemental Waterbolt'),
 (31935, 0.07, -1, 0.07, -1, 'Paladin - Avenger Shield'),
 (53742, -1, 0.0176, -1, 0.03, 'Paladin - Blood Corruption'),
 (26573, -1, 0.04, -1, 0.04, 'Paladin - Consecration'),
diff --git a/sql/updates/world/2011_04_17_01_world_spell_bonus_data.sql b/sql/updates/world/2011_04_17_01_world_spell_bonus_data.sql
new file mode 100644
index 00000000000..4c1fca8d728
--- /dev/null
+++ b/sql/updates/world/2011_04_17_01_world_spell_bonus_data.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_bonus_data` WHERE `entry`=31707;
+INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES
+(31707,0.8333,0,0,0, 'Mage - Water Elemental Waterbolt');