$dbw->delete( 'recentchanges', '*' );
print( "Loading from page and revision tables...\n" );
-
+
global $wgRCMaxAge;
$cutoff = time() - $wgRCMaxAge;
$dbw->insertSelect( 'recentchanges', array( 'page', 'revision' ),
'rc_last_oldid' => 0, // is this ok?
'rc_type' => $dbw->conditional( 'page_is_new != 0', RC_NEW, RC_EDIT ),
), array(
- 'rev_timestamp > ' . $dbw->timestamp( $cutoff ),
+ 'rev_timestamp > ' . $dbw->addQuotes( $dbw->timestamp( $cutoff ) ),
'rev_page=page_id'
- ), $fname, array( 'ORDER BY' => 'rev_timestamp', 'LIMIT' => 5000 )
+ ), $fname,
+ array(), // INSERT options
+ array( 'ORDER BY' => 'rev_timestamp', 'LIMIT' => 5000 ) // SELECT options
);
}
function rebuildRecentChangesTablePass2()
{
$dbw =& wfGetDB( DB_MASTER );
- extract( $dbw->tableNames( 'recentchanges', 'revision' ) );
-
- $ns = $id = $count = 0;
- $title = $ct = "";
+ list ($recentchanges, $revision) = $dbw->tableNamesN( 'recentchanges', 'revision' );
print( "Updating links...\n" );