Exclude forums from Recent Active

Download and support for PhpBB3 Top Stats Mod
User avatar
Stoker
Site Admin
Site Admin
Posts: 3521
Joined: 12 May 2008, 23:26
BBCodes: 239
Favourite BBCode: Anipro
Favourite MOD: PrettyPhoto
Location: Denmark
Contact:

Exclude forums from Recent Active

Post by Stoker »

AND topic_approved 8-)
Board rules! No PM support
User avatar
Blackwolf
BBCoder IV
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

Post 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.
Ultimate Edition, Ultimate Edition Oz, Oz Unity

“We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.”
User avatar
Stoker
Site Admin
Site Admin
Posts: 3521
Joined: 12 May 2008, 23:26
BBCodes: 239
Favourite BBCode: Anipro
Favourite MOD: PrettyPhoto
Location: Denmark
Contact:

Exclude forums from Recent Active

Post by Stoker »

try: AND forum_id <> 59
Board rules! No PM support
User avatar
Blackwolf
BBCoder IV
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

Post 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
Ultimate Edition, Ultimate Edition Oz, Oz Unity

“We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.”
User avatar
Stoker
Site Admin
Site Admin
Posts: 3521
Joined: 12 May 2008, 23:26
BBCodes: 239
Favourite BBCode: Anipro
Favourite MOD: PrettyPhoto
Location: Denmark
Contact:

Exclude forums from Recent Active

Post by Stoker »

and which error did this produce: AND t.forum_id <> 59 ?
Board rules! No PM support
User avatar
Blackwolf
BBCoder IV
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

Post 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:
Ultimate Edition, Ultimate Edition Oz, Oz Unity

“We are Anonymous. We are Legion. We do not forgive. We do not forget. Expect us.”
User avatar
Stoker
Site Admin
Site Admin
Posts: 3521
Joined: 12 May 2008, 23:26
BBCodes: 239
Favourite BBCode: Anipro
Favourite MOD: PrettyPhoto
Location: Denmark
Contact:

Exclude forums from Recent Active

Post by Stoker »

No problem ;)
Board rules! No PM support
User avatar
RMcGirr83
BBCoder III
BBCoder III
Posts: 104
Joined: 08 Mar 2010, 13:17
Favourite MOD: mChat
Contact:

Exclude forums from Recent Active

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