AND topic_approved
Exclude forums from Recent Active
- Blackwolf
- BBCoder IV
- Posts: 272
- Joined: 04 Dec 2010, 12:36
- BBCodes: 101
- Favourite BBCode: Dropcap
- Favourite MOD: mchat
- Location: Melbourne Australia
Exclude forums from Recent Active
Thankyou
So instead of
what do I input please....otherwise I get a general error.
So instead of
Code: Select all
AND t.forum_id <> 59
Ultimate Edition, Ultimate Edition Oz, Oz Unity
“We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.”
“We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.”
- Blackwolf
- BBCoder IV
- Posts: 272
- Joined: 04 Dec 2010, 12:36
- BBCodes: 101
- Favourite BBCode: Dropcap
- Favourite MOD: mchat
- Location: Melbourne Australia
Exclude forums from Recent Active
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 the result.
Ultimate Edition, Ultimate Edition Oz, Oz Unity
“We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.”
“We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.”
- Stoker
- Site Admin
- Posts: 3536
- Joined: 12 May 2008, 23:26
- BBCodes: 239
- Favourite BBCode: Anipro
- Favourite MOD: PrettyPhoto
- Location: Denmark
- Contact:
Exclude forums from Recent Active
and which error did this produce:
AND t.forum_id <> 59
?Board rules! No PM support
- Blackwolf
- BBCoder IV
- Posts: 272
- Joined: 04 Dec 2010, 12:36
- BBCodes: 101
- Favourite BBCode: Dropcap
- Favourite MOD: mchat
- Location: Melbourne Australia
Exclude forums from Recent Active
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.
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.
Ultimate Edition, Ultimate Edition Oz, Oz Unity
“We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.”
“We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.”
Exclude forums from Recent Active
doktornotor wrote:Or maybe something like:Stoker wrote:Could be:AND t.forum_id <> 11 AND t.forum_id <> 18
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)