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
Previous Topic
Index