MyBB Community Forums
List members that can access each forum - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Security Management and Support (https://community.mybb.com/forum-179.html)
+--- Thread: List members that can access each forum (/thread-226673.html)



List members that can access each forum - warpedone - 2020-02-29

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?


RE: List members that can access each forum - .m. - 2020-02-29

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 ..]