phpBB.de

Code: Alles auswählen

$sql = "SELECT * FROM " . FORUMS_TABLE;
if(!($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
}
$forums = array();
while( $row = $db->sql_fetchrow($result) )
{
	$forums[] = $row;
}
$db->sql_freeresult($result);

$is_auth_ary = array();
$is_auth_ary = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata);

$auth_forums = '\'start\'';
for( $i = 0; $i < count($forums); $i++ )
{
	if(!$is_auth_ary[$forums[$i]['forum_id']]['auth_view'])
	{
		if( $auth_forums == '\'start\'' )
		{
			$auth_forums = $forums[$i]['forum_id'];
		}
		else
		{
			$auth_forums .= ','. $forums[$i]['forum_id'];
		}
	}
}

$sql = "SELECT count(p.post_id) AS post_count, p.topic_id, t.topic_title 
	FROM " . POSTS_TABLE . " AS p, " . TOPICS_TABLE . " AS t
		WHERE p.forum_id NOT IN (" . $auth_forums . ")
		AND p.post_time > " . (time() - 2419200) . "
		AND p.topic_id = t.topic_id
		AND p.post_id <> t.topic_first_post_id 
	GROUP BY p.topic_id 
	ORDER BY post_count DESC
	LIMIT 0,10";