5 * FIXME: this code is crap, should use Pager and Database::select().
11 function wfSpecialNewimages( $par, $specialPage ) {
12 global $wgUser, $wgOut, $wgLang, $wgRequest, $wgGroupPermissions, $wgMiserMode;
14 $wpIlMatch = $wgRequest->getText( 'wpIlMatch' );
15 $dbr = wfGetDB( DB_SLAVE
);
16 $sk = $wgUser->getSkin();
17 $shownav = !$specialPage->including();
18 $hidebots = $wgRequest->getBool('hidebots',1);
23 /** Make a list of group names which have the 'bot' flag
27 foreach ( User
::getGroupsWithPermission('bot') as $groupname ) {
28 $botconds[]="ug_group='$groupname'";
31 /* If not bot groups, do not set $hidebotsql */
33 $isbotmember=$dbr->makeList($botconds, LIST_OR
);
35 /** This join, in conjunction with WHERE ug_group
36 IS NULL, returns only those rows from IMAGE
37 where the uploading user is not a member of
38 a group which has the 'bot' permission set.
40 $ug = $dbr->tableName('user_groups');
41 $hidebotsql = " LEFT OUTER JOIN $ug ON img_user=ug_user AND ($isbotmember)";
45 $image = $dbr->tableName('image');
47 $sql="SELECT img_timestamp from $image";
49 $sql .= "$hidebotsql WHERE ug_group IS NULL";
51 $sql.=' ORDER BY img_timestamp DESC LIMIT 1';
52 $res = $dbr->query($sql, 'wfSpecialNewImages');
53 $row = $dbr->fetchRow($res);
59 $dbr->freeResult($res);
62 /** If we were clever, we'd use this to cache. */
63 $latestTimestamp = wfTimestamp( TS_MW
, $ts);
65 /** Hardcode this for now. */
68 if ( $parval = intval( $par ) ) {
69 if ( $parval <= $limit && $parval > 0 ) {
76 if ( $wpIlMatch != '' && !$wgMiserMode) {
77 $nt = Title
::newFromUrl( $wpIlMatch );
79 $m = $dbr->strencode( strtolower( $nt->getDBkey() ) );
80 $m = str_replace( '%', "\\%", $m );
81 $m = str_replace( '_', "\\_", $m );
82 $where[] = "LOWER(img_name) LIKE '%{$m}%'";
83 $searchpar = '&wpIlMatch=' . urlencode( $wpIlMatch );
88 if( $until = $wgRequest->getVal( 'until' ) ) {
89 $where[] = "img_timestamp < '" . $dbr->timestamp( $until ) . "'";
91 if( $from = $wgRequest->getVal( 'from' ) ) {
92 $where[] = "img_timestamp >= '" . $dbr->timestamp( $from ) . "'";
95 $sql='SELECT img_size, img_name, img_user, img_user_text,'.
96 "img_description,img_timestamp FROM $image";
100 $where[]='ug_group IS NULL';
103 $sql.=' WHERE '.$dbr->makeList($where, LIST_AND
);
105 $sql.=' ORDER BY img_timestamp '. ( $invertSort ?
'' : ' DESC' );
106 $sql.=' LIMIT '.($limit+
1);
107 $res = $dbr->query($sql, 'wfSpecialNewImages');
110 * We have to flip things around to get the last N after a certain date
113 while ( $s = $dbr->fetchObject( $res ) ) {
115 array_unshift( $images, $s );
117 array_push( $images, $s );
120 $dbr->freeResult( $res );
122 $gallery = new ImageGallery();
123 $firstTimestamp = null;
124 $lastTimestamp = null;
126 foreach( $images as $s ) {
127 if( ++
$shownImages > $limit ) {
128 # One extra just to test for whether to show a page link;
129 # don't actually show it.
133 $name = $s->img_name
;
134 $ut = $s->img_user_text
;
136 $nt = Title
::newFromText( $name, NS_IMAGE
);
137 $ul = $sk->makeLinkObj( Title
::makeTitle( NS_USER
, $ut ), $ut );
139 $gallery->add( $nt, "$ul<br />\n<i>".$wgLang->timeanddate( $s->img_timestamp
, true )."</i><br />\n" );
141 $timestamp = wfTimestamp( TS_MW
, $s->img_timestamp
);
142 if( empty( $firstTimestamp ) ) {
143 $firstTimestamp = $timestamp;
145 $lastTimestamp = $timestamp;
148 $bydate = wfMsg( 'bydate' );
149 $lt = $wgLang->formatNum( min( $shownImages, $limit ) );
151 $text = wfMsgExt( 'imagelisttext', array('parse'), $lt, $bydate );
152 $wgOut->addHTML( $text . "\n" );
155 $sub = wfMsg( 'ilsubmit' );
156 $titleObj = SpecialPage
::getTitleFor( 'Newimages' );
157 $action = $titleObj->escapeLocalURL( $hidebots ?
'' : 'hidebots=0' );
158 if ($shownav && !$wgMiserMode) {
159 $wgOut->addHTML( "<form id=\"imagesearch\" method=\"post\" action=\"" .
161 Xml
::input( 'wpIlMatch', 20, $wpIlMatch ) . ' ' .
162 Xml
::submitButton( $sub, array( 'name' => 'wpIlSubmit' ) ) .
170 # If we change bot visibility, this needs to be carried along.
172 $botpar='&hidebots=0';
176 $now = wfTimestampNow();
177 $d = $wgLang->date( $now, true );
178 $t = $wgLang->time( $now, true );
179 $dateLink = $sk->makeKnownLinkObj( $titleObj, wfMsgHtml( 'sp-newimages-showfrom', $d, $t ),
180 'from='.$now.$botpar.$searchpar );
182 $botLink = $sk->makeKnownLinkObj($titleObj, wfMsgHtml( 'showhidebots',
183 ($hidebots ?
wfMsgHtml('show') : wfMsgHtml('hide'))),'hidebots='.($hidebots ?
'0' : '1').$searchpar);
186 $opts = array( 'parsemag', 'escapenoentities' );
187 $prevLink = wfMsgExt( 'prevn', $opts, $wgLang->formatNum( $limit ) );
188 if( $firstTimestamp && $firstTimestamp != $latestTimestamp ) {
189 $prevLink = $sk->makeKnownLinkObj( $titleObj, $prevLink, 'from=' . $firstTimestamp . $botpar . $searchpar );
192 $nextLink = wfMsgExt( 'nextn', $opts, $wgLang->formatNum( $limit ) );
193 if( $shownImages > $limit && $lastTimestamp ) {
194 $nextLink = $sk->makeKnownLinkObj( $titleObj, $nextLink, 'until=' . $lastTimestamp.$botpar.$searchpar );
197 $prevnext = '<p>' . $botLink . ' '. wfMsgHtml( 'viewprevnext', $prevLink, $nextLink, $dateLink ) .'</p>';
200 $wgOut->addHTML( $prevnext );
202 if( count( $images ) ) {
203 $wgOut->addHTML( $gallery->toHTML() );
205 $wgOut->addHTML( $prevnext );
207 $wgOut->addWikiMsg( 'noimages' );