Remove Staff From Top Posters List

Current Version: 1.0.6
Released: 09.01.10
Forum rules
Before creating a new support thread, please take a look in the board3 Portal FAQ and use the search!
Many questions have already been answered.
Locked

Topic author
dragz
Valued Contributor
Posts: 70
Joined: 17. September 2008 17:18

Remove Staff From Top Posters List

Post by dragz »

Your Portal Version: 1.2
Your phpBB Type: Premodded phpBB
MODs installed: Yes
Your knowledge: Beginner
Boardlink: http://maxxforum.co.nr

What have you done before the problem was there?


What have you already tryed to solve the problem?


Description and Message
I don't want my staff to be on the top posters list. Can anyone help me to remove them from the top list?
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: Remove Staff From Top Posters List

Post by Kevin »

Quick & dirty, not tested:

Open portal/block/top_posters.php

Search:

Code: Select all

$sql = 'SELECT user_id, username, user_posts, user_colour
    FROM ' . USERS_TABLE . '
    WHERE user_type <> ' . USER_IGNORE . '
        AND user_posts <> 0
    ORDER BY user_posts DESC';
$result = $db->sql_query_limit($sql, $portal_config['portal_max_most_poster']); 
replace with:

Code: Select all

$sql = 'SELECT user_id, username, user_posts, user_colour
    FROM ' . USERS_TABLE . '
    WHERE user_type <> ' . USER_IGNORE . '
        AND user_posts <> 0
        AND group_id != 3 
    ORDER BY user_posts DESC';
$result = $db->sql_query_limit($sql, $portal_config['portal_max_most_poster']); 
You need to set the correct group ID, which you want to exclude in
AND group_id != 3
(in this example = 3)
You can add more lines like this, for each group you want to exclude.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!

Topic author
dragz
Valued Contributor
Posts: 70
Joined: 17. September 2008 17:18

Re: Remove Staff From Top Posters List

Post by dragz »

Thanks a lot, I'll try

dv-design
Active Member
Posts: 25
Joined: 22. October 2008 21:02

Re: Remove Staff From Top Posters List

Post by dv-design »

I tried making this change and i still show up in this box. How can i find out what group numbers correspond to which group?

Topic author
dragz
Valued Contributor
Posts: 70
Joined: 17. September 2008 17:18

Re: Remove Staff From Top Posters List

Post by dragz »

Me too have the same above question. How can I find the group id?
User avatar

Kevin
Site Admin
Posts: 2989
Joined: 7. January 2006 20:11
phpBB.de User: Saint
phpBB.com User: Saint_hh
Location: Hamburg
Contact:

Re: Remove Staff From Top Posters List

Post by Kevin »

Point on a link to the group.
E.g. memberlist.php?mode=group&g=9 is the link to our testgroup.
mode=group&g=9 <-- this is the group ID.
~~~ They say the definition of madness is doing the same thing and expecting a different result ~~~

Kein Support per PN / No support via PM!
Locked

Return to “board3 Portal 1.0.x - English Support”