/* ############## TOP 5 oder 10 Hack © by Shorty############## */
list($showtoplist) = $db->query_first("SELECT value FROM bb".$n."_options WHERE varname='showtoplist' LIMIT 1");
if($showtoplist!=0)
{
	$toplistcount=$showtoplist*5;
	function getSearchableBoards()
	{
		global $db,$n,$wbbuserdata,$boardcache;
		list($excludedboards) = $db->query_first("SELECT value FROM bb".$n."_options WHERE varname='excludedtoplist' LIMIT 1");
		$excludedboards=str_replace("\n",",",trim($excludedboards));
		if(!isset($boardcache) || !is_array($boardcache)) $boardcache=array();
		$result=$db->query("SELECT boardid,boardorder,parentid,parentlist FROM bb".$n."_boards WHERE password='' AND invisible!='2'".((!empty($excludedboards)) ? (" AND boardid NOT IN(".$excludedboards.")") : (""))." ORDER BY parentid ASC, boardorder ASC");
		while($row=$db->fetch_array($result)) {
			$boardcache[$row['parentid']][$row['boardorder']][$row['boardid']] = $row;
		}
 
		$boardpermissions=getPermissions();
		$boardids="";
		foreach($boardcache as $key=>$val)
		{
			foreach($val as $key2=>$val2)
			{
				foreach($val2 as $row) if(!isset($boardpermissions[$row['boardid']]['can_use_search']) || $boardpermissions[$row['boardid']]['can_use_search']!=0) $boardids.=",".$row['boardid'];
			}
		}
		return $boardids;
	}
 
	//Top List Posts
	unset($toplistposters);
	$toplistposters = $db->query("SELECT DISTINCT userid, username, userposts,   useronlinegroupid,  g.useronlinemarking
	FROM bb".$n."_users
	LEFT JOIN bb".$n."_groups g ON (g.groupid=useronlinegroupid) 
	ORDER BY userposts DESC LIMIT $toplistcount");
	while($toplistposter = $db->fetch_array($toplistposters))
	{
		$toplistposterid = $toplistposter['userid'];
		$toplistpostername = htmlconverter(textwrap($toplistposter['username'],25));
		$toplistpostername = sprintf($toplistposter['useronlinemarking'], $toplistposter['username']);
		$toplist_counts = $toplistposter['userposts'];
		eval ("\$toplistposterbit .= \"".$tpl->get("index_toplist_posterbit")."\";");
	}
 
	//Top List New Member
	unset($toplistnewmembers);
	$toplistnewmembers = $db->query("SELECT DISTINCT username,userid,userposts, useronlinegroupid,  g.useronlinemarking 
	 FROM bb".$n."_users 
	 LEFT JOIN bb".$n."_groups g ON (g.groupid=useronlinegroupid)
	 ORDER BY regdate DESC LIMIT $toplistcount");
	while($toplistnewmember = $db->fetch_array($toplistnewmembers))
	{
		$toplistposterid = $toplistnewmember['userid'];
		$toplistpostername = htmlconverter(textwrap($toplistnewmember['username'],25));
		$toplistpostername = sprintf($toplistnewmember['useronlinemarking'], $toplistnewmember['username']);
		$toplist_counts = $toplistnewmember['userposts'];
		eval ("\$toplistmembersbit .= \"".$tpl->get("index_toplist_posterbit")."\";");
	}
 
	//New Posts		
  	$toplistthreads = $db->query ("SELECT DISTINCT bb".$n."_threads.*, 
	bb".$n."_users.username as lastposter , useronlinegroupid,  g.useronlinemarking 
	FROM bb".$n."_threads 
	LEFT JOIN bb".$n."_users ON (bb".$n."_threads.lastposterid=bb".$n."_users.userid) 
	LEFT JOIN bb".$n."_groups g ON (g.groupid=useronlinegroupid)
	WHERE  bb".$n."_threads.boardid IN (0".getSearchableBoards().") AND bb".$n."_threads.closed!=3 ORDER BY bb".$n."_threads.lastposttime DESC LIMIT $toplistcount");
	while($toplistthread = $db->fetch_array($toplistthreads))
	{
		$toplistthreadid = $toplistthread['threadid'];
 		if(strlen($toplistthread['topic']) > "30"){ $toplistthread['topic'] = "".substr($toplistthread['topic'], 0, 30);$toplistthread['topic'].=" ...";};
		$toplistthreadname = htmlconverter(textwrap($toplistthread['topic']));
		$toplistposterid = $toplistthread['lastposterid'];
		$toplist_counts = $toplistthread['views'];
		$toplistpostername = htmlconverter(textwrap($toplistthread['lastposter'],25));
		$toplistpostername = sprintf($toplistthread['useronlinemarking'], $toplistthread['lastposter']);
		eval ("\$toplistthreadbit .= \"".$tpl->get("index_toplist_threadbit")."\";");
	}
 
	//Top Clicks
	$topclicks=$db->query_first("SELECT DISTINCT topic,views,threadid FROM bb".$n."_threads WHERE bb".$n."_threads.boardid IN (0".getSearchableBoards().") AND bb".$n."_threads.closed!=3 ORDER BY views DESC LIMIT 1");
	$topthreadid=$topclicks['threadid'];
	$topthreadname=htmlconverter(textwrap($topclicks['topic']));
	$topclicksviews = $topclicks['views'];
	eval ("\$topclickstitle .= \"".$tpl->get("index_toplist_topthreadbit")."\";");
 
 
	//Top Vote
	$topvote=$db->query_first("SELECT DISTINCT topic,voted,votepoints,threadid  FROM bb".$n."_threads WHERE bb".$n."_threads.boardid IN (0".getSearchableBoards().") AND bb".$n."_threads.closed!=3  ORDER BY voted DESC LIMIT 1");
	$topthreadid=$topvote['threadid'];
	$topthreadname=htmlconverter(textwrap($topvote['topic']));
	$votedrating = $topvote['votepoints'];
	eval ("\$votedthread .= \"".$tpl->get("index_toplist_topthreadbit")."\";");
 
 
	//Sprachvariablen einlesen
	eval ("\$toplisttoplist .= \"".$lang->get("LANG_START_TOPLIST_TOPLIST")."\";");
	eval ("\$toplistposter .= \"".$lang->get("LANG_START_TOPLIST_TOPPOSTER")."\";");
	eval ("\$toplistnew_members .= \"".$lang->get("LANG_START_TOPLIST_NEWMEMBERS")."\";");
	eval ("\$toplistlastpost .= \"".$lang->get("LANG_START_TOPLIST_LASTPOST")."\";");
	eval ("\$toplistusername .= \"".$lang->get("LANG_START_TOPLIST_USERNAME")."\";");
	eval ("\$toplistposts .= \"".$lang->get("LANG_START_TOPLIST_POSTS")."\";");
	eval ("\$toplisttitle .= \"".$lang->get("LANG_START_TOPLIST_TITLE")."\";");
	eval ("\$toplistclicks .= \"".$lang->get("LANG_START_TOPLIST_CLICKS")."\";");
	eval ("\$toplistvotes .= \"".$lang->get("LANG_START_TOPLIST_VOTES")."\";");
	eval ("\$toplistratings .= \"".$lang->get("LANG_START_TOPLIST_RATINGS")."\";");
	eval ("\$toplistthread .= \"".$lang->get("LANG_START_TOPLIST_THREAD")."\";");
 
	eval ("\$toplist = \"".$tpl->get("index_toplist")."\";");
}
 
/* ############## TOP 5 oder 10 Hack © by Shorty############## */