where to add / adjust notification option in userCP
 

I'm trying to find where in the DB the information for email notifications (that can be set in the userCP) is stored.

I would like to add an additional check box there, for notifications on a custom feature on the site. I know where that tidbit is in the style, but can't seem to find where it is in the DB, and hopefully add a field to that table and easily have the data available to me in my style modification.

any help is appreciated :)
thanks

bump? Anyone?

I'm not sure exactly what you are asking for - what info for email notifications in the user cp?

where in the DB is the data set?
As in, if I wanted to go into the database, and 'enable' or 'disable' a users notifications from admins option, how could I do it?

You mean for subscribed threads that get emailed to you? Each thread someone subscribes to is in the table subscribethread and the email type is listed there (0,1,2,3). I don't know what sort of email you are talking about.

No, I'm referring to the ones at:

user cp -> edit options -> messaging/notifications

there's the option to "Receive Email from Administrators" members, etc.

That is what I'm referring to in particular.
Thanks for your help btw :)

Ah, I believe that is the user options array - user.options. You can see the bitfields listed in includes/xml/bitfield_vbulletin.xml - look for the group useroptions and they will all be listed.

hmm but where in the DB is this stored?
thanks for the help

In the user table in the options field. It isn't a simple single number that is stored. It's kinda like this:

If option 1 is true - add 1
If option 2 is true - add 2
If option 3 is true - add 4
If option 4 is true - add 8
etc

So, if the number in that field is 3, then that means just option 1 and 2 were true (1 + 2). If that field is 9, then that means only option 1 and 4 were true (1 + 8). I think I've seen stuff written over on vb.com on how to do the code to figure it out, but I don't have a thread link handy.