MyBB Community Forums

Full Version: Mybb portal - exclude forums from latest posts
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
on the mybb portal it lists all the forums latests posts, i'd love to be able to exclude say spam sections or random posts sections from showing.

I've managed to go it for "new posts" by setting can search to "no" but it doesn't affect latest posts on portal.

any ideas?Confused
In portal.php, find:
        $query = $db->query("
                SELECT t.*, u.username
                FROM ".TABLE_PREFIX."threads t
                LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)
                WHERE 1=1 $unviewwhere AND t.visible='1' AND t.closed NOT LIKE 'moved|%'
                ORDER BY t.lastpost DESC
                LIMIT 0, ".$mybb->settings['portal_showdiscussionsnum']
        );
Replace with:
        $query = $db->query("
                SELECT t.*, u.username
                FROM ".TABLE_PREFIX."threads t
                LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=t.uid)
                WHERE 1=1 $unviewwhere AND t.visible='1' AND t.closed NOT LIKE 'moved|%'
                        AND t.fid NOT IN(X,Y,Z)
                ORDER BY t.lastpost DESC
                LIMIT 0, ".$mybb->settings['portal_showdiscussionsnum']
        );

Replace X,Y,Z, with the forum IDs you want to exclude.