public function fetch_all_by_upid($upid, $order = null, $sort = 'DESC')
{
$upid = is_array($upid) ? implode("','", array_map('intval', (array) $upid)) : dintval($upid);
if ($upid !== null) {
$ordersql = ' ORDER BY displayorder ASC';
return brian_fetch_all('house_area', " WHERE upid IN ('{$upid}') {$ordersql} ", array('sort' => 'id'));
}
return array();
}
DB::insert('info_cat', $post);
}
if (isset($_GET['del'])) {
$del['cat_id'] = intval($_GET['del']);
DB::delete('info_cat', $del);
}
if (isset($_GET['edit'])) {
$edit = intval($_GET['edit']);
$edit_array = array();
$edit_array = fetch_all('info_cat', ' WHERE cat_id=' . $edit . ' ORDER BY cat_pid DESC,cat_sort ASC', '*', 0);
}
if (isset($_GET['edit_submit'])) {
$edit_array = array();
$edit_array = gpc('cat_');
DB::update('info_cat', $edit_array, array('cat_id' => $edit_array['cat_id']));
}
$cat_array = array();
$cat_array = brian_fetch_all('info_cat', ' ORDER BY cat_sort ASC', array('sort' => 'cat_id'));
brian_cat_cache();
$profile_type_array = fetch_all("info_profile_type", " ORDER BY profile_type_id ASC");
if (!cloudaddons_getmd5("info.plugin")) {
cpmsg(lang('admincp_msg', 'cloudaddons_genuine_message'), '', 'error', array('addonid' => "info.plugin"));
}
$pid_cat_array = array();
$pid_cat_array = fetch_all("info_cat", " WHERE cat_id='{$cat_pid}' ", "*", 0);
$style = 'default';
include template("info:admin/admin_cat");
?>
$search = gpc('search_');
if (!empty($search['search_txt'])) {
$where .= " AND ( ip.post_title LIKE '%{$search['search_txt']}%' OR ip.loupan_title LIKE '%{$search['search_txt']}%') ";
}
}
$dcj_time = time();
$where .= " and ip.`post_begin_time` < {$dcj_time} and ip.`post_end_time` > {$dcj_time} ";
$where .= " ORDER BY ip.post_up DESC,{$orderby} DESC ";
$page = $_GET['page'] ? intval($_GET['page']) : 1;
$perpage = $info_config['perpage'];
$pagenum = DB::num_rows(DB::query("SELECT distinct ip.post_id FROM " . DB::table('info_post') . $where));
$multipage = multi($pagenum, $perpage, $page, $urlnow, 0, 10);
$stat_limit = ($page - 1) * $perpage;
$where .= " LIMIT {$stat_limit},{$perpage}";
//$post_list = brian_fetch_all('info_post',$where,array('filter'=>' distinct ip.post_id, ip.*, cmv.*'));
$post_list = brian_fetch_all('info_post', $where, array('filter' => ' distinct ip.post_id,ip.post_title,ip.area_title,ip.enterprise,ip.tel,ip.post_time,ip.post_img_1 '));
/*
foreach($post_list as $k=>$v){
$_post_profile = array();
$_post_profile = fetch_all('info_post_profile'," WHERE post_id='{$v['post_id']}'");
foreach($_post_profile as $_k=>$_v){
$_post_profile[$_v['profile_setting_name']] = $_v;
unset($_post_profile[$_k]);
}
if(!empty($_post_profile)){
$post_list[$k] = array_merge($post_list[$k],$_post_profile);
}
}*/
$navtitle = $subcat_title . "_" . $area_title . " " . $info_config['name'];
if (defined('IN_MOBILE')) {
include template('info:' . $style . '/list');
