includes/SpecialLonelypages.php

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