session_begin(); $auth->acl($user->data); $user->setup(); $search_type = $config['search_type']; if (!class_exists($search_type)) { trigger_error('NO_SUCH_SEARCH_MODULE'); } $error = false; $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher); if ($error) { trigger_error($error); } print "\n
\n"; // // Fetch a batch of posts_text entries // $sql = "SELECT COUNT(*) as total, MAX(post_id) as max_post_id FROM ". POSTS_TABLE; if ( !($result = $db->sql_query($sql)) ) { $error = $db->sql_error(); die("Couldn't get maximum post ID :: " . $sql . " :: " . $error['message']); } $max_post_id = $db->sql_fetchrow($result); $totalposts = $max_post_id['total']; $max_post_id = $max_post_id['max_post_id']; $postcounter = (!isset($HTTP_GET_VARS['batchstart'])) ? 0 : $HTTP_GET_VARS['batchstart']; $batchsize = 200; // Process this many posts per loop $batchcount = 0; for(;$postcounter <= $max_post_id; $postcounter += $batchsize) { $batchstart = $postcounter + 1; $batchend = $postcounter + $batchsize; $batchcount++; $sql = "SELECT * FROM " . POSTS_TABLE . " WHERE post_id BETWEEN $batchstart AND $batchend"; if( !($result = $db->sql_query($sql)) ) { $error = $db->sql_error(); die("Couldn't get post_text :: " . $sql . " :: " . $error['message']); } $rowset = $db->sql_fetchrowset($result); $db->sql_freeresult($result); $post_rows = sizeof($rowset); if( $post_rows ) { // $sql = "LOCK TABLES ".POST_TEXT_TABLE." WRITE"; // $result = $db->sql_query($sql); print "\n\nRestart from posting $batchstart
\n";
// For every post in the batch:
for($post_nr = 0; $post_nr < $post_rows; $post_nr++ )
{
print ".";
flush();
$post_id = $rowset[$post_nr]['post_id'];
$search->index('post', $rowset[$post_nr]['post_id'], $rowset[$post_nr]['post_text'], $rowset[$post_nr]['post_subject'], $rowset[$post_nr]['poster_id']);
}
// $sql = "UNLOCK TABLES";
// $result = $db->sql_query($sql);
}
}
print "
Removing common words (words that appear in more than 50% of the posts)
\n";
flush();
$search->tidy();
print "Removed words that where too common.
";
echo "
Done";
?>
IA_pO~q}ݜL/#~c,f_PZY e]l3~n="Z0U*QCwP<$C2Ҍ}R@/YkϟhΆlb11z A5M!%ôwCc`ьPv0Z`.݂K4ݢmֽ7%i!t^1]ƒb00 E(:Eam !R pIHOz}( )^:eFuj$b0-Bu~3dR/5c<bMIK|o_+(\K
LU4͠{ yŁݬ|U@%Knx<C{l
dHo2\{"x? >&fO/x۟@=RJTZH#H6f{㧞ȤX݃M0""jد*ymU&7~JBl{0dேǁHtq ï>&*C?z.Gv
(inJ٬3}dD(pQʸ:V&=,LJJBiKqgKX^Q+ bI@AZOr;
0~IT{2B@X!)/o rt@9YP=<ArC$#bMN2_Idk6E:zAN@ -Ex`]th{XSړ58~\a/8aHSaI&yq3*¢kqRH|6BE*cN5}C+.ȤZDgH`4;C&yPqR54&Yv~4yΆ84Hxr.H(rƉbMHf Qygs9Ǹe%myvC;IS ڒy;Xh:(JVW\#[jjeȸ#?l^韯EEF}Ir^A>+7|HiWBMLAСg*Kr`"2ġfsfgw6$b(R*Ȥ2!
!$@WӉN-jӅWӓHNTvx3Y0WYʓ")V&ZSTY6i