Were AAs revamped?

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

You can technically get SoF+ AA's in Titanium but you need to set the client version on all those AA's and also adjust all the fields only effect Titanium AA. It is not as simple as just having the dbstr_us. Basically all the dbstr file does it allow the names and description to display correctly.

I did this--imported AAs beyond the Titanium expansion into Titanium. For anyone else who might also do this I found that any AAs in the database that have 5 digit skill_id numbers will not show up in the client. Just FYI.

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

[revloc02c]

Earthen Brawn
Earthen Stability
Earthen Alacrity
Earthen Artistry
Earthen Sagacity
Earthen Brilliance
Earthen Allure
These AAs all have a prereq_skill of 7357, but there is no such skill in the altadv_vars table. Does anyone know what the prereq AA is supposed to be?

[lerxst2112]

On live they require planar power at level 20 and have a level req of 81