[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * Delete self-references to $wgServer from the externallinks table.
   4   *
   5   * This program is free software; you can redistribute it and/or modify
   6   * it under the terms of the GNU General Public License as published by
   7   * the Free Software Foundation; either version 2 of the License, or
   8   * (at your option) any later version.
   9   *
  10   * This program is distributed in the hope that it will be useful,
  11   * but WITHOUT ANY WARRANTY; without even the implied warranty of
  12   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  13   * GNU General Public License for more details.
  14   *
  15   * You should have received a copy of the GNU General Public License along
  16   * with this program; if not, write to the Free Software Foundation, Inc.,
  17   * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
  18   * http://www.gnu.org/copyleft/gpl.html
  19   *
  20   * @file
  21   * @ingroup Maintenance
  22   */
  23  
  24  require_once  __DIR__ . '/Maintenance.php';
  25  
  26  /**
  27   * Maintenance script that deletes self-references to $wgServer
  28   * from the externallinks table.
  29   *
  30   * @ingroup Maintenance
  31   */
  32  class DeleteSelfExternals extends Maintenance {
  33  	public function __construct() {
  34          parent::__construct();
  35          $this->mDescription = 'Delete self-references to $wgServer from externallinks';
  36          $this->mBatchSize = 1000;
  37      }
  38  
  39  	public function execute() {
  40          global $wgServer;
  41          $this->output( "Deleting self externals from $wgServer\n" );
  42          $db = wfGetDB( DB_MASTER );
  43          while ( 1 ) {
  44              wfWaitForSlaves();
  45              $db->commit( __METHOD__ );
  46              $q = $db->limitResult( "DELETE /* deleteSelfExternals */ FROM externallinks WHERE el_to"
  47                  . $db->buildLike( $wgServer . '/', $db->anyString() ), $this->mBatchSize );
  48              $this->output( "Deleting a batch\n" );
  49              $db->query( $q );
  50              if ( !$db->affectedRows() ) {
  51                  return;
  52              }
  53          }
  54      }
  55  }
  56  
  57  $maintClass = "DeleteSelfExternals";
  58  require_once RUN_MAINTENANCE_IF_MAIN;