Going ahead and adding this field while other DB updates are pending.

Interfaces to use it can be added shortly.

* Add user_editcount field to provide data for heuristics on account use.
  Incremented on edit, with lazy initialization from past revision data.
  Can batch-initialize with maintenance/initEditCount.php (not yet friendly
  to replication environments, this will do all accounts in one query).
* Allow raw SQL subsections in Database::update() SET portion as well as
  for WHERE portion. Handy for increments and such.

1 files changed, 40 insertions, 0 deletions

diff --git a/maintenance/initEditCount.php b/maintenance/initEditCount.php
new file mode 100644
index 000000000000..a975f356162d
--- /dev/null
+++ b/maintenance/initEditCount.php
@@ -0,0 +1,40 @@
+<?php
+
+require_once "commandLine.inc";
+
+// @fixme: add replication-friendly batch mode
+
+$dbw = wfGetDB( DB_MASTER );
+$user = $dbw->tableName( 'user' );
+$revision = $dbw->tableName( 'revision' );
+
+$dbver = $dbw->getServerVersion();
+if( ($dbw instanceof DatabaseMySql && version_compare( $dbver, '4.1' ) < 0)
+	|| isset( $options['force-mysql4'] ) ) {
+	
+	echo "Warning: MySQL $dbver; using hacky MySQL 4.0 compatibility query...\n";
+	$sql = "CREATE TEMPORARY TABLE temp_editcount (
+	  temp_user_id INT,
+	  temp_user_editcount INT
+	)";
+	$dbw->query( $sql );
+	
+	$sql = "INSERT INTO temp_editcount
+	  (temp_user_id, temp_user_editcount)
+	  SELECT rev_user, COUNT(rev_user)
+	    FROM $revision GROUP BY rev_user";
+	$dbw->query( $sql );
+
+	$sql = "UPDATE $user
+	  LEFT OUTER JOIN temp_editcount ON user_id=temp_user_id
+	  SET user_editcount=IF(temp_user_editcount IS NULL,0,temp_user_editcount)";
+	$dbw->query( $sql );
+} else {
+	// Subselect should work on modern MySQLs etc
+	$sql = "UPDATE $user SET user_editcount=(SELECT COUNT(*) FROM $revision WHERE rev_user=user_id)";
+	$dbw->query( $sql );
+}
+
+echo "Done!\n";
+
+?>