Anonymous

<?PHP

$forum_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

		{$table_prefix}topics.topic_title,

		{$table_prefix}users.username AS poster_name,

		{$table_prefix}topics.topic_time,

		{$table_prefix}posts_text.post_text AS topic_text,

		{$table_prefix}topics.topic_views,

		{$table_prefix}topics.topic_replies,

		{$table_prefix}topics.topic_id,

		{$table_prefix}posts_text.post_id,

		{$table_prefix}topics.topic_poster AS poster_id

	FROM

		{$table_prefix}topics,

		{$table_prefix}users,

		{$table_prefix}posts_text

	WHERE

		{$table_prefix}topics.forum_id = {$forum_id} AND

		{$table_prefix}users.user_id =

		{$table_prefix}topics.topic_poster AND

		{$table_prefix}posts_text.post_id =

		{$table_prefix}topics.topic_first_post_id

	ORDER BY topic_time DESC

	LIMIT {$limit_count};");

?>



<?PHP

	if($topics_query && mysql_num_rows($topics_query)) {

?>     

	<?PHP

        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]";

                $post_id = $topic_entry["post_id"];

                $view_link = "{$phpbb_root_path}viewtopic.{$phpEx}?p={$post_id}";

                echo "<li><a title=\"$topic_title\" href=\"$view_link\">$topic_title<br>posted by: $poster_name [$topic_replies/$topic_views]</a></li>";	

        }

	}

}

?>