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         function isSyndicated() { return false; }
  32
  33         function getSQL() {
  34                 $dbr =& wfGetDB( DB_SLAVE );
  35                 extract( $dbr->tableNames( 'page', 'pagelinks' ) );
  36
  37                 return
  38                   "SELECT 'Lonelypages'  AS type,
  39                           page_namespace AS namespace,
  40                           page_title     AS title,
  41                           page_title     AS value
  42                      FROM $page
  43                 LEFT JOIN $pagelinks
  44                        ON page_namespace=pl_namespace AND page_title=pl_title
  45                     WHERE pl_namespace IS NULL
  46                       AND page_namespace=".NS_MAIN."
  47                       AND page_is_redirect=0";
  48
  49         }
  50 }
  51
  52 /**
  53  * Constructor
  54  */
  55 function wfSpecialLonelypages() {
  56         list( $limit, $offset ) = wfCheckLimits();
  57
  58         $lpp = new LonelyPagesPage();
  59
  60         return $lpp->doQuery( $offset, $limit );
  61 }
  62
  63 ?>