includes/SpecialUnusedcategories.php

   1 <?php
   2 /**
   3  *
   4  * @addtogroup SpecialPage
   5  */
   6
   7 /**
   8  *
   9  * @addtogroup SpecialPage
  10  */
  11 class UnusedCategoriesPage extends QueryPage {
  12
  13         function getName() {
  14                 return 'Unusedcategories';
  15         }
  16
  17         function getPageHeader() {
  18                 return '<p>' . wfMsg('unusedcategoriestext') . '</p>';
  19         }
  20
  21         function getSQL() {
  22                 $NScat = NS_CATEGORY;
  23                 $dbr =& wfGetDB( DB_SLAVE );
  24                 list( $categorylinks, $page ) = $dbr->tableNamesN( 'categorylinks', 'page' );
  25                 return "SELECT 'Unusedcategories' as type,
  26                                 {$NScat} as namespace, page_title as title, page_title as value
  27                                 FROM $page
  28                                 LEFT JOIN $categorylinks ON page_title=cl_to
  29                                 WHERE cl_from IS NULL
  30                                 AND page_namespace = {$NScat}
  31                                 AND page_is_redirect = 0";
  32         }
  33
  34         function formatResult( $skin, $result ) {
  35                 $title = Title::makeTitle( NS_CATEGORY, $result->title );
  36                 return $skin->makeLinkObj( $title, $title->getText() );
  37         }
  38 }
  39
  40 /** constructor */
  41 function wfSpecialUnusedCategories() {
  42         list( $limit, $offset ) = wfCheckLimits();
  43         $uc = new UnusedCategoriesPage();
  44         return $uc->doQuery( $offset, $limit );
  45 }
  46 ?>