includes/SpecialUncategorizedpages.php

   1 <?php
   2 /**
   3  *
   4  * @package MediaWiki
   5  * @subpackage SpecialPage
   6  */
   7
   8 /**
   9  *
  10  * @package MediaWiki
  11  * @subpackage SpecialPage
  12  */
  13 class UncategorizedPagesPage extends PageQueryPage {
  14         var $requestedNamespace = NS_MAIN;
  15
  16         function getName() {
  17                 return "Uncategorizedpages";
  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, $categorylinks ) = $dbr->tableNamesN( 'page', 'categorylinks' );
  32                 $name = $dbr->addQuotes( $this->getName() );
  33
  34                 return
  35                         "
  36                         SELECT
  37                                 $name as type,
  38                                 page_namespace AS namespace,
  39                                 page_title AS title,
  40                                 page_title AS value
  41                         FROM $page
  42                         LEFT JOIN $categorylinks ON page_id=cl_from
  43                         WHERE cl_from IS NULL AND page_namespace={$this->requestedNamespace} AND page_is_redirect=0
  44                         ";
  45         }
  46 }
  47
  48 /**
  49  * constructor
  50  */
  51 function wfSpecialUncategorizedpages() {
  52         list( $limit, $offset ) = wfCheckLimits();
  53
  54         $lpp = new UncategorizedPagesPage();
  55
  56         return $lpp->doQuery( $offset, $limit );
  57 }
  58
  59 ?>