$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 if ($val[0]) { $sq .= ' AND g.`' . $key . '` = \'' . $val[0] . '\' '; } } $s = ' LEFT JOIN `' . $db_mymps . 'information_' . $cat[modid] . '` AS g ON a.id = g.id'; $cache['list']['time'] = false; } } } require_once MYMPS_INC . '/cachepages.class.php'; $cachetime = $cache['list']['time']; $cachepages = new cachepages($cache['list']['time'], 'list_' . $catid . '_' . $areaid); $cachepages->cacheCheck(); unset($cache); $cat['caturi'] = Rewrite('category', array('catid' => $catid, 'dir_typename' => $cat['dir_typename'])); $cat['title'] = $cat['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'] . '信息。'; $mymps_extra_model = mod_identifier(); $mymps_extra_model = $mymps_extra_model[$cat['modid']]; $mymps_extra_model = is_array($mymps_extra_model) ? $mymps_extra_model : array(); $area_list = cat_list('area', 0, 0, false, 1); $page_title_extra = $areaid ? $area_list[$areaid]['areaname'] : ''; $area_list = array_merge(array( array('areaid' => '0', 'areaname' => '不限') ), $area_list); $cat_list = get_categories_tree($catid); $where .= 0 < $cat['parentid'] ? ' WHERE ' . get_children($catid) : ' WHERE a.gid = \'' . $catid . '\''; $where .= $sq ? $sq : ''; $where .= ' AND (a.info_level = 1 OR a.info_level = 2)'; $where .= 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 = setParam($allow_identifiers, $rewrite, 'category-', $mymps_global['SiteUrl'] . $seo['seo_htmldir'] . $cat['html_dir']); $rows_num = $db->getOne('SELECT COUNT(a.id) FROM `' . $db_mymps . 'information` AS a ' . $s . ' ' . $where); } else { write_msg('', $mymps_global[SiteUrl] . '/404.html'); exit(); $catid = 0; require_once MYMPS_INC . '/cachepages.class.php'; $cachetime = $cache['list']['time']; $cachepages = new cachepages($cache['list']['time'], 'list_' . $catid . '_' . $areaid); $cachepages->cacheCheck(); unset($cache); $cat['title'] = '最新发布 - ' . $mymps_global['SiteName']; $area_list = cat_list('area', 0, 0, false, 1); $cat_list = get_categories_tree(0, 'category'); $where .= ' WHERE 1 '; $where .= $sq ? $sq : ''; $where .= ' AND (a.info_level = 1 OR a.info_level = 2)'; $where .= empty($areaid) ? '' : ' AND a.areaid = \'' . $areaid . '\''; $orderby = ' ORDER BY a.begintime DESC'; $param = setParam(array(), 'rewrite', 'category-', $mymps_global['SiteUrl'] . '/category.html'); $rows_num = $db->getOne('SELECT COUNT(a.id) FROM `' . $db_mymps . 'information` AS a ' . $s . ' ' . $where); } $idin = get_page_idin('id', 'SELECT a.id FROM `' . $db_mymps . 'information` AS a ' . $s . $where . $orderby, $cat['template'] == 'list_gezi' ? 30 : $mymps_global['cfg_list_page_line']); $sql = 'SELECT a.id,a.tel,a.title,a.userid,a.contact_who,a.content,a.img_path,a.img_count,a.upgrade_type,a.upgrade_type_list,a.upgrade_time,a.upgrade_time_list,a.upgrade_time_index,a.begintime,a.endtime,a.info_level,a.certify,a.ifred,a.ifbold,a.dir_typename,b.areaname FROM ' . $db_mymps . 'information AS a LEFT JOIN `' . $db_mymps . 'area` AS b ON a.areaid = b.areaid WHERE a.id IN (' . $idin . ') ' . $orderby; $info_list = array(); $page1 = $idin ? $db->getAll($sql) : array(); foreach ($page1 as $key => $val) { $infolist['id'] = $val['id']; $infolist['begintime'] = $val['begintime']; $infolist['title'] = $val['title']; $infolist['ifred'] = $val['ifred']; $infolist['ifbold'] = $val['ifbold']; $infolist['tel'] = $val['tel']; $infolist['img_count'] = $val['img_count']; $infolist['content'] = clear_html($val['content']); $infolist['areaname'] = $val['areaname']; $infolist['contact_who'] = $val['contact_who']; $infolist['poster'] = !empty($val['userid']) ? ' $val['userid'])) . '>' . $val['userid'] . '' : ($val['contact_who'] ? $val['contact_who'] : '游客'); $infolist['img_path'] = $val['img_path']; $infolist['uri'] = Rewrite('info', array('id' => $val['id'], 'dir_typename' => $val['dir_typename'])); $infolist['info_level'] = $val['info_level']; $infolist['upgrade_type'] = !$cat['parentid'] ? $val['upgrade_type'] : $val['upgrade_type_list']; $infolist['certify'] = $val['certify']; $info_list[$val['id']] = $infolist; $ids = true; if (0 < $val['upgrade_time'] && $val['upgrade_time'] < $timestamp) { $db->query('UPDATE `' . $db_mymps . 'information` SET upgrade_type = \'1\',upgrade_time = \'0\' WHERE id =\'' . $val['id'] . '\''); } if (0 < $val['upgrade_time_list'] && $val['upgrade_time_list'] < $timestamp) { $db->query('UPDATE `' . $db_mymps . 'information` SET upgrade_type_list = \'1\',upgrade_time_list = \'0\' WHERE id =\'' . $val['id'] . '\''); } if (0 < $val['upgrade_time_index'] && $val['upgrade_time_index'] < $timestamp) { $db->query('UPDATE `' . $db_mymps . 'information` SET upgrade_type_index = \'1\',upgrade_time_index = \'0\' WHERE id =\'' . $val['id'] . '\''); } } $idin = $ids ? ' AND a.id IN (' . $idin . ') ' : ''; $pageline = NULL; $pageview = 0 < $catid ? page2($rewrite) : page2('rewrite'); $advertisement = get_advertisement('category'); $adveritems = $advertisement['items']; $advertisement['type'] = $advertisement['all'] ? (is_array($advertisement[$catid]['type']) ? array_merge($advertisement['all']['type'], $advertisement[$catid]['type']) : $advertisement['all']['type']) : $advertisement[$catid]['type']; if (0 < $catid) { 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'; foreach ($allow_identifiers as $keys) { if ($v['identifier'] == $keys) { $mymps_extra_model[$key]['list'][$k]['uri'] .= $v[id] ? '-' . $keys . '-' . $v[id] : ''; } else { $mymps_extra_model[$key]['list'][$k]['uri'] .= ${$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 . '/'; foreach ($allow_identifiers as $keys) { if ($v['identifier'] == $keys) { $mymps_extra_model[$key]['list'][$k]['uri'] .= $v['id'] ? $keys . '-' . $v['id'] . '-' : ''; } else { $mymps_extra_model[$key]['list'][$k]['uri'] .= ${$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?'; foreach ($allow_identifiers as $keys) { if ($v['identifier'] == $keys) { $mymps_extra_model[$key]['list'][$k]['uri'] .= $v['id'] ? $keys . '=' . $v[id] . '&' : ''; } else { $mymps_extra_model[$key]['list'][$k]['uri'] .= ${$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'] = '/category.php?'; 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('category', $catid, '', '', $pdetail); $page_title = $loc['page_title']; $location = $loc['location']; } else { foreach ($area_list as $key => $val) { $area_list[$key]['uri'] = '/category'; $area_list[$key]['uri'] .= $val['areaid'] ? '-areaid-' . $val['areaid'] : ''; $area_list[$key]['uri'] .= '.html'; $area_list[$key]['select'] = $val['areaid'] == $areaid ? 1 : 0; } $pdetail = $mymps_global['SiteCity'] . $page_title_extra . '最新信息'; $pdetail .= 1 < $page ? '-第' . $page . '页' : ''; $pdetail .= '-' . $mymps_global['SiteName']; $loc = get_location('category', '', '', '', $pdetail); $page_title = $loc['page_title']; $location = $loc['location'] . ' » 最新信息'; } if (0 < $cat['parentid']) { $flag = array_reverse(get_parent_cats('category', $catid)); $cat['parentid'] = $flag[0]['catid']; } if (0 < $catid) { $allow_identifier = $allow_identifer[$cat['modid']]['identifier']; } globalassign(); if ($cat['template'] == 'list') { 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']; } } } } } else if ($cat['template'] == 'list_simple') { } else if ($cat['template'] == 'list_box') { } else { 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']][$u] = $g['value']; } } } } } include 0 < $catid ? mymps_tpl($cat['template'] ? $cat['template'] : 'list') : mymps_tpl('list'); is_object($db) && $db->Close(); $cachetime && $cachepages->caching(); $info_list = $advertisement = NULL; unset($info_list); unset($advertisement); ?>