4 * @addtogroup SpecialPage
9 * @addtogroup SpecialPage
11 class UnusedCategoriesPage
extends QueryPage
{
14 return 'Unusedcategories';
17 function getPageHeader() {
18 return wfMsgExt( 'unusedcategoriestext', array( 'parse' ) );
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
28 LEFT JOIN $categorylinks ON page_title=cl_to
30 AND page_namespace = {$NScat}
31 AND page_is_redirect = 0";
34 function formatResult( $skin, $result ) {
35 $title = Title
::makeTitle( NS_CATEGORY
, $result->title
);
36 return $skin->makeLinkObj( $title, $title->getText() );
41 function wfSpecialUnusedCategories() {
42 list( $limit, $offset ) = wfCheckLimits();
43 $uc = new UnusedCategoriesPage();
44 return $uc->doQuery( $offset, $limit );