<?php
$host="
Хост";
$user="
Потребител";
$pass="
Парола";
$link=mysql_connect($host, $user, $pass) or die(mysql_error());
$db=mysql_select_db("
База данни") or die(mysql_error());
$query="SELECT
c.topic_time , c.topic_title,c.forum_id,c.topic_id,
c.topic_replies,c.topic_type FROM
phpbb_topics c ,
phpbb_forums f WHERE
c.forum_id=f.forum_id and f.prune_freq like '0' ORDER BY c.topic_time DESC LIMIT 0,10";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
if (strlen($row['c.topic_title'])>35)
{$totchki="...";}
else
{$totchki="";}
$row['c.topic_title']=substr($tema,0 , 35);
echo "» $vazna<a href=\"".$phpbb_root_path."viewtopic.php?t=$row[topic_id]\" title=\"$row[topic_title]\">$row[topic_title]$totchki</a><br>";
}
?>
