Новостной слайдер

 
WHERE con.published = 1 AND con.showlatest = 1
 

AND con.category_id=4

WHERE con.published = 1 AND con.showlatest = 1 AND con.category_id IN (10, 11, 12, 13, 14, 15, 16, 17)

<?php
function mod_latestslider($module_id){
$inCore = cmsCore::getInstance();
$inDB = cmsDatabase::getInstance();
$cfg = $inCore->loadModuleConfig($module_id);
global $_LANG;
if (!isset($cfg['maxlen'])) { $cfg['maxlen'] = 150;}
$today = date("Y-m-d H:i:s");
$sql = "
SELECT con.*, con.id as slid, 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.category_id IN (10, 11, 12, 13, 14, 15, 16, 17)
AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '".$today."' AND con.pubdate <= '".$today."'))
ORDER BY con.pubdate DESC LIMIT 4";
 
$result = $inDB->query($sql);
$is_slider = false;
if ($inDB->num_rows($result)){
$slider = array();
$is_slider = true;
while($con = $inDB->fetch_assoc($result)){
$next = sizeof($slider);
if(strlen($con['content'])>$cfg['maxlen']){
$con['content'] = substr($con['content'], 0, $cfg['maxlen']) . '...';
}
$slider[$next]['title'] = substr($con['title'], 0, 75) . '...';
$slider[$next]['content'] = $con['content'];
$slider[$next]['id'] = $con['id'];
$slider[$next]['seolink'] = $con['seolink'];
}
}
 
$smarty = $inCore->initSmarty('modules', 'mod_latestslider.tpl');
$smarty->assign('slider', $slider);
$smarty->assign('is_slider', $is_slider);
$smarty->display('mod_latestslider.tpl');
return true;
}
?>

{literal}
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.5.3/jquery-ui.min.js" ></script>
    <script type="text/javascript">
        $(document).ready(function(){
        $("#featured > ul").tabs({fx:{opacity: "toggle"}}).tabs("rotate", 5000, true);
    });
    </script>
{/literal}
 
{if $is_slider}
<div id="featured">
	<ul class="ui-tabs-nav">
		{foreach key=id item=title from=$slider}
		<li class="ui-tabs-nav-item ui-tabs-selected" id="nav-fragment-{$title.id}"><a href="#fragment-{$title.id}"><img src="/images/photos/small/article{$title.id}.jpg" alt="" width="50px" height="50px" /><span class="ttl">{$title.title}</span></a></li>
		{/foreach}
	</ul>
	{foreach key=id item=title from=$slider}
	<div id="fragment-{$title.id}" class="ui-tabs-panel" style="">
        <a href="/{$title.seolink}.html" style="border-radius: 8px; overflow: hidden; display: block;">
		<img src="/images/photos/medium/article{$title.id}.jpg" alt="" width="350px" /></a>
		<div class="info" >
			<!-- <a href="#" >{$title.title}</a> -->
			<p><a href="/{$title.seolink}.html" >{$title.content}</a></p>
		</div>
	</div>
	{/foreach}
 
</div>
{/if}

WHERE con.published = 1 AND con.showlatest = 1 AND con.category_id IN (10, 11, 12, 13, 14, 15, 16, 17)

WHERE con.published = 1 AND con.showlatest = 1 AND con.category_id IN (10, 11, 12, 13, 14)

WHERE con.published = 1 AND con.showlatest = 1 AND con.category_id BETWEEN 10 AND 17

 
$con['content'] = substr($con['content'], 0, $cfg['maxlen']) . '...';
}
$slider[$next]['title'] = substr($con['title'], 0, 75) . '...';
 

$con['content'] = substr($con['content'], 0, $cfg['maxlen']) . '...';
	}
	$slider[$next]['title'] = substr($con['title'], 0, 75) . '...';

 
if( strlen( strip_tags( $con['content'] ) ) > $cfg['maxlen'] ) {
$con['content'] = substr( strip_tags( $con['content'] ), 0, $cfg['maxlen'] ) . '...'; }
$slider[$next]['title'] = substr( strip_tags( $con['title'] ), 0, 75 ) . '...';