maintenance/updaters.inc

   1 <?php
   2
   3 function do_revision_updates() {
   4         global $wgSoftwareRevision;
   5         if ( $wgSoftwareRevision < 1001 ) {
   6                 update_passwords();
   7         }
   8 }
   9
  10 function update_passwords() {
  11         global $wgDatabase;
  12         $fname = "Update script: update_passwords()";
  13         print "\nIt appears that you need to update the user passwords in your\n" .
  14           "database. If you have already done this (if you've run this update\n" .
  15           "script once before, for example), doing so again will make all your\n" .
  16           "user accounts inaccessible, so be sure you only do this once.\n" .
  17           "Update user passwords? (yes/no)";
  18
  19         $resp = readconsole();
  20     if ( ! ( "Y" == $resp{0} || "y" == $resp{0} ) ) { return; }
  21
  22         $sql = "SELECT user_id,user_password FROM user";
  23         $source = $wgDatabase->query( $sql, $fname );
  24
  25         while ( $row = $wgDatabase->fetchObject( $source ) ) {
  26                 $id = $row->user_id;
  27                 $oldpass = $row->user_password;
  28                 $newpass = md5( "{$id}-{$oldpass}" );
  29
  30                 $sql = "UPDATE user SET user_password='{$newpass}' " .
  31                   "WHERE user_id={$id}";
  32                 $wgDatabase->query( $sql, $fname );
  33         }
  34 }
  35
  36 function do_ipblocks_update() {
  37         global $wgDatabase;
  38
  39         $do1 = $do2 = false;
  40
  41         if ( !$wgDatabase->fieldExists( "ipblocks", "ipb_id" ) ) {
  42                 $do1 = true;
  43         }
  44         if ( !$wgDatabase->fieldExists( "ipblocks", "ipb_expiry" ) ) {
  45                 $do2 = true;
  46         }
  47
  48         if ( $do1 || $do2 ) {
  49                 echo "Updating ipblocks table... ";
  50                 if ( $do1 ) {
  51                         dbsource( "maintenance/archives/patch-ipblocks.sql", $wgDatabase );
  52                 }
  53                 if ( $do2 ) {
  54                         dbsource( "maintenance/archives/patch-ipb_expiry.sql", $wgDatabase );
  55                 }
  56                 echo "ok\n";
  57         } else {
  58                 echo "...ipblocks is up to date.\n";
  59         }
  60
  61 }
  62
  63
  64 function do_interwiki_update() {
  65         # Check that interwiki table exists; if it doesn't source it
  66         global $wgDatabase;
  67         if( $wgDatabase->tableExists( "interwiki" ) ) {
  68                 echo "...already have interwiki table\n";
  69                 return true;
  70         }
  71         echo "Creating interwiki table: ";
  72         dbsource( "maintenance/archives/patch-interwiki.sql" );
  73         echo "ok\n";
  74         echo "Adding default interwiki definitions: ";
  75         dbsource( "maintenance/interwiki.sql" );
  76         echo "ok\n";
  77 }
  78
  79 function do_index_update() {
  80         # Check that proper indexes are in place
  81         global $wgDatabase;
  82         $meta = $wgDatabase->fieldInfo( "recentchanges", "rc_timestamp" );
  83         if( $meta->multiple_key == 0 ) {
  84                 echo "Updating indexes to 20031107: ";
  85                 dbsource( "maintenance/archives/patch-indexes.sql" );
  86                 echo "ok\n";
  87                 return true;
  88         }
  89         echo "...indexes seem up to 20031107 standards\n";
  90         return false;
  91 }
  92
  93 function do_linkscc_update() {
  94         // Create linkscc if necessary
  95         global $wgDatabase;
  96         if( $wgDatabase->tableExists( "linkscc" ) ) {
  97                 echo "...have linkscc table.\n";
  98         } else {
  99                 echo "Adding linkscc table... ";
 100                 dbsource( "maintenance/archives/patch-linkscc.sql", $wgDatabase );
 101                 echo "ok\n";
 102         }
 103 }
 104
 105 function do_hitcounter_update() {
 106         // Create hitcounter if necessary
 107         global $wgDatabase;
 108         if( $wgDatabase->tableExists( "hitcounter" ) ) {
 109                 echo "...have hitcounter table.\n";
 110         } else {
 111                 echo "Adding hitcounter table... ";
 112                 dbsource( "maintenance/archives/patch-hitcounter.sql", $wgDatabase );
 113                 echo "ok\n";
 114         }
 115 }
 116
 117 function do_recentchanges_update() {
 118         global $wgDatabase;
 119         if ( !$wgDatabase->fieldExists( "recentchanges", "rc_type" ) ) {
 120                 echo "Adding rc_type, rc_moved_to_ns, rc_moved_to_title...";
 121                 dbsource( "maintenance/archives/patch-rc_type.sql" , $wgDatabase );
 122                 echo "ok\n";
 123         }
 124 }
 125
 126 function do_user_real_name_update() {
 127         global $wgDatabase;
 128         if ( $wgDatabase->fieldExists( "user", "user_real_name" ) ) {
 129                 echo "...have user_real_name field in user table.\n";
 130         } else {
 131                 echo "Adding user_real_name field to table user...";
 132                 dbsource( "maintenance/archives/patch-user-realname.sql" , $wgDatabase );
 133                 echo "ok\n";
 134         }
 135 }
 136
 137 ?>