phpBB.de

Code: Alles auswählen

$sql = 'SELECT * FROM phpbb_topics, phpbb_posts ORDER BY topic_time, post_time DESC LIMIT 0,5';

Code: Alles auswählen

$topic_length = '30';	// length of topic title
$topic_limit = '7';	// limit of displayed topics
$special_forums = '1';	// specify forums ('0' = no; '1' = yes)
$forum_ids = '1,2,3,4,7,8,9,10,15,19,26,30,31,32,33,34,39,41,42,43,44,46,47,48,49,53,54,55,59,61,62,63,64,65,66,67,68';		// IDs of forums; separate them with a comma

Code: Alles auswählen

$where_forums = ( $special_forums == '0' ) ? '' : 't.forum_id IN ('. $forum_ids .') AND ';
$sql = "SELECT t.*, f.forum_id, f.forum_name, u.username AS first_poster, u.user_id AS first_poster_id, u2.username AS last_poster, u2.user_id AS last_poster_id, p.post_username AS first_poster_name, p2.post_username AS last_poster_name, p2.post_time
	FROM ". $table_prefix ."topics t, ". $table_prefix ."forums f, ". $table_prefix ."users u, ". $table_prefix ."posts p, ". $table_prefix ."posts p2, ". $table_prefix ."users u2
	WHERE $where_forums t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id".$querytoadd."
	ORDER BY t.topic_last_post_id DESC LIMIT $topic_limit";

$result = mysql_query($sql);


if( !$result )
{
	die('SQL Statement Error: '. mysql_error());
	exit();
}

Code: Alles auswählen

$sql = 'SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username'
        . ' FROM phpbb_topics t, phpbb_forums f, phpbb_posts p, phpbb_users u'
        . ' WHERE t.topic_id = p.topic_id AND '
        . ' f.forum_id = t.forum_id AND '
        . ' t.topic_status <> 2 AND '
        . ' p.post_id = t.topic_last_post_id AND '
        . ' p.poster_id = u.user_id'
        . ' ORDER BY p.post_id DESC LIMIT 5';