MediaWiki REL1_37
ApiQueryFilearchive.php
Go to the documentation of this file.
1<?php
28
35
38
44 public function __construct(
45 ApiQuery $query,
46 $moduleName,
48 ) {
49 parent::__construct( $query, $moduleName, 'fa' );
50 $this->commentStore = $commentStore;
51 }
52
53 public function execute() {
54 $user = $this->getUser();
55 $db = $this->getDB();
56
57 $params = $this->extractRequestParams();
58
59 $prop = array_fill_keys( $params['prop'], true );
60 $fld_sha1 = isset( $prop['sha1'] );
61 $fld_timestamp = isset( $prop['timestamp'] );
62 $fld_user = isset( $prop['user'] );
63 $fld_size = isset( $prop['size'] );
64 $fld_dimensions = isset( $prop['dimensions'] );
65 $fld_description = isset( $prop['description'] ) || isset( $prop['parseddescription'] );
66 $fld_mime = isset( $prop['mime'] );
67 $fld_mediatype = isset( $prop['mediatype'] );
68 $fld_metadata = isset( $prop['metadata'] );
69 $fld_bitdepth = isset( $prop['bitdepth'] );
70 $fld_archivename = isset( $prop['archivename'] );
71
72 if ( $fld_description && !$this->getAuthority()->isAllowed( 'deletedhistory' ) ) {
73 $this->dieWithError( 'apierror-cantview-deleted-description', 'permissiondenied' );
74 }
75 if ( $fld_metadata && !$this->getAuthority()->isAllowedAny( 'deletedtext', 'undelete' ) ) {
76 $this->dieWithError( 'apierror-cantview-deleted-metadata', 'permissiondenied' );
77 }
78
79 $fileQuery = ArchivedFile::getQueryInfo();
80 $this->addTables( $fileQuery['tables'] );
81 $this->addFields( $fileQuery['fields'] );
82 $this->addJoinConds( $fileQuery['joins'] );
83
84 if ( $params['continue'] !== null ) {
85 $cont = explode( '|', $params['continue'] );
86 $this->dieContinueUsageIf( count( $cont ) != 3 );
87 $op = $params['dir'] == 'descending' ? '<' : '>';
88 $cont_from = $db->addQuotes( $cont[0] );
89 $cont_timestamp = $db->addQuotes( $db->timestamp( $cont[1] ) );
90 $cont_id = (int)$cont[2];
91 $this->dieContinueUsageIf( $cont[2] !== (string)$cont_id );
92 $this->addWhere( "fa_name $op $cont_from OR " .
93 "(fa_name = $cont_from AND " .
94 "(fa_timestamp $op $cont_timestamp OR " .
95 "(fa_timestamp = $cont_timestamp AND " .
96 "fa_id $op= $cont_id )))"
97 );
98 }
99
100 // Image filters
101 $dir = ( $params['dir'] == 'descending' ? 'older' : 'newer' );
102 $from = ( $params['from'] === null ? null : $this->titlePartToKey( $params['from'], NS_FILE ) );
103 $to = ( $params['to'] === null ? null : $this->titlePartToKey( $params['to'], NS_FILE ) );
104 $this->addWhereRange( 'fa_name', $dir, $from, $to );
105 if ( isset( $params['prefix'] ) ) {
106 $this->addWhere( 'fa_name' . $db->buildLike(
107 $this->titlePartToKey( $params['prefix'], NS_FILE ),
108 $db->anyString() ) );
109 }
110
111 $sha1Set = isset( $params['sha1'] );
112 $sha1base36Set = isset( $params['sha1base36'] );
113 if ( $sha1Set || $sha1base36Set ) {
114 $sha1 = false;
115 if ( $sha1Set ) {
116 $sha1 = strtolower( $params['sha1'] );
117 if ( !$this->validateSha1Hash( $sha1 ) ) {
118 $this->dieWithError( 'apierror-invalidsha1hash' );
119 }
120 $sha1 = Wikimedia\base_convert( $sha1, 16, 36, 31 );
121 } elseif ( $sha1base36Set ) {
122 $sha1 = strtolower( $params['sha1base36'] );
123 if ( !$this->validateSha1Base36Hash( $sha1 ) ) {
124 $this->dieWithError( 'apierror-invalidsha1base36hash' );
125 }
126 }
127 if ( $sha1 ) {
128 $this->addWhereFld( 'fa_sha1', $sha1 );
129 // Paranoia: avoid brute force searches (T19342)
130 if ( !$this->getAuthority()->isAllowed( 'deletedtext' ) ) {
131 $bitmask = File::DELETED_FILE;
132 } elseif ( !$this->getAuthority()->isAllowedAny( 'suppressrevision', 'viewsuppressed' ) ) {
133 $bitmask = File::DELETED_FILE | File::DELETED_RESTRICTED;
134 } else {
135 $bitmask = 0;
136 }
137 if ( $bitmask ) {
138 $this->addWhere( $this->getDB()->bitAnd( 'fa_deleted', $bitmask ) . " != $bitmask" );
139 }
140 }
141 }
142
143 $limit = $params['limit'];
144 $this->addOption( 'LIMIT', $limit + 1 );
145 $sort = ( $params['dir'] == 'descending' ? ' DESC' : '' );
146 $this->addOption( 'ORDER BY', [
147 'fa_name' . $sort,
148 'fa_timestamp' . $sort,
149 'fa_id' . $sort,
150 ] );
151
152 $res = $this->select( __METHOD__ );
153
154 $count = 0;
155 $result = $this->getResult();
156 foreach ( $res as $row ) {
157 if ( ++$count > $limit ) {
158 // We've reached the one extra which shows that there are
159 // additional pages to be had. Stop here...
161 'continue', "$row->fa_name|$row->fa_timestamp|$row->fa_id"
162 );
163 break;
164 }
165
166 $canViewFile = RevisionRecord::userCanBitfield( $row->fa_deleted, File::DELETED_FILE, $user );
167
168 $file = [];
169 $file['id'] = (int)$row->fa_id;
170 $file['name'] = $row->fa_name;
171 $title = Title::makeTitle( NS_FILE, $row->fa_name );
173
174 if ( $fld_description &&
175 RevisionRecord::userCanBitfield( $row->fa_deleted, File::DELETED_COMMENT, $user )
176 ) {
177 $file['description'] = $this->commentStore->getComment( 'fa_description', $row )->text;
178 if ( isset( $prop['parseddescription'] ) ) {
179 $file['parseddescription'] = Linker::formatComment(
180 $file['description'], $title );
181 }
182 }
183 if ( $fld_user &&
184 RevisionRecord::userCanBitfield( $row->fa_deleted, File::DELETED_USER, $user )
185 ) {
186 $file['userid'] = (int)$row->fa_user;
187 $file['user'] = $row->fa_user_text;
188 }
189 if ( $fld_sha1 && $canViewFile ) {
190 $file['sha1'] = Wikimedia\base_convert( $row->fa_sha1, 36, 16, 40 );
191 }
192 if ( $fld_timestamp ) {
193 $file['timestamp'] = wfTimestamp( TS_ISO_8601, $row->fa_timestamp );
194 }
195 if ( ( $fld_size || $fld_dimensions ) && $canViewFile ) {
196 $file['size'] = $row->fa_size;
197
198 $pageCount = ArchivedFile::newFromRow( $row )->pageCount();
199 if ( $pageCount !== false ) {
200 $file['pagecount'] = $pageCount;
201 }
202
203 $file['height'] = $row->fa_height;
204 $file['width'] = $row->fa_width;
205 }
206 if ( $fld_mediatype && $canViewFile ) {
207 $file['mediatype'] = $row->fa_media_type;
208 }
209 if ( $fld_metadata && $canViewFile ) {
210 $file['metadata'] = $row->fa_metadata
211 ? ApiQueryImageInfo::processMetaData( unserialize( $row->fa_metadata ), $result )
212 : null;
213 }
214 if ( $fld_bitdepth && $canViewFile ) {
215 $file['bitdepth'] = $row->fa_bits;
216 }
217 if ( $fld_mime && $canViewFile ) {
218 $file['mime'] = "$row->fa_major_mime/$row->fa_minor_mime";
219 }
220 if ( $fld_archivename && $row->fa_archive_name !== null ) {
221 $file['archivename'] = $row->fa_archive_name;
222 }
223
224 if ( $row->fa_deleted & File::DELETED_FILE ) {
225 $file['filehidden'] = true;
226 }
227 if ( $row->fa_deleted & File::DELETED_COMMENT ) {
228 $file['commenthidden'] = true;
229 }
230 if ( $row->fa_deleted & File::DELETED_USER ) {
231 $file['userhidden'] = true;
232 }
233 if ( $row->fa_deleted & File::DELETED_RESTRICTED ) {
234 // This file is deleted for normal admins
235 $file['suppressed'] = true;
236 }
237
238 $fit = $result->addValue( [ 'query', $this->getModuleName() ], null, $file );
239 if ( !$fit ) {
241 'continue', "$row->fa_name|$row->fa_timestamp|$row->fa_id"
242 );
243 break;
244 }
245 }
246
247 $result->addIndexedTagName( [ 'query', $this->getModuleName() ], 'fa' );
248 }
249
250 public function getAllowedParams() {
251 return [
252 'from' => null,
253 'to' => null,
254 'prefix' => null,
255 'dir' => [
256 ApiBase::PARAM_DFLT => 'ascending',
258 'ascending',
259 'descending'
260 ]
261 ],
262 'sha1' => null,
263 'sha1base36' => null,
264 'prop' => [
265 ApiBase::PARAM_DFLT => 'timestamp',
268 'sha1',
269 'timestamp',
270 'user',
271 'size',
272 'dimensions',
273 'description',
274 'parseddescription',
275 'mime',
276 'mediatype',
277 'metadata',
278 'bitdepth',
279 'archivename',
280 ],
282 ],
283 'limit' => [
285 ApiBase::PARAM_TYPE => 'limit',
289 ],
290 'continue' => [
291 ApiBase::PARAM_HELP_MSG => 'api-help-param-continue',
292 ],
293 ];
294 }
295
296 protected function getExamplesMessages() {
297 return [
298 'action=query&list=filearchive'
299 => 'apihelp-query+filearchive-example-simple',
300 ];
301 }
302
303 public function getHelpUrls() {
304 return 'https://www.mediawiki.org/wiki/Special:MyLanguage/API:Filearchive';
305 }
306}
unserialize( $serialized)
const NS_FILE
Definition Defines.php:70
wfTimestamp( $outputtype=TS_UNIX, $ts=0)
Get a timestamp string in one of various formats.
dieWithError( $msg, $code=null, $data=null, $httpCode=0)
Abort execution with an error.
Definition ApiBase.php:1436
const PARAM_MAX2
Definition ApiBase.php:89
const PARAM_MAX
Definition ApiBase.php:85
dieContinueUsageIf( $condition)
Die with the 'badcontinue' error.
Definition ApiBase.php:1620
const PARAM_TYPE
Definition ApiBase.php:81
const PARAM_DFLT
Definition ApiBase.php:73
const PARAM_HELP_MSG_PER_VALUE
((string|array|Message)[]) When PARAM_TYPE is an array, this is an array mapping those values to $msg...
Definition ApiBase.php:195
const PARAM_MIN
Definition ApiBase.php:93
const LIMIT_BIG1
Fast query, standard limit.
Definition ApiBase.php:220
getResult()
Get the result object.
Definition ApiBase.php:628
extractRequestParams( $options=[])
Using getAllowedParams(), this function makes an array of the values provided by the user,...
Definition ApiBase.php:764
const PARAM_HELP_MSG
(string|array|Message) Specify an alternative i18n documentation message for this parameter.
Definition ApiBase.php:162
const LIMIT_BIG2
Fast query, apihighlimits limit.
Definition ApiBase.php:222
getModuleName()
Get the name of the module being executed by this instance.
Definition ApiBase.php:497
const PARAM_ISMULTI
Definition ApiBase.php:77
This is a base class for all Query modules.
static addTitleInfo(&$arr, $title, $prefix='')
Add information (title and namespace) about a Title object to a result array.
setContinueEnumParameter( $paramName, $paramValue)
Set a query-continue value.
validateSha1Base36Hash( $hash)
addWhereRange( $field, $dir, $start, $end, $sort=true)
Add a WHERE clause corresponding to a range, and an ORDER BY clause to sort in the right direction.
validateSha1Hash( $hash)
addFields( $value)
Add a set of fields to select to the internal array.
addOption( $name, $value=null)
Add an option such as LIMIT or USE INDEX.
addTables( $tables, $alias=null)
Add a set of tables to the internal array.
getDB()
Get the Query database connection (read-only)
select( $method, $extraQuery=[], array &$hookData=null)
Execute a SELECT query based on the values in the internal arrays.
addJoinConds( $join_conds)
Add a set of JOIN conditions to the internal array.
addWhereFld( $field, $value)
Equivalent to addWhere( [ $field => $value ] )
titlePartToKey( $titlePart, $namespace=NS_MAIN)
Convert an input title or title prefix into a dbkey.
addWhere( $value)
Add a set of WHERE clauses to the internal array.
Query module to enumerate all deleted files.
getExamplesMessages()
Returns usage examples for this module.
execute()
Evaluates the parameters, performs the requested query, and sets up the result.
__construct(ApiQuery $query, $moduleName, CommentStore $commentStore)
getHelpUrls()
Return links to more detailed help pages about the module.
getAllowedParams()
Returns an array of allowed parameters (parameter name) => (default value) or (parameter name) => (ar...
static processMetaData( $metadata, $result)
This is the main query class.
Definition ApiQuery.php:37
static getQueryInfo()
Return the tables, fields, and join conditions to be selected to create a new archivedfile object.
static newFromRow( $row)
Loads a file object from the filearchive table.
Handle database storage of comments such as edit summaries and log reasons.
static formatComment( $comment, $title=null, $local=false, $wikiId=null)
This function is called by all recent changes variants, by the page history, and by the user contribu...
Definition Linker.php:1372
Page revision base class.
if(PHP_SAPI !='cli-server') if(!isset( $_SERVER['SCRIPT_FILENAME'])) $file
Item class for a filearchive table row.
Definition router.php:42