MediaWiki REL1_35
ApiQueryFilearchive.php
Go to the documentation of this file.
1<?php
28
35
36 public function __construct( ApiQuery $query, $moduleName ) {
37 parent::__construct( $query, $moduleName, 'fa' );
38 }
39
40 public function execute() {
41 $user = $this->getUser();
42 $db = $this->getDB();
43 $commentStore = CommentStore::getStore();
44
45 $params = $this->extractRequestParams();
46
47 $prop = array_flip( $params['prop'] );
48 $fld_sha1 = isset( $prop['sha1'] );
49 $fld_timestamp = isset( $prop['timestamp'] );
50 $fld_user = isset( $prop['user'] );
51 $fld_size = isset( $prop['size'] );
52 $fld_dimensions = isset( $prop['dimensions'] );
53 $fld_description = isset( $prop['description'] ) || isset( $prop['parseddescription'] );
54 $fld_mime = isset( $prop['mime'] );
55 $fld_mediatype = isset( $prop['mediatype'] );
56 $fld_metadata = isset( $prop['metadata'] );
57 $fld_bitdepth = isset( $prop['bitdepth'] );
58 $fld_archivename = isset( $prop['archivename'] );
59
60 if ( $fld_description &&
61 !$this->getPermissionManager()->userHasRight( $user, 'deletedhistory' )
62 ) {
63 $this->dieWithError( 'apierror-cantview-deleted-description', 'permissiondenied' );
64 }
65 if ( $fld_metadata &&
66 !$this->getPermissionManager()->userHasAnyRight( $user, 'deletedtext', 'undelete' )
67 ) {
68 $this->dieWithError( 'apierror-cantview-deleted-metadata', 'permissiondenied' );
69 }
70
71 $fileQuery = ArchivedFile::getQueryInfo();
72 $this->addTables( $fileQuery['tables'] );
73 $this->addFields( $fileQuery['fields'] );
74 $this->addJoinConds( $fileQuery['joins'] );
75
76 if ( $params['continue'] !== null ) {
77 $cont = explode( '|', $params['continue'] );
78 $this->dieContinueUsageIf( count( $cont ) != 3 );
79 $op = $params['dir'] == 'descending' ? '<' : '>';
80 $cont_from = $db->addQuotes( $cont[0] );
81 $cont_timestamp = $db->addQuotes( $db->timestamp( $cont[1] ) );
82 $cont_id = (int)$cont[2];
83 $this->dieContinueUsageIf( $cont[2] !== (string)$cont_id );
84 $this->addWhere( "fa_name $op $cont_from OR " .
85 "(fa_name = $cont_from AND " .
86 "(fa_timestamp $op $cont_timestamp OR " .
87 "(fa_timestamp = $cont_timestamp AND " .
88 "fa_id $op= $cont_id )))"
89 );
90 }
91
92 // Image filters
93 $dir = ( $params['dir'] == 'descending' ? 'older' : 'newer' );
94 $from = ( $params['from'] === null ? null : $this->titlePartToKey( $params['from'], NS_FILE ) );
95 $to = ( $params['to'] === null ? null : $this->titlePartToKey( $params['to'], NS_FILE ) );
96 $this->addWhereRange( 'fa_name', $dir, $from, $to );
97 if ( isset( $params['prefix'] ) ) {
98 $this->addWhere( 'fa_name' . $db->buildLike(
99 $this->titlePartToKey( $params['prefix'], NS_FILE ),
100 $db->anyString() ) );
101 }
102
103 $sha1Set = isset( $params['sha1'] );
104 $sha1base36Set = isset( $params['sha1base36'] );
105 if ( $sha1Set || $sha1base36Set ) {
106 $sha1 = false;
107 if ( $sha1Set ) {
108 $sha1 = strtolower( $params['sha1'] );
109 if ( !$this->validateSha1Hash( $sha1 ) ) {
110 $this->dieWithError( 'apierror-invalidsha1hash' );
111 }
112 $sha1 = Wikimedia\base_convert( $sha1, 16, 36, 31 );
113 } elseif ( $sha1base36Set ) {
114 $sha1 = strtolower( $params['sha1base36'] );
115 if ( !$this->validateSha1Base36Hash( $sha1 ) ) {
116 $this->dieWithError( 'apierror-invalidsha1base36hash' );
117 }
118 }
119 if ( $sha1 ) {
120 $this->addWhereFld( 'fa_sha1', $sha1 );
121 // Paranoia: avoid brute force searches (T19342)
122 if ( !$this->getPermissionManager()->userHasRight( $user, 'deletedtext' ) ) {
123 $bitmask = File::DELETED_FILE;
124 } elseif ( !$this->getPermissionManager()
125 ->userHasAnyRight( $user, 'suppressrevision', 'viewsuppressed' )
126 ) {
127 $bitmask = File::DELETED_FILE | File::DELETED_RESTRICTED;
128 } else {
129 $bitmask = 0;
130 }
131 if ( $bitmask ) {
132 $this->addWhere( $this->getDB()->bitAnd( 'fa_deleted', $bitmask ) . " != $bitmask" );
133 }
134 }
135 }
136
137 $limit = $params['limit'];
138 $this->addOption( 'LIMIT', $limit + 1 );
139 $sort = ( $params['dir'] == 'descending' ? ' DESC' : '' );
140 $this->addOption( 'ORDER BY', [
141 'fa_name' . $sort,
142 'fa_timestamp' . $sort,
143 'fa_id' . $sort,
144 ] );
145
146 $res = $this->select( __METHOD__ );
147
148 $count = 0;
149 $result = $this->getResult();
150 foreach ( $res as $row ) {
151 if ( ++$count > $limit ) {
152 // We've reached the one extra which shows that there are
153 // additional pages to be had. Stop here...
155 'continue', "$row->fa_name|$row->fa_timestamp|$row->fa_id"
156 );
157 break;
158 }
159
160 $canViewFile = RevisionRecord::userCanBitfield( $row->fa_deleted, File::DELETED_FILE, $user );
161
162 $file = [];
163 $file['id'] = (int)$row->fa_id;
164 $file['name'] = $row->fa_name;
165 $title = Title::makeTitle( NS_FILE, $row->fa_name );
167
168 if ( $fld_description &&
169 RevisionRecord::userCanBitfield( $row->fa_deleted, File::DELETED_COMMENT, $user )
170 ) {
171 $file['description'] = $commentStore->getComment( 'fa_description', $row )->text;
172 if ( isset( $prop['parseddescription'] ) ) {
173 $file['parseddescription'] = Linker::formatComment(
174 $file['description'], $title );
175 }
176 }
177 if ( $fld_user &&
178 RevisionRecord::userCanBitfield( $row->fa_deleted, File::DELETED_USER, $user )
179 ) {
180 $file['userid'] = (int)$row->fa_user;
181 $file['user'] = $row->fa_user_text;
182 }
183 if ( $fld_sha1 && $canViewFile ) {
184 $file['sha1'] = Wikimedia\base_convert( $row->fa_sha1, 36, 16, 40 );
185 }
186 if ( $fld_timestamp ) {
187 $file['timestamp'] = wfTimestamp( TS_ISO_8601, $row->fa_timestamp );
188 }
189 if ( ( $fld_size || $fld_dimensions ) && $canViewFile ) {
190 $file['size'] = $row->fa_size;
191
192 $pageCount = ArchivedFile::newFromRow( $row )->pageCount();
193 if ( $pageCount !== false ) {
194 $file['pagecount'] = $pageCount;
195 }
196
197 $file['height'] = $row->fa_height;
198 $file['width'] = $row->fa_width;
199 }
200 if ( $fld_mediatype && $canViewFile ) {
201 $file['mediatype'] = $row->fa_media_type;
202 }
203 if ( $fld_metadata && $canViewFile ) {
204 $file['metadata'] = $row->fa_metadata
205 ? ApiQueryImageInfo::processMetaData( unserialize( $row->fa_metadata ), $result )
206 : null;
207 }
208 if ( $fld_bitdepth && $canViewFile ) {
209 $file['bitdepth'] = $row->fa_bits;
210 }
211 if ( $fld_mime && $canViewFile ) {
212 $file['mime'] = "$row->fa_major_mime/$row->fa_minor_mime";
213 }
214 if ( $fld_archivename && $row->fa_archive_name !== null ) {
215 $file['archivename'] = $row->fa_archive_name;
216 }
217
218 if ( $row->fa_deleted & File::DELETED_FILE ) {
219 $file['filehidden'] = true;
220 }
221 if ( $row->fa_deleted & File::DELETED_COMMENT ) {
222 $file['commenthidden'] = true;
223 }
224 if ( $row->fa_deleted & File::DELETED_USER ) {
225 $file['userhidden'] = true;
226 }
227 if ( $row->fa_deleted & File::DELETED_RESTRICTED ) {
228 // This file is deleted for normal admins
229 $file['suppressed'] = true;
230 }
231
232 $fit = $result->addValue( [ 'query', $this->getModuleName() ], null, $file );
233 if ( !$fit ) {
235 'continue', "$row->fa_name|$row->fa_timestamp|$row->fa_id"
236 );
237 break;
238 }
239 }
240
241 $result->addIndexedTagName( [ 'query', $this->getModuleName() ], 'fa' );
242 }
243
244 public function getAllowedParams() {
245 return [
246 'from' => null,
247 'to' => null,
248 'prefix' => null,
249 'dir' => [
250 ApiBase::PARAM_DFLT => 'ascending',
252 'ascending',
253 'descending'
254 ]
255 ],
256 'sha1' => null,
257 'sha1base36' => null,
258 'prop' => [
259 ApiBase::PARAM_DFLT => 'timestamp',
262 'sha1',
263 'timestamp',
264 'user',
265 'size',
266 'dimensions',
267 'description',
268 'parseddescription',
269 'mime',
270 'mediatype',
271 'metadata',
272 'bitdepth',
273 'archivename',
274 ],
276 ],
277 'limit' => [
279 ApiBase::PARAM_TYPE => 'limit',
283 ],
284 'continue' => [
285 ApiBase::PARAM_HELP_MSG => 'api-help-param-continue',
286 ],
287 ];
288 }
289
290 protected function getExamplesMessages() {
291 return [
292 'action=query&list=filearchive'
293 => 'apihelp-query+filearchive-example-simple',
294 ];
295 }
296
297 public function getHelpUrls() {
298 return 'https://www.mediawiki.org/wiki/Special:MyLanguage/API:Filearchive';
299 }
300}
unserialize( $serialized)
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:1437
const PARAM_MAX2
Definition ApiBase.php:86
const PARAM_MAX
Definition ApiBase.php:82
dieContinueUsageIf( $condition)
Die with the 'badcontinue' error.
Definition ApiBase.php:1617
const PARAM_TYPE
Definition ApiBase.php:78
const PARAM_DFLT
Definition ApiBase.php:70
getPermissionManager()
Obtain a PermissionManager instance that subclasses may use in their authorization checks.
Definition ApiBase.php:692
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:90
const LIMIT_BIG1
Fast query, standard limit.
Definition ApiBase.php:220
getResult()
Get the result object.
Definition ApiBase.php:620
extractRequestParams( $options=[])
Using getAllowedParams(), this function makes an array of the values provided by the user,...
Definition ApiBase.php:772
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:499
const PARAM_ISMULTI
Definition ApiBase.php:74
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) Stable to override.
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.
__construct(ApiQuery $query, $moduleName)
getExamplesMessages()
Returns usage examples for this module.
execute()
Evaluates the parameters, performs the requested query, and sets up the result.
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 Stable to override.
getUser()
Stable to override.
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:1209
Page revision base class.
const NS_FILE
Definition Defines.php:76
if(PHP_SAPI !='cli-server') if(!isset( $_SERVER['SCRIPT_FILENAME'])) $file
Item class for a filearchive table row.
Definition router.php:42