|
|
Joined: Jan 2007
Posts: 70
Power User
|
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.
|
|
|
|
Joined: Nov 2003
Posts: 482
Enthusiast
|
Enthusiast
Joined: Nov 2003
Posts: 482 |
open cache_builders/top_posters.php $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 you could also instead, futz with the limit line and put in limit 2,10 so it skips the top one.. eg: $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
|
|
|
|
Joined: Jan 2007
Posts: 70
Power User
|
Power User
Joined: Jan 2007
Posts: 70 |
Thank You sirdude
|
|
|
|
Joined: Jan 2000
Posts: 5,833 Likes: 20
UBBDev / UBBWiki Owner Time Lord
|
UBBDev / UBBWiki Owner Time Lord
Joined: Jan 2000
Posts: 5,833 Likes: 20 |
SD skins cats; meanie... :x... Good easy mod though
|
|
|
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.
|
|
Posts: 5,833
Joined: January 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|