Only the blog owner has the access capabilities to this resource.');
if ( $_POST['next'] == 1 )
$dialog = 1;
if ( $_POST['mode'] == 'expert' )
$dialog = 2;
if ( $_POST['mode'] == 'normal' ) {
$dialog = 3;
$selected_tables = implode(',', (array) $_SESSION['utf8_db_converter_tables']);
$collation = $_SESSION['utf8_db_converter_collations'][0];
$output = 'direct';
}
if ( $_POST['next'] == 3 ) {
$dialog = 3;
$selected_tables = implode(',', $_POST['tables']);
$collation = $_POST['collation'];
$output = $_POST['output'];
UTF8_DB_Converter_validate($_POST['tables'], $collation, $output);
}
if ( $_POST['next'] == 4 ) {
$dialog = 4;
$tables = explode(',', $_POST['tables']);
$collation = $_POST['collation'];
$output = $_POST['output'];
UTF8_DB_Converter_validate($tables, $collation, $output);
$total_tables = count((array) $_SESSION['utf8_db_converter_tables']);
$selected_total_tables = count($tables);
}
}
?>
UTF-8 Database Converter
Error establishing a database connection');
@mysql_select_db(DB_NAME, $link_id) or wp_die('
Can’t select database
');
$resource = mysql_query('SHOW TABLES', $link_id);
while ( $result = mysql_fetch_row($resource) )
$tables[] = $result[0];
$resource = mysql_query("SHOW COLLATION LIKE 'utf8%'", $link_id);
while ( $result = mysql_fetch_assoc($resource) ) {
if ( 'Yes' == $result['Compiled'] )
$collations[] = $result['Collation'];
}
$_SESSION['utf8_db_converter_tables'] = $tables;
$_SESSION['utf8_db_converter_collations'] = $collations;
@mysql_close($link_id);
}
}
// WhiteList-Based Very Simple Protection against common injections
function UTF8_DB_Converter_validate($tables, $collation, $output) {
$valid = true;
foreach ( (array) $tables as $table ) {
if ( array_search($table, (array) $_SESSION['utf8_db_converter_tables']) === false )
$valid = false;
}
if ( array_search($collation, (array) $_SESSION['utf8_db_converter_collations']) === false )
$valid = false;
if ( array_search($output, array('direct', 'sql')) === false )
$valid = false;
if ( !$valid )
wp_die('
Detected possible injection
');
}
function UTF8_DB_Converter_core($tables, $collation, $complete_convert = true) {
// Initialize vars.
$string_querys = array();
$binary_querys = array();
$gen_index_querys = array();
$drop_index_querys = array();
$final_querys = array();
// Since we cannot use the WordPress DB Class Object (wp-includes/wp-db.php),
// we have to make a stand-alone connection to the database.
$link_id = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or wp_die('
Error establishing a database connection
');
@mysql_select_db(DB_NAME, $link_id) or wp_die('
Can’t select database
');
// Begin Converter Core
if ( !empty($tables) ) {
foreach ( (array) $tables as $table ) {
// Analyze tables for string types columns and generate his binary and string correctness sql sentences.
$resource = mysql_query("DESCRIBE $table", $link_id);
while ( $result = mysql_fetch_assoc($resource) ) {
if ( preg_match('/(char)|(text)|(enum)|(set)/', $result['Type']) ) {
// String Type SQL Sentence.
$string_querys[] = "ALTER TABLE $table MODIFY " . $result['Field'] . ' ' . $result['Type'] . " CHARACTER SET utf8 COLLATE $collation " . ( ( (!empty($result['Default'])) || ($result['Default'] === '0') || ($result['Default'] === 0) ) ? "DEFAULT '". $result['Default'] ."' " : '' ) . ( 'YES' == $result['Null'] ? '' : 'NOT ' ) . 'NULL';
// Binary String Type SQL Sentence.
if ( preg_match('/(enum)|(set)/', $result['Type']) ) {
$binary_querys[] = "ALTER TABLE $table MODIFY " . $result['Field'] . ' ' . $result['Type'] . ' CHARACTER SET binary ' . ( ( (!empty($result['Default'])) || ($result['Default'] === '0') || ($result['Default'] === 0) ) ? "DEFAULT '". $result['Default'] ."' " : '' ) . ( 'YES' == $result['Null'] ? '' : 'NOT ' ) . 'NULL';
} else {
$result['Type'] = preg_replace('/char/', 'binary', $result['Type']);
$result['Type'] = preg_replace('/text/', 'blob', $result['Type']);
$binary_querys[] = "ALTER TABLE $table MODIFY " . $result['Field'] . ' ' . $result['Type'] . ' ' . ( ( (!empty($result['Default'])) || ($result['Default'] === '0') || ($result['Default'] === 0) ) ? "DEFAULT '". $result['Default'] ."' " : '' ) . ( 'YES' == $result['Null'] ? '' : 'NOT ' ) . 'NULL';
}
}
}
// Analyze table indexs for any FULLTEXT-Type of index in the table.
$fulltext_indexes = array();
$resource = mysql_query("SHOW INDEX FROM $table", $link_id);
while ( $result = mysql_fetch_assoc($resource) ) {
if ( preg_match('/FULLTEXT/', $result['Index_type']) )
$fulltext_indexes[$result['Key_name']][$result['Column_name']] = 1;
}
// Generate the SQL Sentence for drop and add every FULLTEXT index we found previously.
if ( !empty($fulltext_indexes) ) {
foreach ( (array) $fulltext_indexes as $key_name => $column ) {
$drop_index_querys[] = "ALTER TABLE $table DROP INDEX $key_name";
$tmp_gen_index_query = "ALTER TABLE $table ADD FULLTEXT $key_name(";
$fields_names = array_keys($column);
for ($i = 1; $i <= count($column); $i++)
$tmp_gen_index_query .= $fields_names[$i - 1] . (($i == count($column)) ? '' : ', ');
$gen_index_querys[] = $tmp_gen_index_query . ')';
}
}
// Generate the SQL Sentence for change default table character set.
$tables_querys[] = "ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE $collation";
// Generate the SQL Sentence for Optimize Table.
$optimize_querys[] = "OPTIMIZE TABLE $table";
}
// SQL Sentence for change the default database character set.
if ( $complete_convert )
$db_query = "ALTER DATABASE " . DB_NAME . " DEFAULT CHARACTER SET utf8 COLLATE $collation";
} else {
wp_die('
There are no tables?
');
}
// End Converter Core
// Close MySQL Link.
@mysql_close($link_id);
// Merge all SQL Sentences that we temporary store in arrays.
$final_querys = array_merge( (array) $drop_index_querys, (array) $binary_querys, (array) $db_query, (array) $tables_querys, (array) $string_querys, (array) $gen_index_querys, (array) $optimize_querys );
// Time to return.
return $final_querys;
}
function UTF8_DB_Converter_do_querys($querys) {
/*
if ( (!empty(mysql_error($link_id))) && (!empty(mysql_errno($link_id))) )
return "Error " . mysql_errno($link_id) . ": " . mysql_error($link_id);
else
return false;
*/
}
add_action('admin_menu', 'UTF8_DB_Converter_menu_add');
?>