代碼: 選擇全部
$active_topics_sql="SELECT a.topic_id,a.topic_title, a.topic_replies, a.topic_last_post_id, c.post_time, d.forum_id, d.forum_name
FROM phpbb_topics a, phpbb_users b, phpbb_posts c, phpbb_forums d
where a.topic_last_post_id=c.post_id and b.user_id=c.poster_id
and d.forum_id=a.forum_id
and d.auth_view=0
ORDER BY topic_last_post_id DESC
LIMIT 5";
$active_topics = $db->sql_query($active_topics_sql);
while (($line = mysql_fetch_array($active_topics)))
{
if (strlen($line['forum_name']) > 40)
{
$line_topic_title = substr($line['forum_name'], 0, 40)." ...";
}
else
{
$line_topic_title = $line['forum_name'];
}
$lastpost = "<a href=\"".$phpbb_root_path."announce.php?f=" . $line['forum_id'] . "\" title=\"" . $line['forum_name'] ."\">" . $line_topic_title . "</a>";
$template->assign_block_vars('topicrecentpopular', array(
'TOPICSRECENT' => $lastpost)
);
}
請問包子大，該怎麼改><!!
