includes/SpecialUnusedcategories.php

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