Alternate Advancement Question
 

I have been doing a lot of research on the forums and wiki as well as digging around in the PEQ database, and I have a few questions on how AA's work.

1) The wiki only has effectid's up to 198, but the AA_effects table has values as high as 327. Is there a chart of the current list?

2) What file or other location stores all of the table altadv_vars - hotkey_sid1, hotkey_sid2, title_sid, desc_sid info?

3) Does the value of 4294967295 for table altadv_vars - spell_id and prereq_skill mean it doesn't have one? what of the value 4294967294?

4) Where does table altadv_vars - prereq_skill get it's number from?
Ex: divine resurrection and celestial regeneration both have the value of 19. What does that 19 correspond to?

5) Several of the AA_effects - aaid entries do not have a corresponding entry in the altadv_vars table. Is this simply the effect isn't implemented yet or is it a database issue as to why they don't work are are broken?
Ex: AA_effects - ID 374 thru 378 (which = aaid 1007) isn't listed at all in the altadv_vars table
Ex2: altadv_vars - skill_id 1129 (adv pet disc) says it has 2 ranks, but table aa_effects - id 400 is the only one listed when there should be 2 (a row for each rank)

1) spdat.h has a list of all known spell effects

2) depends on client on 6.2 it's in the normal strings file but on titanium it's in dbstr_us.txt. On titanium you merely have to have it set and the client will find the automatic string from the file.

3) 4294967295 generally means not used except in prereq skill. 0 means you can train it at 51, 4294967295 means you can train it at 55 with 6 in general, 4294967294 means you must be above 59 with 12 pts in arch to be able to train it.

4) it's the simple index of the aavars loaded in the db. For example swift journey has 13 as it's prereq so when we SELECT * FROM `altadv_vars` the 13th row is innate run speed.

5) Means for some reason they got deleted after I put them in the DB initially dunno why.

Thanks for the enlightenment KLS. Now I begin the fun part of code and DB manipulation to see if I can bring online some of the broken or missing AAs. I am sure I will have more questions, but I will see how far my tinkering can get me before I ask a million more questions :)

Is there a hard coded number of AA's that can be in each catagory? If so, is it set in the server code or client?

I am trying to get all AA's to be usable by all classes and it seems like no matter what I do, only up to 50 AA's will show up in any given catagory.

Probably, but I'm not sure I've never tried it.