'; $html .= '

'; $html .= PMA_Util::getImage('b_export.png', __('Export')); if ($export_type == 'server') { $html .= __('Exporting databases from the current server'); } elseif ($export_type == 'database') { $html .= sprintf( __('Exporting tables from "%s" database'), htmlspecialchars($db) ); } else { $html .= sprintf( __('Exporting rows from "%s" table'), htmlspecialchars($table) ); } $html .= '

'; $html .= '

'; $html .= '

' . __('Export Method:') . '

'; $html .= '

'; $html .= '
• '; $html .= ''; } else if ($export_type == 'database') { $html .= '

  ' . __('Table(s):') . '

  '; } if (! empty($multi_values)) { $html .= $multi_values; } $html .= '

'; $html .= '

' . __('Format:') . '

'; $html .= PMA_pluginGetChoice('Export', 'what', $export_list, 'format'); $html .= '

'; $html .= '

' . __('Format-specific options:') . '

'; $html .= '

'; $html .= __( 'Scroll down to fill in the options for the selected format ' . 'and ignore the options for other formats.' ); $html .= '

'; $html .= PMA_pluginGetOptions('Export', $export_list); $html .= '

'; $html .= '

' . __('Encoding Conversion:') . '

'; $html .= PMA_Kanji_encodingForm(); $html .= '

'; $html .= PMA_Util::getExternalBug( __('SQL compatibility mode'), 'mysql', '50027', '14515' ); global $cfg; if ($cfg['ExecTimeLimit'] > 0) { $html .= ''; } else { // if the time limit set is zero, then time out won't occur // So no need to check for time out. $html .= ''; } $html .= '

'; $html .= '

' . __('Rows:') . '

'; $html .= '

'; $html .= '
• '; $html .= ''; $html .= '
  '; $html .= '
  • '; $html .= '' . __('Number of rows:') . ''; $html .= ''; $html .= '
  '; $html .= '
  • '; $html .= '' . __('Row to begin at:') . ''; $html .= ''; $html .= '
  '; $html .= '
  '; $html .= '
'; $html .= '
• '; $html .= ''; $html .= '
'; $html .= '

'; $html .= '

'; $html .= '

' . __('Output:') . '

'; $html .= '

'; $html .= '
• '; $html .= '%s'), htmlspecialchars(PMA_Util::userDir($cfg['SaveDir'])) ); $html .= ''; $html .= '
'; $html .= '
• '; $html .= '%s'), htmlspecialchars(PMA_Util::userDir($cfg['SaveDir'])) ); $html .= ''; $html .= '
'; $html .= '
• '; $html .= 'addMessage(__('@SERVER@ will become the server name')); if ($export_type == 'database' || $export_type == 'table') { $trans->addMessage(__(', @DATABASE@ will become the database name')); if ($export_type == 'table') { $trans->addMessage(__(', @TABLE@ will become the table name')); } } $msg = new PMA_Message( __( 'This value is interpreted using %1$sstrftime%2$s, ' . 'so you can use time formatting strings. ' . 'Additionally the following transformations will happen: %3$s. ' . 'Other text will be kept as is. See the %4$sFAQ%5$s for details.' ) ); $msg->addParam( '', false ); $msg->addParam('', false); $msg->addParam($trans); $doc_url = PMA_Util::getDocuLink('faq', 'faq6-27'); $msg->addParam( '', false ); $msg->addParam('', false); $html .= PMA_Util::showHint($msg); $html .= ''; $html .= 'getUserValue( 'pma_db_filename_template', $GLOBALS['cfg']['Export']['file_template_database'] ) ); } elseif ($export_type == 'table') { $html .= htmlspecialchars( $GLOBALS['PMA_Config']->getUserValue( 'pma_table_filename_template', $GLOBALS['cfg']['Export']['file_template_table'] ) ); } else { $html .= htmlspecialchars( $GLOBALS['PMA_Config']->getUserValue( 'pma_server_filename_template', $GLOBALS['cfg']['Export']['file_template_server'] ) ); } } $html .= '"'; $html .= '/>'; $html .= '' . "\n"; reset($cfg['AvailableCharsets']); $html .= ''; foreach ($cfg['AvailableCharsets'] as $temp_charset) { $html .= ''; } // end foreach $html .= '
'; return $html; } /** * Prints Html For Export Options Compression * * @return string */ function PMA_getHtmlForExportOptionsOutputCompression() { global $cfg; if (isset($_GET['compression'])) { $selected_compression = $_GET['compression']; } elseif (isset($cfg['Export']['compression'])) { $selected_compression = $cfg['Export']['compression']; } else { $selected_compression = "none"; } $html = ""; // zip and gzip encode features $is_zip = ($cfg['ZipDump'] && @function_exists('gzcompress')); $is_gzip = ($cfg['GZipDump'] && @function_exists('gzencode')); if ($is_zip || $is_gzip) { $html .= '
• '; $html .= '' . __('Compression:') . ''; $html .= ''; $html .= '' . __('None') . ''; if ($is_zip) { $html .= ''; } if ($is_gzip) { $html .= ''; } $html .= ''; $html .= '
'; } else { $html .= ''; } return $html; } /** * Prints Html For Export Options Radio * * @return string */ function PMA_getHtmlForExportOptionsOutputRadio() { $html = '
• '; $html .= '
'; return $html; } /** * Prints Html For Export Options * * @param String $export_type Selected Export Type * * @return string */ function PMA_getHtmlForExportOptionsOutput($export_type) { global $cfg; $html = '
'; $html .= '
' . __('Output:') . '
'; $html .= '
'; $html .= '
• '; $html .= '
  '; if (isset($cfg['SaveDir']) && !empty($cfg['SaveDir'])) { $html .= PMA_getHtmlForExportOptionsOutputSaveDir(); } $html .= PMA_getHtmlForExportOptionsOutputFormat($export_type); // charset of file if ($GLOBALS['PMA_recoding_engine'] != PMA_CHARSET_NONE) { $html .= PMA_getHtmlForExportOptionsOutputCharset(); } // end if $html .= PMA_getHtmlForExportOptionsOutputCompression(); $html .= '
  '; $html .= '
'; $html .= PMA_getHtmlForExportOptionsOutputRadio(); $html .= '
'; /* * @todo use sprintf() for better translatability, while keeping the * principle (for screen readers) */ $html .= '' . __('Skip tables larger than') . ''; $html .= '' . __('MiB'); $html .= '
'; return $html; } /** * Prints Html For Export Options * * @param String $export_type Selected Export Type * @param String $db Selected DB * @param String $table Selected Table * @param String $multi_values Export selection * @param String $num_tables number of tables * @param array $export_list Export List * @param String $unlim_num_rows Number of Rows * * @return string */ function PMA_getHtmlForExportOptions( $export_type, $db, $table, $multi_values, $num_tables, $export_list, $unlim_num_rows ) { global $cfg; $html = PMA_getHtmlForExportOptionHeader($export_type, $db, $table); $html .= PMA_getHtmlForExportOptionsMethod(); $html .= PMA_getHtmlForExportOptionsSelection($export_type, $multi_values); $tableLength = /*overload*/mb_strlen($table); if ($tableLength && empty($num_tables) && ! PMA_Table::isMerge($db, $table)) { $html .= PMA_getHtmlForExportOptionsRows($db, $table, $unlim_num_rows); } if (isset($cfg['SaveDir']) && !empty($cfg['SaveDir'])) { $html .= PMA_getHtmlForExportOptionsQuickExport(); } $html .= PMA_getHtmlForAliasModalDialog($db, $table); $html .= PMA_getHtmlForExportOptionsOutput($export_type); $html .= PMA_getHtmlForExportOptionsFormat($export_list); return $html; } /** * Prints Html For Alias Modal Dialog * * @param String $db Selected DB * @param String $table Selected Table * * @return string */ function PMA_getHtmlForAliasModalDialog($db = '', $table = '') { if (isset($_SESSION['tmpval']['aliases'])) { $aliases = $_SESSION['tmpval']['aliases']; } // In case of server export, the following list of // databases are not shown in the list. $dbs_not_allowed = array( 'information_schema', 'performance_schema', 'mysql' ); // Fetch Columns info // Server export does not have db set. $title = __('Rename exported databases/tables/columns'); if (empty($db)) { $databases = $GLOBALS['dbi']->getColumnsFull( null, null, null, $GLOBALS['userlink'] ); foreach ($dbs_not_allowed as $db) { unset($databases[$db]); } // Database export does not have table set. } elseif (empty($table)) { $tables = $GLOBALS['dbi']->getColumnsFull( $db, null, null, $GLOBALS['userlink'] ); $databases = array($db => $tables); // Table export } else { $columns = $GLOBALS['dbi']->getColumnsFull( $db, $table, null, $GLOBALS['userlink'] ); $databases = array( $db => array( $table => $columns ) ); } $html = '
'; $db_html = '' . __('Select database') . ': ' . ''; $table_html = '' . __('Select table') . ': '; $first_db = true; $table_input_html = $db_input_html = ''; foreach ($databases as $db => $tables) { $val = ''; if (!empty($aliases[$db]['alias'])) { $val = htmlspecialchars($aliases[$db]['alias']); } $db = htmlspecialchars($db); $name_attr = 'aliases[' . $db . '][alias]'; $id_attr = substr(md5($name_attr), 0, 12); $class = 'hide'; if ($first_db) { $first_db = false; $class = ''; $db_input_html = '' . __('New database name') . ': '; } $db_input_html .= ''; $db_html .= '' . $db . ''; $table_html .= ''; $table_html .= ''; $first_tbl = true; $col_html = ''; foreach ($tables as $table => $columns) { $val = ''; if (!empty($aliases[$db]['tables'][$table]['alias'])) { $val = htmlspecialchars($aliases[$db]['tables'][$table]['alias']); } $table = htmlspecialchars($table); $name_attr = 'aliases[' . $db . '][tables][' . $table . '][alias]'; $id_attr = substr(md5($name_attr), 0, 12); $class = 'hide'; if ($first_tbl) { $first_tbl = false; $class = ''; $table_input_html = '' . __('New table name') . ': '; } $table_input_html .= ''; $table_html .= '' . $table . ''; $col_html .= ''; $col_html .= '' . ''; $class = 'odd'; foreach ($columns as $column => $col_def) { $val = ''; if (!empty($aliases[$db]['tables'][$table]['columns'][$column])) { $val = htmlspecialchars( $aliases[$db]['tables'][$table]['columns'][$column] ); } $column = htmlspecialchars($column); $name_attr = 'aliases[' . $db . '][tables][' . $table . '][columns][' . $column . ']'; $id_attr = substr(md5($name_attr), 0, 12); $col_html .= ''; $col_html .= ''; $col_html .= ''; $col_html .= ''; $class = $class === 'odd' ? 'even' : 'odd'; } $col_html .= '
' . __('Old column name') . '	' . __('New column name') . '
' . $column . '
'; } $table_html .= ''; $table_html .= $table_input_html . '
---
' . $col_html . ''; } $db_html .= ''; $html .= $db_html; $html .= $db_input_html . '
---
'; $html .= $table_html; $html .= '
'; return $html; } ?>