Page 1 of 1
Remove Staff From Top Posters List
Posted: 22. October 2008 11:56
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?
Re: Remove Staff From Top Posters List
Posted: 22. October 2008 13:04
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.
Re: Remove Staff From Top Posters List
Posted: 22. October 2008 16:58
by dragz
Thanks a lot, I'll try
Re: Remove Staff From Top Posters List
Posted: 23. October 2008 22:57
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?
Re: Remove Staff From Top Posters List
Posted: 24. October 2008 10:06
by dragz
Me too have the same above question. How can I find the group id?
Re: Remove Staff From Top Posters List
Posted: 24. October 2008 20:49
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.