* (bug 6023) Fixed mismatch of 0/NULL for wl_notificationtimestamp; now notification
[lhc/web/wiklou.git] / includes / SpecialImagelist.php
index 39737fe..54ee83e 100644 (file)
 <?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" ) . "</p>\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( "<p>{$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}</p>\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();
        }
-       $wgOut->addHTML( "</p>" );
-       wfFreeResult( $res );
 }
 
 ?>