phpBB.de

Code: Alles auswählen

	$sql =
		'SELECT
			post_id,
			topic_id,
			poster_id,
			post_time,
			post_subject,
			post_text,
			forum_id,
			bbcode_uid,
			bbcode_bitfield,
			user_id,
			username
		FROM
			'.$table_prefix.'posts,
			'.$table_prefix.'users
		WHERE
			forum_id = 21 AND poster_id = user_id OR forum_id = 23 AND poster_id = user_id OR forum_id = 24 AND poster_id = user_id
		ORDER BY
			post_id DESC LIMIT 8';

Code: Alles auswählen

	$sql =
		'SELECT
			p.post_id,
			p.topic_id,
			p.poster_id,
			p.post_time,
			p.post_subject,
			p.post_text,
			p.forum_id,
			p.bbcode_uid,
			p.bbcode_bitfield,
			u.user_id,
			u.username,
			t.topic_first_post_id
		FROM
			'.$table_prefix.'posts p,
			'.$table_prefix.'topics t,
			'.$table_prefix.'users u
		WHERE
			p.forum_id = 21 AND p.poster_id = u.user_id AND p.post_id = t.topic_first_post_id OR p.forum_id = 23 AND p.poster_id = u.user_id AND p.post_id = t.topic_first_post_id OR p.forum_id = 24 AND p.poster_id = u.user_id AND p.post_id = t.topic_first_post_id
		ORDER BY
			post_id DESC LIMIT 8';