X-Git-Url: http://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2FSpecialImagelist.php;h=54ee83e5f1fdde16dfa8b20bcb5f340a9388fb39;hb=f509270254cba380a092168d236cd529f3e8e10e;hp=a3424aa54c6cb68f58743585baf15e01237db69d;hpb=0332f4c59809e5a89f626e8969cd76261819f432;p=lhc%2Fweb%2Fwiklou.git
diff --git a/includes/SpecialImagelist.php b/includes/SpecialImagelist.php
index a3424aa54c..54ee83e5f1 100644
--- a/includes/SpecialImagelist.php
+++ b/includes/SpecialImagelist.php
@@ -1,112 +1,169 @@
getForm();
+ $body = $pager->getBody();
+ $nav = $pager->getNavigationBar();
+ $wgOut->addHTML( "
+ $limit
+
+ $body
+ $nav" );
+}
-function wfSpecialImagelist()
-{
- global $wgUser, $wgOut, $wgLang, $sort;
- global $wpIlMatch, $wpIlSubmit;
-
- $fields = array( 'wpIlMatch' );
- wfCleanFormFields( $fields );
-
- $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 = "${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( "" . wfMsg( "imglegend" ) . "\n" );
-
- $text = wfMsg( "imagelisttext",
- "{$lt}", "{$st}" );
- $wgOut->addHTML( "
{$text}\n
" );
-
- $sk = $wgUser->getSkin();
- $cap = wfMsg( "ilshowmatch" );
- $sub = wfMsg( "ilsubmit" );
- $action = wfLocalUrlE( $wgLang->specialPage( "Imagelist" ),
- "sort=byname&limit={$limit}" );
-
- $wgOut->addHTML( "
" );
-
- $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, "{$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}
\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, $num,
- "sort=bydate&limit={$num}" );
+ function getDefaultSort() {
+ return 'img_timestamp';
}
- $text = wfMsg( "showlast", $fill, $bydate );
- $wgOut->addHTML( "{$text}
\n" );
-
- $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 = "{$name}";
-
- $nb = wfMsg( "nbytes", $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 .= " ({$s->img_description})";
+
+ 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}
\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 = "" . $this->mMessages['imgfile'] . "";
+ $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 = "
\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 );
}
?>