Page 2 of 2
Exclude forums from Recent Active
Posted: 01 Dec 2011, 10:41
by Stoker
AND topic_approved
![Cool 8-)](./images/smilies/icon_cool.gif)
Exclude forums from Recent Active
Posted: 01 Dec 2011, 10:44
by Blackwolf
![Happy :thumb:](./images/smilies/good2.gif)
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.
![Embarrassed :oops:](./images/smilies/icon_redface.gif)
Exclude forums from Recent Active
Posted: 01 Dec 2011, 12:14
by Stoker
No problem
![Wink ;)](./images/smilies/icon_e_wink.gif)
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)
![Wink ;)](./images/smilies/icon_e_wink.gif)