includes/SpecialLonelypages.php

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