Последни теми от форума

[Johny_Rocker]

Търся кода за последни теми от форума (phpbb3) Пробвах всички в WEb Tourist и не работят.

 

[lub4o]

Това ?

или ето т

<center>

<?php
include "forum/config.php";
//Брой на последните теми, които искате да се показват
$latest = "6";

$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 cp1251");
$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);



echo "

<table style='width: 620px; color: #000000; font-size:14px; text-align:center;'>

<tr style='background:#; height:30px;'><td style='border: 1px solid #000000;'>Тема</td><td style='border: 1px solid #000000;'>Автор</td><td style='border: 1px solid #000;'>Отговори</td><td style='border: 1px solid #000;'>Преглеждания</td></tr>

";
while($row = mysql_fetch_array($topics))
{
extract($row);
if ( ($auth->acl_get('f_read', $row['forum_id'])) || ($row['forum_id'] == '0') )
{

$topics_p = mysql_query("SELECT * FROM $table_prefix".users." WHERE `user_id`='$topic_poster'");
$row2 = mysql_fetch_array($topics_p);
$poster = $row2['username'];

$forums = mysql_query("SELECT * FROM $table_prefix".forums." WHERE `forum_id`='$forum_id'");
$row3 = mysql_fetch_array($forums);
$forum5 = $row3['forum_name'];




echo "




<tr style='height:45px'>
<td style='background:#; border: 1px solid #000; width:350px; text-align:left;'><div style='padding: 0px 0 0 10px;' class='last_news'>

<a href='".$phpbb_root_path."viewtopic.php?f=".$forum_id."&t=".$topic_id."' target='_blank' class='last_news'><font color='#38719c'>".$topic_title."</font></a>
<br>
<font size='2px'>(<a href='".$phpbb_root_path."viewforum.php?f=".$forum_id."' target='_blank' class='last_news'>".$forum5."</a>)</font>
</div></td>
<td style='border: 1px solid #000;'><div style='padding: 0px 0 0 10px;' class='last_news'><a href='".$phpbb_root_path."memberlist.php?mode=viewprofile&u=".$topic_poster."' target='_blank' class='last_news'>".$poster."</a></div></td>
<td style='colour: #000; border: 1px solid #000;'>".$topic_replies."</td>
<td style='border: 1px solid #000;'>".$topic_views."</td>
</tr>





";
}
}

echo "</table>";
?></center>

 

[Johny_Rocker]

Мерси.