MediaWiki  1.30.1
LogPager.php
Go to the documentation of this file.
1 <?php
31  private $types = [];
32 
34  private $performer = '';
35 
37  private $title = '';
38 
40  private $pattern = '';
41 
43  private $typeCGI = '';
44 
46  private $action = '';
47 
50 
64  public function __construct( $list, $types = [], $performer = '', $title = '',
65  $pattern = '', $conds = [], $year = false, $month = false, $tagFilter = '',
66  $action = '', $logId = false
67  ) {
68  parent::__construct( $list->getContext() );
69  $this->mConds = $conds;
70 
71  $this->mLogEventsList = $list;
72 
73  $this->limitType( $types ); // also excludes hidden types
74  $this->limitPerformer( $performer );
75  $this->limitTitle( $title, $pattern );
76  $this->limitAction( $action );
77  $this->getDateCond( $year, $month );
78  $this->mTagFilter = $tagFilter;
79  $this->limitLogId( $logId );
80 
81  $this->mDb = wfGetDB( DB_REPLICA, 'logpager' );
82  }
83 
84  public function getDefaultQuery() {
85  $query = parent::getDefaultQuery();
86  $query['type'] = $this->typeCGI; // arrays won't work here
87  $query['user'] = $this->performer;
88  $query['month'] = $this->mMonth;
89  $query['year'] = $this->mYear;
90 
91  return $query;
92  }
93 
94  // Call ONLY after calling $this->limitType() already!
95  public function getFilterParams() {
97  $filters = [];
98  if ( count( $this->types ) ) {
99  return $filters;
100  }
101  foreach ( $wgFilterLogTypes as $type => $default ) {
102  // Avoid silly filtering
103  if ( $type !== 'patrol' || $this->getUser()->useNPPatrol() ) {
104  $hide = $this->getRequest()->getInt( "hide_{$type}_log", $default );
105  $filters[$type] = $hide;
106  if ( $hide ) {
107  $this->mConds[] = 'log_type != ' . $this->mDb->addQuotes( $type );
108  }
109  }
110  }
111 
112  return $filters;
113  }
114 
122  private function limitType( $types ) {
124 
125  $user = $this->getUser();
126  // If $types is not an array, make it an array
127  $types = ( $types === '' ) ? [] : (array)$types;
128  // Don't even show header for private logs; don't recognize it...
129  $needReindex = false;
130  foreach ( $types as $type ) {
131  if ( isset( $wgLogRestrictions[$type] )
132  && !$user->isAllowed( $wgLogRestrictions[$type] )
133  ) {
134  $needReindex = true;
135  $types = array_diff( $types, [ $type ] );
136  }
137  }
138  if ( $needReindex ) {
139  // Lots of this code makes assumptions that
140  // the first entry in the array is $types[0].
141  $types = array_values( $types );
142  }
143  $this->types = $types;
144  // Don't show private logs to unprivileged users.
145  // Also, only show them upon specific request to avoid suprises.
146  $audience = $types ? 'user' : 'public';
147  $hideLogs = LogEventsList::getExcludeClause( $this->mDb, $audience, $user );
148  if ( $hideLogs !== false ) {
149  $this->mConds[] = $hideLogs;
150  }
151  if ( count( $types ) ) {
152  $this->mConds['log_type'] = $types;
153  // Set typeCGI; used in url param for paging
154  if ( count( $types ) == 1 ) {
155  $this->typeCGI = $types[0];
156  }
157  }
158  }
159 
166  private function limitPerformer( $name ) {
167  if ( $name == '' ) {
168  return;
169  }
170  $usertitle = Title::makeTitleSafe( NS_USER, $name );
171  if ( is_null( $usertitle ) ) {
172  return;
173  }
174  // Normalize username first so that non-existent users used
175  // in maintenance scripts work
176  $name = $usertitle->getText();
177  /* Fetch userid at first, if known, provides awesome query plan afterwards */
178  $userid = User::idFromName( $name );
179  if ( !$userid ) {
180  $this->mConds['log_user_text'] = IP::sanitizeIP( $name );
181  } else {
182  $this->mConds['log_user'] = $userid;
183  }
184  // Paranoia: avoid brute force searches (T19342)
185  $user = $this->getUser();
186  if ( !$user->isAllowed( 'deletedhistory' ) ) {
187  $this->mConds[] = $this->mDb->bitAnd( 'log_deleted', LogPage::DELETED_USER ) . ' = 0';
188  } elseif ( !$user->isAllowedAny( 'suppressrevision', 'viewsuppressed' ) ) {
189  $this->mConds[] = $this->mDb->bitAnd( 'log_deleted', LogPage::SUPPRESSED_USER ) .
190  ' != ' . LogPage::SUPPRESSED_USER;
191  }
192 
193  $this->performer = $name;
194  }
195 
204  private function limitTitle( $page, $pattern ) {
206 
207  if ( $page instanceof Title ) {
208  $title = $page;
209  } else {
210  $title = Title::newFromText( $page );
211  if ( strlen( $page ) == 0 || !$title instanceof Title ) {
212  return;
213  }
214  }
215 
216  $this->title = $title->getPrefixedText();
217  $ns = $title->getNamespace();
218  $db = $this->mDb;
219 
220  $doUserRightsLogLike = false;
221  if ( $this->types == [ 'rights' ] ) {
222  $parts = explode( $wgUserrightsInterwikiDelimiter, $title->getDBkey() );
223  if ( count( $parts ) == 2 ) {
224  list( $name, $database ) = array_map( 'trim', $parts );
225  if ( strstr( $database, '*' ) ) { // Search for wildcard in database name
226  $doUserRightsLogLike = true;
227  }
228  }
229  }
230 
244  $this->mConds['log_namespace'] = $ns;
245  if ( $doUserRightsLogLike ) {
247  foreach ( explode( '*', $database ) as $databasepart ) {
248  $params[] = $databasepart;
249  $params[] = $db->anyString();
250  }
251  array_pop( $params ); // Get rid of the last % we added.
252  $this->mConds[] = 'log_title' . $db->buildLike( $params );
253  } elseif ( $pattern && !$wgMiserMode ) {
254  $this->mConds[] = 'log_title' . $db->buildLike( $title->getDBkey(), $db->anyString() );
255  $this->pattern = $pattern;
256  } else {
257  $this->mConds['log_title'] = $title->getDBkey();
258  }
259  // Paranoia: avoid brute force searches (T19342)
260  $user = $this->getUser();
261  if ( !$user->isAllowed( 'deletedhistory' ) ) {
262  $this->mConds[] = $db->bitAnd( 'log_deleted', LogPage::DELETED_ACTION ) . ' = 0';
263  } elseif ( !$user->isAllowedAny( 'suppressrevision', 'viewsuppressed' ) ) {
264  $this->mConds[] = $db->bitAnd( 'log_deleted', LogPage::SUPPRESSED_ACTION ) .
266  }
267  }
268 
274  private function limitAction( $action ) {
276  // Allow to filter the log by actions
278  if ( $type === '' ) {
279  // nothing to do
280  return;
281  }
282  $actions = $wgActionFilteredLogs;
283  if ( isset( $actions[$type] ) ) {
284  // log type can be filtered by actions
285  $this->mLogEventsList->setAllowedActions( array_keys( $actions[$type] ) );
286  if ( $action !== '' && isset( $actions[$type][$action] ) ) {
287  // add condition to query
288  $this->mConds['log_action'] = $actions[$type][$action];
289  $this->action = $action;
290  }
291  }
292  }
293 
298  protected function limitLogId( $logId ) {
299  if ( !$logId ) {
300  return;
301  }
302  $this->mConds['log_id'] = $logId;
303  }
304 
310  public function getQueryInfo() {
312 
313  $tables = $basic['tables'];
314  $fields = $basic['fields'];
315  $conds = $basic['conds'];
316  $options = $basic['options'];
317  $joins = $basic['join_conds'];
318 
319  # Add log_search table if there are conditions on it.
320  # This filters the results to only include log rows that have
321  # log_search records with the specified ls_field and ls_value values.
322  if ( array_key_exists( 'ls_field', $this->mConds ) ) {
323  $tables[] = 'log_search';
324  $options['IGNORE INDEX'] = [ 'log_search' => 'ls_log_id' ];
325  $options['USE INDEX'] = [ 'logging' => 'PRIMARY' ];
326  if ( !$this->hasEqualsClause( 'ls_field' )
327  || !$this->hasEqualsClause( 'ls_value' )
328  ) {
329  # Since (ls_field,ls_value,ls_logid) is unique, if the condition is
330  # to match a specific (ls_field,ls_value) tuple, then there will be
331  # no duplicate log rows. Otherwise, we need to remove the duplicates.
332  $options[] = 'DISTINCT';
333  }
334  }
335  # Don't show duplicate rows when using log_search
336  $joins['log_search'] = [ 'INNER JOIN', 'ls_log_id=log_id' ];
337 
338  $info = [
339  'tables' => $tables,
340  'fields' => $fields,
341  'conds' => array_merge( $conds, $this->mConds ),
342  'options' => $options,
343  'join_conds' => $joins,
344  ];
345  # Add ChangeTags filter query
346  ChangeTags::modifyDisplayQuery( $info['tables'], $info['fields'], $info['conds'],
347  $info['join_conds'], $info['options'], $this->mTagFilter );
348 
349  return $info;
350  }
351 
357  protected function hasEqualsClause( $field ) {
358  return (
359  array_key_exists( $field, $this->mConds ) &&
360  ( !is_array( $this->mConds[$field] ) || count( $this->mConds[$field] ) == 1 )
361  );
362  }
363 
364  function getIndexField() {
365  return 'log_timestamp';
366  }
367 
368  public function getStartBody() {
369  # Do a link batch query
370  if ( $this->getNumRows() > 0 ) {
371  $lb = new LinkBatch;
372  foreach ( $this->mResult as $row ) {
373  $lb->add( $row->log_namespace, $row->log_title );
374  $lb->addObj( Title::makeTitleSafe( NS_USER, $row->user_name ) );
375  $lb->addObj( Title::makeTitleSafe( NS_USER_TALK, $row->user_name ) );
376  $formatter = LogFormatter::newFromRow( $row );
377  foreach ( $formatter->getPreloadTitles() as $title ) {
378  $lb->addObj( $title );
379  }
380  }
381  $lb->execute();
382  $this->mResult->seek( 0 );
383  }
384 
385  return '';
386  }
387 
388  public function formatRow( $row ) {
389  return $this->mLogEventsList->logLine( $row );
390  }
391 
392  public function getType() {
393  return $this->types;
394  }
395 
401  public function getPerformer() {
402  return $this->performer;
403  }
404 
408  public function getPage() {
409  return $this->title;
410  }
411 
412  public function getPattern() {
413  return $this->pattern;
414  }
415 
416  public function getYear() {
417  return $this->mYear;
418  }
419 
420  public function getMonth() {
421  return $this->mMonth;
422  }
423 
424  public function getTagFilter() {
425  return $this->mTagFilter;
426  }
427 
428  public function getAction() {
429  return $this->action;
430  }
431 
432  public function doQuery() {
433  // Workaround MySQL optimizer bug
434  $this->mDb->setBigSelects();
435  parent::doQuery();
436  $this->mDb->setBigSelects( 'default' );
437  }
438 }
$wgActionFilteredLogs
$wgActionFilteredLogs
List of log types that can be filtered by action types.
Definition: DefaultSettings.php:7728
ReverseChronologicalPager\getDateCond
getDateCond( $year, $month, $day=-1)
Set and return the mOffset timestamp such that we can get all revisions with a timestamp up to the sp...
Definition: ReverseChronologicalPager.php:73
$user
please add to it if you re going to add events to the MediaWiki code where normally authentication against an external auth plugin would be creating a account $user
Definition: hooks.txt:244
LogPage\SUPPRESSED_ACTION
const SUPPRESSED_ACTION
Definition: LogPage.php:39
Title\newFromText
static newFromText( $text, $defaultNamespace=NS_MAIN)
Create a new Title from text, such as what one would find in a link.
Definition: Title.php:268
LogPage\SUPPRESSED_USER
const SUPPRESSED_USER
Definition: LogPage.php:38
LogPager\getPattern
getPattern()
Definition: LogPager.php:412
$tables
this hook is for auditing only RecentChangesLinked and Watchlist RecentChangesLinked and Watchlist Do not use this to implement individual filters if they are compatible with the ChangesListFilter and ChangesListFilterGroup structure use sub classes of those in conjunction with the ChangesListSpecialPageStructuredFilters hook This hook can be used to implement filters that do not implement that or custom behavior that is not an individual filter e g Watchlist & $tables
Definition: hooks.txt:988
LogPager\getType
getType()
Definition: LogPager.php:392
LinkBatch
Class representing a list of titles The execute() method checks them all for existence and adds them ...
Definition: LinkBatch.php:34
LinkBatch\add
add( $ns, $dbkey)
Definition: LinkBatch.php:80
LogPager\getPerformer
getPerformer()
Guaranteed to either return a valid title string or a Zero-Length String.
Definition: LogPager.php:401
LogPager\limitTitle
limitTitle( $page, $pattern)
Set the log reader to return only entries affecting the given page.
Definition: LogPager.php:204
LogPager\getMonth
getMonth()
Definition: LogPager.php:420
LogPager\getFilterParams
getFilterParams()
Definition: LogPager.php:95
captcha-old.count
count
Definition: captcha-old.py:249
LogPager\$types
array $types
Log types.
Definition: LogPager.php:31
DatabaseLogEntry\getSelectQueryData
static getSelectQueryData()
Returns array of information that is needed for querying log entries.
Definition: LogEntry.php:172
LogPager\getQueryInfo
getQueryInfo()
Constructs the most part of the query.
Definition: LogPager.php:310
Title\getPrefixedText
getPrefixedText()
Get the prefixed title with spaces.
Definition: Title.php:1550
LogPager
Definition: LogPager.php:29
$params
$params
Definition: styleTest.css.php:40
$name
Allows to change the fields on the form that will be generated $name
Definition: hooks.txt:302
ContextSource\getRequest
getRequest()
Get the WebRequest object.
Definition: ContextSource.php:78
ContextSource\getUser
getUser()
Get the User object.
Definition: ContextSource.php:133
php
injection txt This is an overview of how MediaWiki makes use of dependency injection The design described here grew from the discussion of RFC T384 The term dependency this means that anything an object needs to operate should be injected from the the object itself should only know narrow no concrete implementation of the logic it relies on The requirement to inject everything typically results in an architecture that based on two main types of and essentially stateless service objects that use other service objects to operate on the value objects As of the beginning MediaWiki is only starting to use the DI approach Much of the code still relies on global state or direct resulting in a highly cyclical dependency which acts as the top level factory for services in MediaWiki which can be used to gain access to default instances of various services MediaWikiServices however also allows new services to be defined and default services to be redefined Services are defined or redefined by providing a callback the instantiator that will return a new instance of the service When it will create an instance of MediaWikiServices and populate it with the services defined in the files listed by thereby bootstrapping the DI framework Per $wgServiceWiringFiles lists includes ServiceWiring php
Definition: injection.txt:35
IndexPager\$mDb
$mDb
Definition: IndexPager.php:83
title
to move a page</td >< td > &*You are moving the page across *A non empty talk page already exists under the new or *You uncheck the box below In those you will have to move or merge the page manually if desired</td >< td > be sure to &You are responsible for making sure that links continue to point where they are supposed to go Note that the page will &a page at the new title
Definition: All_system_messages.txt:2696
LogPager\getPage
getPage()
Definition: LogPager.php:408
ChangeTags\modifyDisplayQuery
static modifyDisplayQuery(&$tables, &$fields, &$conds, &$join_conds, &$options, $filter_tag='')
Applies all tags-related changes to a query.
Definition: ChangeTags.php:661
LogPager\$title
string Title $title
Events limited to those about Title when set.
Definition: LogPager.php:37
$query
null for the 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:1581
Title\getDBkey
getDBkey()
Get the main part with underscores.
Definition: Title.php:955
LogPager\$action
string $action
Definition: LogPager.php:46
LogPager\formatRow
formatRow( $row)
Abstract formatting function.
Definition: LogPager.php:388
LogFormatter\newFromRow
static newFromRow( $row)
Handy shortcut for constructing a formatter directly from database row.
Definition: LogFormatter.php:76
LogPager\getIndexField
getIndexField()
This function should be overridden to return the name of the index fi- eld.
Definition: LogPager.php:364
Title\getNamespace
getNamespace()
Get the namespace index, i.e.
Definition: Title.php:978
$wgFilterLogTypes
$wgFilterLogTypes
Show/hide links on Special:Log will be shown for these log types.
Definition: DefaultSettings.php:7616
LogPage\DELETED_USER
const DELETED_USER
Definition: LogPage.php:34
wfGetDB
wfGetDB( $db, $groups=[], $wiki=false)
Get a Database object.
Definition: GlobalFunctions.php:2856
$wgUserrightsInterwikiDelimiter
$wgUserrightsInterwikiDelimiter
Character used as a delimiter when testing for interwiki userrights (In Special:UserRights,...
Definition: DefaultSettings.php:4947
global
when a variable name is used in a it is silently declared as a new masking the global
Definition: design.txt:93
DB_REPLICA
const DB_REPLICA
Definition: defines.php:25
LogPager\__construct
__construct( $list, $types=[], $performer='', $title='', $pattern='', $conds=[], $year=false, $month=false, $tagFilter='', $action='', $logId=false)
Definition: LogPager.php:64
LogEventsList
Definition: LogEventsList.php:30
list
deferred txt A few of the database updates required by various functions here can be deferred until after the result page is displayed to the user For updating the view updating the linked to tables after a etc PHP does not yet have any way to tell the server to actually return and disconnect while still running these but it might have such a feature in the future We handle these by creating a deferred update object and putting those objects on a global list
Definition: deferred.txt:11
LogPage\DELETED_ACTION
const DELETED_ACTION
Definition: LogPage.php:32
captcha-old.action
action
Definition: captcha-old.py:212
LogPager\getStartBody
getStartBody()
Hook into getBody(), allows text to be inserted at the start.
Definition: LogPager.php:368
Title\makeTitleSafe
static makeTitleSafe( $ns, $title, $fragment='', $interwiki='')
Create a new Title from a namespace index and a DB key.
Definition: Title.php:557
NS_USER_TALK
const NS_USER_TALK
Definition: Defines.php:68
$wgLogRestrictions
$wgLogRestrictions
This restricts log access to those who have a certain right Users without this will not see it in the...
Definition: DefaultSettings.php:7593
LogEventsList\getExcludeClause
static getExcludeClause( $db, $audience='public', User $user=null)
SQL clause to skip forbidden log types for this user.
Definition: LogEventsList.php:750
LogPager\$mLogEventsList
LogEventsList $mLogEventsList
Definition: LogPager.php:49
LogPager\$typeCGI
string $typeCGI
Definition: LogPager.php:43
LogPager\doQuery
doQuery()
Do the query, using information from the object context.
Definition: LogPager.php:432
LogPager\getAction
getAction()
Definition: LogPager.php:428
ReverseChronologicalPager\$mYear
$mYear
Definition: ReverseChronologicalPager.php:30
LogPager\getTagFilter
getTagFilter()
Definition: LogPager.php:424
LogPager\$performer
string $performer
Events limited to those by performer when set.
Definition: LogPager.php:34
LogPager\limitType
limitType( $types)
Set the log reader to return only entries of the given type.
Definition: LogPager.php:122
IP\sanitizeIP
static sanitizeIP( $ip)
Convert an IP into a verbose, uppercase, normalized form.
Definition: IP.php:152
LogPager\limitPerformer
limitPerformer( $name)
Set the log reader to return only entries by the given user.
Definition: LogPager.php:166
Title
Represents a title within MediaWiki.
Definition: Title.php:39
LogPager\hasEqualsClause
hasEqualsClause( $field)
Checks if $this->mConds has $field matched to a single value.
Definition: LogPager.php:357
$wgMiserMode
$wgMiserMode
Disable database-intensive features.
Definition: DefaultSettings.php:2166
LogPager\$pattern
string $pattern
Definition: LogPager.php:40
$options
null means default in associative array with keys and values unescaped Should be merged with default with a value of false meaning to suppress the attribute in associative array with keys and values unescaped & $options
Definition: hooks.txt:1965
LogPager\getDefaultQuery
getDefaultQuery()
Get an array of query parameters that should be put into self-links.
Definition: LogPager.php:84
User\idFromName
static idFromName( $name, $flags=self::READ_NORMAL)
Get database id given a user name.
Definition: User.php:765
as
This document is intended to provide useful advice for parties seeking to redistribute MediaWiki to end users It s targeted particularly at maintainers for Linux since it s been observed that distribution packages of MediaWiki often break We ve consistently had to recommend that users seeking support use official tarballs instead of their distribution s and this often solves whatever problem the user is having It would be nice if this could such as
Definition: distributors.txt:9
ReverseChronologicalPager\$mMonth
$mMonth
Definition: ReverseChronologicalPager.php:31
NS_USER
const NS_USER
Definition: Defines.php:67
ReverseChronologicalPager
Efficient paging for SQL queries.
Definition: ReverseChronologicalPager.php:28
LogPager\limitAction
limitAction( $action)
Set the log_action field to a specified value (or values)
Definition: LogPager.php:274
IndexPager\getNumRows
getNumRows()
Get the number of rows in the result set.
Definition: IndexPager.php:555
array
the array() calling protocol came about after MediaWiki 1.4rc1.
LogPager\limitLogId
limitLogId( $logId)
Limit to the (single) specified log ID.
Definition: LogPager.php:298
LogPager\getYear
getYear()
Definition: LogPager.php:416
$type
$type
Definition: testCompression.php:48