vBulletin database question (2.2.8 to 3.7.3)

[manfai777]

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!

[Opserty]

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 (https://vborg.vbsupport.ru/showthread.php?t=166940))

[manfai777]

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?

[Opserty]

Yes
Yes
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)