Someone

<?PHP
$cat_id = 1;
$limit_count = 10;
$phpbb_root_path = "forum/";

if(!defined("IN_PHPBB"))
{
  define("IN_PHPBB", true);
  include($phpbb_root_path . "extension.inc");
  include($phpbb_root_path . "common.".$phpEx);
  include($phpbb_root_path . "config.".$phpEx);
}

if($db) {
	/*$topics_query = $db->sql_query("
		SELECT DISTINCT
			{$table_prefix}topics.topic_title, 
			{$table_prefix}topics.topic_id, 
			{$table_prefix}topics.topic_replies, 
			{$table_prefix}topics.topic_views, 
			{$table_prefix}topics.topic_poster
                        {$table_prefix}users.username AS poster_name,
                        {$table_prefix}users.user_id
		FROM 
			{$table_prefix}topics, 
			{$table_prefix}users
		LEFT JOIN 
			{$table_prefix}forums ON cat_id = {$cat_id}
                WHERE 
                        {$table_prefix}_users.user_id = {$table_prefix}_topics.topic_poster
		ORDER BY 
			{$table_prefix}topics.topic_id
		DESC LIMIT 
			{$limit_count};
	");*/
	$topics_query = $db->sql_query("
		SELECT 
			{$table_prefix}topics.topic_title, 
			{$table_prefix}topics.topic_id, 
			{$table_prefix}topics.topic_replies, 
			{$table_prefix}topics.topic_views, 
			{$table_prefix}topics.topic_poster, 
			{$table_prefix}users.username AS poster_name,
			{$table_prefix}users.user_id
		FROM 
			{$table_prefix}topics, 
			{$table_prefix}users
		LEFT JOIN 
			{$table_prefix}forums ON cat_id = {$cat_id}
		WHERE 
			{$table_prefix}_users.user_id = {$table_prefix}_topics.topic_poster			
		ORDER BY 
			{$table_prefix}topics.topic_id
		DESC LIMIT 
			{$limit_count};
	");
	
	if($topics_query && mysql_num_rows($topics_query)) {
           while($topic_entry = $db->sql_fetchrow($topics_query)) {
                $poster_name = $topic_entry["poster_name"];
                $topic_title = $topic_entry["topic_title"];
                $topic_replies = $topic_entry["topic_replies"];
                $topic_views = $topic_entry["topic_views"];
                $topic_id = $topic_entry["topic_id"];
                $view_link = "{$phpbb_root_path}viewtopic.{$phpEx}?t={$topic_id}";
                echo "<li><a title=\"$topic_title\" href=\"$view_link\">$topic_title<br>posted by: $poster_name [$topic_replies/$topic_views]</a></li>";			   	
           }
	}
}
?>