' . wfMsg('protectedpagestext') . '

'; } /** * LEFT JOIN is expensive * * @return true */ function isExpensive( ) { return 1; } function isSyndicated() { return false; } /** * @return false */ function sortDescending() { return false; } /** * @return string an sqlquery */ function getSQL() { $dbr =& wfGetDB( DB_SLAVE ); list( $page, $page_restrictions ) = $dbr->tableNamesN( 'page', 'page_restrictions' ); return "SELECT DISTINCT page_id, 'Protectedpages' as type, page_namespace AS namespace, page_title as title, " . "page_title AS value, pr_level " . "FROM $page LEFT JOIN $page_restrictions ON page_id = pr_page WHERE pr_level IS NOT NULL "; } /** * Make link to the page, and add the protection levels. * * @param $skin Skin to be used * @param $result Result row * @return string */ function formatResult( $skin, $result ) { global $wgLang; $title = Title::makeTitleSafe( $result->namespace, $result->title ); $link = $skin->makeLinkObj( $title ); $protType = wfMsg( 'restriction-level-' . $result->pr_level ); return wfSpecialList( $link, $protType ); } } /** * Constructor */ function wfSpecialProtectedpages() { list( $limit, $offset ) = wfCheckLimits(); $depp = new ProtectedPagesPage(); return $depp->doQuery( $offset, $limit ); } ?>