return "Shortpages";
}
+ /**
+ * This query is indexed as of 1.5
+ */
function isExpensive() {
return true;
}
+ function isSyndicated() {
+ return false;
+ }
+
function getSQL() {
$dbr =& wfGetDB( DB_SLAVE );
- $cur = $dbr->tableName( 'cur' );
-
+ $page = $dbr->tableName( 'page' );
+ $name = $dbr->addQuotes( $this->getName() );
+
return
- "SELECT 'Shortpages' as type,
- cur_namespace as namespace,
- cur_title as title,
- LENGTH(cur_text) AS value
- FROM $cur
- WHERE cur_namespace=0 AND cur_is_redirect=0";
+ "SELECT $name as type,
+ page_namespace as namespace,
+ page_title as title,
+ page_len AS value
+ FROM $page FORCE INDEX (page_len)
+ WHERE page_namespace=".NS_MAIN." AND page_is_redirect=0";
}
-
+
function sortDescending() {
return false;
}
function formatResult( $skin, $result ) {
- global $wgLang;
- $nb = wfMsg( "nbytes", $wgLang->formatNum( $result->value ) );
- $link = $skin->makeKnownLink( $result->title, "" );
- return "{$link} ({$nb})";
+ global $wgLang, $wgContLang;
+ $nb = htmlspecialchars( wfMsg( 'nbytes', $wgLang->formatNum( $result->value ) ) );
+ $title = Title::makeTitle( $result->namespace, $result->title );
+ $link = $skin->makeKnownLinkObj( $title, htmlspecialchars( $wgContLang->convert( $title->getPrefixedText() ) ) );
+ $histlink = $skin->makeKnownLinkObj( $title, wfMsgHtml('hist'), 'action=history' );
+ return "({$histlink}) $link ({$nb})";
}
}