#
# You should have received a copy of the GNU General Public License along
# with this program; if not, write to the Free Software Foundation, Inc.,
-# 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
# http://www.gnu.org/copyleft/gpl.html
+/**
+ * @file
+ * @ingroup Maintenance
+ */
+
/**
* Look for duplicate user table entries and optionally prune them.
+ * @ingroup Maintenance
*/
class UserDupes {
var $db;
var $reassigned;
var $trimmed;
var $failed;
-
+
function UserDupes( &$database ) {
$this->db =& $database;
}
-
+
/**
* Check if this database's user table has already had a unique
* user_name index applied.
echo "WARNING: doesn't seem to have user_name index at all!\n";
return false;
}
-
+
# Confusingly, 'Non_unique' is 0 for *unique* indexes,
# and 1 for *non-unique* indexes. Pass the crack, MySQL,
# it's obviously some good stuff!
- return ( $info->Non_unique == 0 );
+ return ( $info[0]->Non_unique == 0 );
}
-
+
/**
* Checks the database for duplicate user account records
* and remove them in preparation for application of a unique
function clearDupes() {
return $this->checkDupes( true );
}
-
+
/**
* Checks the database for duplicate user account records
* in preparation for application of a unique index on the
* @return bool
*/
function checkDupes( $doDelete = false ) {
- global $wgDBname;
-
if( $this->hasUniqueIndex() ) {
- echo "$wgDBname already has a unique index on its user table.\n";
+ echo wfWikiID()." already has a unique index on its user table.\n";
return true;
}
-
+
$this->lock();
-
+
echo "Checking for duplicate accounts...\n";
$dupes = $this->getDupes();
$count = count( $dupes );
-
- echo "Found $count accounts with duplicate records on $wgDBname.\n";
+
+ echo "Found $count accounts with duplicate records on ".wfWikiID().".\n";
$this->trimmed = 0;
$this->reassigned = 0;
$this->failed = 0;
foreach( $dupes as $name ) {
$this->examine( $name, $doDelete );
}
-
+
$this->unlock();
-
+
echo "\n";
-
+
if( $this->reassigned > 0 ) {
if( $doDelete ) {
echo "$this->reassigned duplicate accounts had edits reassigned to a canonical record id.\n";
echo "$this->reassigned duplicate accounts need to have edits reassigned.\n";
}
}
-
+
if( $this->trimmed > 0 ) {
if( $doDelete ) {
- echo "$this->trimmed duplicate user records were deleted from $wgDBname.\n";
+ echo "$this->trimmed duplicate user records were deleted from ".wfWikiID().".\n";
} else {
- echo "$this->trimmed duplicate user accounts were found on $wgDBname which can be removed safely.\n";
+ echo "$this->trimmed duplicate user accounts were found on ".wfWikiID()." which can be removed safely.\n";
}
}
-
+
if( $this->failed > 0 ) {
echo "Something terribly awry; $this->failed duplicate accounts were not removed.\n";
return false;
}
-
+
if( $this->trimmed == 0 || $doDelete ) {
echo "It is now safe to apply the unique index on user_name.\n";
return true;
return false;
}
}
-
+
/**
* We don't want anybody to mess with our stuff...
* @access private
}
$names = array_map( array( $this, 'lockTable' ), $set );
$tables = implode( ',', $names );
-
- $result = $this->db->query( "LOCK TABLES $tables", $fname );
+
+ $this->db->query( "LOCK TABLES $tables", $fname );
}
-
+
function lockTable( $table ) {
return $this->db->tableName( $table ) . ' WRITE';
}
-
+
/**
* @return bool
* @access private
function newSchema() {
return class_exists( 'Revision' );
}
-
+
/**
* @access private
*/
function unlock() {
$fname = 'UserDupes::unlock';
- $result = $this->db->query( "UNLOCK TABLES", $fname );
+ $this->db->query( "UNLOCK TABLES", $fname );
}
-
+
/**
* Grab usernames for which multiple records are present in the database.
* @return array
FROM $user
GROUP BY user_name
HAVING n > 1", $fname );
-
+
$list = array();
while( $row = $this->db->fetchObject( $result ) ) {
$list[] = $row->user_name;
}
$this->db->freeResult( $result );
-
+
return $list;
}
-
+
/**
* Examine user records for the given name. Try to see which record
* will be the one that actually gets used, then check remaining records
array( 'user_id' ),
array( 'user_name' => $name ),
$fname );
-
+
$firstRow = $this->db->fetchObject( $result );
$firstId = $firstRow->user_id;
echo "Record that will be used for '$name' is user_id=$firstId\n";
-
+
while( $row = $this->db->fetchObject( $result ) ) {
$dupeId = $row->user_id;
echo "... dupe id $dupeId: ";
}
$this->db->freeResult( $result );
}
-
+
/**
* Count the number of edits attributed to this user.
* Does not currently check log table or other things
$this->editCountOn( 'old', 'old_user', $userid );
}
}
-
+
/**
* Count the number of hits on a given table for this account.
* @param string $table
array( $field => $userid ),
$fname ) );
}
-
+
/**
* @param int $from
* @param int $to
$this->reassignEditsOn( $table, $field, $from, $to );
}
}
-
+
/**
* @param string $table
* @param string $field
function reassignEditsOn( $table, $field, $from, $to ) {
$fname = 'UserDupes::reassignEditsOn';
echo "reassigning on $table... ";
- $result = $this->db->update( $table,
+ $this->db->update( $table,
array( $field => $to ),
array( $field => $from ),
$fname );
echo "ok. ";
}
-
+
/**
* Remove a user account line.
* @param int $userid
$this->db->delete( 'user', array( 'user_id' => $userid ), $fname );
echo " ok";
}
-
-}
-
-?>
\ No newline at end of file
+}