(bug 20268) Fixed Database::estimateRowCount on SQLite backend. This involved moving...

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

diff --git a/maintenance/deleteRevision.php b/maintenance/deleteRevision.php
index 6623de1..5dc0b59 100644 (file)
--- a/maintenance/deleteRevision.php
+++ b/maintenance/deleteRevision.php
@@ -2,11 +2,25 @@
 /**
  * Delete one or more revisions by moving them to the archive table.
  *
- * @file
+ * 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
+ * (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.,
+ * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
+ * http://www.gnu.org/copyleft/gpl.html
+ *
  * @ingroup Maintenance
  */
 
-require_once( "Maintenance.php" );
+require_once( dirname(__FILE__) . '/Maintenance.php' );
 
 class DeleteRevision extends Maintenance {
        
@@ -30,6 +44,7 @@ class DeleteRevision extends Maintenance {
                                array(
                                        'ar_namespace'  => 'page_namespace',
                                        'ar_title'      => 'page_title',
+                                       'ar_page_id'    => 'page_id',
                                        'ar_comment'    => 'rev_comment',
                                        'ar_user'       => 'rev_user',
                                        'ar_user_text'  => 'rev_user_text',
@@ -37,6 +52,8 @@ class DeleteRevision extends Maintenance {
                                        'ar_minor_edit' => 'rev_minor_edit',
                                        'ar_rev_id'     => 'rev_id',
                                        'ar_text_id'    => 'rev_text_id',
+                                       'ar_deleted'    => 'rev_deleted',
+                                       'ar_len'        => 'rev_len',
                                ), array(
                                        'rev_id' => $revID,
                                        'page_id = rev_page'
@@ -46,7 +63,14 @@ class DeleteRevision extends Maintenance {
                                $this->output( "Revision $revID not found\n" );
                        } else {
                                $affected += $dbw->affectedRows();
+                               $pageID = $dbw->selectField( 'revision', 'rev_page', array( 'rev_id' => $revID ), __METHOD__ );
+                               $pageLatest = $dbw->selectField( 'page', 'page_latest', array( 'page_id' => $pageID ), __METHOD__ );
                                $dbw->delete( 'revision', array( 'rev_id' => $revID ) );
+                               if ( $pageLatest == $revID ) {
+                                       // Database integrity
+                                       $newLatest = $dbw->selectField( 'revision', 'rev_id', array( 'rev_page' => $pageID ), __METHOD__, array( 'ORDER BY' => 'rev_timestamp DESC' ) );
+                                       $dbw->update( 'page', array( 'page_latest' => $newLatest ), array( 'page_id' => $pageID ), __METHOD__ );
+                               }
                        }
                }
                $this->output( "Deleted $affected revisions\n" );