<?php
+/**
+ *
+ * @package MediaWiki
+ * @subpackage SpecialPage
+ */
+
+/**
+ *
+ */
+function wfSpecialImagelist() {
+ global $wgUser, $wgOut, $wgLang, $wgContLang, $wgRequest, $wgMiserMode;
+
+ $pager = new ImageListPager;
+
+ $limit = $pager->getForm();
+ $body = $pager->getBody();
+ $nav = $pager->getNavigationBar();
+ $wgOut->addHTML( "
+ $limit
+ <br/>
+ $body
+ $nav" );
+}
-function wfSpecialImagelist()
-{
- global $wgUser, $wgOut, $wgLang, $wgRequest;
-
- $sort = $wgRequest->getVal( 'sort' );
- $wpIlMatch = $wgRequest->getText( 'wpIlMatch' );
-
- $sql = "SELECT img_size,img_name,img_user,img_user_text," .
- "img_description,img_timestamp FROM image";
-
- $byname = wfMsg( "byname" );
- $bydate = wfMsg( "bydate" );
- $bysize = wfMsg( "bysize" );
-
- if ( "bysize" == $sort ) {
- $sql .= " ORDER BY img_size DESC";
- $st = $bysize;
- } else if ( "byname" == $sort ) {
- if ( $wpIlMatch ) {
- $nt = Title::newFromUrl( $wpIlMatch );
- $m = wfStrencode( strtolower( $nt->getDBkey() ) );
- $m = str_replace( "%", "\\%", $m );
- $m = str_replace( "_", "\\_", $m );
- $sql .= " WHERE LCASE(img_name) LIKE '%{$m}%'";
+class ImageListPager extends TablePager {
+ var $mFieldNames = null;
+ var $mMessages = array();
+ var $mQueryConds = array();
+
+ function __construct() {
+ global $wgRequest, $wgMiserMode;
+ if ( $wgRequest->getText( 'sort', 'img_date' ) == 'img_date' ) {
+ $this->mDefaultDirection = true;
+ } else {
+ $this->mDefaultDirection = false;
+ }
+ $search = $wgRequest->getText( 'ilsearch' );
+ if ( $search != '' && !$wgMiserMode ) {
+ $nt = Title::newFromUrl( $search );
+ if( $nt ) {
+ $dbr =& wfGetDB( DB_SLAVE );
+ $m = $dbr->strencode( strtolower( $nt->getDBkey() ) );
+ $m = str_replace( "%", "\\%", $m );
+ $m = str_replace( "_", "\\_", $m );
+ $this->mQueryConds = array( "LCASE(img_name) LIKE '%{$m}%'" );
+ }
}
- $sql .= " ORDER BY img_name";
- $st = $byname;
- } else {
- $sql .= " ORDER BY img_timestamp DESC";
- $st = $bydate;
+
+ parent::__construct();
}
- list( $limit, $offset ) = wfCheckLimits( 50 );
- if ( 0 == $limit ) {
- $lt = wfMsg( "all" );
- } else {
- $lt = $wgLang->formatNum( "${limit}" );
- $sql .= " LIMIT {$limit}";
+
+ function getFieldNames() {
+ if ( !$this->mFieldNames ) {
+ $this->mFieldNames = array(
+ 'links' => '',
+ 'img_timestamp' => wfMsg( 'imagelist_date' ),
+ 'img_name' => wfMsg( 'imagelist_name' ),
+ 'img_user_text' => wfMsg( 'imagelist_user' ),
+ 'img_size' => wfMsg( 'imagelist_size' ),
+ 'img_description' => wfMsg( 'imagelist_description' ),
+ );
+ }
+ return $this->mFieldNames;
}
- $wgOut->addHTML( "<p>" . wfMsg( "imglegend" ) . "\n" );
-
- $text = wfMsg( "imagelisttext",
- "<strong>{$lt}</strong>", "<strong>{$st}</strong>" );
- $wgOut->addHTML( "<p>{$text}\n<p>" );
-
- $sk = $wgUser->getSkin();
- $cap = wfMsg( "ilshowmatch" );
- $sub = wfMsg( "ilsubmit" );
- $titleObj = Title::makeTitle( NS_SPECIAL, "Imagelist" );
- $action = $titleObj->escapeLocalURL( "sort=byname&limit={$limit}" );
-
- $wgOut->addHTML( "<form id=\"imagesearch\" method=\"post\" action=\"" .
- "{$action}\">" .
- "{$cap}: <input type=text size=8 name=\"wpIlMatch\" value=\"\"> " .
- "<input type=submit name=\"wpIlSubmit\" value=\"{$sub}\"></form>" );
-
- $nums = array( 50, 100, 250, 500 );
- $here = $wgLang->specialPage( "Imagelist" );
-
- $fill = "";
- $first = true;
- foreach ( $nums as $num ) {
- if ( ! $first ) { $fill .= " | "; }
- $first = false;
-
- $fill .= $sk->makeKnownLink( $here, $wgLang->formatNum( $num ),
- "sort=bysize&limit={$num}" );
+
+ function isFieldSortable( $field ) {
+ static $sortable = array( 'img_timestamp', 'img_name', 'img_size' );
+ return in_array( $field, $sortable );
}
- $text = wfMsg( "showlast", $fill, $bysize );
- $wgOut->addHTML( "{$text}<br>\n" );
- $fill = "";
- $first = true;
- foreach ( $nums as $num ) {
- if ( ! $first ) { $fill .= " | "; }
- $first = false;
+ function getQueryInfo() {
+ $fields = $this->getFieldNames();
+ unset( $fields['links'] );
+ $fields = array_keys( $fields );
+ $fields[] = 'img_user';
+ return array(
+ 'tables' => 'image',
+ 'fields' => $fields,
+ 'conds' => $this->mQueryConds
+ );
+ }
- $fill .= $sk->makeKnownLink( $here, $wgLang->formatNum( $num ),
- "sort=bydate&limit={$num}" );
+ function getDefaultSort() {
+ return 'img_timestamp';
}
- $text = wfMsg( "showlast", $fill, $bydate );
- $wgOut->addHTML( "{$text}<br>\n<p>" );
-
- $res = wfQuery( $sql, DB_READ, "wfSpecialImagelist" );
- while ( $s = wfFetchObject( $res ) ) {
- $name = $s->img_name;
- $ut = $s->img_user_text;
- if ( 0 == $s->img_user ) { $ul = $ut; }
- else { $ul = $sk->makeLink( $wgLang->getNsText(
- Namespace::getUser() ) . ":{$ut}", $ut ); }
-
- $ilink = "<a href=\"" . wfImageUrl( $name ) .
- "\">{$name}</a>";
-
- $nb = wfMsg( "nbytes", $wgLang->formatNum( $s->img_size ) );
- $l = "(" .
- $sk->makeKnownLink( $wgLang->getNsText(
- Namespace::getImage() ) . ":{$name}", wfMsg( "imgdesc" ) ) .
- ") {$ilink} . . {$nb} . . {$ul} . . " .
- $wgLang->timeanddate( $s->img_timestamp, true );
-
- if ( "" != $s->img_description ) {
- $l .= " <em>({$s->img_description})</em>";
+
+ function getStartBody() {
+ # Do a link batch query for user pages
+ if ( $this->mResult->numRows() ) {
+ $lb = new LinkBatch;
+ $this->mResult->seek( 0 );
+ while ( $row = $this->mResult->fetchObject() ) {
+ if ( $row->img_user ) {
+ $lb->add( NS_USER, str_replace( ' ', '_', $row->img_user_text ) );
+ }
+ }
+ $lb->execute();
}
- $wgOut->addHTML( "{$l}<br>\n" );
+
+ # Cache messages used in each row
+ $this->mMessages['imgdesc'] = wfMsgHtml( 'imgdesc' );
+ $this->mMessages['imgfile'] = wfMsgHtml( 'imgfile' );
+
+ return parent::getStartBody();
+ }
+
+ function formatValue( $field, $value ) {
+ global $wgLang;
+ switch ( $field ) {
+ case 'links':
+ $name = $this->mCurrentRow->img_name;
+ $ilink = "<a href=\"" . htmlspecialchars( Image::imageUrl( $name ) ) .
+ "\">" . $this->mMessages['imgfile'] . "</a>";
+ $desc = $this->getSkin()->makeKnownLinkObj( Title::makeTitle( NS_IMAGE, $name ),
+ $this->mMessages['imgdesc'] );
+ return "$desc | $ilink";
+ case 'img_timestamp':
+ return $wgLang->timeanddate( $value, true );
+ case 'img_name':
+ return htmlspecialchars( $value );
+ case 'img_user_text':
+ if ( $this->mCurrentRow->img_user ) {
+ $link = $this->getSkin()->makeLinkObj( Title::makeTitle( NS_USER, $value ),
+ htmlspecialchars( $value ) );
+ } else {
+ $link = htmlspecialchars( $value );
+ }
+ return $link;
+ case 'img_size':
+ return $wgLang->formatNum( $value );
+ case 'img_description':
+ return $this->getSkin()->commentBlock( $value );
+ }
+ }
+
+ function getForm() {
+ global $wgRequest, $wgMiserMode;
+ $url = $this->getTitle()->escapeLocalURL();
+ $msgSubmit = wfMsgHtml( 'table_pager_limit_submit' );
+ $msgSearch = wfMsgHtml( 'imagelist_search_for' );
+ $search = $wgRequest->getText( 'ilsearch' );
+ $encSearch = htmlspecialchars( $search );
+ $s = "<form method=\"get\" action=\"$url\">\n" .
+ wfMsgHtml( 'table_pager_limit', $this->getLimitSelect() );
+ if ( !$wgMiserMode ) {
+ $s .= "<br/>\n" . $msgSearch .
+ " <input type=\"text\" size=\"20\" name=\"ilsearch\" value=\"$encSearch\"/><br/>\n";
+ }
+ $s .= " <input type=\"submit\" value=\"$msgSubmit\"/>\n" .
+ $this->getHiddenFields( array( 'limit', 'ilsearch' ) ) .
+ "</form>\n";
+ return $s;
+ }
+
+ function getTableClass() {
+ return 'imagelist ' . parent::getTableClass();
+ }
+
+ function getNavClass() {
+ return 'imagelist_nav ' . parent::getNavClass();
+ }
+
+ function getSortHeaderClass() {
+ return 'imagelist_sort ' . parent::getSortHeaderClass();
}
- wfFreeResult( $res );
}
?>