| Zeile 180 | Zeile 180 |
|---|
if($mybb->request_method == "post" || ($mybb->input['do'] == "all" && !empty($mybb->input['table'])))
{
|
if($mybb->request_method == "post" || ($mybb->input['do'] == "all" && !empty($mybb->input['table'])))
{
|
| | if(!empty($mybb->input['mb4']) && version_compare($db->get_version(), '5.5.3', '<'))
{
flash_message($lang->error_utf8mb4_version, 'error');
admin_redirect("index.php?module=tools-system_health&action=utf8_conversion");
}
|
@set_time_limit(0);
|
@set_time_limit(0);
|
|
|
$old_table_prefix = $db->table_prefix;
$db->set_table_prefix('');
if(!$db->table_exists($db->escape_string($mybb->input['table'])))
|
$old_table_prefix = $db->table_prefix;
$db->set_table_prefix('');
if(!$db->table_exists($db->escape_string($mybb->input['table'])))
|
{
| {
$db->set_table_prefix($old_table_prefix);
|
flash_message($lang->error_invalid_table, 'error');
admin_redirect("index.php?module=tools-system_health&action=utf8_conversion");
|
flash_message($lang->error_invalid_table, 'error');
admin_redirect("index.php?module=tools-system_health&action=utf8_conversion");
|
}
$db->set_table_prefix($old_table_prefix);
| }
$db->set_table_prefix($old_table_prefix);
|
$page->add_breadcrumb_item($lang->utf8_conversion, "index.php?module=tools-system_health&action=utf8_conversion");
$page->output_header($lang->system_health." - ".$lang->utf8_conversion);
| $page->add_breadcrumb_item($lang->utf8_conversion, "index.php?module=tools-system_health&action=utf8_conversion");
$page->output_header($lang->system_health." - ".$lang->utf8_conversion);
|
| Zeile 210 | Zeile 216 |
|---|
);
$page->output_nav_tabs($sub_tabs, 'utf8_conversion');
|
);
$page->output_nav_tabs($sub_tabs, 'utf8_conversion');
|
|
|
$old_table_prefix = $db->table_prefix;
$db->set_table_prefix('');
| $old_table_prefix = $db->table_prefix;
$db->set_table_prefix('');
|
| Zeile 220 | Zeile 226 |
|---|
preg_match("#CHARSET=([a-zA-Z0-9_]+)\s?#i", $table1, $matches);
$charset = $matches[1];
|
preg_match("#CHARSET=([a-zA-Z0-9_]+)\s?#i", $table1, $matches);
$charset = $matches[1];
|
$table->construct_cell("<strong>".$lang->sprintf($lang->converting_to_utf8, $mybb->input['table'], $charset)."</strong>");
| if(!empty($mybb->input['mb4']))
{
$table->construct_cell("<strong>".$lang->sprintf($lang->converting_to_utf8mb4, $mybb->input['table'], $charset)."</strong>");
}
else
{
$table->construct_cell("<strong>".$lang->sprintf($lang->converting_to_utf8, $mybb->input['table'], $charset)."</strong>");
}
|
$table->construct_row();
$table->construct_cell($lang->please_wait);
$table->construct_row();
$table->output($converting_table." {$mybb->input['table']}");
|
$table->construct_row();
$table->construct_cell($lang->please_wait);
$table->construct_row();
$table->output($converting_table." {$mybb->input['table']}");
|
$db->set_table_prefix($old_table_prefix);
|
$db->set_table_prefix($old_table_prefix);
|
$page->output_footer(false);
|
$page->output_footer(false);
|
|
|
$old_table_prefix = $db->table_prefix;
$db->set_table_prefix('');
flush();
|
$old_table_prefix = $db->table_prefix;
$db->set_table_prefix('');
flush();
|
|
|
$types = array(
'text' => 'blob',
'mediumtext' => 'mediumblob',
| $types = array(
'text' => 'blob',
'mediumtext' => 'mediumblob',
|
| Zeile 253 | Zeile 266 |
|---|
$convert_to_utf8 = '';
$comma = '';
|
$convert_to_utf8 = '';
$comma = '';
|
// Set table default charset
$db->write_query("ALTER TABLE {$mybb->input['table']} DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
| if(!empty($mybb->input['mb4']))
{
$character_set = 'utf8mb4';
$collation = 'utf8mb4_general_ci';
}
else
{
$character_set = 'utf8';
$collation = 'utf8_general_ci';
}
// Set table default charset
$db->write_query("ALTER TABLE {$mybb->input['table']} DEFAULT CHARACTER SET {$character_set} COLLATE {$collation}");
|
// Fetch any fulltext keys
if($db->supports_fulltext($mybb->input['table']))
|
// Fetch any fulltext keys
if($db->supports_fulltext($mybb->input['table']))
|
| Zeile 279 | Zeile 303 |
|---|
// Find out which columns need converting and build SQL statements
$query = $db->query("SHOW FULL COLUMNS FROM {$mybb->input['table']}");
while($column = $db->fetch_array($query))
|
// Find out which columns need converting and build SQL statements
$query = $db->query("SHOW FULL COLUMNS FROM {$mybb->input['table']}");
while($column = $db->fetch_array($query))
|
{
| {
|
list($type) = explode('(', $column['Type']);
if(array_key_exists($type, $types))
{
| list($type) = explode('(', $column['Type']);
if(array_key_exists($type, $types))
{
|
| Zeile 320 | Zeile 344 |
|---|
}
$convert_to_binary .= $comma.$names.preg_replace('/'.$type.'/i', $types[$type], $column['Type']).' '.$attributes;
|
}
$convert_to_binary .= $comma.$names.preg_replace('/'.$type.'/i', $types[$type], $column['Type']).' '.$attributes;
|
$convert_to_utf8 .= "{$comma}{$names}{$column['Type']} CHARACTER SET utf8 COLLATE utf8_general_ci {$attributes}";
| $convert_to_utf8 .= "{$comma}{$names}{$column['Type']} CHARACTER SET {$character_set} COLLATE {$collation} {$attributes}";
|
$comma = $lang->comma;
}
|
$comma = $lang->comma;
}
|
| Zeile 363 | Zeile 387 |
|---|
{
$table = $db->show_create_table($tablename);
preg_match("#CHARSET=([a-zA-Z0-9_]+)\s?#i", $table, $matches);
|
{
$table = $db->show_create_table($tablename);
preg_match("#CHARSET=([a-zA-Z0-9_]+)\s?#i", $table, $matches);
|
if(fetch_iconv_encoding($matches[1]) == 'utf-8' && $mybb->input['table'] != $tablename)
| if(empty($mybb->input['mb4']) && (fetch_iconv_encoding($matches[1]) == 'utf-8' || $matches[1] == 'utf8mb4') && $mybb->input['table'] != $tablename)
{
continue;
}
elseif(!empty($mybb->input['mb4']) && fetch_iconv_encoding($matches[1]) != 'utf-8' && $mybb->input['table'] != $tablename)
|
{
continue;
}
| {
continue;
}
|
| Zeile 396 | Zeile 424 |
|---|
if($nexttable)
{
$nexttable = $db->escape_string($nexttable);
|
if($nexttable)
{
$nexttable = $db->escape_string($nexttable);
|
admin_redirect("index.php?module=tools-system_health&action=utf8_conversion&do=all&table={$nexttable}");
| $mb4 = '';
if(!empty($mybb->input['mb4']))
{
$mb4 = "&mb4=1";
}
admin_redirect("index.php?module=tools-system_health&action=utf8_conversion&do=all&table={$nexttable}{$mb4}");
|
exit;
}
|
exit;
}
|
}
| }
|
admin_redirect("index.php?module=tools-system_health&action=utf8_conversion");
exit;
| admin_redirect("index.php?module=tools-system_health&action=utf8_conversion");
exit;
|
| Zeile 408 | Zeile 441 |
|---|
if($mybb->input['table'] || $mybb->input['do'] == "all")
{
|
if($mybb->input['table'] || $mybb->input['do'] == "all")
{
|
| | if(!empty($mybb->input['mb4']) && version_compare($db->get_version(), '5.5.3', '<'))
{
flash_message($lang->error_utf8mb4_version, 'error');
admin_redirect("index.php?module=tools-system_health&action=utf8_conversion");
}
|
$old_table_prefix = $db->table_prefix;
$db->set_table_prefix('');
| $old_table_prefix = $db->table_prefix;
$db->set_table_prefix('');
|
| Zeile 427 | Zeile 466 |
|---|
{
$table = $db->show_create_table($tablename);
preg_match("#CHARSET=([a-zA-Z0-9_]+)\s?#i", $table, $matches);
|
{
$table = $db->show_create_table($tablename);
preg_match("#CHARSET=([a-zA-Z0-9_]+)\s?#i", $table, $matches);
|
if(fetch_iconv_encoding($matches[1]) == 'utf-8')
| if(empty($mybb->input['mb4']) && (fetch_iconv_encoding($matches[1]) == 'utf-8' || $matches[1] == 'utf8mb4'))
{
continue;
}
elseif(!empty($mybb->input['mb4']) && fetch_iconv_encoding($matches[1]) != 'utf-8')
|
{
continue;
}
| {
continue;
}
|
| Zeile 445 | Zeile 488 |
|---|
}
else
{
|
}
else
{
|
| | $db->set_table_prefix($old_table_prefix);
|
flash_message($lang->success_all_tables_already_converted, 'success');
admin_redirect("index.php?module=tools-system_health");
}
| flash_message($lang->success_all_tables_already_converted, 'success');
admin_redirect("index.php?module=tools-system_health");
}
|
| Zeile 480 | Zeile 524 |
|---|
preg_match("#CHARSET=([a-zA-Z0-9_]+)\s?#i", $table, $matches);
$charset = $matches[1];
|
preg_match("#CHARSET=([a-zA-Z0-9_]+)\s?#i", $table, $matches);
$charset = $matches[1];
|
$form = new Form("index.php?module=tools-system_health&action=utf8_conversion", "post", "utf8_conversion");
| $mb4 = '';
if(!empty($mybb->input['mb4']))
{
$mb4 = "&mb4=1";
}
$form = new Form("index.php?module=tools-system_health&action=utf8_conversion{$mb4}", "post", "utf8_conversion");
|
echo $form->generate_hidden_field("table", $mybb->input['table']);
if($mybb->input['do'] == "all")
{
echo $form->generate_hidden_field("do", "all");
|
echo $form->generate_hidden_field("table", $mybb->input['table']);
if($mybb->input['do'] == "all")
{
echo $form->generate_hidden_field("do", "all");
|
}
$table = new Table;
if($mybb->input['do'] == "all")
{
$table->construct_cell("<strong>".$lang->sprintf($lang->convert_all_to_utf, $charset)."</strong>");
}
else
{
$table->construct_cell("<strong>".$lang->sprintf($lang->convert_to_utf8, $mybb->input['table'], $charset)."</strong>");
}
$table->construct_row();
| }
$table = new Table;
if(!empty($mybb->input['mb4']))
{
$table->construct_cell("<strong>".$lang->sprintf($lang->convert_all_to_utf8mb4, $charset)."</strong>");
$lang->notice_process_long_time .= "<br /><br /><strong>{$lang->notice_mb4_warning}</strong>";
}
else
{
if($mybb->input['do'] == "all")
{
$table->construct_cell("<strong>".$lang->sprintf($lang->convert_all_to_utf, $charset)."</strong>");
}
else
{
$table->construct_cell("<strong>".$lang->sprintf($lang->convert_to_utf8, $mybb->input['table'], $charset)."</strong>");
}
}
$table->construct_row();
|
$table->construct_cell($lang->notice_process_long_time);
$table->construct_row();
| $table->construct_cell($lang->notice_process_long_time);
$table->construct_row();
|
| Zeile 518 | Zeile 576 |
|---|
$form->output_submit_wrapper($buttons);
$form->end();
|
$form->output_submit_wrapper($buttons);
$form->end();
|
|
|
$db->set_table_prefix($old_table_prefix);
|
$db->set_table_prefix($old_table_prefix);
|
|
|
$page->output_footer();
|
$page->output_footer();
|
|
|
exit;
|
exit;
|
| | }
if(!$mybb->config['database']['encoding'])
{
flash_message($lang->error_db_encoding_not_set, 'error');
admin_redirect("index.php?module=tools-system_health");
|
}
$tables = $db->list_tables($mybb->config['database']['database']);
| }
$tables = $db->list_tables($mybb->config['database']['database']);
|
| Zeile 531 | Zeile 595 |
|---|
$old_table_prefix = $db->table_prefix;
$db->set_table_prefix('');
|
$old_table_prefix = $db->table_prefix;
$db->set_table_prefix('');
|
$not_okey_count = 0;
$not_okey = array();
$okey_count = 0;
| $encodings = array();
|
foreach($tables as $key => $tablename)
{
if(substr($tablename, 0, strlen($old_table_prefix)) == $old_table_prefix)
{
$table = $db->show_create_table($tablename);
preg_match("#CHARSET=([a-zA-Z0-9_]+)\s?#i", $table, $matches);
|
foreach($tables as $key => $tablename)
{
if(substr($tablename, 0, strlen($old_table_prefix)) == $old_table_prefix)
{
$table = $db->show_create_table($tablename);
preg_match("#CHARSET=([a-zA-Z0-9_]+)\s?#i", $table, $matches);
|
if(fetch_iconv_encoding($matches[1]) != 'utf-8')
{
$not_okey[$key] = $tablename;
++$not_okey_count;
}
else
{
++$okay_count;
}
| $encodings[$key] = fetch_iconv_encoding($matches[1]);
|
$mybb_tables[$key] = $tablename;
|
$mybb_tables[$key] = $tablename;
|
}
}
$db->set_table_prefix($old_table_prefix);
if($okay_count == count($mybb_tables))
{
flash_message($lang->success_all_tables_already_converted, 'success');
admin_redirect("index.php?module=tools-system_health");
}
if(!$mybb->config['database']['encoding'])
{
flash_message($lang->error_db_encoding_not_set, 'error');
admin_redirect("index.php?module=tools-system_health");
}
$page->add_breadcrumb_item($lang->utf8_conversion, "index.php?module=tools-system_health&action=utf8_conversion");
| }
}
$db->set_table_prefix($old_table_prefix);
$page->add_breadcrumb_item($lang->utf8_conversion, "index.php?module=tools-system_health&action=utf8_conversion");
|
$page->output_header($lang->system_health." - ".$lang->utf8_conversion);
|
$page->output_header($lang->system_health." - ".$lang->utf8_conversion);
|
|
|
$page->output_nav_tabs($sub_tabs, 'utf8_conversion');
asort($mybb_tables);
|
$page->output_nav_tabs($sub_tabs, 'utf8_conversion');
asort($mybb_tables);
|
|
$unique = array_unique($encodings);
$convert_utf8 = $convert_utf8mb4 = false;
foreach($unique as $encoding)
{
if($encoding == 'utf-8')
{
$convert_utf8mb4 = true;
}
elseif($encoding != 'utf8mb4')
{
$convert_utf8 = true;
}
}
if(count($unique) > 1)
{
$page->output_error("<p><em>{$lang->warning_multiple_encodings}</em></p>");
}
if(in_array('utf8mb4', $unique) && $mybb->config['database']['encoding'] != 'utf8mb4')
{
$page->output_error("<p><em>{$lang->warning_utf8mb4_config}</em></p>");
}
|
$table = new Table;
$table->construct_header($lang->table);
|
$table = new Table;
$table->construct_header($lang->table);
|
$table->construct_header($lang->status, array("class" => "align_center"));
| $table->construct_header($lang->status_utf8, array("class" => "align_center"));
$table->construct_header($lang->status_utf8mb4, array("class" => "align_center"));
$all_utf8 = $all_utf8mb4 = '-';
if($convert_utf8)
{
$all_utf8 = "<strong><a href=\"index.php?module=tools-system_health&action=utf8_conversion&do=all\">{$lang->convert_all}</a></strong>";
}
if($convert_utf8mb4)
{
$all_utf8mb4 = "<strong><a href=\"index.php?module=tools-system_health&action=utf8_conversion&do=all&mb4=1\">{$lang->convert_all}</a></strong>";
}
$table->construct_cell("<strong>{$lang->all_tables}</strong>");
$table->construct_cell($all_utf8, array("class" => "align_center", 'width' => '15%'));
$table->construct_cell($all_utf8mb4, array("class" => "align_center", 'width' => '25%'));
$table->construct_row();
$db_version = $db->get_version();
|
foreach($mybb_tables as $key => $tablename)
{
|
foreach($mybb_tables as $key => $tablename)
{
|
if(array_key_exists($key, $not_okey))
{
| if($encodings[$key] != 'utf-8' && $encodings[$key] != 'utf8mb4')
{
|
$status = "<a href=\"index.php?module=tools-system_health&action=utf8_conversion&table={$tablename}\" style=\"background: url(styles/{$page->style}/images/icons/cross.gif) no-repeat; padding-left: 20px;\">{$lang->convert_now}</a>";
}
else
{
|
$status = "<a href=\"index.php?module=tools-system_health&action=utf8_conversion&table={$tablename}\" style=\"background: url(styles/{$page->style}/images/icons/cross.gif) no-repeat; padding-left: 20px;\">{$lang->convert_now}</a>";
}
else
{
|
$status = "<img src=\"styles/{$page->style}/images/icons/tick.gif\" alt=\"{$lang->ok}\" />";
| $status = "<img src=\"styles/{$page->style}/images/icons/tick.gif\" alt=\"{$lang->ok}\" />";
}
if(version_compare($db_version, '5.5.3', '<'))
{
$utf8mb4 = $lang->not_available;
}
elseif($encodings[$key] == 'utf8mb4')
{
$utf8mb4 = "<img src=\"styles/{$page->style}/images/icons/tick.gif\" alt=\"{$lang->ok}\" />";
}
elseif($encodings[$key] == 'utf-8')
{
$utf8mb4 = "<a href=\"index.php?module=tools-system_health&action=utf8_conversion&table={$tablename}&mb4=1\" style=\"background: url(styles/{$page->style}/images/icons/cross.gif) no-repeat; padding-left: 20px;\">{$lang->convert_now}</a>";
}
else
{
$utf8mb4 = "-";
|
}
$table->construct_cell("<strong>{$tablename}</strong>");
$table->construct_cell($status, array("class" => "align_center", 'width' => '15%'));
|
}
$table->construct_cell("<strong>{$tablename}</strong>");
$table->construct_cell($status, array("class" => "align_center", 'width' => '15%'));
|
| | $table->construct_cell($utf8mb4, array("class" => "align_center", 'width' => '25%'));
|
$table->construct_row();
}
|
$table->construct_row();
}
|
$table->output("<div style=\"float: right; text-decoration: underline\"><small><a href=\"index.php?module=tools-system_health&action=utf8_conversion&do=all\">({$lang->convert_all})</a></small></div><div>{$lang->utf8_conversion}</div>");
| $table->output("<div>{$lang->utf8_conversion}</div>");
|
$page->output_footer();
}
|
$page->output_footer();
}
|