How to decode user options

[hardwareirc.com]

Hello,
I would like to use my forum for mailing list purposes too, and I want to send emails only to the members that have the "Receive emails" option enabled.

I looked on the vbulletin 3 database, and I saw that the user options preferences are coded with a number, so it's quite difficult to see which number represents the desire to receive emails...

Can anyone help me "decoding" the number?

Thanks

[Andreas]

The user options are just a bitfield.
From init.php

PHP Code:

// Defined constants used for user field.
$_USEROPTIONS = array(
    'showsignatures'    => 1,
    'showavatars'       => 2,
    'showimages'        => 4,
    'coppauser'         => 8,
    'adminemail'        => 16, 


So if you want to get all users which have this options enabled;:

[sql]SELECT username, email FROM user WHERE options & 16[/sql]

[hardwareirc.com]

Originally Posted by KirbyDE

The user options are just a bitfield.
From init.php

PHP Code:

// Defined constants used for user field.
$_USEROPTIONS = array(
    'showsignatures'    => 1,
    'showavatars'       => 2,
    'showimages'        => 4,
    'coppauser'         => 8,
    'adminemail'        => 16, 


So if you want to get all users which have this options enabled;:

[sql]SELECT username, email FROM user WHERE options & 16[/sql]

Great
It works fine

[hardwareirc.com]

Hi guys, I'm not familiar with bitfields... There's a way to set the bit #16 to 0 with just a mysql query?

Thanks

[Andreas]

Yes. Bit #16 = 2^15 = 32768
[sql]UPDATE table SET field=field-32768 WHERE field & 32768[/sql]

Or to set it where it is not set
[sql]UPDATE table SET field=field+32768 WHERE NOT (field & 32768)[/sql]

[Paul M]

Except, I think he means the bit valued at 16, not the 16th bit . In the above options case the value should be 16.

[Andreas]

But he said bit #16

[Paul M]

Originally Posted by KirbyDE

But he said bit #16

Technically Yes, because he doesn't understand bit fields - read the posts and I think you will agree with me.

[hardwareirc.com]

Originally Posted by Paul M

Technically Yes, because he doesn't understand bit fields - read the posts and I think you will agree with me.

hmmm... well, could you explain me bitfields in order to avoid any further doubts? :P

or where could I find more info? google doesn't help

[Paul M]

Correct me if I'm wrong - but you want to set the 'adminemail' option (which is bit 5, value 16) to zero ?