Code: Alles auswählen
$sql = "SELECT f.*, p.post_time, p.topic_id, p.post_username, t.topic_title, u.username, u.user_id
FROM (( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id ),
" . TOPICS_TABLE . " t
WHERE t.topic_id = p.topic_id
AND t.topic_last_post_id = f.forum_last_post_id
ORDER BY f.cat_id, f.forum_order";Code: Alles auswählen
$ltid = $forum_data[$j]['topic_id'];
$lttitle = $forum_data[$j]['topic_title'];
// append first 25 characters of topic title to last topic data
if (strlen($lttitle) > 22)
{
$last_post = '<a href="' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$ltid") . '">' . substr($lttitle, 0, 20) . '...</a><br />';
}
else
{
$last_post = '<a href="' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$ltid") . '">' . substr($lttitle, 0, 22) . '</a><br />';
}
$last_post_time = create_date($board_config['default_dateformat'], $forum_data[$j]['post_time'], $board_config['board_timezone']);
$last_post .= $last_post_time . '<br />';