includes/SpecialNewimages.php

   1 <?php
   2 /**
   3  *
   4  * @package MediaWiki
   5  * @subpackage SpecialPage
   6  */
   7
   8 /** */
   9 require_once( 'ImageGallery.php' );
  10
  11 /**
  12  *
  13  */
  14 function wfSpecialNewimages( $par, $specialPage ) {
  15         global $wgUser, $wgOut, $wgLang, $wgContLang, $wgRequest,
  16                $wgGroupPermissions;
  17
  18         $wpIlMatch = $wgRequest->getText( 'wpIlMatch' );
  19         $dbr =& wfGetDB( DB_SLAVE );
  20         $sk = $wgUser->getSkin();
  21         $shownav = !$specialPage->including();
  22         $hidebots = $wgRequest->getBool('hidebots',1);
  23
  24         # Show only for a single user?
  25         $targetUser = isset($par) ? $par : $wgRequest->getVal( 'target' );
  26         if ( $targetUser != "" ) {
  27                 $singleUser = User::newFromName ( urldecode ( $targetUser ) ) ;
  28         }
  29
  30         if($hidebots) {
  31
  32                 /** Make a list of group names which have the 'bot' flag
  33                     set.
  34                 */
  35                 $botconds=array();
  36                 foreach ($wgGroupPermissions as $groupname=>$perms) {
  37                         if(array_key_exists('bot',$perms) && $perms['bot']) {
  38                                 $botconds[]="ug_group='$groupname'";
  39                         }
  40                 }
  41                 $isbotmember=$dbr->makeList($botconds, LIST_OR);
  42
  43                 /** This join, in conjunction with WHERE ug_group
  44                     IS NULL, returns only those rows from IMAGE
  45                     where the uploading user is not a member of
  46                     a group which has the 'bot' permission set.
  47                 */
  48                 $ug = $dbr->tableName('user_groups');
  49                 $joinsql=" LEFT OUTER JOIN $ug ON img_user=ug_user AND ("
  50                   . $isbotmember.')';
  51         }
  52
  53         $image = $dbr->tableName('image');
  54
  55         $sql="SELECT img_timestamp from $image";
  56
  57         # Hide bots?
  58         if($hidebots) {
  59                 $sql.=$joinsql.' WHERE ug_group IS NULL';
  60         }
  61
  62         $sql.=' ORDER BY img_timestamp DESC LIMIT 1';
  63         $res = $dbr->query($sql, 'wfSpecialNewImages');
  64         $row = $dbr->fetchRow($res);
  65         if($row!==false) {
  66                 $ts=$row[0];
  67         } else {
  68                 $ts=false;
  69         }
  70         $dbr->freeResult($res);
  71         $sql='';
  72
  73         /** If we were clever, we'd use this to cache. */
  74         $latestTimestamp = wfTimestamp( TS_MW, $ts);
  75
  76         /** Was a limit set? */
  77         $limitvar = NULL ;
  78         $offset = NULL ;
  79         $limitpar = "" ;
  80         $maxlimit = 48 ;
  81         $limit = $maxlimit ;
  82         list( $limitvar, $offset ) = wfCheckLimits();
  83         # Ignoring offset, checking limit
  84         if ( isset ( $limitvar ) AND $limitvar != NULL AND $parval = intval( $limitvar ) ) {
  85                 if ( $parval <= $maxlimit && $parval > 0 ) {
  86                         $limit = $parval;
  87                 }
  88                 if ( $limit != $maxlimit ) {
  89                         $limitpar = "&limit=" . $limit ;
  90                 }
  91         }
  92
  93 /*
  94         # Old limit code
  95         $limit = 48;
  96         if ( $parval = intval( $par ) )
  97                 if ( $parval <= $limit && $parval > 0 )
  98                         $limit = $parval;
  99 */
 100
 101         $where = array();
 102         $searchpar = '';
 103         if ( $wpIlMatch != '' ) {
 104                 $nt = Title::newFromUrl( $wpIlMatch );
 105                 if($nt ) {
 106                         $m = $dbr->strencode( strtolower( $nt->getDBkey() ) );
 107                         $m = str_replace( '%', "\\%", $m );
 108                         $m = str_replace( '_', "\\_", $m );
 109                         $where[] = "LCASE(img_name) LIKE '%{$m}%'";
 110                         $searchpar = '&wpIlMatch=' . urlencode( $wpIlMatch );
 111                 }
 112         }
 113
 114         # SQL for single user only?
 115         if ( isset ( $singleUser ) ) {
 116                 $where[] .= "img_user='" . $singleUser->getID() . "'" ;
 117                 $userpar = "&target=" . urlencode ( $singleUser->getName() ) ;
 118         } else {
 119                 $userpar = "" ;
 120         }
 121
 122         $invertSort = false;
 123         if( $until = $wgRequest->getVal( 'until' ) ) {
 124                 $where[] = 'img_timestamp < ' . $dbr->timestamp( $until );
 125         }
 126         if( $from = $wgRequest->getVal( 'from' ) ) {
 127                 $where[] = 'img_timestamp >= ' . $dbr->timestamp( $from );
 128                 $invertSort = true;
 129         }
 130         $sql='SELECT img_size, img_name, img_user, img_user_text,'.
 131              "img_description,img_timestamp FROM $image";
 132
 133         if($hidebots) {
 134                 $sql.=$joinsql;
 135                 $where[]='ug_group IS NULL';
 136         }
 137         if(count($where)) {
 138                 $sql.=' WHERE '.$dbr->makeList($where, LIST_AND);
 139         }
 140         $sql.=' ORDER BY img_timestamp '. ( $invertSort ? '' : ' DESC' );
 141         $sql.=' LIMIT '.($limit+1);
 142         $res = $dbr->query($sql, 'wfSpecialNewImages');
 143
 144         /**
 145          * We have to flip things around to get the last N after a certain date
 146          */
 147         $images = array();
 148         while ( $s = $dbr->fetchObject( $res ) ) {
 149                 if( $invertSort ) {
 150                         array_unshift( $images, $s );
 151                 } else {
 152                         array_push( $images, $s );
 153                 }
 154         }
 155         $dbr->freeResult( $res );
 156
 157         $gallery = new ImageGallery();
 158         $firstTimestamp = null;
 159         $lastTimestamp = null;
 160         $shownImages = 0;
 161         foreach( $images as $s ) {
 162                 if( ++$shownImages > $limit ) {
 163                         # One extra just to test for whether to show a page link;
 164                         # don't actually show it.
 165                         break;
 166                 }
 167
 168                 $name = $s->img_name;
 169                 $ut = $s->img_user_text;
 170
 171                 $nt = Title::newFromText( $name, NS_IMAGE );
 172                 $img = Image::newFromTitle( $nt );
 173                 $ul = $sk->makeLinkObj( Title::makeTitle( NS_USER, $ut ), $ut );
 174
 175                 $gallery->add( $img, "$ul<br />\n<i>".$wgLang->timeanddate( $s->img_timestamp, true )."</i><br />\n" );
 176
 177                 $timestamp = wfTimestamp( TS_MW, $s->img_timestamp );
 178                 if( empty( $firstTimestamp ) ) {
 179                         $firstTimestamp = $timestamp;
 180                 }
 181                 $lastTimestamp = $timestamp;
 182         }
 183
 184         $bydate = wfMsg( 'bydate' );
 185         $lt = $wgLang->formatNum( min( $shownImages, $limit ) );
 186         if ($shownav) {
 187                 $text = wfMsg( 'imagelisttext', "<strong>{$lt}</strong>", "<strong>{$bydate}</strong>" );
 188                 $wgOut->addHTML( "<p>{$text}\n</p>" );
 189         }
 190
 191         # Single user search note
 192         if ( isset ( $singleUser ) ) {
 193                 $t = $singleUser->getUserPage() ;
 194                 $uPage = $sk->makeLinkObj( $t ) ;
 195                 $wgOut->addHTML ( wfMsg ( 'imagelistforuser' , $uPage ) ) ;
 196         }
 197
 198         $sub = wfMsg( 'ilsubmit' );
 199         $titleObj = Title::makeTitle( NS_SPECIAL, 'Newimages' );
 200         $action = $titleObj->escapeLocalURL();
 201         if(!$hidebots) {
 202                 $action.='&hidebots=0';
 203         }
 204         if ($shownav) {
 205                 $wgOut->addHTML( "<form id=\"imagesearch\" method=\"post\" action=\"" .
 206                   "{$action}\">" .
 207                   "<input type='text' size='20' name=\"wpIlMatch\" value=\"" .
 208                   htmlspecialchars( $wpIlMatch ) . "\" /> " .
 209                   "<input type='submit' name=\"wpIlSubmit\" value=\"{$sub}\" /></form>" );
 210         }
 211         $here = $wgContLang->specialPage( 'Newimages' );
 212
 213         /**
 214          * Paging controls...
 215          */
 216
 217         # If we change bot visibility, this needs to be carried along.
 218         if(!$hidebots) {
 219                 $botpar='&hidebots=0';
 220         } else {
 221                 $botpar='';
 222         }
 223         $now = wfTimestampNow();
 224         $date = $wgLang->timeanddate( $now );
 225         $dateLink = $sk->makeKnownLinkObj( $titleObj, wfMsg( 'rclistfrom', $date ), 'from='.$now.$botpar.$searchpar );
 226
 227         $botLink = $sk->makeKnownLinkObj($titleObj, wfMsg( 'showhidebots', ($hidebots ? wfMsg('show') : wfMsg('hide'))),'hidebots='.($hidebots ? '0' : '1').$searchpar);
 228
 229         $prevLink = wfMsg( 'prevn', $wgLang->formatNum( $limit ) );
 230         if( $firstTimestamp && $firstTimestamp != $latestTimestamp ) {
 231                 $prevLink = $sk->makeKnownLinkObj( $titleObj, $prevLink, 'from=' . $firstTimestamp . $botpar . $searchpar . $userpar . $limitpar );
 232         }
 233
 234         $nextLink = wfMsg( 'nextn', $wgLang->formatNum( $limit ) );
 235         if( $shownImages > $limit && $lastTimestamp ) {
 236                 $nextLink = $sk->makeKnownLinkObj( $titleObj, $nextLink, 'until=' . $lastTimestamp.$botpar.$searchpar.$userpar.$limitpar );
 237         }
 238
 239         $prevnext = '<p>' . $botLink . ' '. wfMsg( 'viewprevnext', $prevLink, $nextLink, $dateLink ) .'</p>';
 240
 241         if ($shownav)
 242                 $wgOut->addHTML( $prevnext );
 243
 244         if( count( $images ) ) {
 245                 $wgOut->addHTML( $gallery->toHTML() );
 246                 if ($shownav)
 247                         $wgOut->addHTML( $prevnext );
 248         } else {
 249                 $wgOut->addWikiText( wfMsg( 'noimages' ) );
 250         }
 251 }
 252
 253 ?>