revamped AA

[demonstar55]

This might help a bit, let me go over an AA:

select * from aa_ability where name = "Innate Strength"\G;
*************************** 1. row ***************************
              id: 1
            name: Innate Strength
        category: -1
         classes: 65535
           races: 65535
drakkin_heritage: 127
         deities: 131071
          status: 0
            type: 1
         charges: 0
      grant_only: 0
   first_rank_id: 2
         enabled: 1

Here we see the ID of the AA group for Innate Strength is 1. This is what we once called SEQ (for sequence.) This is also the number you use for /alt act if this was an activated AA.

Here we can see the first_rank_id tells us the first AA ID is 2. So lets grab that from aa_rank.

select * from aa_ranks where id = 2\G;
*************************** 1. row ***************************
              id: 2
upper_hotkey_sid: -1
lower_hotkey_sid: -1
       title_sid: 2
        desc_sid: 2
            cost: 1
       level_req: 51
           spell: -1
      spell_type: 0
     recast_time: 0
       expansion: 3
         prev_id: -1
         next_id: 3

Here we can see stuff like hotkey SIDs, title SID, cost, level, etc. Here we see prev_id is -1 meaning there is none, and the next_id is 3, so we can do select * from aa_ranks where id = 3 to get that one. Now this doesn't tell us how many abilities the AA have since we can just calculate that.

select * from aa_rank_effects where rank_id = 2\G;
*************************** 1. row ***************************
  rank_id: 2
     slot: 1
effect_id: 4
    base1: 2
    base2: 0

Now Innate Strength doesn't have any prereqs, so let me just grab an example from a random AA

select * from aa_rank_prereqs where rank_id = 255\G;
*************************** 1. row ***************************
rank_id: 255
  aa_id: 309
 points: 3

This is the Flurry AA which depends on rank 3 of AA 309, which is the id from aa_ability, which means ...

select * from aa_ability where id = 309\G;
*************************** 1. row ***************************
              id: 309
            name: Combat Fury
        category: -1
         classes: 32769
           races: 65535
drakkin_heritage: 127
         deities: 131071
          status: 0
            type: 2
         charges: 0
      grant_only: 0
   first_rank_id: 934
         enabled: 1

It depends on rank 3 of Combat Fury :P