3 * Makes the required database updates for the log_user_text column
5 * Run via update.php or directly through populateLogUsertext.php
11 define( 'LOG_USERTEXT_BATCH_SIZE', 100 );
13 function populate_logusertext( $db ) {
14 $start = $db->selectField( 'logging', 'MIN(log_id)', false, __FUNCTION__ );
16 echo "Nothing to do.\n";
19 $end = $db->selectField( 'logging', 'MAX(log_id)', false, __FUNCTION__ );
22 $end += LOG_USERTEXT_BATCH_SIZE - 1;
24 $blockEnd = $start + LOG_USERTEXT_BATCH_SIZE - 1;
25 while( $blockEnd <= $end ) {
26 echo "...doing log_id from $blockStart to $blockEnd\n";
27 $cond = "log_id BETWEEN $blockStart AND $blockEnd AND log_user = user_id";
28 $res = $db->select( array('logging','user'),
29 array('log_id','user_name'), $cond, __FUNCTION__ );
32 while( $row = $db->fetchObject( $res ) ) {
33 $db->update( 'logging', array('log_user_text' => $row->user_name),
34 array('log_id' => $row->log_id), __FUNCTION__ );
37 $blockStart += LOG_USERTEXT_BATCH_SIZE;
38 $blockEnd += LOG_USERTEXT_BATCH_SIZE;
43 array( 'ul_key' => 'populate log_usertext' ),
48 wfOut( "log_usertext population complete.\n" );
51 wfOut( "Could not insert log_usertext population row.\n" );