includes/SpecialLonelypages.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 LonelyPagesPage extends PageQueryPage {
  19
  20         function getName() {
  21                 return "Lonelypages";
  22         }
  23
  24         function sortDescending() {
  25                 return false;
  26         }
  27
  28         function isExpensive() {
  29                 return true;
  30         }
  31
  32         function getSQL() {
  33                 $dbr =& wfGetDB( DB_SLAVE );
  34                 extract( $dbr->tableNames( 'cur', 'links' ) );
  35
  36                 return "SELECT 'Lonelypages' as type, cur_namespace AS namespace, cur_title AS title, cur_title AS value " .
  37                         "FROM $cur LEFT JOIN $links ON cur_id=l_to ".
  38                         "WHERE l_to IS NULL AND cur_namespace=0 AND cur_is_redirect=0";
  39         }
  40 }
  41
  42 /**
  43  * Constructor
  44  */
  45 function wfSpecialLonelypages() {
  46         list( $limit, $offset ) = wfCheckLimits();
  47
  48         $lpp = new LonelyPagesPage();
  49
  50         return $lpp->doQuery( $offset, $limit );
  51 }
  52
  53 ?>