'0', 'areaname' => '不限')), $area_list); $sq = $s = ''; if (1 < $cat['modid']) { $s = ''; foreach ($_GET as $key => $val) { if (in_array($key, $allow_identifier) && !empty($key)) { $val = explode('~', $val); $val[0] = $val[0] ? intval($val[0]) : ''; $val[1] = $val[1] ? intval($val[1]) : ''; if ($val[1]) { $sq .= ' AND g.`' . $key . '` <= \'' . $val[1] . '\' AND g.`' . $key . '` >= \'' . $val[0] . '\''; } else { if ($val[0] && 0 < $val[1]) { $sq .= ' AND g.`' . $key . '` >= \'' . $val[0] . '\''; } else { $sq .= ' AND g.`' . $key . '` = \'' . $val[0] . '\' '; } } $s = ' LEFT JOIN `' . $db_mymps . 'information_' . $cat[modid] . '` AS g ON a.id = g.id'; } } } $cate_limit = 0 < $cat['parentid'] ? ' AND ' . get_children($catid) : ' AND a.gid = \'' . $catid . '\''; $city_limit = empty($city['cityid']) ? '' : ' AND a.cityid = \'' . $city['cityid'] . '\''; $city_limit .= empty($areaid) ? '' : ' AND a.areaid = \'' . $areaid . '\''; $orderby = $cat['parentid'] == 0 ? ' ORDER BY a.upgrade_type DESC,a.begintime DESC' : ' ORDER BY a.upgrade_type_list DESC,a.begintime DESC'; $param = setparams($allow_identifiers); $rows_num = $cat['totalnum'] = $db->getOne('SELECT COUNT(a.id) FROM `' . $db_mymps . 'information` AS a ' . $s . ' WHERE a.info_level > 0 ' . $sq . $cate_limit . $city_limit); $totalpage = ceil($rows_num / $perpage); $num = intval($page - 1) * $perpage; $idin = get_page_idin('id', 'SELECT a.id FROM `' . $db_mymps . 'information` AS a ' . $s . ' WHERE (a.info_level = 1 OR a.info_level = 2) ' . $sq . $cate_limit . $city_limit . $orderby, $perpage); $idin2 = $idin ? ' AND a.infoid IN (' . $idin . ') ' : ''; $idin = $idin ? ' AND a.id IN (' . $idin . ') ' : ''; $sql = 'SELECT a.*,b.areaname FROM ' . $db_mymps . 'information AS a LEFT JOIN `' . $db_mymps . 'area` AS b ON a.areaid = b.areaid WHERE 1 ' . $idin . ' ' . $orderby; $infolist = $idin ? $db->getAll($sql) : array(); foreach ($infolist as $k => $row) { $arr['id'] = $row['id']; $arr['face'] = $row['face']; $arr['face'] = @strstr($arr['face'], 'http') ? $arr['face'] : $mymps_global['SiteUrl'] . $arr['face']; $arr['title'] = $row['title']; $arr['titlej'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['title']) : $arr['title']; $arr['hit'] = $row['hit']; $arr['uri_m'] = mRewrite('info', array('id' => $row[id], 'dir_typename' => $row['dir_typename'])); $arr['img_path'] = $row['img_path']; $arr['ifred'] = $row['ifred']; $arr['ifbold'] = $row['ifbold']; $arr['hit'] = $row['hit']; $arr['zan'] = intval($row['zan']); $arr['certify'] = $row['certify']; $arr['catname'] = $row['catname']; $arr['catnamej'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['catname']) : $arr['catname']; $arr['areaname'] = $row['areaname']; $arr['areanamej'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['areaname']) : $arr['areaname']; $arr['tel'] = empty($cat['usecoin']) ? 'tel:' . $row['tel'] : $arr['uri_m']; $arr['img_count'] = $row['img_count']; $arr['upgrade_type'] = !$cat['parentid'] ? $row['upgrade_type'] : $row['upgrade_type_list']; $arr['userid'] = $row['userid'] ? $row['userid'] : $row['contact_who']; $arr['useridj'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['userid']) : $arr['userid']; $arr['content'] = $row['content']; $arr['contentj'] = cutstr(clear_html($row['content']), 50); $arr['contentj'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['contentj']) : $arr['contentj']; $arr['begintime'] = get_format_time($row['begintime']); $arr['endtime'] = $row['endtime'] ? $row['endtime'] : $timestamp; $info_list[$row['id']] = $arr; $ids .= $row['id'] . ','; if (0 < $row['upgrade_time'] && $row['upgrade_time'] < $timestamp) { $db->query('UPDATE `' . $db_mymps . 'information` SET upgrade_type = \'1\',upgrade_time = \'0\' WHERE id =\'' . $row['id'] . '\''); } if (0 < $row['upgrade_time_list'] && $row['upgrade_time_list'] < $timestamp) { $db->query('UPDATE `' . $db_mymps . 'information` SET upgrade_type_list = \'1\',upgrade_time_list = \'0\' WHERE id =\'' . $row['id'] . '\''); } } if ($idin2) { $iquery = $db->query('SELECT a.infoid,a.prepath FROM `' . $db_mymps . 'info_img` AS a WHERE 1 ' . $idin2); while ($r = $db->fetchRow($iquery)) { $info_list[$r['infoid']]['img'][] = $r['prepath']; } } $i = NULL; if (1 < $cat['modid'] && $idin) { $des = get_info_option_array(); $extra = $db->getAll('SELECT a.* FROM `' . $db_mymps . 'information_' . $cat[modid] . '` AS a WHERE 1 ' . $idin); foreach ($extra as $k => $v) { unset($v['iid']); unset($v['content']); foreach ($v as $u => $w) { $g = get_info_option_titval($des[$u], $w); if ($u != 'id' && !is_numeric($u)) { $info_list[$v['id']]['extra'][$u] = $g['value']; $info_list[$v['id']]['extraj'][$u] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $g['value']) : $g['value']; $info_list[$v['id']][$u] = $g['value']; } } } } if ($mayi) { $info_list = 5.4 <= PHP_VERSION ? json_encode($info_list, JSON_UNESCAPED_SLASHES) : str_replace('\\/', '/', json_encode($info_list)); echo $info_list; exit; } switch ($rewrite) { case 'rewrite': foreach ($mymps_extra_model as $key => $val) { if (is_array($val['list'])) { foreach ($val['list'] as $k => $v) { $mymps_extra_model[$key]['list'][$k]['uri'] = 'category'; $mymps_extra_model[$key]['list'][$k]['uri_a'] = 'index.php?mod=category&areaid=' . $areaid; foreach ($allow_identifiers as $keys) { if ($v['identifier'] == $keys) { $mymps_extra_model[$key]['list'][$k]['uri'] .= $v['id'] ? '-' . $keys . '-' . $v['id'] : ''; $mymps_extra_model[$key]['list'][$k]['uri_a'] .= $v['id'] ? '&' . $keys . '=' . $v['id'] : ''; } else { $mymps_extra_model[$key]['list'][$k]['uri'] .= ${$keys} ? '-' . $keys . '-' . ${$keys} : ''; $mymps_extra_model[$key]['list'][$k]['uri_a'] .= ${$keys} ? '&' . $keys . '=' . ${$keys} : ''; } } $mymps_extra_model[$key]['list'][$k]['uri'] .= '.html'; if ($v['id'] == ${$v}['identifier']) { $mymps_extra_model[$key]['list'][$k]['select'] .= 1; $page_title_extra .= $v[name] != '不限' ? $v[name] : ''; } else { $mymps_extra_model[$key]['list'][$k]['select'] .= 0; } } } } foreach ($area_list as $key => $val) { $area_list[$key]['uri'] = '/category'; foreach ($allow_identifiers as $keys) { if ($keys == 'areaid') { $area_list[$key]['uri'] .= $val['areaid'] ? '-' . $keys . '-' . $val[areaid] : ''; } else { $area_list[$key]['uri'] .= ${$keys} ? '-' . $keys . '-' . ${$keys} : ''; } } $area_list[$key]['uri'] .= '.html'; $area_list[$key]['select'] = $val['areaid'] == $areaid ? 1 : 0; } break; case 'rewrite_py': foreach ($mymps_extra_model as $key => $val) { if (is_array($val['list'])) { foreach ($val['list'] as $k => $v) { $mymps_extra_model[$key]['list'][$k]['uri'] = '/' . $dir_typename . '/'; $mymps_extra_model[$key]['list'][$k]['uri_a'] = 'index.php?mod=category&areaid=' . $areaid; foreach ($allow_identifiers as $keys) { if ($v['identifier'] == $keys) { $mymps_extra_model[$key]['list'][$k]['uri'] .= $v['id'] ? $keys . '-' . $v['id'] . '-' : ''; $mymps_extra_model[$key]['list'][$k]['uri_a'] .= $v['id'] ? '&' . $keys . '=' . $v['id'] : ''; } else { $mymps_extra_model[$key]['list'][$k]['uri'] .= ${$keys} ? $keys . '-' . ${$keys} . '-' : ''; $mymps_extra_model[$key]['list'][$k]['uri_a'] .= ${$keys} ? '&' . $keys . '=' . ${$keys} : ''; } } $mymps_extra_model[$key]['list'][$k]['uri'] = substr($mymps_extra_model[$key]['list'][$k]['uri'], 0, -1); $mymps_extra_model[$key]['list'][$k]['uri'] .= '/'; if ($v['id'] == ${$v}['identifier']) { $mymps_extra_model[$key]['list'][$k]['select'] .= 1; $page_title_extra .= $v['name'] != '不限' ? $v['name'] : ''; } else { $mymps_extra_model[$key]['list'][$k]['select'] .= 0; } } } } foreach ($area_list as $key => $val) { $area_list[$key]['uri'] = '/' . $dir_typename . '/'; foreach ($allow_identifiers as $keys) { if ($keys == 'areaid') { $area_list[$key]['uri'] .= $val['areaid'] ? $keys . '-' . $val['areaid'] . '-' : ''; } else { $area_list[$key]['uri'] .= ${$keys} ? $keys . '-' . ${$keys} . '-' : ''; } } $area_list[$key]['uri'] = substr($area_list[$key]['uri'], 0, -1); $area_list[$key]['uri'] .= '/'; $area_list[$key]['select'] = $val['areaid'] == $areaid ? 1 : 0; } break; default: foreach ($mymps_extra_model as $key => $val) { if (is_array($val['list'])) { foreach ($val['list'] as $k => $v) { // $mymps_extra_model[$key]['list'][$k]['uri'] = 'category.php?'; $mymps_extra_model[$key]['list'][$k]['uri'] = 'index.php?mod=category&'; $mymps_extra_model[$key]['list'][$k]['uri_a'] = 'index.php?mod=category&areaid=' . $areaid; foreach ($allow_identifiers as $keys) { if ($v['identifier'] == $keys) { $mymps_extra_model[$key]['list'][$k]['uri'] .= $v['id'] ? $keys . '=' . $v[id] . '&' : ''; $mymps_extra_model[$key]['list'][$k]['uri_a'] .= $v['id'] ? '&' . $keys . '=' . $v[id] : ''; } else { $mymps_extra_model[$key]['list'][$k]['uri'] .= ${$keys} ? $keys . '=' . ${$keys} . '&' : ''; $mymps_extra_model[$key]['list'][$k]['uri_a'] .= ${$keys} ? '&' . $keys . '=' . ${$keys} : ''; } } $mymps_extra_model[$key]['list'][$k]['uri'] = substr($mymps_extra_model[$key]['list'][$k]['uri'], 0, -1); if ($v[id] == ${$v}[identifier]) { $mymps_extra_model[$key]['list'][$k]['select'] .= 1; $page_title_extra .= $v[name] != '不限' ? $v[name] : ''; } else { $mymps_extra_model[$key]['list'][$k]['select'] .= 0; } } } } foreach ($area_list as $key => $val) { // $area_list[$key]['uri'] = '/index.php?mod=category&'; $area_list[$key]['uri'] = 'index.php?mod=category&'; foreach ($allow_identifiers as $keys) { if ($keys == 'areaid') { $area_list[$key]['uri'] .= $val['areaid'] ? $keys . '=' . $val[areaid] . '&' : ''; } else { $area_list[$key]['uri'] .= ${$keys} ? $keys . '=' . ${$keys} . '&' : ''; } } $area_list[$key]['uri'] = substr($area_list[$key]['uri'], 0, -1); $area_list[$key]['select'] = $val['areaid'] == $areaid ? 1 : 0; } break; } $pdetail = $mymps_global['SiteCity'] . $page_title_extra . ($cat['title'] ? $cat['title'] : $cat['catname']); $pdetail .= 1 < $page ? '-第' . $page . '页' : ''; $pdetail .= '-' . $mymps_global['SiteName']; $loc = get_location_m('category', $catid, '', '', $pdetail); $page_title = $loc['page_title']; $cat['keywords'] = $cat['keywords'] ? $cat['keywords'] : $cat['catname'] . '信息'; $cat['description'] = $cat['description'] ? $cat['description'] : $mymps_global['SiteCity'] . $cat['catname'] . '频道为您提供' . $mymps_global['SiteCity'] . $cat['catname'] . '信息,在此有大量' . $mymps_global['SiteCity'] . $cat['catname'] . '信息供您选择,您可以免费查看和发布' . $mymps_global['SiteCity'] . $cat['catname'] . '信息。'; include mymps_tpl('category_list');