UBB.Developers Forums UBB.threads 7 Development Addons and Modifications [7.0.x] Top Posters in Last X Days

<?php
// Number of days - Top Posters in X days - Edit as needed
$days = 1;

if (!defined('UBB_MAIN_PROGRAM')) {
	exit;
}
$today = $html -> get_date();
$limittime = ($today - ($days * 86400));

$query = "
	SELECT 
		COUNT(*) as Total, p.USER_ID, u.USER_DISPLAY_NAME, 
		u.USER_MEMBERSHIP_LEVEL, up.USER_NAME_COLOR
	FROM {$config['TABLE_PREFIX']}POSTS p,
			 {$config['TABLE_PREFIX']}USERS u,
			 {$config['TABLE_PREFIX']}USER_PROFILE up
	WHERE u.USER_ID = up.USER_ID
	AND	 p.POST_POSTED_TIME > $limittime
	AND	 p.USER_ID != 1
	AND		p.USER_ID = u.USER_ID
	GROUP BY p.USER_ID ORDER BY Total DESC
	limit {$config['TOP_POSTERS']}
";
$sth = $dbh->do_query($query);
$users = array();
$i = 0;
while(list($total,$uid,$username,$memberlevel,$namecolor) = $dbh->fetch_array($sth)) {
	$users[$i]['namecolor'] = $html->user_color($username, $namecolor, $memberlevel);
	$users[$i]['name'] = $username;
	$users[$i]['posts'] = $total;
	$users[$i]['uid'] = $uid;
	$i++;
}

$smarty->assign("users",$users);

$island = $smarty->fetch("island_top_posters.tpl");

lock_and_write("{$config['FULL_PATH']}/cache/top_posters.php",$island);

@chmod("{$config['FULL_PATH']}/cache/top_posters.php",0666);

?>