AA Purchase question

[John Adams]

I know AA's are not officially working, so this is more a heads up than a bug report. Move the post if you feel drawn to do so (just not to the trash bin, please).

I was playing with some AA testing, and have been using the mlog/logs system a lot more lately. Since becoming more familiar with it, I am starting to see some interesting things when purchasing AAs. Here's a complete log of tonights tests. I'll explain after the quote:

[Sat Dec 30 23:26:56 2006] You say, '#resetaa'
[Sat Dec 30 23:26:57 2006] Successfully reset TestPlayer's AAs
[Sat Dec 30 23:27:40 2006] You say, '#setaapts 20'
[Sat Dec 30 23:27:40 2006] Usage: #setaapts <AA|group|raid> <new AA points value>
[Sat Dec 30 23:27:50 2006] You say, '#setaapts AA 20'
[Sat Dec 30 23:27:51 2006] You gain experience!!
[Sat Dec 30 23:27:51 2006] You have gained an ability point! You now have 28 ability points.
[Sat Dec 30 23:28:20 2006] [AA__IN] TestPlayer: Received OP_AAAction
[Sat Dec 30 23:28:20 2006] [AA__IN] [AA__IN] TestPlayer: [OpCode OP_AAAction (0x0681) Size=16]
[Sat Dec 30 23:28:20 2006] [AA__IN] 0000: 03 00 00 00 16 00 00 00 - 00 00 00 00 00 00 00 00 | ................

[Sat Dec 30 23:28:20 2006] [AA__MESSAGE] TestPlayer: Starting to buy AA 22
[Sat Dec 30 23:28:20 2006] [AA__MESSAGE] TestPlayer: Set AA 22 to level 1
[Sat Dec 30 23:28:20 2006] You have gained the ability "Innate Intelligence" at a cost of 1 ability point.
[Sat Dec 30 23:28:28 2006] [AA__IN] TestPlayer: Received OP_AAAction
[Sat Dec 30 23:28:28 2006] [AA__IN] [AA__IN] TestPlayer: [OpCode OP_AAAction (0x0681) Size=16]
[Sat Dec 30 23:28:28 2006] [AA__IN] 0000: 03 00 00 00 17 00 00 00 - 00 00 00 00 00 00 00 00 | ................
[Sat Dec 30 23:28:28 2006] [AA__MESSAGE] TestPlayer: Starting to buy AA 23
[Sat Dec 30 23:28:28 2006] [AA__MESSAGE] TestPlayer: Could not find AA 23, trying potential parent 22
[Sat Dec 30 23:28:28 2006] [AA__MESSAGE] TestPlayer: Set AA 22 to level 2
[Sat Dec 30 23:28:28 2006] You have improved Innate Intelligence 1 at a cost of 1 ability point.
[Sat Dec 30 23:28:56 2006] [AA__IN] TestPlayer: Received OP_AAAction
[Sat Dec 30 23:28:56 2006] [AA__IN] [AA__IN] TestPlayer: [OpCode OP_AAAction (0x0681) Size=16]
[Sat Dec 30 23:28:56 2006] [AA__IN] 0000: 03 00 00 00 18 00 00 00 - 00 00 00 00 00 00 00 00 | ................
[Sat Dec 30 23:28:56 2006] [AA__MESSAGE] TestPlayer: Starting to buy AA 24
[Sat Dec 30 23:28:56 2006] [AA__MESSAGE] TestPlayer: Could not find AA 24, trying potential parent 23
[Sat Dec 30 23:28:56 2006] [AA__MESSAGE] TestPlayer: Could not find AA 24, trying potential parent 22
[Sat Dec 30 23:28:56 2006] [AA__MESSAGE] TestPlayer: Set AA 22 to level 3
[Sat Dec 30 23:28:56 2006] You have improved Innate Intelligence 2 at a cost of 1 ability point.
[Sat Dec 30 23:29:42 2006] [AA__IN] TestPlayer: Received OP_AAAction
[Sat Dec 30 23:29:42 2006] [AA__IN] [AA__IN] TestPlayer: [OpCode OP_AAAction (0x0681) Size=16]
[Sat Dec 30 23:29:42 2006] [AA__IN] 0000: 03 00 00 00 19 00 00 00 - 00 00 00 00 00 00 00 00 | ................
[Sat Dec 30 23:29:42 2006] [AA__MESSAGE] TestPlayer: Starting to buy AA 25
[Sat Dec 30 23:29:42 2006] [AA__MESSAGE] TestPlayer: Could not find AA 25, trying potential parent 24
[Sat Dec 30 23:29:42 2006] [AA__MESSAGE] TestPlayer: Could not find AA 25, trying potential parent 23
[Sat Dec 30 23:29:42 2006] [AA__MESSAGE] TestPlayer: Could not find AA 25, trying potential parent 22
[Sat Dec 30 23:29:42 2006] [AA__MESSAGE] TestPlayer: Set AA 22 to level 4
[Sat Dec 30 23:29:42 2006] You have improved Innate Intelligence 3 at a cost of 1 ability point.
[Sat Dec 30 23:29:54 2006] Unable to find data for pet SumSword, check pets table.
[Sat Dec 30 23:30:01 2006] Unable to find data for pet SumSword, check pets table.
[Sat Dec 30 23:30:04 2006] Unable to find data for pet SumSword, check pets table.
[Sat Dec 30 23:31:02 2006] [AA__IN] TestPlayer: Received OP_AAAction
[Sat Dec 30 23:31:02 2006] [AA__IN] [AA__IN] TestPlayer: [OpCode OP_AAAction (0x0681) Size=16]
[Sat Dec 30 23:31:02 2006] [AA__IN] 0000: 03 00 00 00 1a 00 00 00 - 00 00 00 00 00 00 00 00 | ................
[Sat Dec 30 23:31:02 2006] [AA__MESSAGE] TestPlayer: Starting to buy AA 26
[Sat Dec 30 23:31:02 2006] [AA__MESSAGE] TestPlayer: Could not find AA 26, trying potential parent 25
[Sat Dec 30 23:31:02 2006] [AA__MESSAGE] TestPlayer: Could not find AA 26, trying potential parent 24
[Sat Dec 30 23:31:02 2006] [AA__MESSAGE] TestPlayer: Could not find AA 26, trying potential parent 23
[Sat Dec 30 23:31:02 2006] [AA__MESSAGE] TestPlayer: Could not find AA 26, trying potential parent 22
[Sat Dec 30 23:31:02 2006] [AA__MESSAGE] TestPlayer: Set AA 22 to level 5
[Sat Dec 30 23:31:02 2006] You have improved Innate Intelligence 4 at a cost of 1 ability point.
[Sat Dec 30 23:31:10 2006] [AA__IN] TestPlayer: Received OP_AAAction
[Sat Dec 30 23:31:10 2006] [AA__IN] [AA__IN] TestPlayer: [OpCode OP_AAAction (0x0681) Size=16]
[Sat Dec 30 23:31:10 2006] [AA__IN] 0000: 03 00 00 00 3e 00 00 00 - 00 00 00 00 00 00 00 00 | ....>...........
[Sat Dec 30 23:31:10 2006] [AA__MESSAGE] TestPlayer: Starting to buy AA 62
[Sat Dec 30 23:31:10 2006] [AA__MESSAGE] TestPlayer: Set AA 62 to level 1
[Sat Dec 30 23:31:10 2006] You have gained the ability "Innate Run Speed" at a cost of 1 ability point.
[Sat Dec 30 23:31:29 2006] [AA__IN] TestPlayer: Received OP_AAAction
[Sat Dec 30 23:31:29 2006] [AA__IN] [AA__IN] TestPlayer: [OpCode OP_AAAction (0x0681) Size=16]
[Sat Dec 30 23:31:29 2006] [AA__IN] 0000: 03 00 00 00 3f 00 00 00 - 00 00 00 00 00 00 00 00 | ....?...........
[Sat Dec 30 23:31:29 2006] [AA__MESSAGE] TestPlayer: Starting to buy AA 63
[Sat Dec 30 23:31:29 2006] [AA__MESSAGE] TestPlayer: Could not find AA 63, trying potential parent 62
[Sat Dec 30 23:31:29 2006] [AA__MESSAGE] TestPlayer: Set AA 62 to level 2
[Sat Dec 30 23:31:29 2006] You have improved Innate Run Speed 1 at a cost of 1 ability point.
[Sat Dec 30 23:31:37 2006] [AA__IN] TestPlayer: Received OP_AAAction
[Sat Dec 30 23:31:37 2006] [AA__IN] [AA__IN] TestPlayer: [OpCode OP_AAAction (0x0681) Size=16]
[Sat Dec 30 23:31:37 2006] [AA__IN] 0000: 03 00 00 00 40 00 00 00 - 00 00 00 00 00 00 00 00 | ....@...........
[Sat Dec 30 23:31:37 2006] [AA__MESSAGE] TestPlayer: Starting to buy AA 64
[Sat Dec 30 23:31:37 2006] [AA__MESSAGE] TestPlayer: Could not find AA 64, trying potential parent 63
[Sat Dec 30 23:31:37 2006] [AA__MESSAGE] TestPlayer: Could not find AA 64, trying potential parent 62
[Sat Dec 30 23:31:37 2006] [AA__MESSAGE] TestPlayer: Set AA 62 to level 3
[Sat Dec 30 23:31:37 2006] You have improved Innate Run Speed 2 at a cost of 1 ability point.
[Sat Dec 30 23:32:10 2006] Unable to find data for pet SumSword, check pets table.
[Sat Dec 30 23:32:11 2006] Unable to find data for pet SumSword, check pets table.
[Sat Dec 30 23:32:26 2006] Unable to find data for pet SumSword, check pets table.

These 2 tests are purchasing 5 AA for innate intelligence and run speed. As you see, the first purchased AA (cyan log entry) is expected results... get the request for the AA training, and process it. However, note the yellow log entries are the 2-5 or 2-3 purchases, and seem to be stumbling through AA id's until it lands on the right one.

My question is, is this correct behavior? I've paired the "AA ##" to the data coming from the client [03 00 00 00 ##...] so it would appear the client is feeding the new ID, and we're handling additional levels as "children" of the "parent" or original ID. This explains why in the altadv_vars table, "skill_id" column seems scattered, rather than sequential. AA 22 is Innate Intelligence. The next skill_id is AA 27, or Innate Wisdom -- seems there is room for 22-26, or 5 levels. Starting to make sense now...

If this is by-design, ignore this post. Thought I'd bring it up since it looked strange to me, but is becoming clearer as I write.

[KLS]

I think you have the idea of what's going on there's room between AA_ids and the client sends us the aa_id + n levels purchased but we actually have to work with the base aa_id numbers when talking back to the client so it goes backwards through the list till it finds the AA we want to work with in the database. Or something to that effect.

[John Adams]

Thanks KLS. As I was writing that, it was becoming more clear what was happening. Can a mod pls move this from Bugs to General Support or something? So anyone looking for how they work might still find the info.

When the wiki is born (after more research), I'll put this stuff there, too.

[ven-elexver]

Hi . the noob is here haha . i know i know i need to read more but may i ask are the aas working at all in the new peq ? this may not be the place to ask and i should look in forums i just hit on this in search of how to trun my peq db server to pvp no luck yet on that one i have not seen any thing yet on VET AAs and if you can flag a account with out being on a server for 1 year not sure if Vet AAs even work yet on eqemu .Sorry my mind wonders. I am like a kid in a candy store here