Profile BLOB Questions
 

Profile BLOB Questions

Ok, I figured out Base Stats and Money. But AA's seem to be eluding me. Any one know what their offsets are or why I can't find them (When ever I edit a suspect it removes all the points)

Can you analyze how the source code peels that apart? I haven't gone there yet, but it is something I wanted to look into to see why hair is being lost during zone... I cannot see where a players facial preferences are stored, but I think it's there.

Look at struct PlayerProfile_Struct in common/eq_packet_structs.h (~line 3192). That struct is written to the blob.

According to that, AAs start at offset 0432 (decimal). Keep in mind that there are also some AA-specific tables in the database.

I used that Struct but when I edit the values and repatch, it takes all the points in that AA away. I don't know what I'm doing wrong.

Can you show an example of the code that you are using to pull the profile out of the database and save it back to the DB?

MySQL Tools
 

I extracted it with MySQL tools and used Hex Workshop. I've edited money, total AA points left, and My characters in profile name (Is different that the character listing in SQL). Is there a way to list the data with an SQL command? If so that would save me a lot of work ^-^.

Not wanting to Double Post
 

I figured it out (It was a lot easer that I thought it would be)