diff options
Diffstat (limited to 'maintenance/rebuildrecentchanges.inc')
| -rw-r--r-- | maintenance/rebuildrecentchanges.inc | 96 |
1 files changed, 84 insertions, 12 deletions
diff --git a/maintenance/rebuildrecentchanges.inc b/maintenance/rebuildrecentchanges.inc index 8b2c7805..f846d2b7 100644 --- a/maintenance/rebuildrecentchanges.inc +++ b/maintenance/rebuildrecentchanges.inc @@ -2,8 +2,9 @@ /** * Rebuild recent changes table. * + * @file * @todo document - * @addtogroup Maintenance + * @ingroup Maintenance */ /** Public entry; more passes might come in! :) */ @@ -11,12 +12,12 @@ function rebuildRecentChangesTable() { rebuildRecentChangesTablePass1(); rebuildRecentChangesTablePass2(); rebuildRecentChangesTablePass3(); + rebuildRecentChangesTablePass4(); } /** */ function rebuildRecentChangesTablePass1() { - $fname = 'rebuildRecentChangesTablePass1'; $dbw = wfGetDB( DB_MASTER ); $dbw->delete( 'recentchanges', '*' ); @@ -24,6 +25,15 @@ function rebuildRecentChangesTablePass1() print( "Loading from page and revision tables...\n" ); global $wgRCMaxAge; + + print( '$wgRCMaxAge=' . $wgRCMaxAge ); + $days = $wgRCMaxAge / 24 / 3600; + if ( intval($days) == $days ) { + print( " (" . $days . " days)\n" ); + } else { + print( " (approx. " . intval($days) . " days)\n" ); + } + $cutoff = time() - $wgRCMaxAge; $dbw->insertSelect( 'recentchanges', array( 'page', 'revision' ), array( @@ -41,10 +51,11 @@ function rebuildRecentChangesTablePass1() 'rc_this_oldid' => 'rev_id', 'rc_last_oldid' => 0, // is this ok? 'rc_type' => $dbw->conditional( 'page_is_new != 0', RC_NEW, RC_EDIT ), + 'rc_deleted' => 'rev_deleted' ), array( 'rev_timestamp > ' . $dbw->addQuotes( $dbw->timestamp( $cutoff ) ), 'rev_page=page_id' - ), $fname, + ), __METHOD__, array(), // INSERT options array( 'ORDER BY' => 'rev_timestamp DESC', 'LIMIT' => 5000 ) // SELECT options ); @@ -70,18 +81,19 @@ function rebuildRecentChangesTablePass2() # Switch! Look up the previous last edit, if any $lastCurId = intval( $obj->rc_cur_id ); $emit = $obj->rc_timestamp; - $sql2 = "SELECT rev_id, rev_len FROM $revision " . + $sql2 = "SELECT rev_id,rev_len FROM $revision " . "WHERE rev_page={$lastCurId} ". "AND rev_timestamp<'{$emit}' ORDER BY rev_timestamp DESC LIMIT 1"; $res2 = $dbw->query( $sql2 ); if( $row = $dbw->fetchObject( $res2 ) ) { - $lastOldId = intval( $row->rev_id ); - $lastSize = $row->rev_len; # Grab the last text size + $lastOldId = intval($row->rev_id); + # Grab the last text size if available + $lastSize = !is_null($row->rev_len) ? intval($row->rev_len) : 'NULL'; } else { # No previous edit $lastOldId = 0; $lastSize = 'NULL'; - $new = 1; + $new = 1; // probably true } $dbw->freeResult( $res2 ); } @@ -90,10 +102,10 @@ function rebuildRecentChangesTablePass2() } else { # Grab the entry's text size $size = $dbw->selectField( 'revision', 'rev_len', array('rev_id' => $obj->rc_this_oldid ) ); - $size = $size ? $size : 'NULL'; + $size = !is_null($size) ? intval($size) : 'NULL'; $sql3 = "UPDATE $recentchanges SET rc_last_oldid=$lastOldId,rc_new=$new,rc_type=$new," . - "rc_old_len='$lastSize',rc_new_len='$size' " . + "rc_old_len=$lastSize,rc_new_len=$size " . "WHERE rc_cur_id={$lastCurId} AND rc_this_oldid={$obj->rc_this_oldid}"; $dbw->query( $sql3 ); @@ -105,6 +117,67 @@ function rebuildRecentChangesTablePass2() function rebuildRecentChangesTablePass3() { + $dbw = wfGetDB( DB_MASTER ); + + print( "Loading from user, page, and logging tables...\n" ); + + global $wgRCMaxAge; + // Some logs don't go in RC. This can't really detect all of those. + // At least do the basics logs for a standard install... + // FIXME: this needs to be maintained + $basicRCLogs = array( + 'block', + 'protect', + 'rights', + 'delete', + 'upload', + 'move', + 'import', + 'merge' ); + // Escape...blah blah + $selectLogs = array(); + foreach( $basicRCLogs as $logtype ) { + $safetype = $dbw->strencode( $logtype ); + $selectLogs[] = "'$safetype'"; + } + + $cutoff = time() - $wgRCMaxAge; + $dbw->insertSelect( 'recentchanges', array( 'logging', 'page', 'user' ), + array( + 'rc_timestamp' => 'log_timestamp', + 'rc_cur_time' => 'log_timestamp', + 'rc_user' => 'log_user', + 'rc_user_text' => 'user_name', + 'rc_namespace' => 'log_namespace', + 'rc_title' => 'log_title', + 'rc_comment' => 'log_comment', + 'rc_minor' => 0, + 'rc_bot' => 0, + 'rc_patrolled' => 1, + 'rc_new' => 0, + 'rc_this_oldid' => 0, + 'rc_last_oldid' => 0, + 'rc_type' => RC_LOG, + 'rc_cur_id' => 'page_id', + 'rc_log_type' => 'log_type', + 'rc_log_action' => 'log_action', + 'rc_logid' => 'log_id', + 'rc_params' => 'log_params', + 'rc_deleted' => 'log_deleted' + ), array( + 'log_timestamp > ' . $dbw->addQuotes( $dbw->timestamp( $cutoff ) ), + 'log_user=user_id', + 'log_namespace=page_namespace', + 'log_title=page_title', + 'log_type IN(' . implode(',',$selectLogs) . ')' + ), __METHOD__, + array(), // INSERT options + array( 'ORDER BY' => 'log_timestamp DESC', 'LIMIT' => 5000 ) // SELECT options + ); +} + +function rebuildRecentChangesTablePass4() +{ global $wgGroupPermissions, $wgUseRCPatrol; $dbw = wfGetDB( DB_MASTER ); @@ -143,8 +216,9 @@ function rebuildRecentChangesTablePass3() $dbw->query( $sql2 ); } } + global $wgMiserMode; # Flag our recent autopatrolled edits - if( !empty($autopatrolgroups) ) { + if( !$wgMiserMode && !empty($autopatrolgroups) ) { $patrolwhere = implode(',',$autopatrolgroups); $patrolusers = array(); @@ -170,5 +244,3 @@ function rebuildRecentChangesTablePass3() $dbw->freeResult( $res ); } - -?> |