List members that can access each forum
#1
Is there a plugin that would list all existing forums and state which users can view its threads, post replies, post new threads?


Or maybe someone can give me a hint what would such an SQL look like?

I have:

SELECT (SELECT group_concat(a.name order by a.pid, a.fid separator ' / ')
          from `my_forums` a
        WHERE concat(',',f.parentlist,',') like concat('%,',a.fid, ',%')
      ) as Forum,
      (SELECT group_concat(g.title ORDER BY g.title ASC SEPARATOR ', ')
          FROM my_forumpermissions fp, my_usergroups g
        WHERE fp.fid = f.fid AND g.gid = fp.gid AND (fp.canview != 0)) as CanView,
      (SELECT group_concat(g.title ORDER BY g.title ASC SEPARATOR ', ')
          FROM my_forumpermissions fp, my_usergroups g
        WHERE fp.fid = f.fid AND g.gid = fp.gid AND (fp.canpostreplys != 0)) as CanPostReply,
      (SELECT group_concat(g.title ORDER BY g.title ASC SEPARATOR ', ')
          FROM my_forumpermissions fp, my_usergroups g
        WHERE fp.fid = f.fid AND g.gid = fp.gid AND (fp.canpostthreads != 0)) as CanPostThreads
  FROM `my_forums` f
order by 1

How would I need to handle inherited permissions?
Reply


Messages In This Thread
List members that can access each forum - by warpedone - 2020-02-29, 12:56 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)