Някой може ли да ми редактира този код така, че да ми изкарва последно коментираните теми
PHP:
<?php
include "forum/config.php";
//Брой на последните теми, които искате да се показват
$latest = "8";
$link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
if (!$link)
{
die('Not connected : ' . mysql_error());
}
$db_selected = mysql_select_db("$dbname", $link);
if (!$db_selected)
{
die ('Can\'t use foo : ' . mysql_error());
}
mysql_query("SET NAMES UTF8");
$get_url = "SELECT config_name, config_value FROM $table_prefix".config." WHERE config_name = 'server_name' LIMIT 0,1";
$url = mysql_query($get_url);
$url = mysql_fetch_array($url);
$latest_topics = "SELECT * FROM $table_prefix".topics." WHERE topic_approved = '1' ORDER BY topic_time DESC LIMIT 0,$latest";
$topics = mysql_query($latest_topics);
while($row = mysql_fetch_array($topics))
{
extract($row);
if ( ($auth->acl_get('f_read', $row['forum_id'])) || ($row['forum_id'] == '0') )
{
echo "<li><a href='".$phpbb_root_path."/viewtopic.php?f=".$forum_id."&t=".$topic_id."' title='".$topic_title."' target='_blank'>".$topic_title." (".$topic_replies.")</a></li>";
}
}
?>