MediaWiki REL1_31
ApiQueryFilearchive.php
Go to the documentation of this file.
1<?php
33
34 public function __construct( ApiQuery $query, $moduleName ) {
35 parent::__construct( $query, $moduleName, 'fa' );
36 }
37
38 public function execute() {
39 // Before doing anything at all, let's check permissions
40 $this->checkUserRightsAny( 'deletedhistory' );
41
42 $user = $this->getUser();
43 $db = $this->getDB();
44 $commentStore = CommentStore::getStore();
45
47
48 $prop = array_flip( $params['prop'] );
49 $fld_sha1 = isset( $prop['sha1'] );
50 $fld_timestamp = isset( $prop['timestamp'] );
51 $fld_user = isset( $prop['user'] );
52 $fld_size = isset( $prop['size'] );
53 $fld_dimensions = isset( $prop['dimensions'] );
54 $fld_description = isset( $prop['description'] ) || isset( $prop['parseddescription'] );
55 $fld_mime = isset( $prop['mime'] );
56 $fld_mediatype = isset( $prop['mediatype'] );
57 $fld_metadata = isset( $prop['metadata'] );
58 $fld_bitdepth = isset( $prop['bitdepth'] );
59 $fld_archivename = isset( $prop['archivename'] );
60
61 $fileQuery = ArchivedFile::getQueryInfo();
62 $this->addTables( $fileQuery['tables'] );
63 $this->addFields( $fileQuery['fields'] );
64 $this->addJoinConds( $fileQuery['joins'] );
65
66 if ( !is_null( $params['continue'] ) ) {
67 $cont = explode( '|', $params['continue'] );
68 $this->dieContinueUsageIf( count( $cont ) != 3 );
69 $op = $params['dir'] == 'descending' ? '<' : '>';
70 $cont_from = $db->addQuotes( $cont[0] );
71 $cont_timestamp = $db->addQuotes( $db->timestamp( $cont[1] ) );
72 $cont_id = (int)$cont[2];
73 $this->dieContinueUsageIf( $cont[2] !== (string)$cont_id );
74 $this->addWhere( "fa_name $op $cont_from OR " .
75 "(fa_name = $cont_from AND " .
76 "(fa_timestamp $op $cont_timestamp OR " .
77 "(fa_timestamp = $cont_timestamp AND " .
78 "fa_id $op= $cont_id )))"
79 );
80 }
81
82 // Image filters
83 $dir = ( $params['dir'] == 'descending' ? 'older' : 'newer' );
84 $from = ( $params['from'] === null ? null : $this->titlePartToKey( $params['from'], NS_FILE ) );
85 $to = ( $params['to'] === null ? null : $this->titlePartToKey( $params['to'], NS_FILE ) );
86 $this->addWhereRange( 'fa_name', $dir, $from, $to );
87 if ( isset( $params['prefix'] ) ) {
88 $this->addWhere( 'fa_name' . $db->buildLike(
89 $this->titlePartToKey( $params['prefix'], NS_FILE ),
90 $db->anyString() ) );
91 }
92
93 $sha1Set = isset( $params['sha1'] );
94 $sha1base36Set = isset( $params['sha1base36'] );
95 if ( $sha1Set || $sha1base36Set ) {
96 $sha1 = false;
97 if ( $sha1Set ) {
98 $sha1 = strtolower( $params['sha1'] );
99 if ( !$this->validateSha1Hash( $sha1 ) ) {
100 $this->dieWithError( 'apierror-invalidsha1hash' );
101 }
102 $sha1 = Wikimedia\base_convert( $sha1, 16, 36, 31 );
103 } elseif ( $sha1base36Set ) {
104 $sha1 = strtolower( $params['sha1base36'] );
105 if ( !$this->validateSha1Base36Hash( $sha1 ) ) {
106 $this->dieWithError( 'apierror-invalidsha1base36hash' );
107 }
108 }
109 if ( $sha1 ) {
110 $this->addWhereFld( 'fa_sha1', $sha1 );
111 }
112 }
113
114 // Exclude files this user can't view.
115 if ( !$user->isAllowed( 'deletedtext' ) ) {
116 $bitmask = File::DELETED_FILE;
117 } elseif ( !$user->isAllowedAny( 'suppressrevision', 'viewsuppressed' ) ) {
119 } else {
120 $bitmask = 0;
121 }
122 if ( $bitmask ) {
123 $this->addWhere( $this->getDB()->bitAnd( 'fa_deleted', $bitmask ) . " != $bitmask" );
124 }
125
126 $limit = $params['limit'];
127 $this->addOption( 'LIMIT', $limit + 1 );
128 $sort = ( $params['dir'] == 'descending' ? ' DESC' : '' );
129 $this->addOption( 'ORDER BY', [
130 'fa_name' . $sort,
131 'fa_timestamp' . $sort,
132 'fa_id' . $sort,
133 ] );
134
135 $res = $this->select( __METHOD__ );
136
137 $count = 0;
138 $result = $this->getResult();
139 foreach ( $res as $row ) {
140 if ( ++$count > $limit ) {
141 // We've reached the one extra which shows that there are
142 // additional pages to be had. Stop here...
144 'continue', "$row->fa_name|$row->fa_timestamp|$row->fa_id"
145 );
146 break;
147 }
148
149 $file = [];
150 $file['id'] = (int)$row->fa_id;
151 $file['name'] = $row->fa_name;
152 $title = Title::makeTitle( NS_FILE, $row->fa_name );
153 self::addTitleInfo( $file, $title );
154
155 if ( $fld_description &&
156 Revision::userCanBitfield( $row->fa_deleted, File::DELETED_COMMENT, $user )
157 ) {
158 $file['description'] = $commentStore->getComment( 'fa_description', $row )->text;
159 if ( isset( $prop['parseddescription'] ) ) {
160 $file['parseddescription'] = Linker::formatComment(
161 $file['description'], $title );
162 }
163 }
164 if ( $fld_user &&
165 Revision::userCanBitfield( $row->fa_deleted, File::DELETED_USER, $user )
166 ) {
167 $file['userid'] = (int)$row->fa_user;
168 $file['user'] = $row->fa_user_text;
169 }
170 if ( $fld_sha1 ) {
171 $file['sha1'] = Wikimedia\base_convert( $row->fa_sha1, 36, 16, 40 );
172 }
173 if ( $fld_timestamp ) {
174 $file['timestamp'] = wfTimestamp( TS_ISO_8601, $row->fa_timestamp );
175 }
176 if ( $fld_size || $fld_dimensions ) {
177 $file['size'] = $row->fa_size;
178
179 $pageCount = ArchivedFile::newFromRow( $row )->pageCount();
180 if ( $pageCount !== false ) {
181 $file['pagecount'] = $pageCount;
182 }
183
184 $file['height'] = $row->fa_height;
185 $file['width'] = $row->fa_width;
186 }
187 if ( $fld_mediatype ) {
188 $file['mediatype'] = $row->fa_media_type;
189 }
190 if ( $fld_metadata ) {
191 $file['metadata'] = $row->fa_metadata
192 ? ApiQueryImageInfo::processMetaData( unserialize( $row->fa_metadata ), $result )
193 : null;
194 }
195 if ( $fld_bitdepth ) {
196 $file['bitdepth'] = $row->fa_bits;
197 }
198 if ( $fld_mime ) {
199 $file['mime'] = "$row->fa_major_mime/$row->fa_minor_mime";
200 }
201 if ( $fld_archivename && !is_null( $row->fa_archive_name ) ) {
202 $file['archivename'] = $row->fa_archive_name;
203 }
204
205 if ( $row->fa_deleted & File::DELETED_FILE ) {
206 $file['filehidden'] = true;
207 }
208 if ( $row->fa_deleted & File::DELETED_COMMENT ) {
209 $file['commenthidden'] = true;
210 }
211 if ( $row->fa_deleted & File::DELETED_USER ) {
212 $file['userhidden'] = true;
213 }
214 if ( $row->fa_deleted & File::DELETED_RESTRICTED ) {
215 // This file is deleted for normal admins
216 $file['suppressed'] = true;
217 }
218
219 $fit = $result->addValue( [ 'query', $this->getModuleName() ], null, $file );
220 if ( !$fit ) {
222 'continue', "$row->fa_name|$row->fa_timestamp|$row->fa_id"
223 );
224 break;
225 }
226 }
227
228 $result->addIndexedTagName( [ 'query', $this->getModuleName() ], 'fa' );
229 }
230
231 public function getAllowedParams() {
232 return [
233 'from' => null,
234 'to' => null,
235 'prefix' => null,
236 'dir' => [
237 ApiBase::PARAM_DFLT => 'ascending',
239 'ascending',
240 'descending'
241 ]
242 ],
243 'sha1' => null,
244 'sha1base36' => null,
245 'prop' => [
246 ApiBase::PARAM_DFLT => 'timestamp',
249 'sha1',
250 'timestamp',
251 'user',
252 'size',
253 'dimensions',
254 'description',
255 'parseddescription',
256 'mime',
257 'mediatype',
258 'metadata',
259 'bitdepth',
260 'archivename',
261 ],
263 ],
264 'limit' => [
266 ApiBase::PARAM_TYPE => 'limit',
270 ],
271 'continue' => [
272 ApiBase::PARAM_HELP_MSG => 'api-help-param-continue',
273 ],
274 ];
275 }
276
277 protected function getExamplesMessages() {
278 return [
279 'action=query&list=filearchive'
280 => 'apihelp-query+filearchive-example-simple',
281 ];
282 }
283
284 public function getHelpUrls() {
285 return 'https://www.mediawiki.org/wiki/Special:MyLanguage/API:Filearchive';
286 }
287}
unserialize( $serialized)
wfTimestamp( $outputtype=TS_UNIX, $ts=0)
Get a timestamp string in one of various formats.
const PARAM_MAX2
(integer) Max value allowed for the parameter for users with the apihighlimits right,...
Definition ApiBase.php:96
checkUserRightsAny( $rights, $user=null)
Helper function for permission-denied errors.
Definition ApiBase.php:2006
const PARAM_MAX
(integer) Max value allowed for the parameter, for PARAM_TYPE 'integer' and 'limit'.
Definition ApiBase.php:90
dieWithError( $msg, $code=null, $data=null, $httpCode=null)
Abort execution with an error.
Definition ApiBase.php:1895
dieContinueUsageIf( $condition)
Die with the 'badcontinue' error.
Definition ApiBase.php:2066
const PARAM_TYPE
(string|string[]) Either an array of allowed value strings, or a string type as described below.
Definition ApiBase.php:87
const PARAM_DFLT
(null|boolean|integer|string) Default value of the parameter.
Definition ApiBase.php:48
extractRequestParams( $parseLimit=true)
Using getAllowedParams(), this function makes an array of the values provided by the user,...
Definition ApiBase.php:749
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:157
const PARAM_MIN
(integer) Lowest value allowed for the parameter, for PARAM_TYPE 'integer' and 'limit'.
Definition ApiBase.php:99
const LIMIT_BIG1
Fast query, standard limit.
Definition ApiBase.php:234
getResult()
Get the result object.
Definition ApiBase.php:641
const PARAM_HELP_MSG
(string|array|Message) Specify an alternative i18n documentation message for this parameter.
Definition ApiBase.php:124
const LIMIT_BIG2
Fast query, apihighlimits limit.
Definition ApiBase.php:236
getModuleName()
Get the name of the module being executed by this instance.
Definition ApiBase.php:521
const PARAM_ISMULTI
(boolean) Accept multiple pipe-separated values for this parameter (e.g.
Definition ApiBase.php:51
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)
addJoinConds( $join_conds)
Add a set of JOIN conditions to the internal array.
addWhereFld( $field, $value)
Equivalent to addWhere(array($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:36
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.
const DELETED_COMMENT
Definition File.php:54
const DELETED_RESTRICTED
Definition File.php:56
const DELETED_FILE
Definition File.php:53
const DELETED_USER
Definition File.php:55
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:1109
We use the convention $dbr for read and $dbw for write to help you keep track of whether the database object is a the world will explode Or to be a subsequent write query which succeeded on the master may fail when replicated to the slave due to a unique key collision Replication on the slave will stop and it may take hours to repair the database and get it back online Setting read_only in my cnf on the slave will avoid this but given the dire we prefer to have as many checks as possible We provide a but the wrapper functions like select() and insert() are usually more convenient. They take care of things like table prefixes and escaping for you. If you really need to make your own SQL
$res
Definition database.txt:21
null for the local wiki Added should default to null in handler for backwards compatibility add a value to it if you want to add a cookie that have to vary cache options can modify $query
Definition hooks.txt:1620
const NS_FILE
Definition Defines.php:80
$sort
$params