*/ /** * Searches the database for files of the requested MIME type, comparing this with the * 'img_major_mime' and 'img_minor_mime' fields in the image table. * @ingroup SpecialPage */ class MIMEsearchPage extends QueryPage { protected $major, $minor, $mime; function __construct( $name = 'MIMEsearch' ) { parent::__construct( $name ); } function isExpensive() { return false; } function isSyndicated() { return false; } function isCacheable() { return false; } function linkParameters() { return array( 'mime' => "{$this->major}/{$this->minor}" ); } public function getQueryInfo() { $minorType = array(); if ( $this->minor !== '*' ) { // Allow wildcard searching $minorType['img_minor_mime'] = $this->minor; } $qi = array( 'tables' => array( 'image' ), 'fields' => array( 'namespace' => NS_FILE, 'title' => 'img_name', // Still have a value field just in case, // but it isn't actually used for sorting. 'value' => 'img_name', 'img_size', 'img_width', 'img_height', 'img_user_text', 'img_timestamp' ), 'conds' => array( 'img_major_mime' => $this->major, // This is in order to trigger using // the img_media_mime index in "range" mode. 'img_media_type' => array( MEDIATYPE_BITMAP, MEDIATYPE_DRAWING, MEDIATYPE_AUDIO, MEDIATYPE_VIDEO, MEDIATYPE_MULTIMEDIA, MEDIATYPE_UNKNOWN, MEDIATYPE_OFFICE, MEDIATYPE_TEXT, MEDIATYPE_EXECUTABLE, MEDIATYPE_ARCHIVE, ), ) + $minorType, ); return $qi; } /** * The index is on (img_media_type, img_major_mime, img_minor_mime) * which unfortunately doesn't have img_name at the end for sorting. * So tell db to sort it however it wishes (Its not super important * that this report gives results in a logical order). As an aditional * note, mysql seems to by default order things by img_name ASC, which * is what we ideally want, so everything works out fine anyhow. * @return array */ function getOrderFields() { return array(); } /** * Return HTML to put just before the results. */ function getPageHeader() { return Xml::openElement( 'form', array( 'id' => 'specialmimesearch', 'method' => 'get', 'action' => wfScript() ) ) . Xml::openElement( 'fieldset' ) . Html::hidden( 'title', $this->getPageTitle()->getPrefixedText() ) . Xml::element( 'legend', null, $this->msg( 'mimesearch' )->text() ) . Xml::inputLabel( $this->msg( 'mimetype' )->text(), 'mime', 'mime', 20, $this->mime ) . ' ' . Xml::submitButton( $this->msg( 'ilsubmit' )->text() ) . Xml::closeElement( 'fieldset' ) . Xml::closeElement( 'form' ); } function execute( $par ) { $this->mime = $par ? $par : $this->getRequest()->getText( 'mime' ); $this->mime = trim( $this->mime ); list( $this->major, $this->minor ) = File::splitMime( $this->mime ); if ( $this->major == '' || $this->minor == '' || $this->minor == 'unknown' || !self::isValidType( $this->major ) ) { $this->setHeaders(); $this->outputHeader(); $this->getOutput()->addHTML( $this->getPageHeader() ); return; } parent::execute( $par ); } /** * @param Skin $skin * @param object $result Result row * @return string */ function formatResult( $skin, $result ) { global $wgContLang; $nt = Title::makeTitle( $result->namespace, $result->title ); $text = $wgContLang->convert( $nt->getText() ); $plink = Linker::link( Title::newFromText( $nt->getPrefixedText() ), htmlspecialchars( $text ) ); $download = Linker::makeMediaLinkObj( $nt, $this->msg( 'download' )->escaped() ); $download = $this->msg( 'parentheses' )->rawParams( $download )->escaped(); $lang = $this->getLanguage(); $bytes = htmlspecialchars( $lang->formatSize( $result->img_size ) ); $dimensions = $this->msg( 'widthheight' )->numParams( $result->img_width, $result->img_height )->escaped(); $user = Linker::link( Title::makeTitle( NS_USER, $result->img_user_text ), htmlspecialchars( $result->img_user_text ) ); $time = $lang->userTimeAndDate( $result->img_timestamp, $this->getUser() ); $time = htmlspecialchars( $time ); return "$download $plink . . $dimensions . . $bytes . . $user . . $time"; } /** * @param string $type * @return bool */ protected static function isValidType( $type ) { // From maintenance/tables.sql => img_major_mime $types = array( 'unknown', 'application', 'audio', 'image', 'text', 'video', 'message', 'model', 'multipart', 'chemical' ); return in_array( $type, $types ); } protected function getGroupName() { return 'media'; } }