/**
* Get HTML for "check all" check box with "with selected" dropdown
*
* @param string $pmaThemeImage pma theme image url
* @param string $text_dir url for text directory
* @param string $overhead_check overhead check
* @param boolean $db_is_system_schema whether database is information schema or not
* @param array $hidden_fields hidden fields
*
* @return string $html_output
*/
function PMA_getHtmlForCheckAllTables($pmaThemeImage, $text_dir, $overhead_check, $db_is_system_schema, $hidden_fields)
{
$html_output = '<div class="clearfloat">';
$html_output .= '<img class="selectallarrow" ' . 'src="' . $pmaThemeImage . 'arrow_' . $text_dir . '.png" ' . 'width="38" height="22" alt="' . __('With selected:') . '" />';
$html_output .= '<input type="checkbox" id="tablesForm_checkall" ' . 'class="checkall_box" title="' . __('Check All') . '" />';
$html_output .= '<label for="tablesForm_checkall">' . __('Check All') . '</label>';
if ($overhead_check != '') {
$html_output .= PMA_getHtmlForCheckTablesHavingOverheadlink($overhead_check);
}
$html_output .= '<select name="submit_mult" class="autosubmit" ' . 'style="margin: 0 3em 0 3em;">';
$html_output .= '<option value="' . __('With selected:') . '" selected="selected">' . __('With selected:') . '</option>' . "\n";
$html_output .= '<option value="export" >' . __('Export') . '</option>' . "\n";
$html_output .= '<option value="print" >' . __('Print view') . '</option>' . "\n";
if (!$db_is_system_schema && !$GLOBALS['cfg']['DisableMultiTableMaintenance']) {
$html_output .= '<option value="empty_tbl" >' . __('Empty') . '</option>' . "\n";
$html_output .= '<option value="drop_tbl" >' . __('Drop') . '</option>' . "\n";
$html_output .= '<option value="check_tbl" >' . __('Check table') . '</option>' . "\n";
if (!PMA_DRIZZLE) {
$html_output .= '<option value="optimize_tbl" >' . __('Optimize table') . '</option>' . "\n";
$html_output .= '<option value="repair_tbl" >' . __('Repair table') . '</option>' . "\n";
}
$html_output .= '<option value="analyze_tbl" >' . __('Analyze table') . '</option>' . "\n";
$html_output .= '<option value="add_prefix_tbl" >' . __('Add prefix to table') . '</option>' . "\n";
$html_output .= '<option value="replace_prefix_tbl" >' . __('Replace table prefix') . '</option>' . "\n";
$html_output .= '<option value="copy_tbl_change_prefix" >' . __('Copy table with prefix') . '</option>' . "\n";
}
$html_output .= '</select>' . implode("\n", $hidden_fields) . "\n";
$html_output .= '</div>';
return $html_output;
}
/**
* Get HTML for "check all" check box with "with selected" dropdown
*
* @param string $pmaThemeImage pma theme image url
* @param string $text_dir url for text directory
* @param string $overhead_check overhead check
* @param boolean $db_is_system_schema whether database is information schema or not
* @param array $hidden_fields hidden fields
*
* @return string $html_output
*/
function PMA_getHtmlForCheckAllTables($pmaThemeImage, $text_dir, $overhead_check, $db_is_system_schema, $hidden_fields)
{
$html_output = '<div class="clearfloat print_ignore">';
$html_output .= '<img class="selectallarrow" ' . 'src="' . $pmaThemeImage . 'arrow_' . $text_dir . '.png" ' . 'width="38" height="22" alt="' . __('With selected:') . '" />';
$html_output .= '<input type="checkbox" id="tablesForm_checkall" ' . 'class="checkall_box" title="' . __('Check All') . '" />';
$html_output .= '<label for="tablesForm_checkall">' . __('Check All') . '</label>';
if ($overhead_check != '') {
$html_output .= PMA_getHtmlForCheckTablesHavingOverheadlink($overhead_check);
}
$html_output .= '<select name="submit_mult" class="autosubmit" ' . 'style="margin: 0 3em 0 3em;">';
$html_output .= '<option value="' . __('With selected:') . '" selected="selected">' . __('With selected:') . '</option>' . "\n";
$html_output .= '<option value="show_create" >' . __('Show create') . '</option>' . "\n";
$html_output .= '<option value="export" >' . __('Export') . '</option>' . "\n";
if (!$db_is_system_schema && !$GLOBALS['cfg']['DisableMultiTableMaintenance']) {
$html_output .= '<optgroup label="' . __('Delete data or table') . '">';
$html_output .= '<option value="empty_tbl" >' . __('Empty') . '</option>' . "\n";
$html_output .= '<option value="drop_tbl" >' . __('Drop') . '</option>' . "\n";
$html_output .= '</optgroup>';
$html_output .= '<optgroup label="' . __('Table maintenance') . '">';
$html_output .= '<option value="analyze_tbl" >' . __('Analyze table') . '</option>' . "\n";
$html_output .= '<option value="check_tbl" >' . __('Check table') . '</option>' . "\n";
if (!PMA_DRIZZLE) {
$html_output .= '<option value="checksum_tbl" >' . __('Checksum table') . '</option>' . "\n";
$html_output .= '<option value="optimize_tbl" >' . __('Optimize table') . '</option>' . "\n";
$html_output .= '<option value="repair_tbl" >' . __('Repair table') . '</option>' . "\n";
}
$html_output .= '</optgroup>';
$html_output .= '<optgroup label="' . __('Prefix') . '">';
$html_output .= '<option value="add_prefix_tbl" >' . __('Add prefix to table') . '</option>' . "\n";
$html_output .= '<option value="replace_prefix_tbl" >' . __('Replace table prefix') . '</option>' . "\n";
$html_output .= '<option value="copy_tbl_change_prefix" >' . __('Copy table with prefix') . '</option>' . "\n";
$html_output .= '</optgroup>';
}
if (isset($GLOBALS['cfgRelation']['central_columnswork']) && $GLOBALS['cfgRelation']['central_columnswork']) {
$html_output .= '<optgroup label="' . __('Central columns') . '">';
$html_output .= '<option value="sync_unique_columns_central_list" >' . __('Add columns to central list') . '</option>' . "\n";
$html_output .= '<option value="delete_unique_columns_central_list" >' . __('Remove columns from central list') . '</option>' . "\n";
$html_output .= '<option value="make_consistent_with_central_list" >' . __('Make consistent with central list') . '</option>' . "\n";
$html_output .= '</optgroup>';
}
$html_output .= '</select>' . implode("\n", $hidden_fields) . "\n";
$html_output .= '</div>';
return $html_output;
}