Getting forumpermission from usergroupid/userid

[Marco van Herwaarden]

For each forum/usergroup you will find an entry in the forumpermission, unless the default usergroup permissions are used.

The 'forumpermissions' column is a so called bitfield. A bitfield is stored as an integer, and each bit represents a permission.

For example:
Permission A
Bit: xxxxxxxxxxxxx1
Decimal value: 1

Permission B
Bit: xxxxxxxxxxxx1x
Decimal value: 2

Permission C
Bit: xxxxxxxxxxx1xx
Decimal value: 4

If permissions A & C are on, but B is off, the decimal value for the permission field would be 5 (1 + 100 = 101 binary = 5 decimal)