Determing user forum access programatically

[edunn]

Hi.

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

I just realized I posted this in the wrong forum... Can someone please advise me of the proper etiquette in this instance? Or can someone please move this to the programming board?