Модуль JComments Latest - страница 3 - Общие вопросы

<a class="jcl_comment" href="index.php?option=com_content&amp;task=view&amp;id=128&amp;Itemid=1#comment-24" title="<img src="components/com_jcomments/images/smiles/normal.gif" border="0" alt="" /> wow!!!!"><img src="components/com_jcomments/images/smiles/normal.gif" border="0" alt="" /> wow!!!!</a>

$link_title = str_replace( '"', '', $title );
$link_text = $title;

switch($showsmiles) {
	case 1:
		$link_text = $smiles->replace($link_text);
		//~ $link_title = $smiles->replace($link_title);
		break;
	case 2:
		$link_text = $smiles->strip($link_text);
		break;
}

$link_title = str_replace('"','',$row->title);

if ($show_object_title == 1) {
					$title = JCommentsObjectHelper::getTitle( $row->object_id, $row->object_group );
					$title = JCommentsText::substr($title, $limit_object_title);
					$title = str_replace( '"', '', $title );

					echo '<a class="jcl_objtitle" href="'.$link.'" title="'.$title.'">'.$title.'</a><br />';
				}

	function modJCommentsLatestCommented( &$params ) {
		global $mainframe, $my, $Itemid;

		$dbo = & JCommentsFactory::getDBO();
		
		$sectionid = intval($params->get('sectionid'));
		$exclude_sectionid = trim($params->get('exclude_sectionid', ''));
		$exclude_sections = array();
		if ($exclude_sectionid != '') {
			$exclude_sections = explode(',', $exclude_sectionid);
		}
		
		$catid = intval($params->get('catid'));
		$exclude_catid = trim($params->get('exclude_catid', ''));
		$exclude_catids = array();
		if ($exclude_catid != '') {
			$exclude_catids = explode(',', $exclude_catid);
		}

		$query = "SELECT c.id AS id, c.title AS title, c.sectionid"
			. ((JCOMMENTS_JVERSION == '1.5') ? ', CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug' : '')
			. ((JCOMMENTS_JVERSION == '1.5') ? ', CASE WHEN CHAR_LENGTH(ct.alias) THEN CONCAT_WS(":", ct.id, ct.alias) ELSE ct.id END as catslug' : '')
			. "\n, COUNT(cc.id) AS comments, MAX(cc.date) AS commentdate"
			. "\n FROM #__content AS c"
			. "\n LEFT JOIN #__jcomments AS cc ON c.id = cc.object_id"
			. "\n LEFT JOIN #__categories AS ct ON ct.id = c.catid"
			. "\n WHERE c.state = 1"
			. "\n   AND c.access <= '$my->gid'"
			. "\n   AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= NOW())"
			. "\n   AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= NOW())"
			//~ . "\n   AND cc.published = 1"
			//~ . "\n   AND cc.object_group = 'com_content'"
			. ((!$catid && $sectionid) ? "\n   AND (c.sectionid IN ($sectionid) )" : '')
			. (count($exclude_sections) ? "\n AND (c.sectionid NOT IN (".implode(',', $exclude_sections).") )" : '')
			. ($catid ? "\n   AND (c.catid IN ($catid) )" : '')
			. (count($exclude_catids) ? "\n AND (c.catid NOT IN (".implode(',', $exclude_catids).") )" : '')
			. "\n GROUP BY c.id, c.title, c.sectionid"
			. ((JCOMMENTS_JVERSION == '1.5') ? ", slug, catslug" : '')
			. "\n ORDER BY /*commentdate*/ c.created DESC"
			. "\n LIMIT " . intval( $params->get( 'count' ) )
			;
		$dbo->setQuery( $query );
		$rows = $dbo->loadObjectList();
		echo $dbo->getErrorMsg();

		if ( sizeof( $rows ) ) {
			echo '<ul class="jclist'.$params->get( 'moduleclass_sfx' ).'">'."\n";

			foreach( $rows as $row ) {

				$link = modJCommentsHelper::getContentLink($row);
				$link_title = $row->title;
				$link_text = $row->title;

				if ( $params->get( 'showcomments' ) ) { 
					$link_text .= ' (' . $row->comments . ')'; 
				}

				echo '<li><a href="'.$link.'" title="'.$link_title.'">'.$link_text.'</a></li>'."\n";
			}
			echo '</ul>'."\n";
		}
	}

echo '<li><a href="'.$link.'" title="'.$link_title.'">'.$link_text.'</a>'
.'<div class="date">'.date('Y-m-d', strtotime($row->commentdate)).'</div>'
.'</li>'."\n";