Модуль статей с низким рейтингом - Разработка расширений для Joomla 1.5

<?php
/**
* @version		$Id: helper.php 0001 2008-08-19 01:01:01Z pe7er $
* @package		Joomla
* @copyright	Copyright 2008 by Peter Martin / db8.nl. All rights reserved.
* @license		http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
*/

defined('_JEXEC') or die('Restricted access');

//require_once (JPATH_SITE.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php');

/**
* db8 Best Rated Content Module Helper
*
* @static
*/

class modDB8BestRatedContentHelper
{

    /**
    * Gets a list of best rated content
    *
    * @param JParameter Module parameters
    * @return an array best rated articles, ordered by average rating and number of votes
    */

	function &getList(&$params)
	{
		global $mainframe;

		$db			=& JFactory::getDBO();
		$user		=& JFactory::getUser();

        $type 		= intval( $params->get( 'type', 0 ) );
        $count 		= intval( $params->get( 'count' ) );
        $catid 		= trim( $params->get( 'catid' ) );
        $secid 		= trim( $params->get( 'secid' ) );
		$aid		= $user->get('aid', 0);

		$contentConfig = &JComponentHelper::getParams( 'com_content' );
		$access		= !$contentConfig->get('shownoauth');

		$nullDate	= $db->getNullDate();
		$date =& JFactory::getDate();
		$now  = $date->toMySQL();

		if ($catid) {
			$ids = explode( ',', $catid );
			JArrayHelper::toInteger( $ids );
			$catCondition = ' AND (cc.id=' . implode( ' OR cc.id=', $ids ) . ')';
		}
		if ($secid) {
			$ids = explode( ',', $secid );
			JArrayHelper::toInteger( $ids );
			$secCondition = ' AND (s.id=' . implode( ' OR s.id=', $ids ) . ')';
		}

		$query = 'SELECT a.*,' .
			' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,'.
			' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug,'.
	        ' cr.rating_sum AS sum, cr.rating_count AS count,' .
	        ' (cr.rating_sum / cr.rating_count) AS rating' .
			' FROM #__content AS a' .
            ' LEFT JOIN #__content_rating AS cr ON cr.content_id = a.id ' .
			' INNER JOIN #__categories AS cc ON cc.id = a.catid' .
			' INNER JOIN #__sections AS s ON s.id = a.sectionid' .
			' WHERE ( a.state = 1 AND s.id > 0 )' .
			' AND ( a.publish_up = '.$db->Quote($nullDate).' OR a.publish_up <= '.$db->Quote($now).' )' .
			' AND ( a.publish_down = '.$db->Quote($nullDate).' OR a.publish_down >= '.$db->Quote($now).' )'.
			($access ? ' AND a.access <= ' .(int) $aid. ' AND cc.access <= ' .(int) $aid. ' AND s.access <= ' .(int) $aid : '').
			($catid ? $catCondition : '').
			($secid ? $secCondition : '').
			($show_front == '0' ? ' AND f.content_id IS NULL' : '').
			' AND s.published = 1' .
			' AND cc.published = 1' .
            ' AND cr.rating_count > 0' .
            ' ORDER BY rating DESC, rating_count DESC'
            ;
		$db->setQuery($query, 0, $count);
    	$rows = $db->loadObjectList();

		require_once( JPATH_SITE.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php' );
		$i		= 0;
		$lists	= array();
		foreach ( $rows as $row )
		{
			$lists[$i]->link = JRoute::_(ContentHelperRoute::getArticleRoute($row->slug, $row->catslug, $row->sectionid));
			$lists[$i]->text = htmlspecialchars( $row->title );
			$lists[$i]->hits = $row->hits;
			$lists[$i]->rating = $row->rating;
			$lists[$i]->count = $row->count;
			$i++;
		}

		return $lists;

	}
}
?>