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                 global $wgLang;
  41                 $title = Title::makeTitle( NS_CATEGORY, $result->title );
  42                 return $skin->makeLinkObj( $title, $title->getText() );
  43         }
  44 }
  45
  46 /** constructor */
  47 function wfSpecialUnusedCategories() {
  48         list( $limit, $offset ) = wfCheckLimits();
  49         $uc = new UnusedCategoriesPage();
  50         return $uc->doQuery( $offset, $limit );
  51 }
  52 ?>