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' => '')
);
$message = $i . ' posts completed';
$message .= "
" . sprintf('Click %sHere%s to continue (or wait 3 seconds)', "", "");
message_die(GENERAL_MESSAGE, $message);
}
else
{
$message = 'Rebuild successful';
$message .= "
" . sprintf('Click %sHere%s to return to \'Rebuild Search Index\'', "", "") . "
" . sprintf('Click %sHere%s to return to the Admin Index', "", "");
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" => "Rebuild Search Index",
"L_REBUILD_SEARCH_SUBMIT" => "Rebuild")
);
include('./page_header_admin.'.$phpEx);
$template->pparse("body");
include('./page_footer_admin.'.$phpEx);
?>