Agora Forum - лучший форум для joomla

<?php
//
// mod_agora_last.php,v 0.1 27/05/2008
// feel free to ask
// Released under GPL
// The "GNU General Public License" (GPL) is available at
// http://www.gnu.org/copyleft/gpl.html.

defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );
$number=5;
$max=100;
$name=0;
$link=0;
$item_id = 136;
$content ="";
$number = $params->get('number_posts');
$moduleclass_sfx = $params->get('moduleclass_sfx');
$max = $params->get('max_length');
$name = $params->get('name');
$link = $params->get('link');
$language = $params->get('lang');
if($params->get('spacer') != "")
 $spacer = $params->get('spacer')." ";

$database->setQuery("SELECT * FROM #__agora_posts as posts, #__agora_topics as topics, #__agora_users as users WHERE posts.poster_id = users.id AND topics.id = posts.topic_id ORDER BY posts.posted DESC LIMIT $number");
$list = $database->loadObjectList();

foreach ($list as $item)
{
    $thread = $item->subject;
    $length = strlen($thread);
    if ($length > $max) 
    {
        $thread = substr($thread, 0, $max).'...';
    }
    $content .= $spacer."<a class=\"".$moduleclass_sfx."\" href=\"index.php?option=com_agora&Itemid=".$item_id."&amp;task=viewtopic&amp;id=".$item->topic_id."\">".stripslashes($thread)."</a>";
  if($name == 1)
  {
      $content .= " ".$language." ".$item->username."<br/>";
  }
  else
  {
      $content .= "<br/>";
  }
}