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.

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.

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.

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

UPDATE altadv_vars SET prereq_skill = 443 WHERE skill_id = 1041;

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

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

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

Looks like there's only one.

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?

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