Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: lather on January 16, 2019, 10:01:21 AM

Title: where is custom field data stored?
Post by: lather on January 16, 2019, 10:01:21 AM
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!
Title: Re: where is custom field data stored?
Post by: Illori on January 16, 2019, 10:03:48 AM
they should be in the themes table I believe.
Title: Re: where is custom field data stored?
Post by: Sir Osis of Liver on January 16, 2019, 11:13:19 AM
Yes, they're in _themes table, look for cust_fieldname.  They're indexed to id_member.

Title: Re: where is custom field data stored?
Post by: lather on January 16, 2019, 06:47:30 PM
Thanks! I never would have looked in themes.
Title: Re: where is custom field data stored?
Post by: lather on January 16, 2019, 07:11:54 PM
This is all I see in smf_themes table:
Title: Re: where is custom field data stored?
Post by: Sir Osis of Liver on January 16, 2019, 09:41:48 PM
Custom profile fields are in the variable column (don't ask me why).
Title: Re: where is custom field data stored?
Post by: lather on January 17, 2019, 08:49:42 AM
I do not see cutom fields in the themes table at all.
Title: Re: where is custom field data stored?
Post by: Illori on January 17, 2019, 08:52:06 AM
there are other pages, you need to look through them all or build a query to locate what you want.
Title: Re: where is custom field data stored?
Post by: lather on January 17, 2019, 10:46:56 AM
I will try that, thanks.

Found them! Thanks for your help!