Merge from SerbianVariants branch, trunk 16500 vs SerbianVariants 16523

[lhc/web/wiklou.git] / maintenance / orphans.php

diff --git a/maintenance/orphans.php b/maintenance/orphans.php
old mode 100755 (executable)
new mode 100644 (file)
index 7532344..3bfa79f
--- a/maintenance/orphans.php
+++ b/maintenance/orphans.php
@@ -1,20 +1,20 @@
 <?php
 # Copyright (C) 2005 Brion Vibber <brion@pobox.com>
 # http://www.mediawiki.org/
-# 
+#
 # This program is free software; you can redistribute it and/or modify
 # it under the terms of the GNU General Public License as published by
-# the Free Software Foundation; either version 2 of the License, or 
+# the Free Software Foundation; either version 2 of the License, or
 # (at your option) any later version.
-# 
+#
 # This program is distributed in the hope that it will be useful,
 # but WITHOUT ANY WARRANTY; without even the implied warranty of
 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 # GNU General Public License for more details.
-# 
+#
 # 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
 
 /**
@@ -35,6 +35,7 @@ require_once( 'commandLine.inc' );
 $wgTitle = Title::newFromText( 'Orphan revision cleanup script' );
 
 checkOrphans( isset( $options['fix'] ) );
+checkSeparation( isset( $options['fix'] ) );
 #checkWidows( isset( $options['fix'] ) );
 
 # ------
@@ -43,11 +44,11 @@ function checkOrphans( $fix ) {
        $dbw =& wfGetDB( DB_MASTER );
        $page = $dbw->tableName( 'page' );
        $revision = $dbw->tableName( 'revision' );
-       
+
        if( $fix ) {
                $dbw->query( "LOCK TABLES $page WRITE, $revision WRITE" );
        }
-       
+
        echo "Checking for orphan revision table entries... (this may take a while on a large wiki)\n";
        $result = $dbw->query( "
                SELECT *
@@ -79,7 +80,7 @@ function checkOrphans( $fix ) {
        } else {
                echo "No orphans! Yay!\n";
        }
-       
+
        if( $fix ) {
                $dbw->query( "UNLOCK TABLES" );
        }
@@ -94,11 +95,11 @@ function checkWidows( $fix ) {
        $dbw =& wfGetDB( DB_MASTER );
        $page = $dbw->tableName( 'page' );
        $revision = $dbw->tableName( 'revision' );
-       
+
        if( $fix ) {
                $dbw->query( "LOCK TABLES $page WRITE, $revision WRITE" );
        }
-       
+
        echo "\nChecking for childless page table entries... (this may take a while on a large wiki)\n";
        $result = $dbw->query( "
                SELECT *
@@ -126,7 +127,78 @@ function checkWidows( $fix ) {
        } else {
                echo "No childless pages! Yay!\n";
        }
-       
+
+       if( $fix ) {
+               $dbw->query( "UNLOCK TABLES" );
+       }
+}
+
+
+function checkSeparation( $fix ) {
+       $dbw =& wfGetDB( DB_MASTER );
+       $page     = $dbw->tableName( 'page' );
+       $revision = $dbw->tableName( 'revision' );
+       $text     = $dbw->tableName( 'text' );
+
+       if( $fix ) {
+               $dbw->query( "LOCK TABLES $page WRITE, $revision WRITE, $text WRITE" );
+       }
+
+       echo "\nChecking for pages whose page_latest links are incorrect... (this may take a while on a large wiki)\n";
+       $result = $dbw->query( "
+               SELECT *
+               FROM $page LEFT OUTER JOIN $revision ON page_latest=rev_id
+       ");
+       $found = 0;
+       while( $row = $dbw->fetchObject( $result ) ) {
+               $result2 = $dbw->query( "
+                       SELECT MAX(rev_timestamp) as max_timestamp
+                       FROM $revision
+                       WHERE rev_page=$row->page_id
+               " );
+               $row2 = $dbw->fetchObject( $result2 );
+               $dbw->freeResult( $result2 );
+               if( $row2 ) {
+                       if( $row->rev_timestamp != $row2->max_timestamp ) {
+                               if( $found == 0 ) {
+                                       printf( "%10s %10s %14s %14s\n",
+                                               'page_id', 'rev_id', 'timestamp', 'max timestamp' );
+                               }
+                               ++$found;
+                               printf( "%10d %10d %14s %14s\n",
+                                       $row->page_id,
+                                       $row->page_latest,
+                                       $row->rev_timestamp,
+                                       $row2->max_timestamp );
+                               if( $fix ) {
+                                       # ...
+                                       $maxId = $dbw->selectField(
+                                               'revision',
+                                               'rev_id',
+                                               array(
+                                                       'rev_page'      => $row->page_id,
+                                                       'rev_timestamp' => $row2->max_timestamp ) );
+                                       echo "... updating to revision $maxId\n";
+                                       $maxRev = Revision::newFromId( $maxId );
+                                       $title = Title::makeTitle( $row->page_namespace, $row->page_title );
+                                       $article = new Article( $title );
+                                       $article->updateRevisionOn( $dbw, $maxRev );
+                               }
+                       }
+               } else {
+                       echo "wtf\n";
+               }
+       }
+
+       if( $found ) {
+               echo "Found $found pages with incorrect latest revision.\n";
+       } else {
+               echo "No pages with incorrect latest revision. Yay!\n";
+       }
+       if( !$fix && $found > 0 ) {
+               echo "Run again with --fix to remove these entries automatically.\n";
+       }
+
        if( $fix ) {
                $dbw->query( "UNLOCK TABLES" );
        }