Page 2 of 2

Exclude forums from Recent Active

Posted: 01 Dec 2011, 10:41
by Stoker
AND topic_approved 8-)

Exclude forums from Recent Active

Posted: 01 Dec 2011, 10:44
by Blackwolf
:thumb: Thankyou

So instead of

Code: Select all

AND t.forum_id <> 59
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..... :oops:


This is the result.
error.png

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. :oops:

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)
;)