includes/SpecialLonelypages.php

   1 <?php
   2 /**
   3  *
   4  */
   5
   6 /**
   7  *
   8  */
   9 require_once( "QueryPage.php" );
  10
  11 /**
  12  *
  13  */
  14 class LonelyPagesPage extends PageQueryPage {
  15
  16         function getName() {
  17                 return "Lonelypages";
  18         }
  19
  20         function sortDescending() {
  21                 return false;
  22         }
  23
  24         function isExpensive() {
  25                 return true;
  26         }
  27
  28         function getSQL() {
  29                 $dbr =& wfGetDB( DB_SLAVE );
  30                 extract( $dbr->tableNames( 'cur', 'links' ) );
  31
  32                 return "SELECT 'Lonelypages' as type, cur_namespace AS namespace, cur_title AS title, cur_title AS value " .
  33                         "FROM $cur LEFT JOIN $links ON cur_id=l_to ".
  34                         "WHERE l_to IS NULL AND cur_namespace=0 AND cur_is_redirect=0";
  35         }
  36 }
  37
  38 /**
  39  * Constructor
  40  */
  41 function wfSpecialLonelypages() {
  42         list( $limit, $offset ) = wfCheckLimits();
  43
  44         $lpp = new LonelyPagesPage();
  45
  46         return $lpp->doQuery( $offset, $limit );
  47 }
  48
  49 ?>