Determing user forum access programatically

[edunn]

Hi.

Let me first apologize in advance for cross posting this! I accidentally clicked the wrong forum.


I want to write a plug-in very similar to the following: https://vborg.vbsupport.ru/showthread.php?t=141280

Except that instead of send the notification based on forum subscription, send it based on forum access.

I see the forumpermission table, but mine seems to be all denies (forumpermissions field is 0). Is this the function of this table? To soley deny?

If that is the case (which I am not convinced it is) I was wanting to formulate a query such as the following (doing a inverse NOT denied to get an allowed list):

SELECT userid from user where userid NOT IN
(select u.userid from user u
INNER JOIN forumpermission fp ON fp.usergroupid=u.usergroupid
INNER JOIN forum f on f.forumid=fp.forumid
WHERE ( fp.forumid=6 OR FIND_IN_SET(6,f.parentlist) ) AND forumpermissions=0)

All of the data for each groups forum permissions I know is stored somewhere (I suspect in a bitfield somewhere) but even when I find which one I dont know the easiest way to figure out the switches. Using the bitfield method I would want to send to everyone that had Can View Forum and Can Post Threads permission for that forum.


I hope this has some semblance of reason to it!!

Can anyone point me in the right direction?

Many, Many Thanks in advance