From 7e86b9ceb632ac5e879a3eb9e2577a153b06deef Mon Sep 17 00:00:00 2001
From: Aaron Schulz <aaron@users.mediawiki.org>
Date: Mon, 21 May 2007 23:56:05 +0000
Subject: [PATCH] *Flag bot edits

---
 maintenance/rebuildrecentchanges.inc | 21 +++++++++++++++++++++
 maintenance/rebuildrecentchanges.php |  1 +
 2 files changed, 22 insertions(+)

diff --git a/maintenance/rebuildrecentchanges.inc b/maintenance/rebuildrecentchanges.inc
index 9f1abf1bcf..586c9b6ecd 100644
--- a/maintenance/rebuildrecentchanges.inc
+++ b/maintenance/rebuildrecentchanges.inc
@@ -90,4 +90,25 @@ function rebuildRecentChangesTablePass2()
 	$dbw->freeResult( $res );
 }
 
+function rebuildRecentChangesTablePass3()
+{
+	$dbw = wfGetDB( DB_MASTER );
+	list ($recentchanges, $usergroups) = $dbw->tableNamesN( 'recentchanges', 'user_groups' );
+
+	print( "Flagging bot account edits...\n" );
+
+	# Fill in the rc_bot field
+	$sql = "SELECT DISTINCT rc_user FROM $recentchanges " .
+		"LEFT JOIN $usergroups ON rc_user=ug_user " . 
+		"WHERE ug_group='bot'";
+	$res = $dbw->query( $sql, DB_MASTER );
+
+	while ( $obj = $dbw->fetchObject( $res ) ) {
+		$sql2 = "UPDATE $recentchanges SET rc_bot=1 " .
+				"WHERE rc_user={$obj->rc_user}";
+		$dbw->query( $sql2 );
+	}
+	$dbw->freeResult( $res );
+}
+
 ?>
diff --git a/maintenance/rebuildrecentchanges.php b/maintenance/rebuildrecentchanges.php
index 7fe91dd33c..b5c76bf3f1 100644
--- a/maintenance/rebuildrecentchanges.php
+++ b/maintenance/rebuildrecentchanges.php
@@ -17,6 +17,7 @@ $wgDBpassword		= $wgDBadminpassword;
 
 rebuildRecentChangesTablePass1();
 rebuildRecentChangesTablePass2();
+rebuildRecentChangesTablePass3(); // flag bot edits
 
 print "Done.\n";
 exit();
-- 
2.20.1