where to add / adjust notification option in userCP

[feras]

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

[feras]

bump? Anyone?

[Lynne]

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

[feras]

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?

[Lynne]

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.

[feras]

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

[Lynne]

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.

[feras]

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

[Lynne]

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.