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         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 = 'revertmerge protect_change unblocklink change-blocklink revertmove undeletelink revdel-restore rev-delundel hist';
  42                         foreach( explode( ' ', $messages ) as $msg ) {
  43                                 $this->message[$msg] = wfMsgExt( $msg, array( 'escape') );
  44                         }
  45                 }
  46         }
  47
  48         /**
  49          * Set page title and show header for this log type
  50          * @param $type String
  51          */
  52         public function showHeader( $type ) {
  53                 if( LogPage::isLogType( $type ) ) {
  54                         $this->out->setPageTitle( LogPage::logName( $type ) );
  55                         $this->out->addHTML( LogPage::logHeader( $type ) );
  56                 }
  57         }
  58
  59         /**
  60          * Show options for the log list
  61          * @param $type String
  62          * @param $user String
  63          * @param $page String
  64          * @param $pattern String
  65          * @param $year Integer: year
  66          * @param $month Integer: month
  67          * @param $filter Boolean
  68          */
  69         public function showOptions( $type = '', $user = '', $page = '', $pattern = '', $year = '',
  70                         $month = '', $filter = null )
  71         {
  72                 global $wgScript, $wgMiserMode;
  73                 $action = htmlspecialchars( $wgScript );
  74                 $title = SpecialPage::getTitleFor( 'Log' );
  75                 $special = htmlspecialchars( $title->getPrefixedDBkey() );
  76
  77                 $this->out->addHTML( "<form action=\"$action\" method=\"get\"><fieldset>" .
  78                         Xml::element( 'legend', array(), wfMsg( 'log' ) ) .
  79                         Xml::hidden( 'title', $special ) . "\n" .
  80                         $this->getTypeMenu( $type ) . "\n" .
  81                         $this->getUserInput( $user ) . "\n" .
  82                         $this->getTitleInput( $page ) . "\n" .
  83                         ( !$wgMiserMode ? ($this->getTitlePattern( $pattern )."\n") : "" ) .
  84                         "<p>" . $this->getDateMenu( $year, $month ) . "\n" .
  85                         ( $filter ? "</p><p>".$this->getFilterLinks( $type, $filter )."\n" : "" ) .
  86                         Xml::submitButton( wfMsg( 'allpagessubmit' ) ) . "</p>\n" .
  87                         "</fieldset></form>"
  88                 );
  89         }
  90
  91         private function getFilterLinks( $logType, $filter ) {
  92                 global $wgTitle;
  93                 // show/hide links
  94                 $messages = array( wfMsgHtml( 'show' ), wfMsgHtml( 'hide' ) );
  95                 // Option value -> message mapping
  96                 $links = array();
  97                 foreach( $filter as $type => $val ) {
  98                         $hideVal = 1 - intval($val);
  99                         $link = $this->skin->makeKnownLinkObj( $wgTitle, $messages[$hideVal],
 100                                 wfArrayToCGI( array( "hide_{$type}_log" => $hideVal ), $this->getDefaultQuery() )
 101                         );
 102                         $links[$type] = wfMsgHtml( "log-show-hide-{$type}", $link );
 103                 }
 104                 // Build links
 105                 return implode( ' | ', $links );
 106         }
 107
 108         private function getDefaultQuery() {
 109                 if ( !isset( $this->mDefaultQuery ) ) {
 110                         $this->mDefaultQuery = $_GET;
 111                         unset( $this->mDefaultQuery['title'] );
 112                         unset( $this->mDefaultQuery['dir'] );
 113                         unset( $this->mDefaultQuery['offset'] );
 114                         unset( $this->mDefaultQuery['limit'] );
 115                         unset( $this->mDefaultQuery['order'] );
 116                         unset( $this->mDefaultQuery['month'] );
 117                         unset( $this->mDefaultQuery['year'] );
 118                 }
 119                 return $this->mDefaultQuery;
 120         }
 121
 122         /**
 123          * @param $queryType String
 124          * @return String: Formatted HTML
 125          */
 126         private function getTypeMenu( $queryType ) {
 127                 global $wgLogRestrictions, $wgUser;
 128
 129                 $html = "<select name='type'>\n";
 130
 131                 $validTypes = LogPage::validTypes();
 132                 $typesByName = array(); // Temporary array
 133
 134                 // First pass to load the log names
 135                 foreach( $validTypes as $type ) {
 136                         $text = LogPage::logName( $type );
 137                         $typesByName[$text] = $type;
 138                 }
 139
 140                 // Second pass to sort by name
 141                 ksort($typesByName);
 142
 143                 // Third pass generates sorted XHTML content
 144                 foreach( $typesByName as $text => $type ) {
 145                         $selected = ($type == $queryType);
 146                         // Restricted types
 147                         if ( isset($wgLogRestrictions[$type]) ) {
 148                                 if ( $wgUser->isAllowed( $wgLogRestrictions[$type] ) ) {
 149                                         $html .= Xml::option( $text, $type, $selected ) . "\n";
 150                                 }
 151                         } else {
 152                                 $html .= Xml::option( $text, $type, $selected ) . "\n";
 153                         }
 154                 }
 155
 156                 $html .= '</select>';
 157                 return $html;
 158         }
 159
 160         /**
 161          * @param $user String
 162          * @return String: Formatted HTML
 163          */
 164         private function getUserInput( $user ) {
 165                 return Xml::inputLabel( wfMsg( 'specialloguserlabel' ), 'user', 'user', 15, $user );
 166         }
 167
 168         /**
 169          * @param $title String
 170          * @return String: Formatted HTML
 171          */
 172         private function getTitleInput( $title ) {
 173                 return Xml::inputLabel( wfMsg( 'speciallogtitlelabel' ), 'page', 'page', 20, $title );
 174         }
 175
 176         /**
 177          * @param $year Integer
 178          * @param $month Integer
 179          * @return string Formatted HTML
 180          */
 181         private function getDateMenu( $year, $month ) {
 182                 # Offset overrides year/month selection
 183                 if( $month && $month !== -1 ) {
 184                         $encMonth = intval( $month );
 185                 } else {
 186                         $encMonth = '';
 187                 }
 188                 if ( $year ) {
 189                         $encYear = intval( $year );
 190                 } else if( $encMonth ) {
 191                         $thisMonth = intval( gmdate( 'n' ) );
 192                         $thisYear = intval( gmdate( 'Y' ) );
 193                         if( intval($encMonth) > $thisMonth ) {
 194                                 $thisYear--;
 195                         }
 196                         $encYear = $thisYear;
 197                 } else {
 198                         $encYear = '';
 199                 }
 200                 return Xml::label( wfMsg( 'year' ), 'year' ) . ' '.
 201                         Xml::input( 'year', 4, $encYear, array('id' => 'year', 'maxlength' => 4) ) .
 202                         ' '.
 203                         Xml::label( wfMsg( 'month' ), 'month' ) . ' '.
 204                         Xml::monthSelector( $encMonth, -1 );
 205         }
 206
 207         /**
 208          * @return boolean Checkbox
 209          */
 210         private function getTitlePattern( $pattern ) {
 211                 return '<span style="white-space: nowrap">' .
 212                         Xml::checkLabel( wfMsg( 'log-title-wildcard' ), 'pattern', 'pattern', $pattern ) .
 213                         '</span>';
 214         }
 215
 216         public function beginLogEventsList() {
 217                 return "<ul>\n";
 218         }
 219
 220         public function endLogEventsList() {
 221                 return "</ul>\n";
 222         }
 223
 224         /**
 225          * @param $row Row: a single row from the result set
 226          * @return String: Formatted HTML list item
 227          */
 228         public function logLine( $row ) {
 229                 global $wgLang, $wgUser, $wgContLang;
 230
 231                 $title = Title::makeTitle( $row->log_namespace, $row->log_title );
 232                 $time = $wgLang->timeanddate( wfTimestamp(TS_MW, $row->log_timestamp), true );
 233                 // User links
 234                 if( self::isDeleted($row,LogPage::DELETED_USER) ) {
 235                         $userLink = '<span class="history-deleted">' . wfMsgHtml( 'rev-deleted-user' ) . '</span>';
 236                 } else {
 237                         $userLink = $this->skin->userLink( $row->log_user, $row->user_name ) .
 238                                 $this->skin->userToolLinks( $row->log_user, $row->user_name, true, 0, $row->user_editcount );
 239                 }
 240                 // Comment
 241                 if( self::isDeleted($row,LogPage::DELETED_COMMENT) ) {
 242                         $comment = '<span class="history-deleted">' . wfMsgHtml('rev-deleted-comment') . '</span>';
 243                 } else {
 244                         $comment = $wgContLang->getDirMark() . $this->skin->commentBlock( $row->log_comment );
 245                 }
 246                 // Extract extra parameters
 247                 $paramArray = LogPage::extractParams( $row->log_params );
 248                 $revert = $del = '';
 249                 // Some user can hide log items and have review links
 250                 if( $wgUser->isAllowed( 'deleterevision' ) ) {
 251                         $del = $this->getShowHideLinks( $row ) . ' ';
 252                 }
 253                 // Add review links and such...
 254                 if( ($this->flags & self::NO_ACTION_LINK) || ($row->log_deleted & LogPage::DELETED_ACTION) ) {
 255                         // Action text is suppressed...
 256                 } else if( self::typeAction($row,'move','move') && !empty($paramArray[0]) && $wgUser->isAllowed( 'move' ) ) {
 257                         $destTitle = Title::newFromText( $paramArray[0] );
 258                         if( $destTitle ) {
 259                                 $revert = '(' . $this->skin->makeKnownLinkObj( SpecialPage::getTitleFor( 'Movepage' ),
 260                                         $this->message['revertmove'],
 261                                         'wpOldTitle=' . urlencode( $destTitle->getPrefixedDBkey() ) .
 262                                         '&wpNewTitle=' . urlencode( $title->getPrefixedDBkey() ) .
 263                                         '&wpReason=' . urlencode( wfMsgForContent( 'revertmove' ) ) .
 264                                         '&wpMovetalk=0' ) . ')';
 265                         }
 266                 // Show undelete link
 267                 } else if( self::typeAction($row,array('delete','suppress'),'delete') && $wgUser->isAllowed( 'delete' ) ) {
 268                         $revert = '(' . $this->skin->makeKnownLinkObj( SpecialPage::getTitleFor( 'Undelete' ),
 269                                 $this->message['undeletelink'], 'target='. urlencode( $title->getPrefixedDBkey() ) ) . ')';
 270                 // Show unblock/change block link
 271                 } else if( self::typeAction( $row, array( 'block', 'suppress' ), 'block' ) && $wgUser->isAllowed( 'block' ) ) {
 272                         $revert = '(' .
 273                                 $this->skin->link( SpecialPage::getTitleFor( 'Ipblocklist' ),
 274                                         $this->message['unblocklink'],
 275                                         array(),
 276                                         array( 'action' => 'unblock', 'ip' => urlencode( $row->log_title ) ),
 277                                         'known' )
 278                                 . ' ' . wfMsg( 'pipe-separator' ) . ' ' .
 279                                 $this->skin->link( SpecialPage::getTitleFor( 'Blockip', htmlspecialchars( $row->log_title ) ),
 280                                         $this->message['change-blocklink'],
 281                                         array(), array(), 'known' ) .
 282                                 ')';
 283                 // Show change protection link
 284                 } else if( self::typeAction($row,'protect',array('modify','protect','unprotect')) ) {
 285                         $revert .= ' (' .  $this->skin->makeKnownLinkObj( $title, $this->message['hist'],
 286                                 'action=history&offset=' . urlencode($row->log_timestamp) ) . ')';
 287                         if( $wgUser->isAllowed('protect') && $row->log_action != 'unprotect' ) {
 288                                 $revert .= ' (' .  $this->skin->makeKnownLinkObj( $title, $this->message['protect_change'],
 289                                         'action=unprotect' ) . ')';
 290                         }
 291                 // Show unmerge link
 292                 } else if ( self::typeAction($row,'merge','merge') ) {
 293                         $merge = SpecialPage::getTitleFor( 'Mergehistory' );
 294                         $revert = '(' .  $this->skin->makeKnownLinkObj( $merge, $this->message['revertmerge'],
 295                                 wfArrayToCGI( array('target' => $paramArray[0], 'dest' => $title->getPrefixedDBkey(),
 296                                         'mergepoint' => $paramArray[1] ) ) ) . ')';
 297                 // If an edit was hidden from a page give a review link to the history
 298                 } else if( self::typeAction($row,array('delete','suppress'),'revision') && $wgUser->isAllowed( 'deleterevision' ) ) {
 299                         if( count($paramArray) == 2 ) {
 300                                 $revdel = SpecialPage::getTitleFor( 'Revisiondelete' );
 301                                 // Different revision types use different URL params...
 302                                 $key = $paramArray[0];
 303                                 // Link to each hidden object ID, $paramArray[1] is the url param
 304                                 $Ids = explode( ',', $paramArray[1] );
 305                                 $revParams = '';
 306                                 foreach( $Ids as $n => $id ) {
 307                                         $revParams .= '&' . urlencode($key) . '[]=' . urlencode($id);
 308                                 }
 309                                 $revert = '(' . $this->skin->makeKnownLinkObj( $revdel, $this->message['revdel-restore'],
 310                                         'target=' . $title->getPrefixedUrl() . $revParams ) . ')';
 311                         }
 312                 // Hidden log items, give review link
 313                 } else if( self::typeAction($row,array('delete','suppress'),'event') && $wgUser->isAllowed( 'deleterevision' ) ) {
 314                         if( count($paramArray) == 1 ) {
 315                                 $revdel = SpecialPage::getTitleFor( 'Revisiondelete' );
 316                                 $Ids = explode( ',', $paramArray[0] );
 317                                 // Link to each hidden object ID, $paramArray[1] is the url param
 318                                 $logParams = '';
 319                                 foreach( $Ids as $n => $id ) {
 320                                         $logParams .= '&logid[]=' . intval($id);
 321                                 }
 322                                 $revert = '(' . $this->skin->makeKnownLinkObj( $revdel, $this->message['revdel-restore'],
 323                                         'target=' . $title->getPrefixedUrl() . $logParams ) . ')';
 324                         }
 325                 // Self-created users
 326                 } else if( self::typeAction($row,'newusers','create2') ) {
 327                         if( isset( $paramArray[0] ) ) {
 328                                 $revert = $this->skin->userToolLinks( $paramArray[0], $title->getDBkey(), true );
 329                         } else {
 330                                 # Fall back to a blue contributions link
 331                                 $revert = $this->skin->userToolLinks( 1, $title->getDBkey() );
 332                         }
 333                         if( $time < '20080129000000' ) {
 334                                 # Suppress $comment from old entries (before 2008-01-29), not needed and can contain incorrect links
 335                                 $comment = '';
 336                         }
 337                 // Do nothing. The implementation is handled by the hook modifiying the passed-by-ref parameters.
 338                 } else {
 339                         wfRunHooks( 'LogLine', array( $row->log_type, $row->log_action, $title, $paramArray,
 340                                 &$comment, &$revert, $row->log_timestamp ) );
 341                 }
 342                 // Event description
 343                 if( self::isDeleted($row,LogPage::DELETED_ACTION) ) {
 344                         $action = '<span class="history-deleted">' . wfMsgHtml('rev-deleted-event') . '</span>';
 345                 } else {
 346                         $action = LogPage::actionText( $row->log_type, $row->log_action, $title, $this->skin, $paramArray, true );
 347                 }
 348
 349                 return "<li>$del$time $userLink $action $comment $revert</li>\n";
 350         }
 351
 352         /**
 353          * @param $row Row
 354          * @return string
 355          */
 356         private function getShowHideLinks( $row ) {
 357                 $revdel = SpecialPage::getTitleFor( 'Revisiondelete' );
 358                 // If event was hidden from sysops
 359                 if( !self::userCan( $row, LogPage::DELETED_RESTRICTED ) ) {
 360                         $del = $this->message['rev-delundel'];
 361                 } else if( $row->log_type == 'suppress' ) {
 362                         // No one should be hiding from the oversight log
 363                         $del = $this->message['rev-delundel'];
 364                 } else {
 365                         $target = SpecialPage::getTitleFor( 'Log', $row->log_type );
 366                         $del = $this->skin->makeKnownLinkObj( $revdel, $this->message['rev-delundel'],
 367                                 'target=' . $target->getPrefixedUrl() . '&logid='.$row->log_id );
 368                         // Bolden oversighted content
 369                         if( self::isDeleted( $row, LogPage::DELETED_RESTRICTED ) )
 370                                 $del = "<strong>$del</strong>";
 371                 }
 372                 return "<tt>(<small>$del</small>)</tt>";
 373         }
 374
 375         /**
 376          * @param $row Row
 377          * @param $type Mixed: string/array
 378          * @param $action Mixed: string/array
 379          * @return bool
 380          */
 381         public static function typeAction( $row, $type, $action ) {
 382                 $match = is_array($type) ? in_array($row->log_type,$type) : $row->log_type == $type;
 383                 if( $match ) {
 384                         $match = is_array($action) ? in_array($row->log_action,$action) : $row->log_action == $action;
 385                 }
 386                 return $match;
 387         }
 388
 389         /**
 390          * Determine if the current user is allowed to view a particular
 391          * field of this log row, if it's marked as deleted.
 392          * @param $row Row
 393          * @param $field Integer
 394          * @return Boolean
 395          */
 396         public static function userCan( $row, $field ) {
 397                 if( ( $row->log_deleted & $field ) == $field ) {
 398                         global $wgUser;
 399                         $permission = ( $row->log_deleted & LogPage::DELETED_RESTRICTED ) == LogPage::DELETED_RESTRICTED
 400                                 ? 'suppressrevision'
 401                                 : 'deleterevision';
 402                         wfDebug( "Checking for $permission due to $field match on $row->log_deleted\n" );
 403                         return $wgUser->isAllowed( $permission );
 404                 } else {
 405                         return true;
 406                 }
 407         }
 408
 409         /**
 410          * @param $row Row
 411          * @param $field Integer: one of DELETED_* bitfield constants
 412          * @return Boolean
 413          */
 414         public static function isDeleted( $row, $field ) {
 415                 return ($row->log_deleted & $field) == $field;
 416         }
 417
 418         /**
 419          * Quick function to show a short log extract
 420          * @param $out OutputPage
 421          * @param $type String
 422          * @param $page String
 423          * @param $user String
 424          * @param $lim Integer
 425          * @param $conds Array
 426          */
 427         public static function showLogExtract( $out, $type='', $page='', $user='', $lim=0, $conds=array() ) {
 428                 global $wgUser;
 429                 # Insert list of top 50 or so items
 430                 $loglist = new LogEventsList( $wgUser->getSkin(), $out, 0 );
 431                 $pager = new LogPager( $loglist, $type, $user, $page, '', $conds );
 432                 if( $lim > 0 ) $pager->mLimit = $lim;
 433                 $logBody = $pager->getBody();
 434                 if( $logBody ) {
 435                         $out->addHTML(
 436                                 $loglist->beginLogEventsList() .
 437                                 $logBody .
 438                                 $loglist->endLogEventsList()
 439                         );
 440                 } else {
 441                         $out->addWikiMsg( 'logempty' );
 442                 }
 443                 return $pager->getNumRows();
 444         }
 445
 446         /**
 447          * SQL clause to skip forbidden log types for this user
 448          * @param $db Database
 449          * @return mixed (string or false)
 450          */
 451         public static function getExcludeClause( $db ) {
 452                 global $wgLogRestrictions, $wgUser;
 453                 // Reset the array, clears extra "where" clauses when $par is used
 454                 $hiddenLogs = array();
 455                 // Don't show private logs to unprivileged users
 456                 foreach( $wgLogRestrictions as $logType => $right ) {
 457                         if( !$wgUser->isAllowed($right) ) {
 458                                 $safeType = $db->strencode( $logType );
 459                                 $hiddenLogs[] = $safeType;
 460                         }
 461                 }
 462                 if( count($hiddenLogs) == 1 ) {
 463                         return 'log_type != ' . $db->addQuotes( $hiddenLogs[0] );
 464                 } elseif( $hiddenLogs ) {
 465                         return 'log_type NOT IN (' . $db->makeList($hiddenLogs) . ')';
 466                 }
 467                 return false;
 468         }
 469 }
 470
 471 /**
 472  * @ingroup Pager
 473  */
 474 class LogPager extends ReverseChronologicalPager {
 475         private $type = '', $user = '', $title = '', $pattern = '';
 476         public $mLogEventsList;
 477
 478         /**
 479          * constructor
 480          * @param $list LogEventsList
 481          * @param $type String
 482          * @param $user String
 483          * @param $title String
 484          * @param $pattern String
 485          * @param $conds Array
 486          * @param $year Integer
 487          * @param $month Integer
 488          */
 489         function __construct( $list, $type = '', $user = '', $title = '', $pattern = '',
 490                         $conds = array(), $year = false, $month = false )
 491         {
 492                 parent::__construct();
 493                 $this->mConds = $conds;
 494
 495                 $this->mLogEventsList = $list;
 496
 497                 $this->limitType( $type );
 498                 $this->limitUser( $user );
 499                 $this->limitTitle( $title, $pattern );
 500                 $this->getDateCond( $year, $month );
 501         }
 502
 503         public function getDefaultQuery() {
 504                 $query = parent::getDefaultQuery();
 505                 $query['type'] = $this->type;
 506                 $query['month'] = $this->mMonth;
 507                 $query['year'] = $this->mYear;
 508                 return $query;
 509         }
 510
 511         public function getFilterParams() {
 512                 global $wgFilterLogTypes, $wgUser, $wgRequest;
 513                 $filters = array();
 514                 if( $this->type ) {
 515                         return $filters;
 516                 }
 517                 foreach( $wgFilterLogTypes as $type => $default ) {
 518                         // Avoid silly filtering
 519                         if( $type !== 'patrol' || $wgUser->useNPPatrol() ) {
 520                                 $hide = $wgRequest->getInt( "hide_{$type}_log", $default );
 521                                 $filters[$type] = $hide;
 522                                 if( $hide )
 523                                         $this->mConds[] = 'log_type != ' . $this->mDb->addQuotes( $type );
 524                         }
 525                 }
 526                 return $filters;
 527         }
 528
 529         /**
 530          * Set the log reader to return only entries of the given type.
 531          * Type restrictions enforced here
 532          * @param $type String: A log type ('upload', 'delete', etc)
 533          */
 534         private function limitType( $type ) {
 535                 global $wgLogRestrictions, $wgUser;
 536                 // Don't even show header for private logs; don't recognize it...
 537                 if( isset($wgLogRestrictions[$type]) && !$wgUser->isAllowed($wgLogRestrictions[$type]) ) {
 538                         $type = '';
 539                 }
 540                 // Don't show private logs to unpriviledged users
 541                 $hideLogs = LogEventsList::getExcludeClause( $this->mDb );
 542                 if( $hideLogs !== false ) {
 543                         $this->mConds[] = $hideLogs;
 544                 }
 545                 if( !$type ) {
 546                         return false;
 547                 }
 548                 $this->type = $type;
 549                 $this->mConds['log_type'] = $type;
 550         }
 551
 552         /**
 553          * Set the log reader to return only entries by the given user.
 554          * @param $name String: (In)valid user name
 555          */
 556         private function limitUser( $name ) {
 557                 if( $name == '' ) {
 558                         return false;
 559                 }
 560                 $usertitle = Title::makeTitleSafe( NS_USER, $name );
 561                 if( is_null($usertitle) ) {
 562                         return false;
 563                 }
 564                 /* Fetch userid at first, if known, provides awesome query plan afterwards */
 565                 $userid = User::idFromName( $name );
 566                 if( !$userid ) {
 567                         /* It should be nicer to abort query at all,
 568                            but for now it won't pass anywhere behind the optimizer */
 569                         $this->mConds[] = "NULL";
 570                 } else {
 571                         $this->mConds['log_user'] = $userid;
 572                         $this->user = $usertitle->getText();
 573                 }
 574         }
 575
 576         /**
 577          * Set the log reader to return only entries affecting the given page.
 578          * (For the block and rights logs, this is a user page.)
 579          * @param $page String: Title name as text
 580          * @param $pattern String
 581          */
 582         private function limitTitle( $page, $pattern ) {
 583                 global $wgMiserMode;
 584
 585                 $title = Title::newFromText( $page );
 586                 if( strlen($page) == 0 || !$title instanceof Title )
 587                         return false;
 588
 589                 $this->title = $title->getPrefixedText();
 590                 $ns = $title->getNamespace();
 591                 # Using the (log_namespace, log_title, log_timestamp) index with a
 592                 # range scan (LIKE) on the first two parts, instead of simple equality,
 593                 # makes it unusable for sorting.  Sorted retrieval using another index
 594                 # would be possible, but then we might have to scan arbitrarily many
 595                 # nodes of that index. Therefore, we need to avoid this if $wgMiserMode
 596                 # is on.
 597                 #
 598                 # This is not a problem with simple title matches, because then we can
 599                 # use the page_time index.  That should have no more than a few hundred
 600                 # log entries for even the busiest pages, so it can be safely scanned
 601                 # in full to satisfy an impossible condition on user or similar.
 602                 if( $pattern && !$wgMiserMode ) {
 603                         # use escapeLike to avoid expensive search patterns like 't%st%'
 604                         $safetitle = $this->mDb->escapeLike( $title->getDBkey() );
 605                         $this->mConds['log_namespace'] = $ns;
 606                         $this->mConds[] = "log_title LIKE '$safetitle%'";
 607                         $this->pattern = $pattern;
 608                 } else {
 609                         $this->mConds['log_namespace'] = $ns;
 610                         $this->mConds['log_title'] = $title->getDBkey();
 611                 }
 612         }
 613
 614         public function getQueryInfo() {
 615                 $this->mConds[] = 'user_id = log_user';
 616                 # Don't use the wrong logging index
 617                 if( $this->title || $this->pattern || $this->user ) {
 618                         $index = array( 'USE INDEX' => array( 'logging' => array('page_time','user_time') ) );
 619                 } else if( $this->type ) {
 620                         $index = array( 'USE INDEX' => array( 'logging' => 'type_time' ) );
 621                 } else {
 622                         $index = array( 'USE INDEX' => array( 'logging' => 'times' ) );
 623                 }
 624                 return array(
 625                         'tables' => array( 'logging', 'user' ),
 626                         'fields' => array( 'log_type', 'log_action', 'log_user', 'log_namespace', 'log_title', 'log_params',
 627                                 'log_comment', 'log_id', 'log_deleted', 'log_timestamp', 'user_name', 'user_editcount' ),
 628                         'conds' => $this->mConds,
 629                         'options' => $index
 630                 );
 631         }
 632
 633         function getIndexField() {
 634                 return 'log_timestamp';
 635         }
 636
 637         public function getStartBody() {
 638                 wfProfileIn( __METHOD__ );
 639                 # Do a link batch query
 640                 if( $this->getNumRows() > 0 ) {
 641                         $lb = new LinkBatch;
 642                         while( $row = $this->mResult->fetchObject() ) {
 643                                 $lb->add( $row->log_namespace, $row->log_title );
 644                                 $lb->addObj( Title::makeTitleSafe( NS_USER, $row->user_name ) );
 645                                 $lb->addObj( Title::makeTitleSafe( NS_USER_TALK, $row->user_name ) );
 646                         }
 647                         $lb->execute();
 648                         $this->mResult->seek( 0 );
 649                 }
 650                 wfProfileOut( __METHOD__ );
 651                 return '';
 652         }
 653
 654         public function formatRow( $row ) {
 655                 return $this->mLogEventsList->logLine( $row );
 656         }
 657
 658         public function getType() {
 659                 return $this->type;
 660         }
 661
 662         public function getUser() {
 663                 return $this->user;
 664         }
 665
 666         public function getPage() {
 667                 return $this->title;
 668         }
 669
 670         public function getPattern() {
 671                 return $this->pattern;
 672         }
 673
 674         public function getYear() {
 675                 return $this->mYear;
 676         }
 677
 678         public function getMonth() {
 679                 return $this->mMonth;
 680         }
 681 }
 682
 683 /**
 684  * @deprecated
 685  * @ingroup SpecialPage
 686  */
 687 class LogReader {
 688         var $pager;
 689         /**
 690          * @param $request WebRequest: for internal use use a FauxRequest object to pass arbitrary parameters.
 691          */
 692         function __construct( $request ) {
 693                 global $wgUser, $wgOut;
 694                 # Get parameters
 695                 $type = $request->getVal( 'type' );
 696                 $user = $request->getText( 'user' );
 697                 $title = $request->getText( 'page' );
 698                 $pattern = $request->getBool( 'pattern' );
 699                 $year = $request->getIntOrNull( 'year' );
 700                 $month = $request->getIntOrNull( 'month' );
 701                 # Don't let the user get stuck with a certain date
 702                 $skip = $request->getText( 'offset' ) || $request->getText( 'dir' ) == 'prev';
 703                 if( $skip ) {
 704                         $year = '';
 705                         $month = '';
 706                 }
 707                 # Use new list class to output results
 708                 $loglist = new LogEventsList( $wgUser->getSkin(), $wgOut, 0 );
 709                 $this->pager = new LogPager( $loglist, $type, $user, $title, $pattern, $year, $month );
 710         }
 711
 712         /**
 713         * Is there at least one row?
 714         * @return bool
 715         */
 716         public function hasRows() {
 717                 return isset($this->pager) ? ($this->pager->getNumRows() > 0) : false;
 718         }
 719 }
 720
 721 /**
 722  * @deprecated
 723  * @ingroup SpecialPage
 724  */
 725 class LogViewer {
 726         const NO_ACTION_LINK = 1;
 727
 728         /**
 729          * LogReader object
 730          */
 731         var $reader;
 732
 733         /**
 734          * @param &$reader LogReader: where to get our data from
 735          * @param $flags Integer: Bitwise combination of flags:
 736          *     LogEventsList::NO_ACTION_LINK   Don't show restore/unblock/block links
 737          */
 738         function __construct( &$reader, $flags = 0 ) {
 739                 global $wgUser;
 740                 $this->reader =& $reader;
 741                 $this->reader->pager->mLogEventsList->flags = $flags;
 742                 # Aliases for shorter code...
 743                 $this->pager =& $this->reader->pager;
 744                 $this->list =& $this->reader->pager->mLogEventsList;
 745         }
 746
 747         /**
 748          * Take over the whole output page in $wgOut with the log display.
 749          */
 750         public function show() {
 751                 # Set title and add header
 752                 $this->list->showHeader( $pager->getType() );
 753                 # Show form options
 754                 $this->list->showOptions( $this->pager->getType(), $this->pager->getUser(), $this->pager->getPage(),
 755                         $this->pager->getPattern(), $this->pager->getYear(), $this->pager->getMonth() );
 756                 # Insert list
 757                 $logBody = $this->pager->getBody();
 758                 if( $logBody ) {
 759                         $wgOut->addHTML(
 760                                 $this->pager->getNavigationBar() .
 761                                 $this->list->beginLogEventsList() .
 762                                 $logBody .
 763                                 $this->list->endLogEventsList() .
 764                                 $this->pager->getNavigationBar()
 765                         );
 766                 } else {
 767                         $wgOut->addWikiMsg( 'logempty' );
 768                 }
 769         }
 770
 771         /**
 772          * Output just the list of entries given by the linked LogReader,
 773          * with extraneous UI elements. Use for displaying log fragments in
 774          * another page (eg at Special:Undelete)
 775          * @param $out OutputPage: where to send output
 776          */
 777         public function showList( &$out ) {
 778                 $logBody = $this->pager->getBody();
 779                 if( $logBody ) {
 780                         $out->addHTML(
 781                                 $this->list->beginLogEventsList() .
 782                                 $logBody .
 783                                 $this->list->endLogEventsList()
 784                         );
 785                 } else {
 786                         $out->addWikiMsg( 'logempty' );
 787                 }
 788         }
 789 }