+// Force the DB type to be MySQL

+$dbms = 'mysql';

+set_time_limit(0); // Unlimited execution time

+ global $table_prefix;

+ $schemafile = file('db/schemas/mysql_schema.sql');

+ // Start of a new table definition, set some variables and go to the next line.

+ // Replace the 'phpbb_' prefix by the user defined prefix.

+ $table = str_replace("phpbb_", $table_prefix, $matches[1]);

+ $table_def[$table] = "CREATE TABLE $table (\n";

+ // End of the table definition

+ // After this we will skip everything until the next 'CREATE' line

+ // We are inside a table definition, parse this line.

+ // Add the current line to the complete table definition:

+ if(preg_match("/^\s*(\w+)\s+(\w+)\((\d+)\)(.*)$/", $line, $matches))

+ {

+ // This is a column definition

+ $field = $matches[1];

+ $type = $matches[2];

+ $size = $matches[3];

+ preg_match("/DEFAULT (NULL|\'.*?\')[,\s](.*)$/i", $matches[4], $match);

+ $default = $match[1];

+ preg_match("/NOT NULL/i", $matches[4]) ? $notnull = 1 : $notnull =0;

+ preg_match("/auto_increment/i", $matches[4]) ? $auto_increment = 1 : $auto_increment = 0;

+ /*

+ $i%2 == 1 ? $color = "#FF0000" : $color = "#0000FF";

+ print "<font color = $color>\n";

+ print "$line<br>\n";

+ print "$field $type($size)";

+ if (isset($default)){

+ print " DEFAULT $default";

+ }

+ if ($notnull == 1)

+ {

+ print " NOT NULL";

+ }

+ if ($auto_increment == 1)

+ {

+ print " auto_increment";

+ }

+ print "<br>\n";

+ print "<font>\n";

+ */

+ $field_def[$table][$field] = array(

+ 'type' => $type,

+ 'size' => $size,

+ 'default' => $default,

+ 'notnull' => $notnull,

+ 'auto_increment' => $auto_increment

+ );

+

+ if(preg_match("/\s*PRIMARY\s+KEY\s*\((.*)\).*/", $line, $matches))

+ // Primary key

+ $key_def[$table]['PRIMARY'] = $matches[1];

+ else if(preg_match("/\s*KEY\s+(\w+)\s*\((.*)\)/", $line, $matches))

+ // Normal key

+ $key_def[$table][$matches[1]] = $matches[2];

+ }

+ else if(preg_match("/^\s*(\w+)\s*(.*?),?\s*$/", $line, $matches))

+ {

+ // Column definition

+ $create_def[$table][$matches[1]] = $matches[2];

+ }

+ else

+ {

+ print "$line<br>";

+ // It's a bird! It's a plane! It's something we didn't expect ;(

+ $schema['create_def'] = $create_def;

+ $schema['key_def'] = $key_def;

+ global $table_prefix;

+ $insertfile = file("db/schemas/mysql_basic.sql");

+ if (preg_match("/^(.*INSERT INTO (.*?)\s.*);$/i", str_replace("phpbb_", $table_prefix, $insertfile[$i]), $matches))

+// Parse the MySQL schema file into some arrays.

+$schema = get_schema();

+$table_def = $schema['table_def'];

+$field_def = $schema['field_def'];

+$key_def = $schema['key_def'];

+$create_def = $schema['create_def'];

+

+/*

+print "tables:<br>";

+print_r($table_def);

+print "create:<br>";

+print_r($create_def);

+die;

+*/

+

+ $sql = "DROP TABLE themes";

+ query($sql, "Couldn't drop table 'themes'");

+ end_step('mod_old_tables');

+ case 'mod_old_tables':

+ $modtables = array(

+ "config" => "old_config",

+ );

+ while(list($old, $new) = each($modtables))

+ $sql = "SHOW INDEX FROM $old";

+ $result = query($sql, "Couldn't get list of indices for table $old");

+ while($row = mysql_fetch_array($result))

+ $index = $row['Key_name'];

+ if($index != 'PRIMARY')

+ {

+ query("ALTER TABLE $old DROP INDEX $index", "Couldn't DROP INDEX $old.$index");

+ }

+

+ // Rename table

+ $new = $table_prefix . $new;

+ $sql = "ALTER TABLE $old RENAME $new";

+ print "Renaming '$old' to '$new'<br>\n";

+ query($sql, "Failed to rename $old to $new");

+

+ $result = query($sql, "Couldn't get list of current tables");

+ print "<font color='green'>Table: $table</font><br>";

+ $result = query($definition, "Couldn't create table $table");

+ if($db->sql_affectedrows($result) < 1)

+ echo "Couldn't create table (no affected rows)<br>\n";

+ print "New config table has been created with default values.<p>\n";

+ $sql = "SELECT * FROM $table_prefix"."old_config";

+

+ // Array with user fields that we want to check for invalid data (to few characters)

+ //$changes[] = "\nADD $field $type($size) $default $notnull $auto_increment ";

+ $changes[] = "\nADD $field ". $create_def[$table][$field];

+ //$changes[] = "\nCHANGE $oldfield $field $type($size) $default $notnull $auto_increment";

+ $changes[] = "\nCHANGE $oldfield $field ". $create_def[$table][$field];

+

+

+ $sql = "SHOW INDEX FROM $table";

+ $result = query($sql, "Couldn't get list of indices for table $table");

+ unset($indices);

+ while($row = mysql_fetch_array($result))

+ {

+ $indices[] = $row['Key_name'];

+ }

+

+ while (list($key_name, $key_field) = each($key_def[$table]) )

+ {

+ if(!inarray($key_name, $indices))

+ {

+ $alter_sql .= ($key_name == 'PRIMARY') ? ",\nADD PRIMARY KEY ($key_field)" : ",\nADD INDEX $key_name ($key_field)";

+ }

+ }