Topic: where is custom field data stored?

[lather]

Looking at the members table in the forum database there are fields labeled member_name and real_name however the entry in both is the user name, not real name.

We have added custom required fields  to our registration page including real name and motorcycle model, Entries for these fields show up in the user profile but I can't find them anywhere in the database. I would like to access this data for matching purposes with an external membership database.

Can anyone tell me where this data is stored? Thanks!

[Illori]

they should be in the themes table I believe.

[Sir Osis of Liver]

Yes, they're in _themes table, look for cust_fieldname.  They're indexed to id_member.

[lather]

Thanks! I never would have looked in themes.

[lather]

This is all I see in smf_themes table:

[Sir Osis of Liver]

Custom profile fields are in the variable column (don't ask me why).

[lather]

I do not see cutom fields in the themes table at all.

[Illori]

there are other pages, you need to look through them all or build a query to locate what you want.

[lather]

I will try that, thanks.

Found them! Thanks for your help!