Advertisement:

Author Topic: where is custom field data stored?  (Read 459 times)

Offline lather

  • Semi-Newbie
  • *
  • Posts: 48
where is custom field data stored?
« 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!

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,488
Re: where is custom field data stored?
« Reply #1 on: January 16, 2019, 10:03:48 AM »
they should be in the themes table I believe.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 8,739
Re: where is custom field data stored?
« Reply #2 on: January 16, 2019, 11:13:19 AM »
Yes, they're in _themes table, look for cust_fieldname.  They're indexed to id_member.


Offline lather

  • Semi-Newbie
  • *
  • Posts: 48
Re: where is custom field data stored?
« Reply #3 on: January 16, 2019, 06:47:30 PM »
Thanks! I never would have looked in themes.

Offline lather

  • Semi-Newbie
  • *
  • Posts: 48
Re: where is custom field data stored?
« Reply #4 on: January 16, 2019, 07:11:54 PM »
This is all I see in smf_themes table:

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 8,739
Re: where is custom field data stored?
« Reply #5 on: January 16, 2019, 09:41:48 PM »
Custom profile fields are in the variable column (don't ask me why).

Offline lather

  • Semi-Newbie
  • *
  • Posts: 48
Re: where is custom field data stored?
« Reply #6 on: January 17, 2019, 08:49:42 AM »
I do not see cutom fields in the themes table at all.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,488
Re: where is custom field data stored?
« Reply #7 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.

Offline lather

  • Semi-Newbie
  • *
  • Posts: 48
Re: where is custom field data stored?
« Reply #8 on: January 17, 2019, 10:46:56 AM »
I will try that, thanks.

Found them! Thanks for your help!
« Last Edit: January 17, 2019, 11:20:42 AM by lather »