<?php

/**
 * @file
 * Administrative page for handling updates from MySQL version 4.0 or earlier to 4.1 or later.
 *
 * Point your browser to "http://www.example.com/mysql-update.php" and wait for instructions.
 *
 * If you are not logged in as administrator, you will need to modify the access
 * check statement below. Change the TRUE to a FALSE to disable the access
 * check. After finishing the upgrade, be sure to open this file and change the
 * FALSE back to a TRUE!
 *
 * For more information, check http://drupal.org/node/198184
 */

// Enforce access checking?
$access_check = TRUE;

function update_sql($sql) {
  $result = db_query($sql);
  return array('success' => $result !== FALSE, 'query' => check_plain($sql));
}

include_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

// Turn error reporting back on. From now on, only fatal errors (which are
// not passed through the error handler) will cause a message to be printed.
ini_set('display_errors', TRUE);

// Access check:
if (($access_check == FALSE) || ($user->uid == 1)) {
  include_once './includes/install.inc';
  /**
   * Convert a single MySQL table to UTF-8.
   *
   * We change all text columns to their corresponding binary type,
   * then back to text, but with a UTF-8 character set.
   * See: http://dev.mysql.com/doc/refman/4.1/en/charset-conversion.html
   */
  function update_convert_table_utf8($table) {
    $ret = array();
    $types = array(
      'char' => 'binary',
      'varchar' => 'varbinary',
      'tinytext' => 'tinyblob',
      'text' => 'blob',
      'mediumtext' => 'mediumblob',
      'longtext' => 'longblob',
    );
    // Get next table in list
    $convert_to_binary = array();
    $convert_to_utf8 = array();  
    // Set table default charset
    $ret[] = update_sql('ALTER TABLE {'. $table .'} DEFAULT CHARACTER SET utf8');
    // Find out which columns need converting and build SQL statements
    $result = db_query('SHOW FULL COLUMNS FROM {'. $table .'}');
    while ($column = db_fetch_array($result)) {
      list($type) = explode('(', $column['Type']);
      if (isset($types[$type])) {
        $names = 'CHANGE `'. $column['Field'] .'` `'. $column['Field'] .'` ';
        $attributes = ' DEFAULT '. ($column['Default'] == 'NULL' ? 'NULL ' : "'". db_escape_string($column['Default']) ."' ") . ($column['Null'] == 'YES' ? 'NULL' : 'NOT NULL');
        $convert_to_binary[] = $names . preg_replace('/'. $type .'/i', $types[$type], $column['Type']) . $attributes;
        $convert_to_utf8[] = $names . $column['Type'] .' CHARACTER SET utf8'. $attributes;
      }
    }
    if (count($convert_to_binary)) {
      // Convert text columns to binary
      $ret[] = update_sql('ALTER TABLE {'. $table .'} '. implode(', ', $convert_to_binary));
      // Convert binary columns to UTF-8
      $ret[] = update_sql('ALTER TABLE {'. $table .'} '. implode(', ', $convert_to_utf8));
    }
    return $ret;
  }  global $db_url;  $url = parse_url($db_url);  $db = substr($url['path'], 1);  $tables = db_query("show tables");  while($table = db_fetch_object($tables)) {    $table = (array)$table;    update_convert_table_utf8($table["Tables_in_$db"]);  }  print t('Your data has been converted. Please check your !site to see if your data looks normal again.', array('!site' => l(t("site"), 'index.php'))); 
}
else {
  print t('Please log in to your site as user 1 or set the $access_check flag to FALSE.'); 
}