Finding values for custom profile fields

[floridaflatlander]

I have found the table smf_custom_fields thats stores new data about a custom field. Things like id_field, col_name, field_name etc.

My problem is, where are the values stored? Say I have a custom field with the field_name of location and it has a value of "Florida" where is this value Florida stored?

I have a test profile with a custom location of florida and I can't find it. It's got to be there somewhere, I have looked in all my tables several times.

Any help would be appreciated.

Thanks
S

[Oya]

see the smf_themes table, theme id should be 0 or 1 (probably 1 iirc), and the custom fields should have entries in the variable column that begin with 'cust'

[floridaflatlander]

.......... the custom fields should have entries in the variable column that begin with 'cust'

Yes they do, thank you.