| |
|
|
|
 |
|
'' ";
if(ForceIncomingInt('selyear',0)>0) $query_string_select.=" and year(d.datecreated)=".ForceIncomingInt('selyear',0);
$query_string_select.=" order by d.datepublished desc,d.datecreated desc ";
$_query=tep_db_query($query_string_select);
$total=mysql_num_rows($_query);
pageft($total,10);
$query_string_select="select d.id,d.name,d.datecreated,d.datepublished,t.name,t.body,f.fname,l.url from asmcs_news_trans t left join asmcs_news_file f on t.id=f.id and f.lang='".$lang."' left join asmcs_news d on d.id=t.id left join asmcs_news_link l on l.id=t.id and l.lang='".$lang."' where d.categoryid=".$cid." and d.deleted=0 and t.lang='".$lang."' and t.name<>'' ";
if(ForceIncomingInt('selyear',0)>0) $query_string_select.=" and year(d.datecreated)=".ForceIncomingInt('selyear',0);
$query_string_select.=" order by d.datepublished desc,d.datecreated desc limit ".$firstcount.",".$displaypg;
$_query=tep_db_query($query_string_select);
while ($_array=tep_db_fetch_array($_query)){
$_arr3[]=$_array;
}
if(isset($_arr3))$smarty->assign("newslist",$_arr3);
$smarty->assign("pager",$pagenav);
require_once '../init_end.php';
$smarty->template_dir="../templates";
$smarty->compile_dir="../templates_c";
$smarty->display('sc_eventscenter.tpl');
?>
|
|
|
