(bug 20275) Fixed LIKE queries on SQLite backend
[lhc/web/wiklou.git] / includes / LogEventsList.php
1 <?php
2 # Copyright (C) 2004 Brion Vibber <brion@pobox.com>, 2008 Aaron Schulz
3 # http://www.mediawiki.org/
4 #
5 # This program is free software; you can redistribute it and/or modify
6 # it under the terms of the GNU General Public License as published by
7 # the Free Software Foundation; either version 2 of the License, or
8 # (at your option) any later version.
9 #
10 # This program is distributed in the hope that it will be useful,
11 # but WITHOUT ANY WARRANTY; without even the implied warranty of
12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 # GNU General Public License for more details.
14 #
15 # You should have received a copy of the GNU General Public License along
16 # with this program; if not, write to the Free Software Foundation, Inc.,
17 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 # http://www.gnu.org/copyleft/gpl.html
19
20 class LogEventsList {
21 const NO_ACTION_LINK = 1;
22
23 private $skin;
24 private $out;
25 public $flags;
26
27 public function __construct( $skin, $out, $flags = 0 ) {
28 $this->skin = $skin;
29 $this->out = $out;
30 $this->flags = $flags;
31 $this->preCacheMessages();
32 }
33
34 /**
35 * As we use the same small set of messages in various methods and that
36 * they are called often, we call them once and save them in $this->message
37 */
38 private function preCacheMessages() {
39 // Precache various messages
40 if( !isset( $this->message ) ) {
41 $messages = array( 'revertmerge', 'protect_change', 'unblocklink', 'change-blocklink',
42 'revertmove', 'undeletelink', 'undeleteviewlink', 'revdel-restore', 'rev-delundel', 'hist', 'diff',
43 'pipe-separator' );
44 foreach( $messages as $msg ) {
45 $this->message[$msg] = wfMsgExt( $msg, array( 'escapenoentities' ) );
46 }
47 }
48 }
49
50 /**
51 * Set page title and show header for this log type
52 * @param $type Array
53 */
54 public function showHeader( $type ) {
55 // If only one log type is used, then show a special message...
56 $headerType = (count($type) == 1) ? $type[0] : '';
57 if( LogPage::isLogType( $headerType ) ) {
58 $this->out->setPageTitle( LogPage::logName( $headerType ) );
59 $this->out->addHTML( LogPage::logHeader( $headerType ) );
60 } else {
61 $this->out->addHTML( wfMsgExt('alllogstext',array('parseinline')) );
62 }
63 }
64
65 /**
66 * Show options for the log list
67 * @param $types string or Array
68 * @param $user String
69 * @param $page String
70 * @param $pattern String
71 * @param $year Integer: year
72 * @param $month Integer: month
73 * @param $filter: array
74 * @param $tagFilter: array?
75 */
76 public function showOptions( $types=array(), $user='', $page='', $pattern='', $year='',
77 $month = '', $filter = null, $tagFilter='' )
78 {
79 global $wgScript, $wgMiserMode;
80
81 $action = $wgScript;
82 $title = SpecialPage::getTitleFor( 'Log' );
83 $special = $title->getPrefixedDBkey();
84
85 // For B/C, we take strings, but make sure they are converted...
86 $types = ($types === '') ? array() : (array)$types;
87
88 $tagSelector = ChangeTags::buildTagFilterSelector( $tagFilter );
89
90 $html = '';
91 $html .= Xml::hidden( 'title', $special );
92
93 // Basic selectors
94 $html .= $this->getTypeMenu( $types ) . "\n";
95 $html .= $this->getUserInput( $user ) . "\n";
96 $html .= $this->getTitleInput( $page ) . "\n";
97 $html .= $this->getExtraInputs( $types ) . "\n";
98
99 // Title pattern, if allowed
100 if (!$wgMiserMode) {
101 $html .= $this->getTitlePattern( $pattern ) . "\n";
102 }
103
104 // date menu
105 $html .= Xml::tags( 'p', null, Xml::dateMenu( $year, $month ) );
106
107 // Tag filter
108 if ($tagSelector) {
109 $html .= Xml::tags( 'p', null, implode( '&nbsp;', $tagSelector ) );
110 }
111
112 // Filter links
113 if ($filter) {
114 $html .= Xml::tags( 'p', null, $this->getFilterLinks( $filter ) );
115 }
116
117 // Submit button
118 $html .= Xml::submitButton( wfMsg( 'allpagessubmit' ) );
119
120 // Fieldset
121 $html = Xml::fieldset( wfMsg( 'log' ), $html );
122
123 // Form wrapping
124 $html = Xml::tags( 'form', array( 'action' => $action, 'method' => 'get' ), $html );
125
126 $this->out->addHTML( $html );
127 }
128
129 /**
130 * @param $filter Array
131 * @return String: Formatted HTML
132 */
133 private function getFilterLinks( $filter ) {
134 global $wgTitle, $wgLang;
135 // show/hide links
136 $messages = array( wfMsgHtml( 'show' ), wfMsgHtml( 'hide' ) );
137 // Option value -> message mapping
138 $links = array();
139 $hiddens = ''; // keep track for "go" button
140 foreach( $filter as $type => $val ) {
141 // Should the below assignment be outside the foreach?
142 // Then it would have to be copied. Not certain what is more expensive.
143 $query = $this->getDefaultQuery();
144 $queryKey = "hide_{$type}_log";
145
146 $hideVal = 1 - intval($val);
147 $query[$queryKey] = $hideVal;
148
149 $link = $this->skin->link(
150 $wgTitle,
151 $messages[$hideVal],
152 array(),
153 $query,
154 array( 'known', 'noclasses' )
155 );
156
157 $links[$type] = wfMsgHtml( "log-show-hide-{$type}", $link );
158 $hiddens .= Xml::hidden( "hide_{$type}_log", $val ) . "\n";
159 }
160 // Build links
161 return '<small>'.$wgLang->pipeList( $links ) . '</small>' . $hiddens;
162 }
163
164 private function getDefaultQuery() {
165 if ( !isset( $this->mDefaultQuery ) ) {
166 $this->mDefaultQuery = $_GET;
167 unset( $this->mDefaultQuery['title'] );
168 unset( $this->mDefaultQuery['dir'] );
169 unset( $this->mDefaultQuery['offset'] );
170 unset( $this->mDefaultQuery['limit'] );
171 unset( $this->mDefaultQuery['order'] );
172 unset( $this->mDefaultQuery['month'] );
173 unset( $this->mDefaultQuery['year'] );
174 }
175 return $this->mDefaultQuery;
176 }
177
178 /**
179 * @param $queryTypes Array
180 * @return String: Formatted HTML
181 */
182 private function getTypeMenu( $queryTypes ) {
183 global $wgLogRestrictions, $wgUser;
184
185 $html = "<select name='type'>\n";
186
187 $validTypes = LogPage::validTypes();
188 $typesByName = array(); // Temporary array
189
190 // First pass to load the log names
191 foreach( $validTypes as $type ) {
192 $text = LogPage::logName( $type );
193 $typesByName[$text] = $type;
194 }
195
196 // Second pass to sort by name
197 ksort($typesByName);
198
199 // Note the query type
200 $queryType = count($queryTypes) == 1 ? $queryTypes[0] : '';
201 // Third pass generates sorted XHTML content
202 foreach( $typesByName as $text => $type ) {
203 $selected = ($type == $queryType);
204 // Restricted types
205 if ( isset($wgLogRestrictions[$type]) ) {
206 if ( $wgUser->isAllowed( $wgLogRestrictions[$type] ) ) {
207 $html .= Xml::option( $text, $type, $selected ) . "\n";
208 }
209 } else {
210 $html .= Xml::option( $text, $type, $selected ) . "\n";
211 }
212 }
213
214 $html .= '</select>';
215 return $html;
216 }
217
218 /**
219 * @param $user String
220 * @return String: Formatted HTML
221 */
222 private function getUserInput( $user ) {
223 return '<span style="white-space: nowrap">' .
224 Xml::inputLabel( wfMsg( 'specialloguserlabel' ), 'user', 'mw-log-user', 15, $user ) .
225 '</span>';
226 }
227
228 /**
229 * @param $title String
230 * @return String: Formatted HTML
231 */
232 private function getTitleInput( $title ) {
233 return '<span style="white-space: nowrap">' .
234 Xml::inputLabel( wfMsg( 'speciallogtitlelabel' ), 'page', 'mw-log-page', 20, $title ) .
235 '</span>';
236 }
237
238 /**
239 * @return boolean Checkbox
240 */
241 private function getTitlePattern( $pattern ) {
242 return '<span style="white-space: nowrap">' .
243 Xml::checkLabel( wfMsg( 'log-title-wildcard' ), 'pattern', 'pattern', $pattern ) .
244 '</span>';
245 }
246
247 private function getExtraInputs( $types ) {
248 global $wgRequest;
249 $offender = $wgRequest->getVal('offender');
250 $user = User::newFromName( $offender, false );
251 if( !$user || ($user->getId() == 0 && !IP::isIPAddress($offender) ) ) {
252 $offender = ''; // Blank field if invalid
253 }
254 if( count($types) == 1 && $types[0] == 'suppress' ) {
255 return Xml::inputLabel( wfMsg('revdelete-offender'), 'offender',
256 'mw-log-offender', 20, $offender );
257 }
258 return '';
259 }
260
261 public function beginLogEventsList() {
262 return "<ul>\n";
263 }
264
265 public function endLogEventsList() {
266 return "</ul>\n";
267 }
268
269 /**
270 * @param $row Row: a single row from the result set
271 * @return String: Formatted HTML list item
272 */
273 public function logLine( $row ) {
274 global $wgLang, $wgUser, $wgContLang;
275
276 $title = Title::makeTitle( $row->log_namespace, $row->log_title );
277 $classes = array( "mw-logline-{$row->log_type}" );
278 $time = $wgLang->timeanddate( wfTimestamp( TS_MW, $row->log_timestamp ), true );
279 // User links
280 if( self::isDeleted( $row, LogPage::DELETED_USER ) ) {
281 $userLink = '<span class="history-deleted">' . wfMsgHtml( 'rev-deleted-user' ) . '</span>';
282 } else {
283 $userLink = $this->skin->userLink( $row->log_user, $row->user_name ) .
284 $this->skin->userToolLinks( $row->log_user, $row->user_name, true, 0, $row->user_editcount );
285 }
286 // Comment
287 if( self::isDeleted( $row, LogPage::DELETED_COMMENT ) ) {
288 $comment = '<span class="history-deleted">' . wfMsgHtml( 'rev-deleted-comment' ) . '</span>';
289 } else {
290 $comment = $wgContLang->getDirMark() . $this->skin->commentBlock( $row->log_comment );
291 }
292 // Extract extra parameters
293 $paramArray = LogPage::extractParams( $row->log_params );
294 $revert = $del = '';
295 // Some user can hide log items and have review links
296 if( !( $this->flags & self::NO_ACTION_LINK ) && $wgUser->isAllowed( 'deletedhistory' ) ) {
297 // Don't show useless link to people who cannot hide revisions
298 if( $row->log_deleted || $wgUser->isAllowed( 'deleterevision' ) ) {
299 $del = $this->getShowHideLinks( $row ) . ' ';
300 }
301 }
302 // Add review links and such...
303 if( ( $this->flags & self::NO_ACTION_LINK ) || ( $row->log_deleted & LogPage::DELETED_ACTION ) ) {
304 // Action text is suppressed...
305 } else if( self::typeAction( $row, 'move', 'move', 'move' ) && !empty( $paramArray[0] ) ) {
306 $destTitle = Title::newFromText( $paramArray[0] );
307 if( $destTitle ) {
308 $revert = '(' . $this->skin->link(
309 SpecialPage::getTitleFor( 'Movepage' ),
310 $this->message['revertmove'],
311 array(),
312 array(
313 'wpOldTitle' => $destTitle->getPrefixedDBkey(),
314 'wpNewTitle' => $title->getPrefixedDBkey(),
315 'wpReason' => wfMsgForContent( 'revertmove' ),
316 'wpMovetalk' => 0
317 ),
318 array( 'known', 'noclasses' )
319 ) . ')';
320 }
321 // Show undelete link
322 } else if( self::typeAction( $row, array( 'delete', 'suppress' ), 'delete', 'deletedhistory' ) ) {
323 if( !$wgUser->isAllowed( 'undelete' ) ) {
324 $viewdeleted = $this->message['undeleteviewlink'];
325 } else {
326 $viewdeleted = $this->message['undeletelink'];
327 }
328
329 $revert = '(' . $this->skin->link(
330 SpecialPage::getTitleFor( 'Undelete' ),
331 $viewdeleted,
332 array(),
333 array( 'target' => $title->getPrefixedDBkey() ),
334 array( 'known', 'noclasses' )
335 ) . ')';
336 // Show unblock/change block link
337 } else if( self::typeAction( $row, array( 'block', 'suppress' ), array( 'block', 'reblock' ), 'block' ) ) {
338 $revert = '(' .
339 $this->skin->link(
340 SpecialPage::getTitleFor( 'Ipblocklist' ),
341 $this->message['unblocklink'],
342 array(),
343 array(
344 'action' => 'unblock',
345 'ip' => $row->log_title
346 ),
347 'known'
348 ) .
349 $this->message['pipe-separator'] .
350 $this->skin->link(
351 SpecialPage::getTitleFor( 'Blockip', $row->log_title ),
352 $this->message['change-blocklink'],
353 array(),
354 array(),
355 'known'
356 ) .
357 ')';
358 // Show change protection link
359 } else if( self::typeAction( $row, 'protect', array( 'modify', 'protect', 'unprotect' ) ) ) {
360 $revert .= ' (' .
361 $this->skin->link( $title,
362 $this->message['hist'],
363 array(),
364 array(
365 'action' => 'history',
366 'offset' => $row->log_timestamp
367 )
368 );
369 if( $wgUser->isAllowed( 'protect' ) ) {
370 $revert .= $this->message['pipe-separator'] .
371 $this->skin->link( $title,
372 $this->message['protect_change'],
373 array(),
374 array( 'action' => 'protect' ),
375 'known' );
376 }
377 $revert .= ')';
378 // Show unmerge link
379 } else if( self::typeAction( $row, 'merge', 'merge', 'mergehistory' ) ) {
380 $merge = SpecialPage::getTitleFor( 'Mergehistory' );
381 $revert = '(' . $this->skin->link(
382 $merge,
383 $this->message['revertmerge'],
384 array(),
385 array(
386 'target' => $paramArray[0],
387 'dest' => $title->getPrefixedDBkey(),
388 'mergepoint' => $paramArray[1]
389 ),
390 array( 'known', 'noclasses' )
391 ) . ')';
392 // If an edit was hidden from a page give a review link to the history
393 } else if( self::typeAction( $row, array( 'delete', 'suppress' ), 'revision', 'deletedhistory' ) ) {
394 if( count($paramArray) >= 2 ) {
395 // Different revision types use different URL params...
396 $key = $paramArray[0];
397 // $paramArray[1] is a CSV of the IDs
398 $Ids = explode( ',', $paramArray[1] );
399 $query = $paramArray[1];
400 $revert = array();
401 // Diff link for single rev deletions
402 if( count($Ids) == 1 ) {
403 // Live revision diffs...
404 if( in_array( $key, array( 'oldid', 'revision' ) ) ) {
405 $revert[] = $this->skin->link(
406 $title,
407 $this->message['diff'],
408 array(),
409 array(
410 'diff' => intval( $Ids[0] ),
411 'unhide' => 1
412 ),
413 array( 'known', 'noclasses' )
414 );
415 // Deleted revision diffs...
416 } else if( in_array( $key, array( 'artimestamp','archive' ) ) ) {
417 $revert[] = $this->skin->link(
418 SpecialPage::getTitleFor( 'Undelete' ),
419 $this->message['diff'],
420 array(),
421 array(
422 'target' => $title->getPrefixedDBKey(),
423 'diff' => 'prev',
424 'timestamp' => $Ids[0]
425 ),
426 array( 'known', 'noclasses' )
427 );
428 }
429 }
430 // View/modify link...
431 $revert[] = $this->skin->link(
432 SpecialPage::getTitleFor( 'Revisiondelete' ),
433 $this->message['revdel-restore'],
434 array(),
435 array(
436 'target' => $title->getPrefixedText(),
437 'type' => $key,
438 'ids' => $query
439 ),
440 array( 'known', 'noclasses' )
441 );
442 // Pipe links
443 $revert = wfMsg( 'parentheses', $wgLang->pipeList( $revert ) );
444 }
445 // Hidden log items, give review link
446 } else if( self::typeAction( $row, array( 'delete', 'suppress' ), 'event', 'deletedhistory' ) ) {
447 if( count($paramArray) >= 1 ) {
448 $revdel = SpecialPage::getTitleFor( 'Revisiondelete' );
449 // $paramArray[1] is a CSV of the IDs
450 $Ids = explode( ',', $paramArray[0] );
451 $query = $paramArray[0];
452 // Link to each hidden object ID, $paramArray[1] is the url param
453 $revert = '(' . $this->skin->link(
454 $revdel,
455 $this->message['revdel-restore'],
456 array(),
457 array(
458 'target' => $title->getPrefixedText(),
459 'type' => 'logging',
460 'ids' => $query
461 ),
462 array( 'known', 'noclasses' )
463 ) . ')';
464 }
465 // Self-created users
466 } else if( self::typeAction( $row, 'newusers', 'create2' ) ) {
467 if( isset( $paramArray[0] ) ) {
468 $revert = $this->skin->userToolLinks( $paramArray[0], $title->getDBkey(), true );
469 } else {
470 # Fall back to a blue contributions link
471 $revert = $this->skin->userToolLinks( 1, $title->getDBkey() );
472 }
473 if( $time < '20080129000000' ) {
474 # Suppress $comment from old entries (before 2008-01-29),
475 # not needed and can contain incorrect links
476 $comment = '';
477 }
478 // Do nothing. The implementation is handled by the hook modifiying the passed-by-ref parameters.
479 } else {
480 wfRunHooks( 'LogLine', array( $row->log_type, $row->log_action, $title, $paramArray,
481 &$comment, &$revert, $row->log_timestamp ) );
482 }
483 // Event description
484 if( self::isDeleted( $row, LogPage::DELETED_ACTION ) ) {
485 $action = '<span class="history-deleted">' . wfMsgHtml( 'rev-deleted-event' ) . '</span>';
486 } else {
487 $action = LogPage::actionText( $row->log_type, $row->log_action, $title,
488 $this->skin, $paramArray, true );
489 }
490
491 // Any tags...
492 list( $tagDisplay, $newClasses ) = ChangeTags::formatSummaryRow( $row->ts_tags, 'logevent' );
493 $classes = array_merge( $classes, $newClasses );
494
495 if( $revert != '' ) {
496 $revert = '<span class="mw-logevent-actionlink">' . $revert . '</span>';
497 }
498
499 $time = htmlspecialchars( $time );
500
501 return Xml::tags( 'li', array( "class" => implode( ' ', $classes ) ),
502 $del . $time . ' ' . $userLink . ' ' . $action . ' ' . $comment . ' ' . $revert . " $tagDisplay" ) . "\n";
503 }
504
505 /**
506 * @param $row Row
507 * @return string
508 */
509 private function getShowHideLinks( $row ) {
510 // If event was hidden from sysops
511 if( !self::userCan( $row, LogPage::DELETED_RESTRICTED ) ) {
512 $del = Xml::tags( 'span', array( 'class'=>'mw-revdelundel-link' ),
513 '(' . $this->message['rev-delundel'] . ')' );
514 } else if( $row->log_type == 'suppress' ) {
515 $del = ''; // No one should be hiding from the oversight log
516 } else {
517 $target = SpecialPage::getTitleFor( 'Log', $row->log_type );
518 $page = Title::makeTitle( $row->log_namespace, $row->log_title );
519 $query = array(
520 'target' => $target->getPrefixedDBkey(),
521 'type' => 'logging',
522 'ids' => $row->log_id,
523 );
524 $del = $this->skin->revDeleteLink( $query,
525 self::isDeleted( $row, LogPage::DELETED_RESTRICTED ) );
526 }
527 return $del;
528 }
529
530 /**
531 * @param $row Row
532 * @param $type Mixed: string/array
533 * @param $action Mixed: string/array
534 * @param $right string
535 * @return bool
536 */
537 public static function typeAction( $row, $type, $action, $right='' ) {
538 $match = is_array($type) ?
539 in_array( $row->log_type, $type ) : $row->log_type == $type;
540 if( $match ) {
541 $match = is_array( $action ) ?
542 in_array( $row->log_action, $action ) : $row->log_action == $action;
543 if( $match && $right ) {
544 global $wgUser;
545 $match = $wgUser->isAllowed( $right );
546 }
547 }
548 return $match;
549 }
550
551 /**
552 * Determine if the current user is allowed to view a particular
553 * field of this log row, if it's marked as deleted.
554 * @param $row Row
555 * @param $field Integer
556 * @return Boolean
557 */
558 public static function userCan( $row, $field ) {
559 return self::userCanBitfield( $row->log_deleted, $field );
560 }
561
562 /**
563 * Determine if the current user is allowed to view a particular
564 * field of this log row, if it's marked as deleted.
565 * @param $bitfield Integer (current field)
566 * @param $field Integer
567 * @return Boolean
568 */
569 public static function userCanBitfield( $bitfield, $field ) {
570 if( $bitfield & $field ) {
571 global $wgUser;
572 $permission = '';
573 if ( $bitfield & LogPage::DELETED_RESTRICTED ) {
574 $permission = 'suppressrevision';
575 } else {
576 $permission = 'deletedhistory';
577 }
578 wfDebug( "Checking for $permission due to $field match on $bitfield\n" );
579 return $wgUser->isAllowed( $permission );
580 } else {
581 return true;
582 }
583 }
584
585 /**
586 * @param $row Row
587 * @param $field Integer: one of DELETED_* bitfield constants
588 * @return Boolean
589 */
590 public static function isDeleted( $row, $field ) {
591 return ( $row->log_deleted & $field ) == $field;
592 }
593
594 /**
595 * Show log extract. Either with text and a box (set $msgKey) or without (don't set $msgKey)
596 * @param $out OutputPage or String-by-reference
597 * @param $types String or Array
598 * @param $page String The page title to show log entries for
599 * @param $user String The user who made the log entries
600 * @param $param Associative Array with the following additional options:
601 * - lim Integer Limit of items to show, default is 50
602 * - conds Array Extra conditions for the query (e.g. "log_action != 'revision'")
603 * - showIfEmpty boolean Set to false if you don't want any output in case the loglist is empty
604 * if set to true (default), "No matching items in log" is displayed if loglist is empty
605 * - msgKey Array If you want a nice box with a message, set this to the key of the message.
606 * First element is the message key, additional optional elements are parameters for the key
607 * that are processed with wgMsgExt and option 'parse'
608 * - offset Set to overwrite offset parameter in $wgRequest
609 * set to '' to unset offset
610 * @return Integer Number of total log items (not limited by $lim)
611 */
612 public static function showLogExtract( &$out, $types=array(), $page='', $user='',
613 $param = array() ) {
614
615 $defaultParameters = array(
616 'lim' => 25,
617 'conds' => array(),
618 'showIfEmpty' => true,
619 'msgKey' => array('')
620 );
621
622 # The + operator appends elements of remaining keys from the right
623 # handed array to the left handed, whereas duplicated keys are NOT overwritten.
624 $param += $defaultParameters;
625
626 global $wgUser, $wgOut;
627 # Convert $param array to individual variables
628 $lim = $param['lim'];
629 $conds = $param['conds'];
630 $showIfEmpty = $param['showIfEmpty'];
631 $msgKey = $param['msgKey'];
632 if ( !is_array( $msgKey ) )
633 $msgKey = array( $msgKey );
634 # Insert list of top 50 (or top $lim) items
635 $loglist = new LogEventsList( $wgUser->getSkin(), $wgOut, 0 );
636 $pager = new LogPager( $loglist, $types, $user, $page, '', $conds );
637 if ( isset( $param['offset'] ) ) # Tell pager to ignore $wgRequest offset
638 $pager->setOffset( $param['offset'] );
639 if( $lim > 0 ) $pager->mLimit = $lim;
640 $logBody = $pager->getBody();
641 $s = '';
642 if( $logBody ) {
643 if ( $msgKey[0] ) {
644 $s = '<div class="mw-warning-with-logexcerpt">';
645
646 if ( count( $msgKey ) == 1 ) {
647 $s .= wfMsgExt( $msgKey[0], array( 'parse' ) );
648 } else { // Process additional arguments
649 $args = $msgKey;
650 array_shift( $args );
651 $s .= wfMsgExt( $msgKey[0], array( 'parse' ), $args );
652 }
653 }
654 $s .= $loglist->beginLogEventsList() .
655 $logBody .
656 $loglist->endLogEventsList();
657 } else {
658 if ( $showIfEmpty )
659 $s = wfMsgExt( 'logempty', array('parse') );
660 }
661 if( $pager->getNumRows() > $pager->mLimit ) { # Show "Full log" link
662 $urlParam = array();
663 if ( $page != '')
664 $urlParam['page'] = $page;
665 if ( $user != '')
666 $urlParam['user'] = $user;
667 if ( !is_array( $types ) ) # Make it an array, if it isn't
668 $types = array( $types );
669 # If there is exactly one log type, we can link to Special:Log?type=foo
670 if ( count( $types ) == 1 )
671 $urlParam['type'] = $types[0];
672 $s .= $wgUser->getSkin()->link(
673 SpecialPage::getTitleFor( 'Log' ),
674 wfMsgHtml( 'log-fulllog' ),
675 array(),
676 $urlParam
677 );
678
679 }
680 if ( $logBody && $msgKey[0] )
681 $s .= '</div>';
682
683 if( $out instanceof OutputPage ){
684 $out->addHTML( $s );
685 } else {
686 $out = $s;
687 }
688 return $pager->getNumRows();
689 }
690
691 /**
692 * SQL clause to skip forbidden log types for this user
693 * @param $db Database
694 * @param $audience string, public/user
695 * @return mixed (string or false)
696 */
697 public static function getExcludeClause( $db, $audience = 'public' ) {
698 global $wgLogRestrictions, $wgUser;
699 // Reset the array, clears extra "where" clauses when $par is used
700 $hiddenLogs = array();
701 // Don't show private logs to unprivileged users
702 foreach( $wgLogRestrictions as $logType => $right ) {
703 if( $audience == 'public' || !$wgUser->isAllowed($right) ) {
704 $safeType = $db->strencode( $logType );
705 $hiddenLogs[] = $safeType;
706 }
707 }
708 if( count($hiddenLogs) == 1 ) {
709 return 'log_type != ' . $db->addQuotes( $hiddenLogs[0] );
710 } elseif( $hiddenLogs ) {
711 return 'log_type NOT IN (' . $db->makeList($hiddenLogs) . ')';
712 }
713 return false;
714 }
715 }
716
717 /**
718 * @ingroup Pager
719 */
720 class LogPager extends ReverseChronologicalPager {
721 private $types = array(), $user = '', $title = '', $pattern = '';
722 private $typeCGI = '';
723 public $mLogEventsList;
724
725 /**
726 * constructor
727 * @param $list LogEventsList
728 * @param $types String or Array log types to show
729 * @param $user String The user who made the log entries
730 * @param $title String The page title the log entries are for
731 * @param $pattern String Do a prefix search rather than an exact title match
732 * @param $conds Array Extra conditions for the query
733 * @param $year Integer The year to start from
734 * @param $month Integer The month to start from
735 */
736 public function __construct( $list, $types = array(), $user = '', $title = '', $pattern = '',
737 $conds = array(), $year = false, $month = false, $tagFilter = '' )
738 {
739 parent::__construct();
740 $this->mConds = $conds;
741
742 $this->mLogEventsList = $list;
743
744 $this->limitType( $types ); // also excludes hidden types
745 $this->limitUser( $user );
746 $this->limitTitle( $title, $pattern );
747 $this->getDateCond( $year, $month );
748 $this->mTagFilter = $tagFilter;
749 }
750
751 public function getDefaultQuery() {
752 $query = parent::getDefaultQuery();
753 $query['type'] = $this->typeCGI; // arrays won't work here
754 $query['user'] = $this->user;
755 $query['month'] = $this->mMonth;
756 $query['year'] = $this->mYear;
757 return $query;
758 }
759
760 // Call ONLY after calling $this->limitType() already!
761 public function getFilterParams() {
762 global $wgFilterLogTypes, $wgUser, $wgRequest;
763 $filters = array();
764 if( count($this->types) ) {
765 return $filters;
766 }
767 foreach( $wgFilterLogTypes as $type => $default ) {
768 // Avoid silly filtering
769 if( $type !== 'patrol' || $wgUser->useNPPatrol() ) {
770 $hide = $wgRequest->getInt( "hide_{$type}_log", $default );
771 $filters[$type] = $hide;
772 if( $hide )
773 $this->mConds[] = 'log_type != ' . $this->mDb->addQuotes( $type );
774 }
775 }
776 return $filters;
777 }
778
779 /**
780 * Set the log reader to return only entries of the given type.
781 * Type restrictions enforced here
782 * @param $types String or array: Log types ('upload', 'delete', etc);
783 * empty string means no restriction
784 */
785 private function limitType( $types ) {
786 global $wgLogRestrictions, $wgUser;
787 // If $types is not an array, make it an array
788 $types = ($types === '') ? array() : (array)$types;
789 // Don't even show header for private logs; don't recognize it...
790 foreach ( $types as $type ) {
791 if( isset( $wgLogRestrictions[$type] ) && !$wgUser->isAllowed($wgLogRestrictions[$type]) ) {
792 $types = array_diff( $types, array( $type ) );
793 }
794 }
795 // Don't show private logs to unprivileged users.
796 // Also, only show them upon specific request to avoid suprises.
797 $audience = $types ? 'user' : 'public';
798 $hideLogs = LogEventsList::getExcludeClause( $this->mDb, $audience );
799 if( $hideLogs !== false ) {
800 $this->mConds[] = $hideLogs;
801 }
802 if( count($types) ) {
803 $this->types = $types;
804 $this->mConds['log_type'] = $types;
805 // Set typeCGI; used in url param for paging
806 if( count($types) == 1 ) $this->typeCGI = $types[0];
807 }
808 }
809
810 /**
811 * Set the log reader to return only entries by the given user.
812 * @param $name String: (In)valid user name
813 */
814 private function limitUser( $name ) {
815 if( $name == '' ) {
816 return false;
817 }
818 $usertitle = Title::makeTitleSafe( NS_USER, $name );
819 if( is_null($usertitle) ) {
820 return false;
821 }
822 /* Fetch userid at first, if known, provides awesome query plan afterwards */
823 $userid = User::idFromName( $name );
824 if( !$userid ) {
825 /* It should be nicer to abort query at all,
826 but for now it won't pass anywhere behind the optimizer */
827 $this->mConds[] = "NULL";
828 } else {
829 global $wgUser;
830 $this->mConds['log_user'] = $userid;
831 // Paranoia: avoid brute force searches (bug 17342)
832 if( !$wgUser->isAllowed( 'deletedhistory' ) ) {
833 $this->mConds[] = $this->mDb->bitAnd('log_deleted', LogPage::DELETED_USER) . ' = 0';
834 } else if( !$wgUser->isAllowed( 'suppressrevision' ) ) {
835 $this->mConds[] = $this->mDb->bitAnd('log_deleted', LogPage::SUPPRESSED_USER) .
836 ' != ' . LogPage::SUPPRESSED_USER;
837 }
838 $this->user = $usertitle->getText();
839 }
840 }
841
842 /**
843 * Set the log reader to return only entries affecting the given page.
844 * (For the block and rights logs, this is a user page.)
845 * @param $page String: Title name as text
846 * @param $pattern String
847 */
848 private function limitTitle( $page, $pattern ) {
849 global $wgMiserMode, $wgUser;
850
851 $title = Title::newFromText( $page );
852 if( strlen( $page ) == 0 || !$title instanceof Title )
853 return false;
854
855 $this->title = $title->getPrefixedText();
856 $ns = $title->getNamespace();
857 $db = $this->mDb;
858
859 # Using the (log_namespace, log_title, log_timestamp) index with a
860 # range scan (LIKE) on the first two parts, instead of simple equality,
861 # makes it unusable for sorting. Sorted retrieval using another index
862 # would be possible, but then we might have to scan arbitrarily many
863 # nodes of that index. Therefore, we need to avoid this if $wgMiserMode
864 # is on.
865 #
866 # This is not a problem with simple title matches, because then we can
867 # use the page_time index. That should have no more than a few hundred
868 # log entries for even the busiest pages, so it can be safely scanned
869 # in full to satisfy an impossible condition on user or similar.
870 if( $pattern && !$wgMiserMode ) {
871 $this->mConds['log_namespace'] = $ns;
872 $this->mConds[] = 'log_title ' . $db->buildLike( $title->getDBkey(), $db->anyString() );
873 $this->pattern = $pattern;
874 } else {
875 $this->mConds['log_namespace'] = $ns;
876 $this->mConds['log_title'] = $title->getDBkey();
877 }
878 // Paranoia: avoid brute force searches (bug 17342)
879 if( !$wgUser->isAllowed( 'deletedhistory' ) ) {
880 $this->mConds[] = $db->bitAnd('log_deleted', LogPage::DELETED_ACTION) . ' = 0';
881 } else if( !$wgUser->isAllowed( 'suppressrevision' ) ) {
882 $this->mConds[] = $db->bitAnd('log_deleted', LogPage::SUPPRESSED_ACTION) .
883 ' != ' . LogPage::SUPPRESSED_ACTION;
884 }
885 }
886
887 public function getQueryInfo() {
888 $tables = array( 'logging', 'user' );
889 $this->mConds[] = 'user_id = log_user';
890 $groupBy = false;
891 # Add log_search table if there are conditions on it
892 if( array_key_exists('ls_field',$this->mConds) ) {
893 $tables[] = 'log_search';
894 $index = array( 'log_search' => 'ls_field_val', 'logging' => 'PRIMARY' );
895 $groupBy = 'ls_log_id';
896 # Don't use the wrong logging index
897 } else if( $this->title || $this->pattern || $this->user ) {
898 $index = array( 'logging' => array('page_time','user_time') );
899 } else if( $this->types ) {
900 $index = array( 'logging' => 'type_time' );
901 } else {
902 $index = array( 'logging' => 'times' );
903 }
904 $options = array( 'USE INDEX' => $index );
905 # Don't show duplicate rows when using log_search
906 if( $groupBy ) $options['GROUP BY'] = $groupBy;
907 $info = array(
908 'tables' => $tables,
909 'fields' => array( 'log_type', 'log_action', 'log_user', 'log_namespace',
910 'log_title', 'log_params', 'log_comment', 'log_id', 'log_deleted',
911 'log_timestamp', 'user_name', 'user_editcount' ),
912 'conds' => $this->mConds,
913 'options' => $options,
914 'join_conds' => array(
915 'user' => array( 'INNER JOIN', 'user_id=log_user' ),
916 'log_search' => array( 'INNER JOIN', 'ls_log_id=log_id' )
917 )
918 );
919 # Add ChangeTags filter query
920 ChangeTags::modifyDisplayQuery( $info['tables'], $info['fields'], $info['conds'],
921 $info['join_conds'], $info['options'], $this->mTagFilter );
922
923 return $info;
924 }
925
926 function getIndexField() {
927 return 'log_timestamp';
928 }
929
930 public function getStartBody() {
931 wfProfileIn( __METHOD__ );
932 # Do a link batch query
933 if( $this->getNumRows() > 0 ) {
934 $lb = new LinkBatch;
935 while( $row = $this->mResult->fetchObject() ) {
936 $lb->add( $row->log_namespace, $row->log_title );
937 $lb->addObj( Title::makeTitleSafe( NS_USER, $row->user_name ) );
938 $lb->addObj( Title::makeTitleSafe( NS_USER_TALK, $row->user_name ) );
939 }
940 $lb->execute();
941 $this->mResult->seek( 0 );
942 }
943 wfProfileOut( __METHOD__ );
944 return '';
945 }
946
947 public function formatRow( $row ) {
948 return $this->mLogEventsList->logLine( $row );
949 }
950
951 public function getType() {
952 return $this->types;
953 }
954
955 public function getUser() {
956 return $this->user;
957 }
958
959 public function getPage() {
960 return $this->title;
961 }
962
963 public function getPattern() {
964 return $this->pattern;
965 }
966
967 public function getYear() {
968 return $this->mYear;
969 }
970
971 public function getMonth() {
972 return $this->mMonth;
973 }
974
975 public function getTagFilter() {
976 return $this->mTagFilter;
977 }
978
979 public function doQuery() {
980 // Workaround MySQL optimizer bug
981 $this->mDb->setBigSelects();
982 parent::doQuery();
983 $this->mDb->setBigSelects( 'default' );
984 }
985 }
986
987 /**
988 * @deprecated
989 * @ingroup SpecialPage
990 */
991 class LogReader {
992 var $pager;
993 /**
994 * @param $request WebRequest: for internal use use a FauxRequest object to pass arbitrary parameters.
995 */
996 function __construct( $request ) {
997 global $wgUser, $wgOut;
998 wfDeprecated(__METHOD__);
999 # Get parameters
1000 $type = $request->getVal( 'type' );
1001 $user = $request->getText( 'user' );
1002 $title = $request->getText( 'page' );
1003 $pattern = $request->getBool( 'pattern' );
1004 $year = $request->getIntOrNull( 'year' );
1005 $month = $request->getIntOrNull( 'month' );
1006 $tagFilter = $request->getVal( 'tagfilter' );
1007 # Don't let the user get stuck with a certain date
1008 $skip = $request->getText( 'offset' ) || $request->getText( 'dir' ) == 'prev';
1009 if( $skip ) {
1010 $year = '';
1011 $month = '';
1012 }
1013 # Use new list class to output results
1014 $loglist = new LogEventsList( $wgUser->getSkin(), $wgOut, 0 );
1015 $this->pager = new LogPager( $loglist, $type, $user, $title, $pattern, $year, $month, $tagFilter );
1016 }
1017
1018 /**
1019 * Is there at least one row?
1020 * @return bool
1021 */
1022 public function hasRows() {
1023 return isset($this->pager) ? ($this->pager->getNumRows() > 0) : false;
1024 }
1025 }
1026
1027 /**
1028 * @deprecated
1029 * @ingroup SpecialPage
1030 */
1031 class LogViewer {
1032 const NO_ACTION_LINK = 1;
1033
1034 /**
1035 * LogReader object
1036 */
1037 var $reader;
1038
1039 /**
1040 * @param &$reader LogReader: where to get our data from
1041 * @param $flags Integer: Bitwise combination of flags:
1042 * LogEventsList::NO_ACTION_LINK Don't show restore/unblock/block links
1043 */
1044 function __construct( &$reader, $flags = 0 ) {
1045 wfDeprecated(__METHOD__);
1046 $this->reader =& $reader;
1047 $this->reader->pager->mLogEventsList->flags = $flags;
1048 # Aliases for shorter code...
1049 $this->pager =& $this->reader->pager;
1050 $this->list =& $this->reader->pager->mLogEventsList;
1051 }
1052
1053 /**
1054 * Take over the whole output page in $wgOut with the log display.
1055 */
1056 public function show() {
1057 # Set title and add header
1058 $this->list->showHeader( $pager->getType() );
1059 # Show form options
1060 $this->list->showOptions( $this->pager->getType(), $this->pager->getUser(), $this->pager->getPage(),
1061 $this->pager->getPattern(), $this->pager->getYear(), $this->pager->getMonth() );
1062 # Insert list
1063 $logBody = $this->pager->getBody();
1064 if( $logBody ) {
1065 $wgOut->addHTML(
1066 $this->pager->getNavigationBar() .
1067 $this->list->beginLogEventsList() .
1068 $logBody .
1069 $this->list->endLogEventsList() .
1070 $this->pager->getNavigationBar()
1071 );
1072 } else {
1073 $wgOut->addWikiMsg( 'logempty' );
1074 }
1075 }
1076
1077 /**
1078 * Output just the list of entries given by the linked LogReader,
1079 * with extraneous UI elements. Use for displaying log fragments in
1080 * another page (eg at Special:Undelete)
1081 * @param $out OutputPage: where to send output
1082 */
1083 public function showList( &$out ) {
1084 $logBody = $this->pager->getBody();
1085 if( $logBody ) {
1086 $out->addHTML(
1087 $this->list->beginLogEventsList() .
1088 $logBody .
1089 $this->list->endLogEventsList()
1090 );
1091 } else {
1092 $out->addWikiMsg( 'logempty' );
1093 }
1094 }
1095 }