phpBB.de

Code: Alles auswählen

//
// MOD START - TOP 'X' USERS MOD - AbelaJohnB
//		This function will be used to acquire the "Top 'x'" members of your forum.
//		It can be called on any page that this file is included on.
//		You can specific the amount of members it returns by chaning the function input string.
//		Example:
//					top_posters('10', x, x) will return Top Ten Members
//					top_posters('5', x, x) will return Top Five Members
//
//		If you want to limit ADMIN and/or MOD from showing, use the following methods:
//
//					top_posters('10', 1, 1) Top Ten Members, Show both ADMIN & MOD
//					top_posters('10', 1, 0) Top Ten Members, Show both ADMIN, but not MOD
//					top_posters('10', 0, 1) Top Ten Members, Show both MOD, but not ADMIN
//					top_posters('10', 0, 0) Top Ten Members, Show neither ADMIN nor MOD
//

function top_posters($str_input, $show_admin, $show_mod)
{
	global $db, $phpEx, $theme;
	// Show All
	if ( ( $show_admin == '1' ) && ( $show_mod == '1' ) )
	{
		$sql = "SELECT u.user_id, u.username, u.user_posts, u.user_level, count(u.user_id) as user_posts
		FROM " . USERS_TABLE . " u, " . POSTS_TABLE . " p 
		WHERE (u.user_id <> " . ANONYMOUS . ") AND (u.user_id = p.poster_id) 
		GROUP BY user_id, username
		ORDER BY user_posts DESC
		LIMIT $str_input";
	}
	// Show Admin But Not Moderators
	elseif ( ( $show_admin == '1' ) && ( $show_mod == '0' ) )
	{
		$sql = "SELECT u.user_id, u.username, u.user_posts, u.user_level, count(u.user_id) as user_posts
		FROM " . USERS_TABLE . " u, " . POSTS_TABLE . " p 
		WHERE (u.user_id <> " . ANONYMOUS . ") AND (u.user_id = p.poster_id) AND (u.user_level != " . MOD . ") 
		GROUP BY user_id, username
		ORDER BY user_posts DESC
		LIMIT $str_input";
	}
	// Show Moderators But Not Admins
	elseif ( ( $show_admin == '0' ) && ( $show_mod == '1' ) )
	{
		$sql = "SELECT u.user_id, u.username, u.user_posts, u.user_level, count(u.user_id) as user_posts
		FROM " . USERS_TABLE . " u, " . POSTS_TABLE . " p 
		WHERE (u.user_id <> " . ANONYMOUS . ") AND (u.user_id = p.poster_id) AND (u.user_level != " . ADMIN . ") 
		GROUP BY user_id, username
		ORDER BY user_posts DESC
		LIMIT $str_input";
	}
	// Show Neither Admins Nor Moderators
	else/// ( ( $show_admin == '0' ) && ( $show_mod == '0' ) )
	{
		$sql = "SELECT u.user_id, u.username, u.user_posts, u.user_level, count(u.user_id) as user_posts
		FROM " . USERS_TABLE . " u, " . POSTS_TABLE . " p 
		WHERE (u.user_id <> " . ANONYMOUS . ") AND (u.user_id = p.poster_id) AND (u.user_level != " . ADMIN . ") AND (u.user_level != " . MOD . ") 
		GROUP BY user_id, username
		ORDER BY user_posts DESC
		LIMIT $str_input";
	}
	//
	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not query forum top poster information', '', __LINE__, __FILE__, $sql);
	}
	// $top_posters = array();
	while( $row = $db->sql_fetchrow($result) )
	{
				$style_color = '';
				if ( $row['user_level'] == ADMIN )
				{
					$row['username'] = '<b>' . $row['username'] . '</b>';
					$style_color = 'style="color:#' . $theme['fontcolor3'] . '"';
				}
				else if ( $row['user_level'] == MOD )
				{
					$row['username'] = '<b>' . $row['username'] . '</b>';
					$style_color = 'style="color:#' . $theme['fontcolor2'] . '"';
				}
		$top_posters .= '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '"' . $style_color .'>' . $row['username'] . '</a>(' . $row['user_posts'] . '), ';
	}
  return $top_posters;
}
// MOD END - TOP 'X' USERS MOD - AbelaJohnB