5 * @subpackage SpecialPage
9 require_once('QueryPage.php');
14 * @subpackage SpecialPage
16 class UnusedCategoriesPage
extends QueryPage
{
19 return 'Unusedcategories';
22 function getPageHeader() {
23 return '<p>' . wfMsg('unusedcategoriestext') . '</p>';
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
33 LEFT JOIN $categorylinks ON page_title=cl_to
35 AND page_namespace = {$NScat}
36 AND page_is_redirect = 0";
39 function formatResult( $skin, $result ) {
40 $title = Title
::makeTitle( NS_CATEGORY
, $result->title
);
41 return $skin->makeLinkObj( $title, $title->getText() );
46 function wfSpecialUnusedCategories() {
47 list( $limit, $offset ) = wfCheckLimits();
48 $uc = new UnusedCategoriesPage();
49 return $uc->doQuery( $offset, $limit );