Customizing SMF > SMF Coding Discussion

info from custom fields

(1/3) > >>

blockus:
Anybody know where in the database the information from custom profile fields is kept in SMF 2.0.1?  I added first and last name fields, and I'd like to use that data, but I can't find it.

Thanks!

-CB

Shambles:
My custom profile stuff is all in 'smf_custom_fields'

blockus:
That table for me holds what the custom fields are, but not the data collected from each member from them is.  For example, in my case, I added a first name and last name column.  In the custom_fields table, it has the information about those fields, but not the actual first and last names of my members.

-CB

Arantor:
It's in the smf_themes table, being the only table that actually has storage for more than one thing in a per user fashion.

The 'variable' that is listed will be dependent on the names of the variables you've used.

blockus:
Lots more complex than I anticipated after looking at the table!  Unless there's a simple way to pull that data in an sql query, I might just have to use usernames.  Maybe first and last names are standard fields that smf should consider building in in the future.

Thanks for the help!

-CB

Navigation

[0] Message Index

[#] Next page