defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );

$menuitem = ($params->get( 'menuitem' )) ? $params->get( 'menuitem' ) : 0;
$titlelenght = ($params->get( 'titlelenght' )) ? $params->get( 'titlelenght' ) : 15;
$moduleclass_sfx = $params->get( 'moduleclass_sfx' );
$access = ($params->get( 'access' )) ? $params->get( 'access' ) : 2;
$number = ($params->get( 'number' )) ? $params->get( 'number' ) : 10;
$linktarget = ($params->get( 'linktarget' )) ? $params->get( 'linktarget' ) : '_self';
$component = $params->get( 'component' );

$access = $access + 1;
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="<?php echo $moduleclass_sfx; ?>content" align="center">
        <tr>
                 <td>
                   
      <?
      
      $link = ($component == 'true') ? '' : '2';
      
                   $query="SELECT DISTINCT t.topic_id, t.topic_title, p.post_id FROM phpbb_topics t, phpbb_posts p, phpbb_forums f WHERE t.forum_id = f.forum_id AND f.auth_read < $access AND p.post_id = t.topic_last_post_id ORDER BY post_time DESC LIMIT 0, $number";
                   $database->setQuery($query);
                   $rows =$database->loadObjectList();
                   $result = $database->query();
                   //going into a loop to display all news
                   $num = $database->getNumRows($result);
                   $i=0;
                 
                   //check if there is result
                   if($num != 0){
                          
                     foreach($rows as $row) {
                     //getting data from resultset
                       $topic_title=mysql_result($result,$i,"topic_title");
                       $title = $topic_title;
                                            if(strlen($topic_title) > $titlelenght){
                                              $topic_title = substr($topic_title, 0, ($titlelenght - 2)) . "...";
                       }
                       //$topic_title = strlen($topic_title);
                       $post_id=mysql_result($result,$i,"post_id");
                       
                       print("                              <font class=\"cross\">+</font> <a target=\"$linktarget\" href=\"index$link.php?option=com_forum&Itemid=" . $menuitem ."&page=viewtopic&p=" . $post_id . "#" . $post_id . "\" title=\"" . $title . "\">" . $topic_title . "</a>
\n");
                       $i++;
                     }
                   }
                   else {
                     print("                              <font class=\"cross\">+</font> <a target=\"$linktarget\" href=\"forum/\">No topics found</a><
");
                   }
                   ?>                           
                          
        </tr>
</table>