maintenance/attribute.php

   1 <?php
   2 /**
   3  * Script for re-attributing edits
   4  *
   5  * @package MediaWiki
   6  * @subpackage Maintenance
   7  */
   8
   9 /** */
  10 require_once( "commandLine.inc" );
  11
  12 # Parameters
  13 if ( count( $args ) < 2 ) {
  14         print "Not enough parameters\n";
  15         if ( $wgWikiFarm ) {
  16                 print "Usage: php attribute.php <language> <site> <source> <destination>\n";
  17         } else {
  18                 print "Usage: php attribute.php <source> <destination>\n";
  19         }
  20         exit;
  21 }
  22
  23 $source = $args[0];
  24 $dest = $args[1];
  25
  26 $dbr =& wfGetDB( DB_SLAVE );
  27 extract( $dbr->tableNames( 'cur','old','user' ));
  28 $eSource = $dbr->strencode( $source );
  29 $eDest = $dbr->strencode( $dest );
  30
  31 # Get user id
  32 $res = $dbr->query( "SELECT user_id FROM $user WHERE user_name='$eDest'" );
  33 $row = $dbr->fetchObject( $res );
  34 if ( !$row ) {
  35         print "Warning: the target name \"$dest\" does not exist";
  36         $uid = 0;
  37 } else {
  38         $uid = $row->user_id;
  39 }
  40
  41 # Initialise files
  42 $logfile = fopen( "attribute.log", "a" );
  43 $sqlfile = fopen( "attribute.sql", "a" );
  44
  45 fwrite( $logfile, "* $source &rarr; $dest\n" );
  46
  47 fwrite( $sqlfile,
  48 "-- Changing attribution SQL file
  49 -- Generated with attribute.php
  50 -- $source -> $dest ($uid)
  51 ");
  52
  53 $omitTitle = "Wikipedia:Changing_attribution_for_an_edit";
  54
  55 # Get old entries
  56 print "\nOld entries\n\n";
  57
  58 $res = $dbr->query( "SELECT old_namespace, old_title, old_id, old_timestamp FROM $old WHERE old_user_text='$eSource'" );
  59 $row = $dbr->fetchObject( $res );
  60
  61 if ( $row ) {
  62 /*
  63         if ( $row->old_title=='Votes_for_deletion' && $row->old_namespace == 4 ) {
  64                 # We don't have that long
  65                 break;
  66         }
  67 */
  68         fwrite( $logfile, "**Old IDs: " );
  69         fwrite( $sqlfile, "UPDATE old SET old_user=$uid, old_user_text='$eDest' WHERE old_id IN (\n" );
  70
  71         for ( $first=true; $row; $row = $dbr->fetchObject( $res ) ) {
  72                 $ns = $wgLang->getNsText( $row->old_namespace );
  73                 if ( $ns ) {
  74                         $fullTitle = "$ns:{$row->old_title}";
  75                 } else {
  76                         $fullTitle = $row->old_title;
  77                 }
  78                 if ( $fullTitle == $omitTitle ) {
  79                         continue;
  80                 }
  81
  82                 print "$fullTitle\n";
  83                 $url = "http://$lang.wikipedia.org/w/wiki.phtml?title=" . urlencode( $fullTitle );
  84                 $url .= "&oldid={$row->old_id}";
  85
  86                 # Output
  87                 fwrite( $sqlfile, "      " );
  88                 if ( $first ) {
  89                         $first = false;
  90                 } else {
  91                         fwrite( $sqlfile, ", " );
  92                         fwrite( $logfile, ", " );
  93                 }
  94
  95                 fwrite( $sqlfile, "{$row->old_id} -- $url\n" );
  96                 fwrite( $logfile, "[$url {$row->old_id}]" );
  97
  98         }
  99         fwrite( $sqlfile, ");\n" );
 100         fwrite( $logfile, "\n" );
 101 }
 102
 103 # Get cur entries
 104 print "\n\nCur entries\n\n";
 105
 106 $res = $dbr->query( "SELECT cur_title, cur_namespace, cur_timestamp, cur_id FROM $cur WHERE cur_user_text='$eSource'" );
 107 $row = $dbr->fetchObject( $res );
 108 if ( $row ) {
 109         fwrite( $sqlfile, "\n\nUPDATE cur SET cur_user=$uid, cur_user_text='$eDest' WHERE cur_id IN(\n" );
 110         fwrite( $logfile, "**Cur entries:\n" );
 111         for ( $first=true; $row; $row = $dbr->fetchObject( $res ) ) {
 112                 $ns = $wgLang->getNsText( $row->cur_namespace );
 113                 if ( $ns ) {
 114                         $fullTitle = "$ns:{$row->cur_title}";
 115                 } else {
 116                         $fullTitle = $row->cur_title;
 117                 }
 118                 if ( $fullTitle == $omitTitle ) {
 119                         continue;
 120                 }
 121                 $url = "http://$lang.wikipedia.org/wiki/" . urlencode($fullTitle);
 122                 if ( $first ) {
 123                         fwrite( $sqlfile, "      " );
 124                         $first = false;
 125                 } else {
 126                         fwrite( $sqlfile, "    , " );
 127                 }
 128                 fwrite( $sqlfile, "{$row->cur_id} -- $url\n" );
 129                 fwrite( $logfile, "***[[$fullTitle]] {$row->cur_timestamp}\n" );
 130                 print "$fullTitle\n";
 131         }
 132         fwrite( $sqlfile, ");\n" );
 133 }
 134 print "\n";
 135
 136 fclose( $sqlfile );
 137 fclose( $logfile );
 138
 139 ?>