[Patch/SQL] Hunter Pet Ability AP scaling

[Auntie Mangos]

crab spell pin http://www.wowhead.com/?spell=50245 is dot so 7% coef should be divided by 4 ticks, 7/4=1,75 is correct coef. and for some reason some spell doesnt get AP coefficient example claw, bite and smack.

changed it. thx for the correction. also thx to miebaik for making it as one query.

for why its not working correctly for some spells:

the bonus ap calculation is completly missing for SchoolDmg Effect.

Fix for it wich is also reviewed atm: [patch/dev] bonus damage handling

[Dealerchen]

* What bug does the patch fix? What features does the patch add?

Adds Hunter Pet spells to spell_bonus_data.

* For which repository revision was the patch created?

7537

* Is there a thread in the bug report section or at lighthouse? If yes, please add a link to the thread.

couldnt find any

* Who has been writing this patch? Please include either forum user names or email addresses.

Dealer

DELETE FROM `spell_bonus_data` WHERE `entry` IN (34889,58604,24640,24844,50519,55749,59881,56626,50274,61193,35387,54644,57386,50541,50479,50871,54706,50271,50245,26090,50256,17253,16827,49966,24423,54680,35290,50518,50433);
INSERT INTO `spell_bonus_data`
  (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`)
VALUES
  (34889, 0, 0, 0.0143, 'Hunter Pet - Fire breath'),
  (58604, 0, 0, 0.0429, 'Hunter Pet - Lava breath'),
  (24640, 0, 0, 0.0143, 'Hunter Pet - Scorpid poison'),
  (24844, 0, 0, 0.0429, 'Hunter Pet - Lightning Breath'),
  (50519, 0, 0, 0.0429, 'Hunter Pet - Sonic Blast'),
  (55749, 0, 0, 0.0429, 'Hunter Pet - Acid Spit'),
  (59881, 0, 0, 0.0175, 'Hunter Pet - Rake'),
  (56626, 0, 0, 0.049, 'Hunter Pet - Sting'),
  (50274, 0, 0, 0.0143, 'Hunter Pet - Spore Cloud'),
  (61193, 0, 0, 0.04, 'Hunter Pet - Spirit Strike'),
  (35387, 0, 0, 0.010725, 'Hunter Pet - Poison Spit'),
  (54644, 0, 0, 0.0429, 'Hunter Pet - Froststorm Breath'),
  (57386, 0, 0, 0.0429, 'Hunter Pet - Stampede'),
  (50541, 0, 0, 0.07, 'Hunter Pet - Snatch'),
  (50479, 0, 0, 0.0429, 'Hunter Pet - Nether Shock'),
  (50871, 0, 0, 0.0175, 'Hunter Pet - Savage Rend'),
  (54706, 0, 0, 0.010725, 'Hunter Pet - Venom Web Spray'),
  (50271, 0, 0, 0.0429, 'Hunter Pet - Tendon Rip'),
  (50245, 0, 0, 0.0175, 'Hunter Pet - Pin'),
  (26090, 0, 0, 0.0429, 'Hunter Pet - Thunderstomp'),
  (50256, 0, 0, 0.07, 'Hunter Pet - Swipe'),
  (17253, 0, 0, 0.07, 'Hunter Pet - Bite'),
  (16827, 0, 0, 0.07, 'Hunter Pet - Claw'),
  (49966, 0, 0, 0.07, 'Hunter Pet - Smack'),
  (24423, 0, 0, 0.07, 'Hunter Pet - Demoralizing Screech'),
  (54680, 0, 0, 0.07, 'Hunter Pet - Monstrous Bite'),
  (35290, 0, 0, 0.07, 'Hunter Pet - Gore'),
  (50518, 0, 0, 0.07, 'Hunter Pet - Ravage'),
  (50433, 0, 0, 0.07, 'Hunter Pet - Bad Attitude');

[pasdVn]

Hmm, in fact very nice. Where did you get those values from?

* INSERT INTO spell_bonus_data

* (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`)

* VALUES

* (34889, 0, 0, 0.0429, 'Hunter Pet - Fire breath');

Are you sure about that? 4.29% seems quite less for me (did you mean 42.9%, in that case you needn't add it, thats the general factor for instant spells).

I always wondered if also the physical attacks (claw, swipe, etc.) are influenced by that, but never found a proof or any information on that.

Edit: Ah, just saw that those are values for ap_bonus. Did this change? I think I read something like that that somewhere...

[Dealerchen]

the values are mainly from elitejerks forum and some from blue posts out of the wow europe forum (for example Spirit Strike and i think scorpid poison too)

i found the info that all should scale with AP on elitejerks forum too.

without the patch all abilitys take 0 bonus from ap.

[pasdVn]

I still wonder why also "magical" spells (lighning breath etc.) scale directly from AP and not from spell power anymore, as we (and blizz, too) still have the spell bonus damage from the owner RAP (12,5%).

Btw those "magical" spells won't get any bonus from the pet's real spellpower anymore (e.g. from buffs) with those entries.

Anyway, thanks for information and the patch :-)

[Dealerchen]

I still wonder why also "magical" spells (lighning breath etc.) scale directly from AP and not from spell power anymore, as we (and blizz, too) still have the spell bonus damage from the owner RAP (12,5%).

Btw those "magical" spells won't get any bonus from the pet's real spellpower anymore (e.g. from buffs) with those entries.

Anyway, thanks for information and the patch :-)

i only can relay on informations i got cause i dont have an hunter on blizzard. if someone has more detailed information about it feel free to post

[jamalae]

I still wonder why also "magical" spells (lighning breath etc.) scale directly from AP and not from spell power anymore, as we (and blizz, too) still have the spell bonus damage from the owner RAP (12,5%).

Btw those "magical" spells won't get any bonus from the pet's real spellpower anymore (e.g. from buffs) with those entries.

Anyway, thanks for information and the patch :-)

http://www.wowhead.com/?forums&topic=74950.2 there is couple replies about this and according to them atm "magical" spells doesnt benefit from +spell power.

[pasdVn]

Aha, ok. Thanks. Anyway it's very confusing :confused:.

Maybe the blizz class designers themself don't really know what they are doing...

[Dealerchen]

changed few spells again with information from http://www.xfire.com/blog/killerrabbit008/505492/

link is in first post

[Graftal]

Can anyone confirm this works properly? Thanks

[miebaik]

just clean up #1 in proper sql query.

DELETED

[jamalae]

crab spell pin http://www.wowhead.com/?spell=50245 is dot so 7% coef should be divided by 4 ticks, 7/4=1,75 is correct coef. and for some reason some spell doesnt get AP coefficient example claw, bite and smack.