*/ /** * Special page lists templates with a large number of * transclusion links, i.e. "most used" templates * * @ingroup SpecialPage */ class MostlinkedTemplatesPage extends QueryPage { function __construct( $name = 'Mostlinkedtemplates' ) { parent::__construct( $name ); } /** * Is this report expensive, i.e should it be cached? * * @return Boolean */ public function isExpensive() { return true; } /** * Is there a feed available? * * @return Boolean */ public function isSyndicated() { return false; } /** * Sort the results in descending order? * * @return Boolean */ public function sortDescending() { return true; } public function getQueryInfo() { return array ( 'tables' => array ( 'templatelinks' ), 'fields' => array ( 'namespace' => 'tl_namespace', 'title' => 'tl_title', 'value' => 'COUNT(*)' ), 'conds' => array ( 'tl_namespace' => NS_TEMPLATE ), 'options' => array( 'GROUP BY' => array( 'tl_namespace', 'tl_title' ) ) ); } /** * Pre-cache page existence to speed up link generation * * @param $db DatabaseBase connection * @param $res ResultWrapper */ public function preprocessResults( $db, $res ) { if ( !$res->numRows() ) { return; } $batch = new LinkBatch(); foreach ( $res as $row ) { $batch->add( $row->namespace, $row->title ); } $batch->execute(); $res->seek( 0 ); } /** * Format a result row * * @param $skin Skin to use for UI elements * @param $result Result row * @return String */ public function formatResult( $skin, $result ) { $title = Title::makeTitleSafe( $result->namespace, $result->title ); if ( !$title ) { return Html::element( 'span', array( 'class' => 'mw-invalidtitle' ), Linker::getInvalidTitleDescription( $this->getContext(), $result->namespace, $result->title ) ); } return $this->getLanguage()->specialList( Linker::link( $title ), $this->makeWlhLink( $title, $result ) ); } /** * Make a "what links here" link for a given title * * @param $title Title to make the link for * @param $result Result row * @return String */ private function makeWlhLink( $title, $result ) { $wlh = SpecialPage::getTitleFor( 'Whatlinkshere', $title->getPrefixedText() ); $label = $this->msg( 'ntransclusions' )->numParams( $result->value )->escaped(); return Linker::link( $wlh, $label ); } }