From 183851b06bd6c52f3cae5375f433da720d410447 Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Wed, 11 Oct 2006 18:12:39 +0000
Subject: MediaWiki 1.7.1 wiederhergestellt

---
 maintenance/rebuildtextindex.inc | 68 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 68 insertions(+)
 create mode 100644 maintenance/rebuildtextindex.inc

(limited to 'maintenance/rebuildtextindex.inc')

diff --git a/maintenance/rebuildtextindex.inc b/maintenance/rebuildtextindex.inc
new file mode 100644
index 00000000..5035b564
--- /dev/null
+++ b/maintenance/rebuildtextindex.inc
@@ -0,0 +1,68 @@
+<?php
+require_once 'counter.php';
+/**
+ * Rebuild the fulltext search indexes. This may take a while
+ * depending on the database size and server configuration.
+ *
+ * Rebuilding is faster if you drop the index and recreate it,
+ * but that will prevent searches from working while it runs.
+ *
+ * @todo document
+ * @package MediaWiki
+ * @subpackage Maintenance
+ */
+
+/** */
+define( "RTI_CHUNK_SIZE", 500 );
+
+function dropTextIndex( &$database )
+{
+	$searchindex = $database->tableName( 'searchindex' );
+	if ( $database->indexExists( "searchindex", "si_title" ) ) {
+		echo "Dropping index...\n";
+		$sql = "ALTER TABLE $searchindex DROP INDEX si_title, DROP INDEX si_text";
+		$database->query($sql, "dropTextIndex" );
+	}
+}
+
+function createTextIndex( &$database )
+{
+	$searchindex = $database->tableName( 'searchindex' );
+	echo "\nRebuild the index...\n";
+	$sql = "ALTER TABLE $searchindex ADD FULLTEXT si_title (si_title), " .
+	  "ADD FULLTEXT si_text (si_text)";
+	$database->query($sql, "createTextIndex" );
+}
+
+function rebuildTextIndex( &$database )
+{
+	extract( $database->tableNames( 'page', 'revision', 'text', 'searchindex' ) );
+
+	$sql = "SELECT MAX(page_id) AS count FROM $page";
+	$res = $database->query($sql, "rebuildTextIndex" );
+	$s = $database->fetchObject($res);
+	$count = $s->count;
+	echo "Rebuilding index fields for {$count} pages...\n";
+	$n = 0;
+
+	while ( $n < $count ) {
+		print_c( $n - 1, $n);
+		$end = $n + RTI_CHUNK_SIZE - 1;
+		$sql = "SELECT page_id, page_namespace, page_title, old_flags, old_text
+		          FROM $page, $revision, $text
+		         WHERE page_id BETWEEN $n AND $end
+		           AND page_latest=rev_id
+		           AND rev_text_id=old_id";
+		$res = $database->query($sql, "rebuildTextIndex" );
+
+		while( $s = $database->fetchObject($res) ) {
+			$revtext = Revision::getRevisionText( $s );
+			$u = new SearchUpdate( $s->page_id, $s->page_title, $revtext );
+			$u->doUpdate();
+		}
+		$database->freeResult( $res );
+		$n += RTI_CHUNK_SIZE;
+	}
+}
+
+?>
-- 
cgit v1.2.2