Quick description assuming you're looking to do custom stuff:
Tables: aa_ability, aa_ranks, aa_rank_effects, an aa_rank_prereqs.
Each of these tables correspond to a new class/object server side.
Each AA line has a single aa_ability. Each aa_ability has multiple aa_ranks with various data. Each rank can have an associated aa_rank_effects, which is just spell data for the AA rank. The aa_rank_prereqs table may seem silly, but live now has AA that have multiple prereqs, which that lets us do. (that's RoF+, so you won't see them on older clients)
That should give you kind of a good idea of how it all works just looking at the tables.
Data common to every line is in aa_ability, note name in this table is just for easy of use, the actual displayed name is done via some DB string ID entries in aa_ranks since live has AAs that change name with each rank. The aa_ability table needs to point to the first rank ID, and each rank points to the next etc.
|