// 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'] . '&amp;t=' . $row['topic_id'])
			)
		);
	}	
}
$db->sql_freeresult($result);