TrinityCore/TrinityCore — Issue #4409: Bonus sp in coeff
Author: resh-u
Created: 2011-12-20 08:39:39+00:00
State: open

As all know there are problems with sp bonus in skill with only ap bonus.

To fix this problem is simple solution

UPDATE `spell_bonus_data` SET `direct_bonus` = 0 WHERE `direct_bonus` = -1;
UPDATE `spell_bonus_data` SET `dot_bonus` = 0 WHERE `dot_bonus` = -1;
UPDATE `spell_bonus_data` SET `ap_bonus` = 0 WHERE `ap_bonus` = -1;
UPDATE `spell_bonus_data` SET `ap_dot_bonus` = 0 WHERE `ap_dot_bonus` = -1;

It works in my server and helps in 95% poisons, druid feral skills, dk skills, etc.
I think core take -1 as 1 witch is == 100% bonus SP. I don't know why you always in fixes put in this positions -1.