Page 2 of 2
Exclude forums from Recent Active
Posted: 01 Dec 2011, 10:41
by Stoker
AND topic_approved
Exclude forums from Recent Active
Posted: 01 Dec 2011, 10:44
by Blackwolf
Thankyou
So instead of
what do I input please....otherwise I get a general error.
Exclude forums from Recent Active
Posted: 01 Dec 2011, 10:50
by Stoker
try: AND forum_id <> 59
Exclude forums from Recent Active
Posted: 01 Dec 2011, 10:56
by Blackwolf
Code: Select all
WHERE ' . $db->sql_in_set('t.forum_id', $flist) . ' AND topic_moved_id = 0 AND topic_approved AND forum_id <> 59
This is how I am doing it....with a space....without a space.....
This is the result.
Exclude forums from Recent Active
Posted: 01 Dec 2011, 11:51
by Stoker
and which error did this produce: AND t.forum_id <> 59
?
Exclude forums from Recent Active
Posted: 01 Dec 2011, 12:08
by Blackwolf
Well....mark it as solved.
I don't know how or why...but I logged in as a test user & the normal member cannot see the posts made in the Administrator Area anyway. Probably due to the permissions.
Sorry to waist your valuable time
Stoker.
Exclude forums from Recent Active
Posted: 01 Dec 2011, 12:14
by Stoker
No problem
Exclude forums from Recent Active
Posted: 05 Dec 2011, 23:33
by RMcGirr83
doktornotor wrote:Stoker wrote:Could be: AND t.forum_id <> 11 AND t.forum_id <> 18
Or maybe something like:
Code: Select all
$recent_forums_excluded = array(1,2,3,4,5);
...
AND !in_array($data['t.forum_id'], $recent_forums_excluded)
Code: Select all
AND ' . $db->sql_in_set('t.forum_id', $recent_forums_excluded, false)