no worries will see what I can do.
I don't mind if this gets scrapped I am baically done, and to be honest this is a dirty way of doing things but it also gets the job done.
My coding style is different from the kunena forums, and I think over all you guys are more skilled than I am.
At the moment, what I will do is finish this as it will only take me a little time, and I won't have to add any more majore changes, then submit the code and you guys can choose whether you want to use any of it or not. Once I am done I will join in and chat to you guys and see wht you think.
I need to write this regardless as I need it to go live with my forums, so I may as well finish it.
I did have to add another query, as for some reason I couldn't get it to work as part of the other queries, but again it's a small one and should add no noticable overheads, it does a dirty replace on the $catlist variable, but means that I don't have to edit any existing tables and making a forum private is simply a matter of making it restricted to any current Joomla ACL group like "author" then if it finds the forum in the usergroup list, it restricts it from view.
Very dirty I know
Code:
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;
}
