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