Counting Myself Out of Post Count

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.

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

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

Thank You sirdude

SD skins cats; meanie... :x... Good easy mod though