includes/SpecialWantedpages.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 WantedPagesPage extends QueryPage {
  19         var $nlinks;
  20
  21         function WantedPagesPage( $inc = false, $nlinks = true ) {
  22                 $this->setListoutput( $inc );
  23                 $this->nlinks = $nlinks;
  24         }
  25
  26         function getName() {
  27                 return 'Wantedpages';
  28         }
  29
  30         function isExpensive() {
  31                 return true;
  32         }
  33         function isSyndicated() { return false; }
  34
  35         function getSQL() {
  36                 $dbr =& wfGetDB( DB_SLAVE );
  37                 $pagelinks = $dbr->tableName( 'pagelinks' );
  38                 $page      = $dbr->tableName( 'page' );
  39                 return
  40                         "SELECT 'Wantedpages' AS type,
  41                                 pl_namespace AS namespace,
  42                                 pl_title AS title,
  43                                 COUNT(*) AS value
  44                          FROM $pagelinks
  45                          LEFT JOIN $page
  46                          ON pl_namespace=page_namespace AND pl_title=page_title
  47                          WHERE page_namespace IS NULL
  48                          GROUP BY pl_namespace,pl_title
  49                          HAVING COUNT(*) > 1";
  50         }
  51
  52         /**
  53          * Fetch user page links and cache their existence
  54          */
  55         function preprocessResults( &$db, &$res ) {
  56                 $batch = new LinkBatch;
  57                 while ( $row = $db->fetchObject( $res ) )
  58                         $batch->addObj( Title::makeTitleSafe( $row->namespace, $row->title ) );
  59                 $batch->execute();
  60
  61                 // Back to start for display
  62                 if ( $db->numRows( $res ) > 0 )
  63                         // If there are no rows we get an error seeking.
  64                         $db->dataSeek( $res, 0 );
  65         }
  66
  67
  68         function formatResult( $skin, $result ) {
  69                 global $wgContLang;
  70
  71                 $nt = Title::makeTitle( $result->namespace, $result->title );
  72                 $text = $wgContLang->convert( $nt->getPrefixedText() );
  73                 $plink = $this->isCached() ?
  74                         $skin->makeLinkObj( $nt, $text ) :
  75                         $skin->makeBrokenLink( $nt->getPrefixedText(), $text );
  76
  77                 $nl = wfMsg( 'nlinks', $result->value );
  78                 $nlink = $skin->makeKnownLink( $wgContLang->specialPage( 'Whatlinkshere' ), $nl, 'target=' . $nt->getPrefixedURL() );
  79
  80                 return $this->nlinks ? "$plink ($nlink)" : $plink;
  81         }
  82 }
  83
  84 /**
  85  * constructor
  86  */
  87 function wfSpecialWantedpages( $par = null, $specialPage ) {
  88         $inc = $specialPage->including();
  89
  90         if ( $inc ) {
  91                 @list( $limit, $nlinks ) = explode( '/', $par, 2 );
  92                 $limit = (int)$limit;
  93                 $nlinks = $nlinks === 'nlinks';
  94                 $offset = 0;
  95         } else {
  96                 list( $limit, $offset ) = wfCheckLimits();
  97                 $nlinks = true;
  98         }
  99
 100         $wpp = new WantedPagesPage( $inc, $nlinks );
 101
 102         $wpp->doQuery( $offset, $limit, !$inc );
 103 }
 104
 105 ?>