array( 'revision', 'page' ), 'fields' => array( 'namespace' => 'page_namespace', 'title' => 'page_title', 'value' => 'COUNT(*)', 'redirect' => 'page_is_redirect' ), 'conds' => array( 'page_namespace' => MWNamespace::getContentNamespaces(), 'page_id = rev_page' ), 'options' => array( 'HAVING' => 'COUNT(*) > 1', // ^^^ This was probably here to weed out redirects. // Since we mark them as such now, it might be // useful to remove this. People _do_ create pages // and never revise them, they aren't necessarily // redirects. 'GROUP BY' => array( 'page_namespace', 'page_title', 'page_is_redirect' ) ) ); } function sortDescending() { return false; } /** * @param Skin $skin * @param object $result Database row * @return string */ function formatResult( $skin, $result ) { global $wgContLang; $nt = Title::makeTitleSafe( $result->namespace, $result->title ); if ( !$nt ) { return Html::element( 'span', array( 'class' => 'mw-invalidtitle' ), Linker::getInvalidTitleDescription( $this->getContext(), $result->namespace, $result->title ) ); } $text = htmlspecialchars( $wgContLang->convert( $nt->getPrefixedText() ) ); $plink = Linker::linkKnown( $nt, $text ); $nl = $this->msg( 'nrevisions' )->numParams( $result->value )->escaped(); $redirect = isset( $result->redirect ) && $result->redirect ? ' - ' . $this->msg( 'isredirect' )->escaped() : ''; $nlink = Linker::linkKnown( $nt, $nl, array(), array( 'action' => 'history' ) ) . $redirect; return $this->getLanguage()->specialList( $plink, $nlink ); } protected function getGroupName() { return 'maintenance'; } }