Were AAs revamped?

[trevius]

It is unfortunate that AAs have to be so complex to manage in the DB. The problem lies in how SOE reworked their AA system after Titanium, and even in how it worked in Titanium. I am sure they could have made a much better system for them, but since they did not, we have to deal with what we have available to us.

Editing AAs can at least be done now in the DB thanks to the work Kayen did. It definitely takes some getting used to, and even once you learn how to do it, it is hard to retain the info unless it is fresh in your head.

[revloc02c]

Yep, that was it. I just added:

2001^1^Advanced Innate Strength II
2001^4^This ability raises your innate Strength by two points per rank.  You may train in this ability twice each level, beginning at level 61.

...to the bottom of the dbstr_us.txt file (in the Everquest installation directory).

Thanks again Kayen, I am rolling now.

[Kayen]

You can technically just use the same desc and title id of the 'Advanced Innate Strength', need to make sure though if on SoF you are set the sof_next_skill = to the skill_id of Advanced Innate Strength.

[revloc02c]

So here's my next question: If I used a dbstr_us file from a SoF client or one of the others more recent than Titanium (HoT, Und) could I get more functional AAs in the Titanium client since there are many things in the database already that Titanium is not using? Has anyone tried this? Could someone PM me to set up emailing me a copy of the SoF dbstr_us file so that I can try it? (I hope I didn't violate any laws asking for that.)

[Kayen]

You can technically get SoF+ AA's in Titanium but you need to set the client version on all those AA's and also adjust all the fields only effect Titanium AA. It is not as simple as just having the dbstr_us. Basically all the dbstr file does it allow the names and description to display correctly.

[revloc02c]

Originally Posted by Kayen

You can technically get SoF+ AA's in Titanium but you need to set the client version on all those AA's and also adjust all the fields only effect Titanium AA.

So, these changes of which you speak, are they in the cpp code or is it simply another database change? (Perhaps the aa_expansion column--hmm, no, wiki says this is for display.)

Originally Posted by Kayen

It is not as simple as just having the dbstr_us. Basically all the dbstr file does it allow the names and description to display correctly.

Understood.

[revloc02c]

Originally Posted by Kayen

You can technically get SoF+ AA's in Titanium but you need to set the client version on all those AA's and also adjust all the fields only effect Titanium AA. It is not as simple as just having the dbstr_us. Basically all the dbstr file does it allow the names and description to display correctly.

I did this--imported AAs beyond the Titanium expansion into Titanium. For anyone else who might also do this I found that any AAs in the database that have 5 digit skill_id numbers will not show up in the client. Just FYI.

[revloc02c]

Earthen Brawn
Earthen Stability
Earthen Alacrity
Earthen Artistry
Earthen Sagacity
Earthen Brilliance
Earthen Allure
These AAs all have a prereq_skill of 7357, but there is no such skill in the altadv_vars table. Does anyone know what the prereq AA is supposed to be?

[lerxst2112]

On live they require planar power at level 20 and have a level req of 81