deleteSelfExternals.php

Go to the documentation of this file.

<?php
require_once( __DIR__ . '/Maintenance.php' );

class DeleteSelfExternals extends Maintenance {
        public function __construct() {
                parent::__construct();
                $this->mDescription = 'Delete self-references to $wgServer from externallinks';
                $this->mBatchSize = 1000;
        }

        public function execute() {
                global $wgServer;
                $this->output( "Deleting self externals from $wgServer\n" );
                $db = wfGetDB( DB_MASTER );
                while ( 1 ) {
                        wfWaitForSlaves();
                        $db->commit( __METHOD__ );
                        $q = $db->limitResult( "DELETE /* deleteSelfExternals */ FROM externallinks WHERE el_to"
                                . $db->buildLike( $wgServer . '/', $db->anyString() ), $this->mBatchSize );
                        $this->output( "Deleting a batch\n" );
                        $db->query( $q );
                        if ( !$db->affectedRows() ) return;
                }
        }
}

$maintClass = "DeleteSelfExternals";
require_once( RUN_MAINTENANCE_IF_MAIN );