rendered paste body<?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};");?><h4>forum posts</h4><ul id="forum-posts"> <?PHP 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]"; $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>"; } } ?></ul><?PHP}?>