vBulletin database question (2.2.8 to 3.7.3)
 

Back in the old days, version 2.2.8, in the User database base, there are the following columns:

showemail [smallint(6), NOTNULL]
emailnotification [smallint(6), NOTNULL]

In the Usergroup table, there is the following column:

canpostnew [smallint(6), NOTNULL]

I can't find these columns anymore in the 3.7.3 vBulletin database tables, can you tell me which are the corresponding new fields for the above columns and in which table can I find them?

Much appreciated!

I think they would probably have been moved into a bitfield setting I think its called "options" in the user table.

You can view the list of bitfield settings by looking in the /includes/xml/bitfield_vbulletin.xml file. I think vBulletin still uses the same name so try doing a "Find" in that file and you should find the info you need.

(A Closer Look at Bitfields)

Thanks for the help. From the bitfield xml file, I see the following:

<bitfield name="canpostnew" group="post_thread_permissions" phrase="can_post_threads" install="2,5,6,7">16</bitfield>

As I understand this, this is the forumpermissions column from the usergroup table, is this correct? Should I just do a bitwise operation to check if 16 is masked? What does "install=2,5,6,7" mean?

1. Yes
2. Yes
3. It refers to when the product (in this case vBulletin) is first installed, which groups should have that set to true (or "Yes") by default.

(2, 5, 6, 7 are the default Registered Users, Super Moderators, Administrators and Moderators usergroups)