|
Joined: Jul 2006
Posts: 47
journeyman
|
journeyman
Joined: Jul 2006
Posts: 47 |
Is it possible to exclued a particular user from displaying his or hers NAME and TOTAL POST NUMBER?
For example, Rick has over 2500 posts (currently). Is it possible to exclude Rick from TOP POSTERS table?
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
You could edit the coding to exclude ricks uid in the sql statement in the appropriate files (I believe top posters island is built from cache_builders/top_posters.php).
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Just screwing around wiht the query, completely untested and i'm half asleep so i don't know if it'll work, but you could try something similar to: Change: $query = "
select t1.USER_ID,t1.USER_DISPLAY_NAME,t2.USER_TOTAL_POSTS
from {$config['TABLE_PREFIX']}USERS as t1,
{$config['TABLE_PREFIX']}USER_PROFILE as t2
where t1.USER_ID <> 1
and t1.USER_ID = t2.USER_ID
and t1.USER_IS_APPROVED = 'yes'
order by t2.USER_TOTAL_POSTS desc
limit {$config['TOP_POSTERS']}
"; To: $query = "
select t1.USER_ID,t1.USER_DISPLAY_NAME,t2.USER_TOTAL_POSTS
from {$config['TABLE_PREFIX']}USERS as t1,
{$config['TABLE_PREFIX']}USER_PROFILE as t2
where t1.USER_ID <> 1
and t1.USER_ID != 1
and t1.USER_ID = t2.USER_ID
and t1.USER_IS_APPROVED = 'yes'
order by t2.USER_TOTAL_POSTS desc
limit {$config['TOP_POSTERS']}
"; Adding the uID of users to ban (in this case, the line below):
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Should also be good to point out that you can add numerous lines like what i added again and again with seperate uid's. Also, be sure to clear your cache after updating the cache builder. Also it's good to note that by modifying stock code you may be voiding your access to official support from Groupee on your forums, and that you may be required to restore the code to stock before requesting support through a support ticket (just a small disclaimer I try to include when showing people how to break, err modify,things .
|
|
|
|
Joined: Jul 2006
Posts: 47
journeyman
|
journeyman
Joined: Jul 2006
Posts: 47 |
It is working. Thank you.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Not a problem, glad I could be of service .
|
|
|
|
Joined: May 2007
Posts: 145
member
|
member
Joined: May 2007
Posts: 145 |
Why is it that my forum panels only show 5 top posters but this website forum shows 10? Thanks.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
You can control how many show via the control panel I think. We changed ours but don't recall 100% if it was a code hack or Control Panel entry, I think it's a control panel entry.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
CP -> Portal -> Portal Settings -> Total # of Top Posters to list
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
1 members (Nightcrawler),
1,165
guests, and
234
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|