代码拉取完成，页面将自动刷新
<?php
define('IN_SMT',true);
define('CURSCRIPT','search');
define('IN_MYMPS', true);
require_once dirname(__FILE__).'/include/global.php';
require_once dirname(__FILE__)."/data/config.php";
require_once MYMPS_DATA.'/config.db.php';
require_once MYMPS_INC.'/db.class.php';
ifsiteopen();
$catid = isset($catid) ? intval($catid) : '';
$areaid = isset($areaid) ? intval($areaid) : '';
$posttime = isset($posttime) ? intval($posttime) : '';
$tel = isset($tel) ? checkhtml($tel) : '';
$keywords = checkhtml($keywords);
if(preg_match("/from|script|or|invalid/i",$keywords)) $keywords = '';
$keywords = str_replace(array('/','?'),array(' ',' '),$keywords);
$keywords = isset($keywords) ? trim(preg_replace("/(\s+)/",' ',$keywords)) : '';
$mod = isset($mod) ? trim(($mod)) : '';
if($keywords == '请输入关键词或分类名') $keywords = $_GET['keywords'] = '';
!in_array($mod,array('information','store','coupon','group','news','goods')) && $mod = 'information';
$pluginsettings = read_static_cache('plugin');
$allowplugin = array();
if(is_array($pluginsettings)){
foreach($pluginsettings as $k => $v){
if($v['disable'] != 1){
$allowplugin[$k]['flag'] = $v['flag'];
$allowplugin[$k]['name'] = $v['name'];
}
}
}
$sql = $search = $where = $cat_children = $allow_identifier = '';
switch($mod){
case 'information':
if($keywords != '' || $tel != ''){
require MYMPS_DATA."/info_posttime.php";
$search['page_title'] = ($keywords != '' ? $keywords.' - ' : '').'信息搜索 - '.$mymps_global['SiteName'];
if($catid){
$modid = $db -> getOne("SELECT modid FROM `{$db_mymps}category` WHERE catid = '$catid'");
$cat_children = get_children($catid);
$allow_identifier = allow_identifier();
$allow_identifier = $allow_identifier[$modid]['identifier'];
$mymps_extra_model = mod_identifier();
$extra_model = $mymps_extra_model[$modid];
$sq = $s = '';
if($modid > 1 && is_array($allow_identifier)){
$s = "LEFT JOIN `{$db_mymps}information_{$modid}` AS g ON a.id = g.id";
foreach ($$_request as $key => $val){
if(in_array($key,$allow_identifier) && !empty($$key)){
$where .= " AND g.`$key` = '$val' ";
}
}
}
}
if(is_array($keyword = explode(' ',$keywords))){
$or = '';
$sqlkeywords = '';
foreach($keyword as $k => $v){
$sqlkeywords .= " $or a.title LIKE '%".$v."%' OR a.content LIKE '%".$v."%' OR c.catname LIKE '%".$v."%'";
$or = 'OR';
}
$where .= " AND ($sqlkeywords)";
}
$where .= $areaid != '' ? " AND a.areaid = '$areaid'" : "";
$where .= $tel != '' ? " AND a.tel LIKE '%".$tel."%'" : "";
$where .= $catid != '' ? " AND ".$cat_children : "";
$where .= $posttime != '' ? "AND a.begintime >= (".$timestamp."-".$posttime."*3600*24)" : "";
$where .= "AND (a.info_level = '1' OR a.info_level = '2')";
$search['rows_num'] = $rows_num = $db -> getOne("SELECT COUNT(a.id) FROM `{$db_mymps}information` AS a LEFT JOIN `{$db_mymps}category` AS c ON a.catid = c.catid {$s} WHERE 1 {$where}");
$param = $catid != '' && is_array($allow_identifier) ? setParam(array_merge(array('part','keywords','catid','areaid','posttime','tel'),$allow_identifier)) : setParam(array('mod','keywords','catid','areaid','posttime','tel'));
$searchresult = page1("SELECT a.id,a.areaid,a.begintime,a.title,a.content,a.ismember,a.contact_who,a.begintime,a.catid,c.catname,a.dir_typename FROM `{$db_mymps}information` AS a LEFT JOIN `{$db_mymps}category` AS c ON a.catid = c.catid {$s} WHERE 1 {$where} ORDER BY a.id DESC");
$ids = '';
foreach($searchresult as $k => $val){
$result['id'] = $val['id'];
$result['uri'] = Rewrite('info',array('id'=>$val['id'],'dir_typename'=>$val['dir_typename']));
$result['begintime'] = $val['begintime'];
$result['title'] = HighLight($val['title'],$keywords);
$result['content'] = HighLight(cutstr(clear_html($val['content']),180),$keywords);
$result['poster'] = $val['ismember'] == 1 ? '<a target="black" href='.Rewrite('space',array("userid"=>$val["userid"])).$val["userid"].'</a>' : $val['contact_who'] ? $val['contact_who'] : '游客';
$result['catname'] = HighLight($val['catname'],$keywords);
$result['caturi'] = Rewrite('category',array('catid'=>$val['catid'],'dir_typename'=>$val['dir_typename']));
$search['result'][$val['id']] = $result;
$ids .= $val['id'].',';
}
if($idin = substr($ids,0,-1)){
$idin = $idin = $idin ? " AND a.id IN (".$idin.") " : "";
}
$search['pagination'] = page2();
if($search['result'] && $catid && $idin && is_array($allow_identifier)){
$des = get_info_option_array();
$extra = $db ->getAll("SELECT a.* FROM `{$db_mymps}information_{$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)){
$search['result'][$v[id]]['extra'][$u] = $g['value'];
}
}
}
}
$posttime_select = GetInfoPostTime($posttime);
$catoption = get_categories_tree(0,'category');
$select_where_option = cat_list('area',0,$areaid);
}
break;
case 'store':
if($keywords != ''){
$document_domain = str_replace('http://www.','',$mymps_global['SiteUrl']);
$search['page_title'] = ($keywords != '' ? $keywords.' - ' : '').'商家搜索 - '.$mymps_global['SiteName'];
if($keywords != ''){
if(is_array($keyword = explode(' ',$keywords))){
$or = '';
$sqlkeywords = '';
foreach($keyword as $k => $v){
$sqlkeywords .= " $or a.tname LIKE '%".$v."%' OR a.introduce LIKE '%".$v."%' OR a.userid LIKE '%".$v."%'";
$or = 'OR';
}
$where .= " AND ($sqlkeywords)";
}
$where .= !empty($catid) ? " AND b.catid IN(".get_corp_children($catid).") " : "";
$where .= !empty($areaid) ? " AND a.areaid = '$areaid' " : "";
$where .= " AND a.if_corp = '1'";
$sql = empty($catid) ? "SELECT a.* FROM `{$db_mymps}member` AS a WHERE 1 {$where} ORDER BY a.jointime DESC" : "SELECT a.* FROM `{$db_mymps}member` AS a LEFT JOIN `{$db_mymps}member_category` AS b ON a.userid = b.userid WHERE 1 {$where} ORDER BY a.jointime DESC";
$count_sql = empty($catid) ? "SELECT COUNT(a.id) FROM `{$db_mymps}member` AS a WHERE 1 {$where}" : "SELECT COUNT(b.id) FROM `{$db_mymps}member` AS a LEFT JOIN {$db_mymps}member_category AS b ON a.userid = b.userid WHERE 1 $where";
$search['rows_num'] = $rows_num = $db -> getOne($count_sql);
$param = setParam(array('mod','catid','areaid','keywords'));
if(is_array($res = page1($sql))){
foreach($res as $key => $val){
$arr['userid'] = $val['userid'];
$arr['tel'] = $val['tel'] ? $val['tel'] : '尚未填写电话信息';
$arr['address'] = $val['address'] ? $val['address'] : '尚未填写地址信息';
$arr['tname'] = $val['tname'] ? $val['tname'] : $val['userid'];
$arr['prelogo'] = $val['prelogo'] ? $val['prelogo'] : '/images/nophoto.jpg';
$arr['tname'] = HighLight($val['tname'] ? $val['tname'] : $val['userid'],$keyword ? $keyword : $keywords);
$arr['uri'] = Rewrite('store',array('uid'=>$val['id']));
$arr['uri_aboutus'] = Rewrite('store',array('uid'=>$val['id'],'part'=>'about'));
$arr['uri_comment'] = Rewrite('store',array('uid'=>$val['id'],'part'=>'comment'));
$arr['uri_album'] = Rewrite('store',array('uid'=>$val['id'],'part'=>'album'));
$search['result'][] = $arr;
}
}
$search['pagination'] = page2();
}
$catoption = get_corp_tree(0,'corp');
$select_where_option = cat_list('area',0,$areaid);
}
break;
case 'news':
if($keywords != ''){
!ifplugin('news') && exit('管理员已禁用或未安装新闻插件...');
$catoption = cat_list('channel',0,0,false,1);
$area_list = cat_list('area',0,$areaid);
if($keywords != ''){
if(is_array($keyword = explode(' ',$keywords))){
$or = '';
$sqlkeywords = '';
foreach($keyword as $k => $v){
$sqlkeywords .= " $or n.title LIKE '%".$v."%' OR n.content LIKE '%".$v."%'";
$or = 'OR';
}
$where .= " AND ($sqlkeywords)";
}
$where .= !empty($catid) ? " AND n.catid IN (".get_cat_children($catid,'channel').")" : "";
$sql = "SELECT n.*,c.catname,c.html_dir FROM `{$db_mymps}news` AS n LEFT JOIN `{$db_mymps}channel` AS c ON n.catid = c.catid WHERE 1 $where";
$search['rows_num'] = $rows_num = $db -> getOne("SELECT COUNT(n.id) FROM `{$db_mymps}news` AS n WHERE 1 $where");
$param = setParam(array('mod','catid','keywords'));
$searchresult = page1($sql);
foreach($searchresult as $k => $val){
$result['id'] = $val['id'];
$result['hit'] = $val['hit'];
$result['uri'] = Rewrite('news',array('id'=>$val['id'],'html_path'=>$val['html_path']));
$result['begintime'] = $val['begintime'];
$result['title'] = HighLight($val['title'],$keyword ? $keyword : $keywords);
$result['content'] = HighLight(cutstr(clear_html($val['content']),300),$keyword ? $keyword : $keywords);
$result['catname'] = $val['catname'];
$result['caturi'] = Rewrite('news',array('catid'=>$val['catid'],'html_dir'=>$val['html_dir']));
$search['result'][] = $result;
}
$search['pagination'] = page2();
}
$search['page_title'] = ($keywords != '' ? $keywords.' - ' : '').'网站新闻搜索 - '.$mymps_global['SiteName'];
}
break;
case 'group':
if($keywords != ''){
require_once MYMPS_ROOT.'/plugin/group/include/functions.php';
$group_class = get_group_class();
$catoption = $group_class;
$select_where_option = cat_list('area',0,$areaid);
require_once MYMPS_DATA.'/grouplevel.inc.php';
if($keywords != ''){
$where = "WHERE glevel > '0'";
if(is_array($keyword = explode(' ',$keywords))){
$or = '';
$sqlkeywords = '';
foreach($keyword as $k => $v){
$sqlkeywords .= " $or gname LIKE '%".$v."%'";
$or = 'OR';
}
$where .= " AND ($sqlkeywords)";
}
if($cate_id) $where .= " AND cate_id = '$cate_id'";
if($areaid) $where .= " AND areaid = '$areaid'";
$search['rows_num'] = $rows_num = $db -> getOne("SELECT COUNT(groupid) FROM `{$db_mymps}group` $where");
$param = setParam(array('mod','cate_id','areaid','keywords'));
$group = page1("SELECT * FROM `{$db_mymps}group` $where ORDER BY displayorder DESC");
foreach($group as $k => $v){
$result['groupid'] = $v['groupid'];
$result['gname'] = $v['gname'];
$result['des'] = clear_html($v['des']);
$result['enddate'] = $v['enddate'];
$result['meetdate'] = $v['meetdate'];
$result['gaddress'] = $v['gaddress'];
$result['glevel'] = $v['glevel'];
$result['signintotal'] = $v['signintotal'];
$result['commenturl'] = $v['commenturl'];
$result['pre_picture'] = $v['pre_picture'];
$result['uri'] = plugin_url('group',array('id'=>$v['groupid']));
$search['result'][] = $result;
}
$search['pagination'] = page2();
}
$search['page_title'] = ($keywords != '' ? $keywords.' - ' : '').'团购活动搜索 - '.$mymps_global['SiteName'];
}
break;
case 'coupon':
if($keywords != ''){
require_once MYMPS_ROOT.'/plugin/coupon/include/functions.php';
$coupon_class = get_coupon_class();
$catoption = $coupon_class;
$select_where_option = cat_list('area',0,$areaid);
if($keywords != ''){
$where = "WHERE status = '1' AND grade > '0'";
if(is_array($keyword = explode(' ',$keywords))){
$or = '';
$sqlkeywords = '';
foreach($keyword as $k => $v){
$sqlkeywords .= " $or title LIKE '%".$v."%'";
$or = 'OR';
}
$where .= " AND ($sqlkeywords)";
}
if($cate_id) $where .= " AND cate_id = '$cate_id'";
if($areaid) $where .= " AND areaid = '$areaid'";
$search['rows_num'] = $rows_num = $db->getOne("SELECT count(id) FROM {$db_mymps}coupon $where");
$param = setParam(array('mod','cate_id','areaid'));
$coupon = page1("SELECT * FROM `{$db_mymps}coupon` $where ORDER BY begindate DESC");
foreach($coupon as $k => $v){
$result['id'] = $v['id'];
$result['title'] = $v['title'];
$result['des'] = $v['des'];
$result['enddate'] = $v['enddate'];
$result['begindate'] = $v['begindate'];
$result['prints'] = $v['prints'];
$result['pre_picture'] = $v['pre_picture'];
$result['sup'] = $v['sup'];
$result['uri'] = plugin_url('coupon',array('id'=>$v['id']));
$search['result'][] = $result;
}
$search['pagination'] = page2();
}
$search['page_title'] = ($keywords != '' ? $keywords.' - ' : '').'优惠券搜索 - '.$mymps_global['SiteName'];
}
break;
case 'goods':
if($keywords != ''){
require_once MYMPS_ROOT.'/plugin/goods/include/functions.php';
$goods_class = goods_category_tree(0);
$catoption = $goods_class;
$area_list = cat_list('area',0,$areaid);
if($keywords != ''){
$where = "WHERE onsale = '1'";
if(is_array($keyword = explode(' ',$keywords))){
$or = '';
$sqlkeywords = '';
foreach($keyword as $k => $v){
$sqlkeywords .= " $or goodsname LIKE '%".$v."%'";
$or = 'OR';
}
$where .= " AND ($sqlkeywords)";
}
if($catid) $where .= " AND catid IN (".mymps_get_goods_children($catid).")";
if($areaid) $where .= " AND areaid = '$areaid'";
$search['rows_num'] = $rows_num = $db -> getOne("SELECT COUNT(goodsid) FROM `{$db_mymps}goods` $where");
$param = setParam(array('mod','cate_id','areaid'));
$goods = page1("SELECT * FROM `{$db_mymps}goods` $where ORDER BY dateline DESC",16);
foreach($goods as $k => $v){
$result['goodsid'] = $v['goodsid'];
$result['goodsname'] = $v['goodsname'];
$result['nowprice'] = $v['nowprice'];
$result['pre_picture'] = $v['pre_picture'] ? $v['pre_picture'] : $mymps_global['SiteUrl'].'/images/nophoto.gif';
$result['uri'] = plugin_url('goods',array('id'=>$v['goodsid']));
$search['result'][] = $result;
}
$search['pagination'] = page2();
}
$search['page_title'] = ($keywords != '' ? $keywords.' - ' : '').'商品搜索 - '.$mymps_global['SiteName'];
}
break;
}
$mtime = explode(' ', microtime());
$totaltime = number_format(($mtime[1] + $mtime[0] - $mymps_starttime), 6);
$sitedebug = 'Processed in '.$totaltime.' second(s) , '.$db->query_num.' queries';
$search['keywords'] = $keywords;
$search['tel'] = $tel;
include ($keywords || $tel) ? mymps_tpl(CURSCRIPT.'_'.$mod) : mymps_tpl('search_index');
is_object($db) && $db -> Close();
?>
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手