вот вторая часть файла
PHP код:
if(empty($areaid))
{
$area_row = get_parent_area();
if(!empty($area_row))
{
$area_arr = array();
foreach($area_row as $val)
{
$val['areaname'] = $val['areaname'];
$val['url'] = url_rewrite('category',array('cid'=>$catid,'eid'=>$val['areaid']));
$area_arr[] = $val;
}
}
$s_area .= '<select name="area" id="area"><option value="0">'.$Language['awebcomphp7'].'</option>';
if($area_row)
{
foreach($area_row as $area)
{
$s_area .= "<option value=$area[areaid]>$area[areaname]</option>";
}
}
$s_area .= '</select>';
}
else
{
$area_parent = $area_info['parentid'];
if(empty($area_parent))
{
$area_row = get_area_children($areaid,'array');
if(!empty($area_row))
{
$s_area .= '<select name="area" id="area"><option value="0">'.$Language['awebcomphp7'].'</option>';
foreach($area_row as $cat)
{
$s_area .= "<option value=$cat[id]>$cat[name]</option>";
}
$s_area .= '</select>';
}
else
{
$s_area .= '<select name="area" id="area" disabled>';
$s_area .= "<option value=$areaid selected>".$area_info['areaname']."</option>";
$s_area .= '</select>';
}
$areas = get_area_children($areaid);
if(!empty($area_row))
{
$area_arr = array();
foreach($area_row as $val)
{
$val['areaname'] = $val['name'];
$val['url'] = url_rewrite('category',array('cid'=>$catid,'eid'=>$val['id']));
$area_arr[] = $val;
}
}
if(empty($areas))$areas=$areaid;
}
else
{
$s_area .= '<select name="area" id="area" disabled>';
$s_area .= "<option value=$areaid selected>".$area_info['areaname']."</option>";
$s_area .= '</select>';
$areas = $areaid;
}
$area_sql = " and i.areaid in ($areas) ";
}
$page = empty($_REQUEST['page']) ? '1' : intval($_REQUEST['page']);
$sql = "SELECT COUNT(*) FROM {$table}info as i WHERE is_check=1 $cat_sql $area_sql";
$count = $db->getone($sql);
$pager = page('category.php',$catid,$areaid,$count,$INF['catw'],$page);
$sql = "SELECT id,title,postdate,enddate,i.catid,catname,i.areaid,areaname,thumb,i.description,content FROM {$table}info AS i LEFT JOIN {$table}area AS a ON a.areaid=i.areaid left join {$table}category as c on c.catid=i.catid WHERE is_check=1 $cat_sql $area_sql ORDER BY postdate DESC limit $pager[start],$pager[size]";
$res = $db->query($sql);
$articles = array();
while($row=$db->fetchRow($res))
{
$articles[$row['id']]['id'] = $row['id'];
$articles[$row['id']]['title'] = $row['title'];
$articles[$row['id']]['thumb'] = $row['thumb'];
$articles[$row['id']]['catid'] = $row['catid'];
$articles[$row['id']]['catname'] = $row['catname'];
$articles[$row['id']]['areaid'] = $row['areaid'];
$articles[$row['id']]['areaname'] = $row['areaname'];
$articles[$row['id']]['url'] = url_rewrite('view',array('vid'=>$row['id']));
$articles[$row['id']]['postdate'] = date('y-m-d', $row['postdate']);
$articles[$row['id']]['lastdate'] = enddate($row['enddate']);
$articles[$row['id']]['intro'] = $row['description'] ? $row['description'] : cut_str($row['content'], 50);
}
if($articles)
{
foreach($articles as $article)
{
$infoid .= $article['id'].',';
}
$infoid = substr($infoid,0,-1);
$sql = "select c.cusname,v.cusid,v.infoid,v.cusvalue from {$table}custom as c left join {$table}cus_value as v on v.cusid=c.cusid where v.infoid in ($infoid)";
$res = $db->query($sql);
while($row=$db->fetchrow($res))
{
$arr[$row['infoid']][$row['cusid']]['cusname'] = $row['cusname'];
$arr[$row['infoid']][$row['cusid']]['cusvalue'] = $row['cusvalue'];
}
foreach($articles as $key=>$article)
{
$articles[$key]['custom'] = is_array($arr[$key]) ? $arr[$key] : array();
}
}
$cat_pro = get_info($cats,$areas,$INF['catvip'],'pro','',$INF['catsimvip']);
$cat_hot = get_info($cats,$areas,$INF['cathot'],'',' click ',$INF['catsimhot']);
$seo['title'] = $area_info['areaname'] . ' ' . $cat_info['catname'] . ' - '. $CFG['webname']. ' - Powered by AwebCom.com';
$seo['keywords'] = $area_info['areaname'].$cat_info['keywords'];
$seo['description'] = $cat_info['description'];
include template('category');
?>