Rake (druid cat form) affected by SP?

Before to post like a Bug, maybe I’m not right and a prefer to answer to the community.

http://www.wowhead.com/spell=1822#comments

Is getting more damage with SP than AP, is easy to test, just get some gear with SP and hit a dummy change your set for AP and try it again, with SP you will done more damage than with AP, that’s ok?

Ty

http://code.google.com/p/trinitycore/issues/detail?id=3474&q=rake&colspec=ID%20Type%20Status%20Stars%20Priority%20Summary%20Reporter%20Attachments%20Com

Old issue.

INSERT INTO spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES (1822, 0, 0, 0.01, 0.06, 'Druid - Rake (rank 1)'); INSERT INTO spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES (1823, 0, 0, 0.01, 0.06, 'Druid - Rake (rank 2)'); INSERT INTO spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES (1824, 0, 0, 0.01, 0.06, 'Druid - Rake (rank 3)'); INSERT INTO spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES (9904, 0, 0, 0.01, 0.06, 'Druid - Rake (rank 4)'); INSERT INTO spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES (27003, 0, 0, 0.01, 0.06, 'Druid - Rake (rank 5)'); INSERT INTO spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES (48573, 0, 0, 0.01, 0.06, 'Druid - Rake (rank 6)'); INSERT INTO spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES (48574, 0, 0, 0.01, 0.06, 'Druid - Rake (rank 6)');[/sql]

Maybe is a old bug but still on TDB: TDB_full_335.11.39_2011_04_02

Just check some spells and still is getting SP not AP.

You don’t need to do a query for each rank.

All ranks will take the coefficient from Rank 1.

Ok, I don’t need to use it on all rank, but check it:

This is from the link Discovery:

INSERT INTO spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES (1822, 0, 0, 0.01, 0.06, 'Druid - Rake (rank 1)');[/SQL]

On Discovery link rake is NOT getting bonus from SP

And this is from TDB_335.11.39_2011_04_02:

[SQL]insert into spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) values
(‘1822’,‘-1’,‘-1’,‘0.01’,‘0.06’,‘Druid - Rake ($AP*0.18 / number of ticks)’);[/SQL]
In TDB (last rev) is getting bonus from SP.

Yo can check it using this: SELECT * FROM spell_bonus_data WHERE entry=‘1822’;

So… Rake is getting bonus from SP and hitting hard, them Druids can heal and done a very good damage (better than with one set of AP). Just try it on your server, and if I’m right I report this to the bug report.

http://www.trinitycore.org/w/Spell_bonus_data_tc2

DELETE FROM spell_bonus_data WHERE entry = 1822;

INSERT INTO spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES

(1822, 0, 0, 0.01, 0.06, ‘Druid - Rake’);

That should do the trick.

Stupid to have a delete/insert query when you are only updating values.

-- Damage of Rake should never scale with spellpower.
UPDATE `spell_bonus_data` SET `direct_bonus`=0,`dot_bonus`=0 WHERE `entry`=1822;
[/SQL]