News:

Wondering if this will always be free?  See why free is better.

Main Menu

where is custom field data stored?

Started by lather, January 16, 2019, 10:01:21 AM

Previous topic - Next topic

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.

Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

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).
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

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

#8
I will try that, thanks.

Found them! Thanks for your help!

Advertisement: