Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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
#2
Permission Viewer plugin can be of some help.
[when I tried last time, it did not have pagination. not sure if it was improved later ..]
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)