includes/SpecialBrokenRedirects.php

   1 <?php
   2 /**
   3  *
   4  * @package MediaWiki
   5  * @subpackage SpecialPage
   6  */
   7
   8 /**
   9  *
  10  */
  11 require_once('QueryPage.php');
  12
  13 /**
  14  *
  15  * @package MediaWiki
  16  * @subpackage SpecialPage
  17  */
  18 class BrokenRedirectsPage extends PageQueryPage {
  19         var $targets = array();
  20
  21         function getName() {
  22                 return 'BrokenRedirects';
  23         }
  24
  25         function isExpensive( ) { return true; }
  26         function isSyndicated() { return false; }
  27
  28         function getPageHeader( ) {
  29                 global $wgOut;
  30                 return $wgOut->parse( wfMsg( 'brokenredirectstext' ) );
  31         }
  32
  33         function getSQL() {
  34                 $dbr =& wfGetDB( DB_SLAVE );
  35                 extract( $dbr->tableNames( 'page', 'pagelinks' ) );
  36
  37                 $sql = "SELECT 'BrokenRedirects'  AS type,
  38                                 p1.page_namespace AS namespace,
  39                                 p1.page_title     AS title,
  40                                 pl_namespace,
  41                                 pl_title
  42                            FROM $pagelinks AS pl
  43                    JOIN $page p1 ON (p1.page_is_redirect=1 AND pl.pl_from=p1.page_id)
  44                       LEFT JOIN $page AS p2 ON (pl_namespace=p2.page_namespace AND pl_title=p2.page_title )
  45                                 WHERE p2.page_namespace IS NULL";
  46                 return $sql;
  47         }
  48
  49         function getOrder() {
  50                 return '';
  51         }
  52
  53         function formatResult( $skin, $result ) {
  54                 $fromObj = Title::makeTitle( $result->namespace, $result->title );
  55                 if ( isset( $result->pl_title ) ) {
  56                         $toObj = Title::makeTitle( $result->pl_namespace, $result->pl_title );
  57                 } else {
  58                         $blinks = $fromObj->getBrokenLinksFrom();
  59                         if ( $blinks ) {
  60                                 $toObj = $blinks[0];
  61                         } else {
  62                                 $toObj = false;
  63                         }
  64                 }
  65
  66                 // $toObj may very easily be false if the $result list is cached
  67                 if ( !is_object( $toObj ) ) {
  68                         return '<s>' . $skin->makeLinkObj( $fromObj ) . '</s>';
  69                 }
  70
  71                 $from = $skin->makeKnownLinkObj( $fromObj ,'', 'redirect=no' );
  72                 $edit = $skin->makeBrokenLinkObj( $fromObj , "(".wfMsg("qbedit").")" , 'redirect=no');
  73                 $to   = $skin->makeBrokenLinkObj( $toObj );
  74
  75                 return "$from $edit &rarr; $to";
  76         }
  77 }
  78
  79 /**
  80  * constructor
  81  */
  82 function wfSpecialBrokenRedirects() {
  83         list( $limit, $offset ) = wfCheckLimits();
  84
  85         $sbr = new BrokenRedirectsPage();
  86
  87         return $sbr->doQuery( $offset, $limit );
  88
  89 }
  90 ?>