Were AAs revamped?

[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;

[revloc02c]

In fact if you run this query it will show where there are disconnects in AA prereq progressions:

SELECT t1.skill_id, t1.name, t1.prereq_skill, t2.name FROM altadv_vars t1 LEFT JOIN altadv_vars t2 ON t1.prereq_skill = t2.skill_id ORDER BY t1.prereq_skill DESC;

Wherever there is a NULL on the right is a disconnect (except where the prereq_skill is zero or 4292967295 of course).

[revloc02c]

And here's one that shows disconnects in the next id progression:

SELECT t1.skill_id, t1.name, t1.sof_next_id, t2.name FROM altadv_vars t1 LEFT JOIN altadv_vars t2 ON t1.sof_next_id = t2.skill_id ORDER BY t1.sof_next_id DESC;

Looks like there's only one.