Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jan 2007
Posts: 70
Power User
OP Offline
Power User
Joined: Jan 2007
Posts: 70
How can I make it so my posts don't count or show on the Top Posters list ?

For some reason some of my members like to see where they are on the Top 5 and as I'm the most prolific poster they're having a hard time taking the number one spot so I would like a way to simply not have my posts count as admin.

How do I do that, if at all ?

Thanks.

smile

Sponsored Links
Joined: Nov 2003
Posts: 482
S
Enthusiast
Offline
Enthusiast
S
Joined: Nov 2003
Posts: 482
open cache_builders/top_posters.php

PHP Code
$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 <> YOUR_USER_ID
and t1.USER_ID = t2.USER_ID
and t1.USER_IS_APPROVED = 'yes'
and t1.USER_IS_BANNED <> 1
order by t2.USER_TOTAL_POSTS desc
limit
{$config['TOP_POSTERS']}
"
;

replace YOUR_USER_ID with the numeric value for your USER_ID wink

you could also instead, futz with the limit line and put in limit 2,10 so it skips the top one..

eg:
PHP Code
$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'
and t1.USER_IS_BANNED <> 1
order by t2.USER_TOTAL_POSTS desc
limit 2,
{$config['TOP_POSTERS']}
"
;

all kinds of ways to skin a cat

note: rebuild your cache to see the effect right away wink

Joined: Jan 2007
Posts: 70
Power User
OP Offline
Power User
Joined: Jan 2007
Posts: 70
Thank You sirdude

smile

Joined: Jan 2000
Posts: 5,819
Likes: 16
UBBDev / UBBWiki Owner
Time Lord
Offline
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,819
Likes: 16
SD skins cats; meanie... :x... Good easy mod though wink


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Bill B
Bill B
Issaquah, WA
Posts: 87
Joined: December 2001
Forum Statistics
Forums63
Topics37,558
Posts293,857
Members13,848
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,819
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 70
Gizmo 16
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2022 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Snapshot build 20220120)
Responsive Width:

PHP: 7.3.29 Page Time: 0.015s Queries: 23 (0.008s) Memory: 0.8048 MB (Peak: 0.8427 MB) Data Comp: Zlib Server Time: 2022-01-27 05:10:24 UTC
Valid HTML 5 and Valid CSS