public static function getBannersbyid($params)
{
$idbanners = ModeasybannerrotatorHelper::getids($params);
$db = JFactory::getDbo();
$query = $db->getQuery(true)->select($db->quoteName(array('id', 'name', 'clickurl', 'description', 'custombannercode', 'params', 'ordering')))->from($db->quoteName('#__banners'))->where($db->quoteName('state') . '=1')->where($db->quoteName('id') . $idbanners);
if ((int) $params->get('display', 0) == 1) {
$query->order('ordering ASC');
}
$db->setQuery($query);
$result = $db->loadObjectList();
return $result;
}
<?php
// no direct access
defined('_JEXEC') or die('Restricted access');
require_once dirname(__FILE__) . '/helper.php';
if ((int) $params->get('bycategory', 1)) {
$banners = ModeasybannerrotatorHelper::getBannersbycategory($params);
} else {
$banners = ModeasybannerrotatorHelper::getBannersbyid($params);
$banners = ModeasybannerrotatorHelper::addpaidstatus($banners, $params);
}
ModeasybannerrotatorHelper::decodeJson($banners);
if ((int) $params->get('display', 0) == 2) {
ModeasybannerrotatorHelper::shufflebanners($banners);
}
if ((int) $params->get('display', 0) == 3) {
$banners = ModeasybannerrotatorHelper::shufflepaidbanners($banners);
}
require JModuleHelper::getLayoutPath('mod_easy_banner_rotator');