// ayarlar
$CFG['forum_id'] = 2; // haber alınacak forum id
$CFG['max_topics'] = 10; // haber sayısı
//
// Recent topic (only show normal topic)
//
$sql = 'SELECT topic_title, forum_id, topic_id
FROM ' . TOPICS_TABLE . '
WHERE forum_id = $CFG['forum_id'];
AND topic_status <> 2
AND topic_approved = 1
AND topic_type = 0
' . $sql_where . '
ORDER BY topic_time DESC';
$result = $db->sql_query_limit($sql, $CFG['max_topics']);
while( ($row = $db->sql_fetchrow($result)) && ($row['topic_title'] != '') )
{
// auto auth
if ( ($auth->acl_get('f_read', $row['forum_id'])) || ($row['forum_id'] == '0') )
{
$template->
assign_block_vars('latest_topics',
array( 'TITLE' => character_limit($row['topic_title'], $CFG['recent_title_limit']),
'FULL_TITLE' => censor_text($row['topic_title']),
'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&t=' . $row['topic_id'])
)
);
}
}
$db->sql_freeresult($result);