Question User Groups, User Group Privileges, ACLs

foreach($rows as $row) { if (($gid == 24 || $gid == 25) or ($row->moderated and $row->ismod) or ($row->pub_access == 0) or ($row->pub_access == -1 and $uid > 0) or ($row->pub_access > 0 and _has_rights($kunena_acl, $gid, $row->pub_access, $row->pub_recurse)) or ($row->admin_access > 0 and _has_rights($kunena_acl, $gid, $row->admin_access, $row->admin_recurse)) ) $catlist .= (($catlist == '')?'':',').$row->id; //check if forum is private and remove it from the list (dirty but can't think of a better way to do this at the moment without adding more tables of fields and wouldn't work as part of the above query $privateforum = "select forum_id as isprivate from #__fb_usergroup_forums where forum_id=$row->id LIMIT 1"; $kunena_db->setQuery($privateforum); $isprivate = $kunena_db->loadResult(); if(!empty($isprivate)) { $catlist = str_replace(','.$row->id, '', $catlist); } //Get the usergroups for the forums $group_query="SELECT a.forum_id from #__fb_usergroup_forums a join #__fb_usergroup_members b ON a.group_id=b.group_id where a.forum_id=".$row->id." and b.user_id={$uid}"; $kunena_db->setQuery($group_query); $groups = $kunena_db->loadObjectList(); foreach($groups as $group) { $catlist .= (($catlist == '')?'':',').$group->forum_id; }