<?php
    defined('_JEXEC') or die('Restricted access');
//    echo JText::_('Последние сообщения');
$pbb_dbname = "имя бд";
$pbb_dbprefix = "префикс таблицы";
$pbb_dbhost ="localhost";
$pbb_dbuser = "логин";
$pbb_dbpass= "пароль";
$pbb_path = "http://путь к форуму";

$xdbx=mysql_connect($pbb_dbhost, $pbb_dbuser, $pbb_dbpass,true);
mysql_select_db($pbb_dbname,$xdbx);
$a = 1;
$result = mysql_query("SELECT a.id,a.subject,FROM_UNIXTIME(a.last_post,'%d/%m/%Y в %T') as last_post,a.last_poster,b.id from ".$pbb_dbprefix."topics a LEFT JOIN ".$pbb_dbprefix."users b ON b.username=a.last_poster ORDER BY a.last_post DESC LIMIT 0, 7", $xdbx);
while(list($topic_id,$topic_name, $post_time,$poster_name,$poster_id) = mysql_fetch_row($result))
{
              $content .="В теме <br>";

       $content .= "<a href=\"$pbb_path/viewtopic.php?id=$topic_id&action=new\"STYLE=\"text-decoration: none\">$topic_name</a><br><i>Оставил(а) <A HREF=\"$pbb_path/profile.php?id=$poster_id\"STYLE=\"text-decoration: none\">$poster_name</a><br> $post_time</i><br><br>";
       $a++;
}
mysql_close($xdbx);
?>