maintenance/deleteSelfExternals.php

   1 <?php
   2
   3 require_once("commandLine.inc");
   4
   5 print "Deleting self externals from $wgServer\n";
   6 $db = wfGetDB(DB_MASTER);
   7 while (1) {
   8         wfWaitForSlaves( 2 );
   9         $db->commit();
  10         $q = $db->limitResult( "DELETE /* deleteSelfExternals */ FROM externallinks WHERE el_to"
  11                 . $db->buildLike( $wgServer . '/', $db->anyString() ), 1000 );
  12         print "Deleting a batch\n";
  13         $db->query($q);
  14         if (!$db->affectedRows()) exit(0);
  15 }