| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223 |
- <?php
- define('IN_SMT', true);
- define('IN_MYMPS', true);
- define('CURSCRIPT', 'index');
- require_once dirname(__FILE__) . '/include/global.php';
- require_once MYMPS_DATA . '/config.php';
- require_once MYMPS_DATA . '/config.db.php';
- require_once MYMPS_INC . '/db.class.php';
- ifsiteopen();
- runcron();
- $mayimobile = get_mobile_settings();
- $mayimobile['mobiledomain'] = $mayimobile['mobiledomain'] ? $mayimobile['mobiledomain'] : $mymps_global['SiteUrl'] . '/m';
- $mayimobile['mobileuri'] = $mayimobile['mobiledomain'];
- if ($ifmobile) {
- write_msg('', $mayimobile['mobileuri']);
- exit;
- }
- $cache = get_cache_config();
- require_once MYMPS_INC . '/cachepages.class.php';
- $cachepages = new cachepages($cache['site']['time'], 'index');
- $cachetime = 0 < $cache['site']['time'] ? true : false;
- $cachepages->cacheCheck();
- unset($cache);
- $tpl_index = get_tpl_index();
- $tpl_index = $tpl_index['tpl_set'];
- $seo = get_seoset();
- $mymps_global = array_merge($mymps_global, $seo);
- $loc = get_location('index');
- $location = $loc['location'];
- $page_title = $loc['page_title'];
- $advertisement = get_advertisement('index');
- $adveritems = $advertisement['items'];
- $advertisement['type'] = $advertisement['all'] ? is_array($advertisement['type']) ? array_merge($advertisement['all']['type'], $advertisement['type']) : $advertisement['all']['type'] : $advertisement['type'];
- $about['friendlink_uri'] = $mymps_global['SiteUrl'] . Rewrite('about', array('part' => 'friendlink'));
- if ($tpl_index['banmian'] == 'portal') {
- $index_cat = get_categories_tree(0, 'category');
- if (ifplugin('group')) {
- require_once MYMPS_ROOT . '/plugin/group/include/functions.php';
- $groups = mymps_get_groups(3);
- $groupclass = get_group_class();
- }
- if (ifplugin('goods')) {
- require_once MYMPS_ROOT . '/plugin/goods/include/functions.php';
- $goods = mymps_get_goods($tpl_index['goods'], 1);
- }
- $in = $tpl_index['portal']['ershou'] . ',' . $tpl_index['portal']['zhaopin'] . ',' . $tpl_index['portal']['ershoufang'] . ',' . $tpl_index['portal']['jianli'] . ',' . $tpl_index['portal']['zufang'];
- if ($query = $db->query('SELECT catid,dir_typename FROM `' . $db_mymps . 'category` WHERE catid IN(' . $in . ')')) {
- while ($row = $db->fetchRow($query)) {
- $hd[$row['catid']]['dir_typename'] = $row['dir_typename'];
- }
- }
- $portaluri['moreershou'] = Rewrite('category', array('catid' => $tpl_index['portal']['ershou'], 'dir_typename' => $hd[$tpl_index['portal']['ershou']]['dir_typename']));
- $portaluri['catidershou'] = $tpl_index['portal']['ershou'];
- $portaluri['morezufang'] = Rewrite('category', array('catid' => $tpl_index['portal']['zufang'], 'dir_typename' => $hd[$tpl_index['portal']['zufang']]['dir_typename']));
- $portaluri['catidzufang'] = $tpl_index['portal']['zufang'];
- $portaluri['postzhaopin'] = $mymps_global['cfg_postfile'] . '?catid=' . $tpl_index['portal']['zhaopin'];
- $portaluri['morezhaopin'] = Rewrite('category', array('catid' => $tpl_index['portal']['zhaopin'], 'dir_typename' => $hd[$tpl_index['portal']['zhaopin']]['dir_typename']));
- $portaluri['catidzhaopin'] = $tpl_index['portal']['zhaopin'];
- $portaluri['moreershoufang'] = Rewrite('category', array('catid' => $tpl_index['portal']['ershoufang'], 'dir_typename' => $hd[$tpl_index['portal']['ershoufang']]['dir_typename']));
- $portaluri['catidershoufang'] = $tpl_index['portal']['ershoufang'];
- $portaluri['morejianli'] = Rewrite('category', array('catid' => $tpl_index['portal']['jianli'], 'dir_typename' => $hd[$tpl_index['portal']['jianli']]['dir_typename']));
- $portaluri['catidjianli'] = $tpl_index['portal']['jianli'];
- $arr = '';
- $zhaopin = array();
- $query = $db->query('SELECT a.id,a.title,a.ifred,a.ifbold,a.dir_typename,g.' . $tpl_index[portali][company] . ' FROM `' . $db_mymps . 'information` AS a LEFT JOIN `' . $db_mymps . 'information_' . $tpl_index[portal][zhaopinmod] . '` AS g ON a.id = g.id WHERE ' . get_children($tpl_index[portal][zhaopin]) . ' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC LIMIT 0,12');
- while ($row = $db->fetchRow($query)) {
- $arr['id'] = $row['id'];
- $arr['title'] = $row['title'];
- $arr['ifred'] = $row['ifred'];
- $arr['ifbold'] = $row['ifbold'];
- $arr[$tpl_index['portali']['company']] = $row[$tpl_index['portali']['company']];
- $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
- $zhaopin[$row['id']] = $arr;
- }
- $arr = '';
- $jianli = array();
- $query = $db->query('SELECT a.id,a.title,a.ifred,a.ifbold,a.contact_who,a.dir_typename FROM `' . $db_mymps . 'information` AS a WHERE ' . get_children($tpl_index[portal][jianli]) . ' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC LIMIT 0,4');
- if ($query) {
- while ($row = $db->fetchRow($query)) {
- $arr['id'] = $row['id'];
- $arr['title'] = $row['title'];
- $arr['ifred'] = $row['ifred'];
- $arr['ifbold'] = $row['ifbold'];
- $arr['contact_who'] = $row['contact_who'];
- $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
- $jianli[$row['id']] = $arr;
- }
- }
- $arr = '';
- $esf = array();
- $query = $db->query('SELECT a.id,a.title,a.ifred,a.ifbold,a.img_path,a.dir_typename,g.' . $tpl_index[portali][acreage] . ',g.' . $tpl_index[portali][prices] . ' FROM `' . $db_mymps . 'information` AS a LEFT JOIN `' . $db_mymps . 'information_' . $tpl_index[portal][ershoufangmod] . '` AS g ON a.id = g.id WHERE ' . get_children($tpl_index[portal][ershoufang]) . ' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC LIMIT 0,12');
- while ($row = $db->fetchRow($query)) {
- $arr['id'] = $row['id'];
- $arr['title'] = $row['title'];
- $arr['ifred'] = $row['ifred'];
- $arr['ifbold'] = $row['ifbold'];
- $arr['img_path'] = $row['img_path'];
- $arr[$tpl_index[portali][prices]] = $row[$tpl_index[portali][prices]];
- $arr[$tpl_index[portali][acreage]] = $row[$tpl_index[portali][acreage]];
- $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
- $esf[$row['id']] = $arr;
- }
- $arr = '';
- $czf = array();
- $query = $db->query('SELECT a.id,a.title,a.ifred,a.ifbold,a.img_path,a.dir_typename FROM `' . $db_mymps . 'information` AS a WHERE ' . get_children($tpl_index[portal][zufang]) . ' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC LIMIT 0,4');
- while ($row = $db->fetchRow($query)) {
- $arr['id'] = $row['id'];
- $arr['title'] = $row['title'];
- $arr['ifred'] = $row['ifred'];
- $arr['ifbold'] = $row['ifbold'];
- $arr['img_path'] = $row['img_path'];
- $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
- $czf[$row['id']] = $arr;
- }
- unset($arr);
- $ershou = $ershou_img = array();
- $inershou = get_children($tpl_index[portal][ershou]);
- $query = $db->query('SELECT a.id,a.title,a.ifred,a.ifbold,a.begintime,a.catname,a.dir_typename FROM ' . $db_mymps . 'information AS a WHERE ' . $inershou . ' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC LIMIT 0,10');
- while ($row = $db->fetchRow($query)) {
- $arr['id'] = $row['id'];
- $arr['title'] = $row['title'];
- $arr['begintime'] = $row['begintime'];
- $arr['catname'] = $row['catname'];
- $arr['ifred'] = $row['ifred'];
- $arr['ifbold'] = $row['ifbold'];
- $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
- $ershou[$row['id']] = $arr;
- }
- $arr = '';
- $query = $db->query('SELECT a.id,a.title,a.img_path,a.dir_typename FROM `' . $db_mymps . 'information` AS a WHERE ' . $inershou . ' AND (a.info_level = 1 OR a.info_level = 2) AND img_path != \'\' ORDER BY a.begintime DESC LIMIT 0,6');
- if ($query) {
- while ($row = $db->fetchRow($query)) {
- $arr['id'] = $row['id'];
- $arr['title'] = $row['title'];
- $arr['img_path'] = $row['img_path'];
- $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
- $ershou_img[$row['id']] = $arr;
- }
- }
- } else {
- if ($tpl_index['banmian'] == 'classic') {
- $index_cat = get_categories_tree(0, 'category');
- if (is_array($index_cat)) {
- foreach ($index_cat as $firstcatkey => $firstcatval) {
- $idin = get_page_idin2('id', 'SELECT a.id FROM `' . $db_mymps . 'information` AS a WHERE a.gid=\'' . $firstcatval['catid'] . '\' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC', $tpl_index['foreachinfo']);
- if ($idin) {
- $query = $db->query('SELECT a.catname,a.dir_typename,a.id,a.userid,a.catid,a.title,a.ifred,a.ifbold,a.begintime FROM `' . $db_mymps . 'information` AS a WHERE a.id IN (' . $idin . ') ORDER BY a.begintime DESC');
- $index_cat[$firstcatval['catid']]['information'] = array();
- while ($irow = $db->fetchRow($query)) {
- $arr['id'] = $irow['id'];
- $arr['title'] = $irow['title'];
- $arr['begintime'] = $irow['begintime'];
- $arr['catname'] = $irow['catname'];
- $arr['ifred'] = $irow['ifred'];
- $arr['ifbold'] = $irow['ifbold'];
- $arr['caturi'] = Rewrite('category', array('dir_typename' => $irow['dir_typename'], 'catid' => $irow['catid']));
- $arr['uri'] = Rewrite('info', array('id' => $irow['id'], 'dir_typename' => $irow['dir_typename']));
- $index_cat[$firstcatval['catid']]['information'][] = $arr;
- }
- }
- }
- }
- $tpl_index[classic][cats] = $tpl_index[classic][cats] ? $tpl_index[classic][cats] + 1 : '12';
- } else {
- if ($tpl_index['banmian'] == 'simple') {
- if (ifplugin('goods')) {
- require_once MYMPS_ROOT . '/plugin/goods/include/functions.php';
- $goods = mymps_get_goods($tpl_index['goods'], 1);
- }
- $index_cat = get_categories_tree(0, 'category');
- $firstcats = get_smplist_cats($tpl_index['smp_cats']['first'], $tpl_index['showstyle']);
- $secondcats = get_smplist_cats($tpl_index['smp_cats']['second'], $tpl_index['showstyle']);
- $thirdcats = get_smplist_cats($tpl_index['smp_cats']['third'], $tpl_index['showstyle']);
- $fourthcats = get_smplist_cats($tpl_index['smp_cats']['fourth'], $tpl_index['showstyle']);
- } else {
- if ($tpl_index['banmian'] == 'gezi') {
- $where .= ' WHERE 1 ';
- $where .= ' AND (a.info_level = 1 OR a.info_level = 2)';
- $orderby = ' ORDER BY a.upgrade_type_index DESC,a.begintime DESC';
- $param = setParam(array('catid'), 'active', 'news-');
- $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, 30);
- $sql = 'SELECT a.id,a.tel,a.title,a.userid,a.contact_who,a.content,a.img_path,a.img_count,a.upgrade_type_index,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']) ? '<a target="black" href=' . Rewrite('space', array('user' => $val['userid'])) . '>' . $val['userid'] . '</a>' : ($val['contact_who'] ? $val['contact_who'] : '游客');
- $infolist['img_path'] = $val['img_path'];
- $infolist['img_count'] = $val['img_count'];
- $infolist['uri'] = Rewrite('info', array('id' => $val['id'], 'dir_typename' => $val['dir_typename']));
- $infolist['info_level'] = $val['info_level'];
- $infolist['upgrade_type_index'] = $val['upgrade_type_index'];
- $infolist['certify'] = $val['certify'];
- $info_list[$val['id']] = $infolist;
- $ids = true;
- 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 = page2('active');
- }
- }
- }
- }
- include mymps_tpl('index_' . $tpl_index['banmian']);
- is_object($db) && $db->Close();
- $cachetime && $cachepages->caching();
- $advertisement = NULL;
- unset($advertisement);
|