SpecialImagelist.php

Go to the documentation of this file.

<?php

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}%'";
                }
                $sql .= " ORDER BY img_name";
                $st = $byname;
        } else {
                $sql .= " ORDER BY img_timestamp DESC";
                $st = $bydate;
        }
        list( $limit, $offset ) = wfCheckLimits( 50 );
        if ( 0 == $limit ) {
                $lt = wfMsg( "all" );
        } else {
                $lt = $wgLang->formatNum( "${limit}" );
                $sql .= " LIMIT {$limit}";
        }
        $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}" );
        }
        $text = wfMsg( "showlast", $fill, $bysize );
        $wgOut->addHTML( "<p>{$text}<br />\n" );

        $fill = "";
        $first = true;
        foreach ( $nums as $num ) {
                if ( ! $first ) { $fill .= " | "; }
                $first = false;

                $fill .= $sk->makeKnownLink( $here, $wgLang->formatNum( $num ),
                  "sort=bydate&limit={$num}" );
        }
        $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=\"" . Image::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>";
                }
                $wgOut->addHTML( "{$l}<br />\n" );
        }
        $wgOut->addHTML( "</p>" );
        wfFreeResult( $res );
}

?>

---