includes/SpecialLonelypages.php

   1 <?php
   2 /**
   3  *
   4  * @package MediaWiki
   5  * @subpackage SpecialPage
   6  */
   7
   8 /**
   9  *
  10  * @package MediaWiki
  11  * @subpackage SpecialPage
  12  */
  13 class LonelyPagesPage extends PageQueryPage {
  14
  15         function getName() {
  16                 return "Lonelypages";
  17         }
  18         function getPageHeader() {
  19                 return '<p>' . wfMsg('lonelypagestext') . '</p>';
  20         }
  21
  22         function sortDescending() {
  23                 return false;
  24         }
  25
  26         function isExpensive() {
  27                 return true;
  28         }
  29         function isSyndicated() { return false; }
  30
  31         function getSQL() {
  32                 $dbr =& wfGetDB( DB_SLAVE );
  33                 list( $page, $pagelinks ) = $dbr->tableNamesN( 'page', 'pagelinks' );
  34
  35                 return
  36                   "SELECT 'Lonelypages'  AS type,
  37                           page_namespace AS namespace,
  38                           page_title     AS title,
  39                           page_title     AS value
  40                      FROM $page
  41                 LEFT JOIN $pagelinks
  42                        ON page_namespace=pl_namespace AND page_title=pl_title
  43                     WHERE pl_namespace IS NULL
  44                       AND page_namespace=".NS_MAIN."
  45                       AND page_is_redirect=0";
  46
  47         }
  48 }
  49
  50 /**
  51  * Constructor
  52  */
  53 function wfSpecialLonelypages() {
  54         list( $limit, $offset ) = wfCheckLimits();
  55
  56         $lpp = new LonelyPagesPage();
  57
  58         return $lpp->doQuery( $offset, $limit );
  59 }
  60
  61 ?>