TOPIC: Comment count

   function mod_commentsGetMostCommented(&$params)
    {
 
	$comObject = &$this->_comObject;
 
	$rows = $comObject->mod_commentsGetMostCommentedQuery($this->_secids, $this->_catids, $this->_maxlines);
		/*
		 * rows must contains row array with following fields :
		 * - $row['id']
		 * - $row['title']
		 * - $row['countid']
		 */
//	global $database;
	//echo $database->getQuery();
 
	    /*
	     * display
	     */
	$html = '';
 
	$maxlinesize = intval($params->get('linesize', 0));
 
	if (!$rows) {
	    $html = "<SPAN class=\"small\"><i>no comments</i></SPAN>";
	} else {
	    $html .= "\n<ul class=\"mod_comments\">\n";
	    foreach($rows as $row) {
//		var_dump($row);
		$id 		= $row['id'];
		$title 		= $row['title'];
		$countid 	= $row['countid'];
 
		$link = $comObject->linkToContent($id);
		$end 	= " (". $countid .")";
		$line	= $maxlinesize ? JOSC_utils::setMaxLength($title, $maxlinesize-JString::strlen($end)): $title;
		$html .= "\n<li class=\"mod_comments\">\n";
		$html .= "\n <a href=\"$link\">". $line ."</a>\n";
		$html .= "$end";
		$html .= "\n</li>\n";
 
	    }
	    $html .= "\n</ul>\n";
	}
	return $html;
    }
 

 
<?php
 
defined('_JEXEC') or die('Restricted access'); ?>
 
 
 
<div class="gn_list_<?php echo $globalnews_id; ?>">
  <ul>
    <?php foreach ($list as $item) :  ?>
    <li> <?php
 
$database =& JFactory::getDBO();
global $database;
 
 
$com = $this->_component;
$query = "SELECT COUNT(*) FROM jos_comment WHERE contentid='2043'";
       $database->SetQuery($query);
       $number = $database->loadResult();
 
 
	 echo $item->title."(".$number.")"; 
 
	?> </li>
    <?php endforeach; ?>
    <?php if ( $more == 1 && $group->link ) { ?>
   <br> <div class="gn_more"> <?php echo JHTML::_('link', $group->link, JText::_('More news...') ); ?> 
    <?php } ?>
  </ul>
</div>
 
 

function mod_commentsGetMostCommented(&$params)
    {
 
$comObject = &$this->_comObject;
 
$rows = $comObject->mod_commentsGetMostCommentedQuery($this->_secids, $this->_catids, $this->_maxlines);
/*
 * rows must contains row array with following fields :
 * - $row['id']
 * - $row['title']
 * - $row['countid']
 */
// global $database;
//echo $database->getQuery();
 
    /*
     * display
     */
$html = '';
 
$maxlinesize = intval($params->get('linesize', 0));
 
if (!$rows) {
    $html = "<SPAN class=\"small\"><i>no comments</i></SPAN>";
} else {
    $html .= "\n<ul class=\"mod_comments\">\n";
    foreach($rows as $row) {
// var_dump($row);
$id  = $row['id'];
$title  = $row['title'];
$countid  = $row['countid'];
 
$link = $comObject->linkToContent($id);
$end  = " (". $countid .")";
$line = $maxlinesize ? JOSC_utils::setMaxLength($title, $maxlinesize-JString::strlen($end)): $title;
$html .= "\n<li class=\"mod_comments\">\n";
$html .= "\n <a href=\"$link\">". $line ."</a>\n";
$html .= "$end";
$html .= "\n</li>\n";
 
    }
    $html .= "\n</ul>\n";
}
return $html;
    }