echo'</div><div id="user2"><center><b>Top Forenbeitr&auml;ge</b></center><hr class="footer-hr">';

echo "<td valign='top'>";



echo "<p style='text-align:left'><span class='alt' style='font-weight:bold'>Letzten Foren</span>";

$result = dbquery("SELECT tf.forum_id, tt.thread_id, tt.thread_subject, COUNT(tp.post_id) as count_posts FROM ".DB_PREFIX."forums tf INNER JOIN ".DB_PREFIX."threads tt USING(forum_id) INNER JOIN ".DB_PREFIX."posts tp USING(thread_id) WHERE ".groupaccess('forum_access')." GROUP BY thread_id ORDER BY count_posts DESC, thread_lastpost DESC LIMIT 5");

	if (dbrows($result) != 0)

	{

	while($data = dbarray($result))

	{

	$itemsubject = trimlink($data['thread_subject'], 25);

	echo "<br>

	<img border='0' src='".THEME."images/bullet1.gif'>

	<a  href='".FORUM."viewthread.php?forum_id=".$data['forum_id']."&thread_id=".$data['thread_id']."' title='".$data['thread_subject']."' >$itemsubject</a>\n";

	}

	

	}

	else

	{

	echo "<div style='text-align:left'>Keine Forenbeitr&auml;ge vorhanden</div>\n";

	}

	echo "</td>";