Discuz!搜索分类信息的字段的实现

admin

Discuz!搜索分类信息的字段的实现


修改文件：search_forum.php
修改方法：
step1：   将 $sqlsrch = $srchtype == 'fulltext' ? 行后修改成

1. "FROM pre_forum_typeoptionvar o, ".DB::table(getposttable($seltableid))." p, ".DB::table('forum_thread')." t WHERE $digestltd t.fid IN ($fids) $topltd AND p.tid=t.tid AND p.invisible='0' AND o.tid=t.tid" :
   
2.     "FROM pre_forum_typeoptionvar o, ".DB::table('forum_thread')." t WHERE $digestltd t.fid IN ($fids) $topltd AND o.tid=t.tid";

复制代码

step2:    将 if($srchtxt) { 的下一行修改成

1. $srcharr = $srchtype == 'fulltext' ? searchkey($keyword, "(p.message LIKE '%{text}%' OR p.subject LIKE '%{text}%' OR o.value LIKE '%{text}%')", true) : searchkey($keyword,"t.subject LIKE '%{text}%' OR o.value LIKE '%{text}%'", true);

复制代码