Where are profile fields stored in the database?

[BirdOPrey5]

Specifically custom profile fields? I figured they'd be in the User Table but they are not... :confused:

I'm looking for where the values/answers to the fields are, I found where the 'questions'/descriptions are stored.

--------------- Added 1277775255 at 1277775255 ---------------

OK, I see it is stored in userfield but unfortunately there isn't an entry for every user... is there an sql statement I can run to set a default value of "Yes" for say field5 for every user I have? I can make field5 required but it doesn't force users to make a choice unless they happen to visit their user cp -> edit options page and the default value isn't in the actual database for them until they make a physical selection.

--------------- Added 1277781913 at 1277781913 ---------------

OK Nevermind,,, when I looked at the database table on my real forum as opposed to test forum 1014 out of 1018 members had entries so no big deal.

[mahz]

Since profile fields are interfaced via Data Manager, wouldn't it be more convenient to issue such changes through the Data Manager and access the specific DM class?

[BirdOPrey5]

You're basically speaking French to me, Data Manager? DM Class? Never heard of this stuff... but I did resolve the issue... instead of testing the condition if $x = "Yes" I test if $X != "No" therefore this evaluates to true even if $x is undefined because a user never set a value. (so "Yes" works as default like I originally intended).