HockeyTeam (HockeyLeague) - Другие компоненты

<?php
/*
 * @package Joomla 1.7
 * @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
 *
 * @module Hockey League - Standings
 * @copyright Copyright (C) Klich JarosЕ‚aw
 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
 */

defined('_JEXEC') or die('Restricted access');
require_once (dirname(__FILE__).DS.'helper.php');

$rows = modStandingsHelper::getList($params);
if (!count($rows)) {
	return; 
}

$title1 = $params->get ( 'title1', 'P' );
$title2 = $params->get ( 'title2', 'Team' );
$title3 = $params->get ( 'title3', 'Ptk' );
$group1 = $params->get ( 'group1', '0' );
$group2 = $params->get ( 'group2', '1' );
$class1 = $params->get ( 'class1', 'tab20' );
$class2 = $params->get ( 'class2', 'tab21' );
$moduleclass_sfx = htmlspecialchars($params->get('moduleclass_sfx'));

require JModuleHelper::getLayoutPath('mod_standings', $params->get('layout', 'default'));

<?php
/*
 * @package Joomla 1.7
 * @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
 *
 * @module Hockey League - Standings
 * @copyright Copyright (C) Klich JarosЕ‚aw
 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
 */
defined('_JEXEC') or die('Restricted access');

class modStandingsHelper {

    function getList(&$params) {
        $db = & JFactory::getDBO ();
        $sez = intval ( $params->get ( 'sez', 0 ) );
        
        $sname = intval ( $params->get ( 'sname', 0 ) );
        $sname = ($sname)? ' tm.short as name ':' tm.name ';

        if ($sez != 0) {
            $query = "SELECT $sname ,t.punkty,t.grupa "
                    ."FROM #__hockey_tabela t "
                    ."INNER JOIN #__hockey_teams tm ON (tm.id = t.team_id) "
                    ."WHERE t.id_system = ".$db->Quote($sez)." AND t.published = 1 "
                    ."ORDER BY t.grupa ASC, t.punkty DESC, t.ordering ASC";
        }  else {
            return NULL;
        }
        $db->setQuery ( $query );
        return $db->loadObjectList ();
    }
}