3 * Remove spurious brokenlinks
5 * @subpackage Maintenance
9 require_once( "commandLine.inc" );
10 require_once( "./rebuildrecentchanges.inc" );
11 $wgTitle = Title
::newFromText( "Rebuild brokenlinks script" );
15 echo "Checking for broken brokenlinks...\n";
17 $dbw =& wfGetDB( DB_MASTER
);
18 extract( $dbw->tableNames( 'brokenlinks', 'cur', 'linkscc' );
20 $res = $dbw->select( 'cur', array( 'cur_namespace', 'cur_title', 'cur_id' ), false );
22 while( $s = $dbw->fetchObject( $res ) ) {
27 $title = Title
::makeTitle( $s->cur_namespace
, $s->cur_title
);
29 $t = $title->getPrefixedDBKey();
30 $tt = $dbw->strencode( $t );
32 $sql2 = "SELECT bl_from,cur_id,cur_namespace,cur_title FROM $brokenlinks,$cur " .
33 "WHERE bl_to='$tt' AND cur_id=bl_from";
34 $res2 = $dbw->query( $sql2 );
35 while( $s = $dbw->fetchObject( $res2 ) ) {
36 $from = Title
::makeTitle( $s->cur_namespace
, $s->cur_title
);
37 $xt = $from->getPrefixedText();
38 echo "Found bad brokenlink to [[$t]] from page #$s->cur_id [[$xt]]!\n";
41 $dbw->freeResult( $res2 );
43 echo "Removing brokenlinks to [[$t]]...\n";
44 $sql3 = "DELETE FROM $brokenlinks WHERE bl_to='$tt'";
45 $res3 = $dbw->query( $sql3 );
49 echo "Illegal title?! Namespace $s->cur_namespace, title '$s->cur_title'\n";
52 echo "Done at $n.\n\n";
54 echo "Clearing linkscc table...\n";
55 $sql4 = "DELETE FROM $linkscc";
56 wfQuery( $sql4, DB_MASTER
);