getOne('SELECT COUNT(a.id) FROM `' . $db_mymps . 'information` AS a ' . $s . ' WHERE (a.info_level = 1 OR a.info_level = 2) ' . $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) ' . $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_index'] = $row['upgrade_type_index']; $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_index'] && $row['upgrade_time_index'] < $timestamp) { $db->query('UPDATE `' . $db_mymps . 'information` SET upgrade_type_index = \'1\',upgrade_time_index = \'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']; } } if ($mayi) { $info_list = 5.4000000000000004 <= PHP_VERSION ? json_encode($info_list, JSON_UNESCAPED_SLASHES) : str_replace('\\/', '/', json_encode($info_list)); echo $info_list; exit(); } $seo = get_seoset(); $mymps_global = array_merge($mymps_global, $seo); $loc = get_location_m('index'); $page_title = $loc['page_title']; $count = array(); $count['info'] = mymps_count('information'); $count['store'] = mymps_count('member', ' WHERE if_corp = 1'); include mymps_tpl('index'); ?>