*/ /** * A special page page that list most used images * * @ingroup SpecialPage */ class MostimagesPage extends ImageQueryPage { function getName() { return 'Mostimages'; } function isExpensive() { return true; } function isSyndicated() { return false; } function getSQL() { $dbr = wfGetDB( DB_SLAVE ); $imagelinks = $dbr->tableName( 'imagelinks' ); return " SELECT 'Mostimages' as type, " . NS_FILE . " as namespace, il_to as title, COUNT(*) as value FROM $imagelinks GROUP BY il_to HAVING COUNT(*) > 1 "; } function getCellHtml( $row ) { global $wgLang; return wfMsgExt( 'nimagelinks', array( 'parsemag', 'escape' ), $wgLang->formatNum( $row->value ) ) . '
'; } } /** * Constructor */ function wfSpecialMostimages() { list( $limit, $offset ) = wfCheckLimits(); $wpp = new MostimagesPage(); $wpp->doQuery( $offset, $limit ); }