插件名稱: 強大搜索功能 全文搜索顯示所在帖
適用版本: 4.0、4.1
作 者: 小康
修 改: search.php、search_thread模版
用 途: 全文搜索能顯示包含字串的帖子, 並可直接跳去瀏覽該帖子
D5.0 & D5.5: http://alan888.com/Discuz/viewthread.php?tid=118158
以往的搜索功能有個缺點..
全文搜索後, 出現回覆數極多的主題...
而你又不知包含字串的帖在哪裏...
你可能要逐頁找找...
這個插件能在全文搜索顯示各主題包含字串的帖子數目
以及帖子的編號, 是以下拉選單顯示的
選取帖子編號後, 便會開新視窗, 直接跳到該帖子的位置!!
******************************************************
1) 升級數據庫:
ALTER TABLE `cdb_searchindex` ADD `pids` text NOT NULL;
2) 修改search.php, 找:
$query = $db->query("SELECT searchstring, keywords, threads, tids
後加:
找:
上加:
if ($index[pids]) {
$tidsa = explode(',', substr($index[tids], 2));
$pids = array();
foreach(explode('|', substr($index[pids], 2)) AS $id => $val) {
$pidsc = explode(',', $val);
$tid = $tidsa[$id];
$pids[$tid][pidsn] = count($pidsc);
foreach($pidsc AS $id2 => $val2) {
$temp = explode(':', $val2);
$pids[$tid][pids][$temp[0]] = "<option value=\"viewthread.php?tid=".$tid."&highlight=".$index[keywords]."&page=".ceil(($temp[1]+1)/$ppp)."#pid".$temp[0]."\">#".($temp[1]+1)."</option>";
}
}
}
找:
$threadlist[] = procthread($thread);
上加:
if ($index[pids]) {
ksort($pids[$thread[tid]][pids]);
$thread[pids] = implode('', $pids[$thread[tid]][pids]);
$thread[pidsn] = $pids[$thread[tid]][pidsn];
}
找:
"FROM {$tablepre}posts p, {$tablepre}threads t WHERE t.fid IN ($fids) AND p.tid=t.tid AND p.invisible='0'"
換成:
", COUNT(pp.pid) AS cnum, p.pid FROM {$tablepre}posts p, {$tablepre}threads t LEFT JOIN {$tablepre}posts pp ON pp.tid=p.tid WHERE pp.pid<p.pid AND p.tid=t.tid AND p.invisible='0'"
找:
$threads = $tids = 0;
$query = $db->query("SELECT DISTINCT t.tid, t.closed $sqlsrch ORDER BY tid DESC LIMIT $maxsearchresults");
while($thread = $db->fetch_array($query)) {
if($thread['closed'] <= 1) {
$tids .= ','.$thread['tid'];
$threads++;
}
}
換成:
$threads = $tids = $pids = $ltid = 0;
$pidarray = array();
$query = $db->query("SELECT DISTINCT t.tid, t.closed $sqlsrch GROUP BY ".($srchtype=='fulltext'?'p.pid':'t.tid')." ORDER BY tid DESC LIMIT $maxsearchresults");
while($thread = $db->fetch_array($query)) {
if($thread['closed'] <= 1) {
if ($thread[tid] != $ltid) {
$tids .= ','.$thread[tid];
$ltid = $thread[tid];
$threads++;
}
if ($srchtype == 'fulltext') {
$pidarray[$thread[tid]][] = $thread[pid].':'.$thread[cnum];
}
}
}
if (is_array($pidarray)) {
foreach($pidarray AS $id => $val) {
$pids .= '|';
foreach($val AS $id2 => $val2) {
$comma = $id2>0 ? ',' : '';
$pids .= $comma.$val2;
}
}
}
找:
$db->query("INSERT INTO {$tablepre}searchindex (keywords, searchstring, useip, uid, dateline, expiration, threads, tids
後加:
下一行找:
VALUES ('$keywords', '$searchstring', '$onlineip', '$discuz_uid', '$timestamp', '$expiration', '$threads', '$tids'
後加:
******************************************************
3) 修改search_thread模版, 找:
<td align="center" width="14%">{lang forum}</td>
<td align="center" width="12%">{lang author}</td>
<td align="center" width="6%">{lang replies}</td>
<td align="center" width="6%">{lang views}</td>
<td align="center" width="19%">{lang lastpost}</td>
換成:
<td align="center" width="13%">{lang forum}</td>
<td align="center" width="9%">{lang author}</td>
<td align="center" width="5%">{lang replies}</td>
<td align="center" width="5%">{lang views}</td>
<!--{if $index[pids]}--><td align="center" width="8%">所在帖</td><!--{/if}-->
<td align="center" width="17%">{lang lastpost}</td>
找(會找到多個, 最後那個):
<td class="altbg1" align="center">
換成:
<!--{if $index[pids]}-->
<td class="altbg1" align="center"><select onchange="if (this.value) window.open(this.value)"><option>共$thread[pidsn]個</option>$thread[pids]</select></td>
<td class="altbg2" align="center">
<!--{else}-->
<td class="altbg1" align="center">
<!--{/if}-->
應該無bug, 如有請pm..
回覆就是力量!!
[
本帖最後由 小康@HK 於 2007-7-11 14:10 編輯 ]
