Were AAs revamped?

[Kayen]

Yeah looks like its missing should be 2% per rank for the 3 ranks.

[Kayen]

In reviewing this also found the SoF+ Healing Adept AA's were not set to the correct values.

Committed an sql to resolve all these issues.

[revloc02c]

Thanks Kayen, I appreciate that. I am still working through AAs and I'll keep an eye out for anything else.

[revloc02c]

Healing Gift VII in the aa_effects table, it's skill_id = 12454. Usually in this table the aaid (skill_id) increments with each rank, so it gets higher, but the other two entries here are aaid=12453, 12452, going lower.

Furthermore, the base1 value for 12454 is a 3, and then it also gets lower to a 2 then 1.

So,

seems like the skill_id for Healing Gift VII should be 12452

OR

the other entries for it in the aa_effects table should increment, 12455, 12456 (adjusting the base1 values for each so that they all correspond correctly).


Or it all may be okay and just work because I don't understand the implementation of it all well enough. But I thought I should bring it up here to make sure.

[revloc02c]

In addition to the previous post...

I could not find Finishing Blow, skill_id=119 in the aa_effects table.

Could someone please double check these things for me?

[revloc02c]

Found another question:
Veteran's Wrath cites 445 as the prereq_skill, but that is the third rank of Fury of Ages skill_id 443. So should the prereq_skill actually be 443?

In game it says Veteran's Wrath "has no previous ability requirements"

Perhaps someone in the know could also check this potential issue.

Thanks.

[revloc02c]

I found another mistake if someone would please take a look:

In the altadv_vars table Healing Gift V prereq_skill = 4479 (two 4s), but Healing Gift IV skill_id is 4779 (two 7s).

Here's a script to fix this if someone with the power will put it in the right place:

UPDATE altadv_vars SET prereq_skill = 4779 WHERE skill_id = 5592;

Thanks.

[revloc02c]

Originally Posted by revloc02c

Found another question:
Veteran's Wrath cites 445 as the prereq_skill, but that is the third rank of Fury of Ages skill_id 443. So should the prereq_skill actually be 443?

In game it says Veteran's Wrath "has no previous ability requirements"

Perhaps someone in the know could also check this potential issue.

Thanks.

Here's a script to fix this problem in case anyone needs it.

UPDATE altadv_vars SET prereq_skill = 443 WHERE skill_id = 1041;