diff options
Diffstat (limited to 'phpBB/develop/search_fill.php')
-rw-r--r-- | phpBB/develop/search_fill.php | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/phpBB/develop/search_fill.php b/phpBB/develop/search_fill.php index 6b83b6848b..371c8c74cc 100644 --- a/phpBB/develop/search_fill.php +++ b/phpBB/develop/search_fill.php @@ -1,4 +1,4 @@ -<?php +<?php // // Security message: @@ -54,9 +54,9 @@ print "<html>\n<body>\n"; // // Fetch a batch of posts_text entries // -$sql = "SELECT COUNT(*) as total, MAX(post_id) as max_post_id +$sql = "SELECT COUNT(*) as total, MAX(post_id) as max_post_id FROM ". POSTS_TABLE; -if ( !($result = $db->sql_query($sql)) ) +if ( !($result = $db->sql_query($sql)) ) { $error = $db->sql_error(); die("Couldn't get maximum post ID :: " . $sql . " :: " . $error['message']); @@ -77,10 +77,10 @@ for(;$postcounter <= $max_post_id; $postcounter += $batchsize) $batchend = $postcounter + $batchsize; $batchcount++; - $sql = "SELECT * - FROM " . POSTS_TABLE . " - WHERE post_id - BETWEEN $batchstart + $sql = "SELECT * + FROM " . POSTS_TABLE . " + WHERE post_id + BETWEEN $batchstart AND $batchend"; if( !($result = $db->sql_query($sql)) ) { @@ -97,16 +97,16 @@ for(;$postcounter <= $max_post_id; $postcounter += $batchsize) { // $sql = "LOCK TABLES ".POST_TEXT_TABLE." WRITE"; - // $result = $db->sql_query($sql); + // $result = $db->sql_query($sql); print "\n<p>\n<a href='{$_SERVER['PHP_SELF']}?batchstart=$batchstart'>Restart from posting $batchstart</a><br>\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']; + $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']); } |