河風本人試用過兩三次，沒有發現問題！(中文化可能不是很好，請自行再翻譯)
將下列代碼存為 admin_rebuild_search.php 後丟到 admin 目錄下
[php]<?php
/***************************************************************************
* admin_rebuild_search.php
* -------------------
* time : Thursday, January 30, 2003
* author : Peter Wyss
* email : wysspeter@bluewin.ch
* version : 1.2
*
*
\n ***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
define('IN_PHPBB', 1);
if( !empty($setmodules) )
{
$filename = basename(__FILE__);
$module['General']['重建搜尋索引'] = $filename;
return;
}
//
// Include required files, get $phpEx and check permissions
//
$no_page_header = TRUE;
$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
if(( isset($HTTP_POST_VARS['rebuild'])) OR ($HTTP_GET_VARS['start_id'] > 0))
{
include($phpbb_root_path . 'includes/functions_search.'.$phpEx);
if ($HTTP_GET_VARS['start_id']==0)
{
// Empty wordlist tables
$sql = "DELETE FROM " . SEARCH_WORD_TABLE;
$result = $db->sql_query($sql);
if ( !$result )
{
message_die(GENERAL_ERROR, "Could not empty search_wordlist table.", "",__LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM " . SEARCH_MATCH_TABLE;
$result = $db->sql_query($sql);
if ( !$result )
{
message_die(GENERAL_ERROR, "Could not empty search_wordmatch table.", "",__LINE__, __FILE__, $sql);
}
}
$sql = "SELECT count(*) as pcount FROM " . POSTS_TEXT_TABLE;
$result = $db->sql_query($sql);
if ( !$result )
{
message_die(GENERAL_ERROR, "Could not find posts.", "",__LINE__, __FILE__, $sql);
}
$postcount = $db->sql_fetchrow($result);
$nextpage = 0;
for( $i = $HTTP_GET_VARS['start_id']; $i < $postcount[pcount]; $i++ )
{
if ($i == $HTTP_GET_VARS['start_id'] + 100)
{
$nextpage=1;
break;
}
$sql = "SELECT post_id FROM " . POSTS_TEXT_TABLE . " LIMIT " . $i . ",1";
$result = $db->sql_query($sql);
if ( !$result )
{
message_die(GENERAL_ERROR, "Could not find posts.", "",__LINE__, __FILE__, $sql);
}
$posts = $db->sql_fetchrow($result);
$activeid = $posts['post_id'];
$sql = "SELECT * FROM " . POSTS_TEXT_TABLE . " WHERE post_id = " . $activeid;
$result = $db->sql_query($sql);
if ( !$result )
{
message_die(GENERAL_ERROR, "Could not find posts.", "",__LINE__, __FILE__, $sql);
}
$activepost = $db->sql_fetchrowset($result);
add_search_words('single', $activepost[0]['post_id'], stripslashes($activepost[0]['post_text']), stripslashes($activepost[0]['post_subject']));
}
if ($nextpage==1)
{
$template->assign_vars(array(
'META' => '<meta http-equiv="refresh" content="3;url=' . append_sid("admin_rebuild_search.$phpEx?start_id=$i") . '">')
);
$message = $i . ' 文章 完成';
$message .= "<br /><br />" . sprintf('點選 %s這裡%s 繼續 (或等待三秒鐘)', "<a href=\"" . append_sid("admin_rebuild_search.$phpEx?start_id=$i") . "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
else
{
$message = '重新建立完成';
$message .= "<br /><br />" . sprintf('點選 %s這裡%s 返回到 重建搜尋索引介面', "<a href=\"" . append_sid("admin_rebuild_search.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf('點選 %s這裡%s 返回控制台', "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
}
$template->set_filenames(array(
"body" => "admin/rebuild_search_body.tpl")
);
$template->assign_vars(array(
"S_FORM_ACTION" => append_sid("admin_rebuild_search.$phpEx?start_id=0"),
"L_INFO" => $output_info,
"L_REBUILD_SEARCH_TITLE" => "重建搜尋索引",
"L_REBUILD_SEARCH_SUBMIT" => "重新建立")
);
include('./page_header_admin.'.$phpEx);
$template->pparse("body");
include('./page_footer_admin.'.$phpEx);
?>[/php]
存成 rebuild_search_body.tpl 後丟到 template 的 admin 目錄下
代碼: 選擇全部
<h1>{L_REBUILD_SEARCH_TITLE}</h1>
<form method="post" action="{S_FORM_ACTION}"><table cellspacing="1" cellpadding="4" border="0" align="center" class="forumline">
<tr>
<th class="thHead" colspan="2">{L_REBUILD_SEARCH_TITLE}</th>
</tr>
<tr>
<td class="row2" align="center"><input type="submit" name="rebuild" value="{L_REBUILD_SEARCH_SUBMIT}" class="mainoption" /></td>
</tr>
</table></form>這個外掛好像是可以加速搜尋時的時間，以及改善文章之間對應的問題，對於有大量文章的論壇來說蠻實用的....
)