From 18f4ed5de4545e2cb8df074183f9ed2c16709442 Mon Sep 17 00:00:00 2001 From: kaelima Date: Sun, 17 Apr 2011 13:32:46 +0200 Subject: 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. --- sql/base/world_database.sql | 1 + sql/updates/world/2011_04_17_01_world_spell_bonus_data.sql | 3 +++ 2 files changed, 4 insertions(+) create mode 100644 sql/updates/world/2011_04_17_01_world_spell_bonus_data.sql (limited to 'sql') 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'); -- cgit v1.2.3