Слайдер контента (новая версия)

 
$sql = "SELECT con.*,
                       con.pubdate as fdate,
                       u.nickname as author,
                       u.login as author_login
                       FROM cms_content con
				       LEFT JOIN cms_category cat ON cat.id = con.category_id
				       LEFT JOIN cms_users u ON u.id = con.user_id
                       WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '$today'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '$today'))
                      ".$catsql."
				ORDER BY con.pubdate DESC
				LIMIT ".$cfg['newscount'];
 

 
$sql = "SELECT con.*,
                       con.pubdate as fdate,
                       u.nickname as author,
                       u.login as author_login
                       FROM cms_content con
				       LEFT JOIN cms_category cat ON cat.id = con.category_id
				       LEFT JOIN cms_users u ON u.id = con.user_id
                       WHERE con.published = 1 AND con.showlatest = 1 AND con.is_arhive = 0 AND con.pubdate <= '$today'
                      AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '$today'))
                      ".$catsql."
				ORDER BY hits DESC
				LIMIT ".$cfg['newscount'];
 

<?php
/******************************************************************************/
//                                                                            //
//                             InstantCMS v1.10                               //
//                        http://instantcms.ru/                           //
//                                                                            //
//                   written by InstantCMS Team, 2007-2012                    //
//                produced by InstantSoft, (www.instantsoft.ru)               //
//                                                                            //
//                        LICENSED BY GNU/GPL v2                              //
//                                                                            //
/******************************************************************************/
 
function mod_lcslider($module_id){
 
	$inCore = cmsCore::getInstance();
	$inDB   = cmsDatabase::getInstance();
 
	$inCore->loadModel('content');
	$model = new cms_model_content();
 
	$cfg = $inCore->loadModuleConfig($module_id);
 
	if (!isset($cfg['subs'])) { $cfg['subs'] = 1; }
	if (!isset($cfg['cat_id'])) { $cfg['cat_id'] = 1; }
	if (!isset($cfg['newscount'])) { $cfg['newscount'] = 5; }
	if (!isset($cfg['sidebar'])) { $cfg['sidebar'] = 1; }
	if (!isset($cfg['accardeon'])) { $cfg['accardeon'] = 1; }
	if (!isset($cfg['width'])) { $cfg['width'] = 960; }
	if (!isset($cfg['height'])) { $cfg['height'] = 320; }
	if (!isset($cfg['truncate'])) { $cfg['truncate'] = 100; }
 
	$width = $cfg['width'];
	$height = $cfg['height'];
	$truncate = $cfg['truncate'];
 
	if($cfg['cat_id']){
 
		if (!$cfg['subs']){
 
			//выбираем из категории
			$model->whereCatIs($cfg['cat_id']);
 
		} else {
 
			//выбираем из категории и подкатегорий
			$rootcat = $inDB->getNsCategory('cms_category', $cfg['cat_id']);
			if(!$rootcat) { return false; }
			$model->whereThisAndNestedCats($rootcat['NSLeft'], $rootcat['NSRight']);
 
		}
 
	}
 
 
	$inDB->where("con.showlatest = 1");
 
	if ($cfg['is_pag']){
		$total = $model->getArticlesCount();
	}
 
	$inDB->orderBy('con.pubdate', 'DESC');
	$inDB->limitPage(1, $cfg['newscount']);
 
	$content_list = $model->getArticlesList();
	if(!$content_list) { return false; }
 
	$smarty = $inCore->initSmarty('modules', 'mod_lcslider.tpl');			
	$smarty->assign('articles', $content_list);
	if ($cfg['is_pag']) {
		$smarty->assign('pagebar_module', cmsPage::getPagebar($total, 1, $cfg['newscount'], 'javascript:conPage(%page%, '.$module_id.')'));
	}
	$smarty->assign('is_ajax', false);
	$smarty->assign('module_id', $module_id);
	$smarty->assign('cfg', $cfg);
	$smarty->display('mod_lcslider.tpl');			
 
	return true;
 
}
?>

$inDB->orderBy('con.pubdate', 'DESC');