query($sql); if($G_DB_CONNECT->affected_rows > 0){ while($data2 = $G_DB_CONNECT->fetch_array($rows2)){ $_REQUEST['cid'] = $data2['id']; } } } if($_REQUEST['cid'] > 0){ $parent_news_category_id = 0; $news_category_id = $_REQUEST['cid']; $sql = "select news_category.*,news_category_desc.name as name, news_category_desc.detail as detail from ".TB_NEWS_CATEGORY." as news_category , ".TB_NEWS_CATEGORY_DESC." as news_category_desc "; $sql .= " where "; $sql .= " news_category.id=news_category_desc.news_category_id "; $sql .= " and news_category_desc.language_id='".CURRENT_LANG."' "; $sql .= " and news_category.disabled='0' "; $sql .= " and news_category.id='".$news_category_id."' "; $sql .= " order by news_category.sort_order asc limit 0 ,1 "; define('THIS_PAGE_SQL',$sql); $rows2 = $G_DB_CONNECT->query($sql); if($G_DB_CONNECT->affected_rows > 0){ while($data2 = $G_DB_CONNECT->fetch_array($rows2)){ $news_category_id= $data2['id']; $news_category_name = $data2['name']; $news_category_detail = displayHTML($data2['detail']); $meta_title2 = $data2['seo_title']; $meta_desc = formatSEOInfo($data2['seo_desc']); $meta_keyword = $data2['seo_keyword']; if($meta_title2 == ''){ $meta_title2 = $news_category_name; } $meta_title = $meta_title2; if($meta_desc == ''){ $meta_desc = formatSEOInfo($news_category_detail); } } }else{ include("index.php"); exit(); } } $date=$_REQUEST['date']; if($date == ''){ $sql = "select YEAR(news.display_date) as year ,MONTH(news.display_date) as month from ".TB_NEWS." as news , ".TB_NEWS_DESC." as news_desc "; $sql .= " where "; $sql .= " news.id=news_desc.news_id "; $sql .= " and news_desc.language_id='".CURRENT_LANG."' "; $sql .= " and news.disabled='0' "; $sql .= " and news.news_category_id='$news_category_id' "; $sql .= " group by YEAR(news.display_date)"; $sql .= " order by YEAR(news.display_date) desc limit 0,1"; $rows2 = $G_DB_CONNECT->query($sql); if($G_DB_CONNECT->affected_rows > 0){ while($data2 = $G_DB_CONNECT->fetch_array($rows2)){ $news_year = $data2['year']; $date =$news_year; } } } define("THIS_DATE",$date); define("CID",$news_category_id); ?>
0 ){ $sql .= " and news.news_category_id='".CID."' "; } $sql .= " order by news.highlight desc,news.display_date desc,news.create_date desc "; $rows = $G_DB_CONNECT->query($sql); if($G_DB_CONNECT->affected_rows > 0){ ?>
fetch_array($rows)){ $k++; $news_id = $data['id']; $news_date = formatDate($data['display_date']); $news_name = $data['name']; $news_detail = draftText(180,$data['detail']); $link = 'news-detail.php?id='.$news_id; if( CID> 0 ){ $link .= "&cid=".CID; } if( THIS_DATE != '' ){ $link .= "&date=".THIS_DATE; } $highlight = $data['highlight']; $class=''; if($highlight == 1 ){ $class='item_highlight'; } ?>