Two missing AA's for Bards

[Zuesrooster]

insert into `altadv_vars` values (213, 'Instrument Mastery', 3, 3, 4294967295,4294967295,13742,13743, 3, 4294967295, 4294967294,0,0,0,33682,0,0)

insert into `altadv_vars` values (213, 'Singing Mastery', 3, 3, 4294967295,4294967295,13817,13818, 3, 4294967295, 4294967294,0,0,0,33682,0,0)

After running that they they show up in my window. The Instrument Mastery does nothing, but seeing that neither do instruments I am not suprised. To get Singing Mastery I had to change the code in a couple of places. I will post those changes on the Dev thread since I have a couple of questions about them.

[John Adams]

Originally Posted by Zuesrooster

4294967295

Not to derail, but do you know what these ungodly numbers are for? Is there a reference anywhere? I wanted to add a bunch of missing AAs but I am intimidated by these digits.

TIA

[Zuesrooster]

that is the MaxValue for an unsigned Int32. It is often used to initilize int32 variables. Don't worry to much about it basically means that column has no real value for that AA. One correction with the insert statement above. singing mastery should be:

insert into `altadv_vars` values (275, 'Singing Mastery', 3, 3, 4294967295,4294967295,13817,13818, 3, 4294967295, 4294967294,0,0,0,33682,0,0)

[fathernitwit]

just a note:
the 'classes' field in your SQL is wrong. It should be 128 not 33682. It is a bit map for each class, and 33682 gives it to quite a lot of classes.

As I type this message, I think i may have just figured out why the altadv_vars table is missing so many things.... whenever I pull it from live, I only use a single char (which happens to be a mage). I noticed when looking at the table that we only seem to have "shared or mage-only" AAs in the table... I bet EQLive is only sending the AAs for my class... I am going to have to look at this, but maybe we can get somebody to make a char of each class on live to collect all the AAs.

[Dralanna]

Sorry to bump an old thread, but is there a list of which class is which in the bitfields?

I tried to figure it out based on the bitfields on my own, but came up blank. At first, I assumed it would be the same as the item bitfields but that doesnt seem to be the case.

For example, 4096 is a Mage in items.... but in the altadv_vars

INSERT INTO altadv_vars VALUES (1344,'Devoted Familiar',12,1,31450,31451,31448,31449,7,5949,179, 1,8,60,4096,0,0);

a wizard AA is assigned 4096... so either the DB is incorrect, or AAs use a different bitfield.

[KLS]

This is what I wrote down last week while tinkering with AAs concerning the class field:

1 - Warrior +2
2 - Cleric +4
3 - Paladin +8
4 - Ranger +16
5 - Shadowknight +32
6 - Druid +64
7 - Monk +128
8 - Bard +256
9 - Rogue +512
10 - Shaman +1024
11 - Necromancer +2048
12 - Wizard +4096
13 - Magician +8192
14 - Enchanter +16384
15 - Beastlord +32768
16 - Beserker has it's own field