session_begin(); $auth->acl($user->data); $user->setup(); $search_type = $config['search_type']; if (!file_exists($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx)) { trigger_error('NO_SUCH_SEARCH_MODULE'); } require($phpbb_root_path . 'includes/search/' . $search_type . '.' . $phpEx); $error = false; $search = new $search_type($error); 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 +ELRrI6-KFLd*?=ؒɼqAjhߓsN_Ƌ>Bjfg5#%FmJa["[@`_q"d?*)M'vN@1d3hN?= _[qYAKcl:RF
8w8RMx^"ea|`|-%XL$3iwзC!-XKܭ+3E݊.og~bdxdnB!QTn1 i<
Vd5wb9~~g1U$O!I߬)o\"NզJiԂdy)>fHOn&qa{_ڂ^r,;@=3_"6@wBCؒ"n4Sj%ɵ";G)~LWBnӃ{O,Ui_nplH,74\j_3IW0f|
\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";
?>
nkƉiY!gCD|l#ib#\֤U?Dl1NQD`&[iȶ0Q']&sR#O)bG9KԴoF=>ph; vۢqi90LJCǡW{,lOhCTS@T{gl_d+d+lTN Iš_0\R~e.@G2u#c/Łaecs-!+
Cݟ`AaY ,AM2oTL땏ó#|IЍ>\*Vpqgg0'b>g8(D,w5ChI-ciu`f΄;lɂy-lE
=ʥO(4ufG\<(03>[[`,CyHX0l%B #q!*qŇۯKD5V5Ѥ; y]>[cS0fҚ5}z%,x94HlCP|FZhWxڽC
ZO*mw&GP?27#Y(SszK\g?a*l gCPb[PG`
ߺDP|Æ
A !RXlKDY lΏ~G$goD
B)WNVNj24
h":UaM-~l{;JQLLn I+2,Px&⡃2긟#E)S `#~2DhB2Aki}i<~-w/d1hK1qP"}3yvZ8iHJdWjMZ}(
MjYYIH0
mNyfr!$T4E!D0爮sW: r3ϝoH{["5yOoiRv+ڧ
F477kR#*r;nt[o=FfcIrJyFJ+bUΣgvXpjWX Fp Pٖp(e~4Ǯ ,RFӜs_$Q/yȯg01Lҍh墑4Zvrabrpݜ.Up7HH!ej/Qraձ]\>e~~vhBL .jLꭍW?f{-:x[U#;g9M4Ѯ 3RS1;*OWٵ!dzYL2i#}Z٣5OCn)m\bE/}&aohi\WgZup8sIN6}]ACvK5?taڵX&l4wL^稷
>?9(x,Oz;H[ co`-h+_DLGV=;I3uA`'?ewaC>363u&gLSBqm+r',eݫ<&.@=3)DQB_(4a˨
vDy