'; $html .= '

' . __('Export method:') . '

'; $html .= '

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

  ' . __('Tables:') . '

  '; } 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\libraries\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\libraries\Util::userDir($cfg['SaveDir'])) ); $html .= ''; $html .= '
'; $html .= '
• '; $html .= '%s'), htmlspecialchars(PMA\libraries\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 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\libraries\Util::getDocuLink('faq', 'faq6-27'); $msg->addParam( '', false ); $msg->addParam('', false); $html .= PMA\libraries\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"; $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"; } // Since separate files export works with ZIP only if (isset($cfg['Export']['as_separate_files']) && $cfg['Export']['as_separate_files'] ) { $selected_compression = "zip"; } $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 Checkbox - Separate files * * @param String $export_type Selected Export Type * * @return string */ function PMA_getHtmlForExportOptionsOutputSeparateFiles($export_type) { $html = '
• '; $html .= ''; $html .= ''; if ($export_type == 'server') { $html .= __('Export databases as separate files'); } elseif ($export_type == 'database') { $html .= __('Export tables as separate files'); } $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 .= '
• '; } elseif (isset($_GET['lock_tables'])) { $html .= ' checked="checked"'; } $html .= ''; $html .= sprintf(__('Use %s statement'), 'LOCK TABLES'); $html .= '
'; } $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(); if ($export_type == 'server' || $export_type == 'database' ) { $html .= PMA_getHtmlForExportOptionsOutputSeparateFiles($export_type); } $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 ExportPlugin[] $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_getHtmlForExportOptionsMethod(); $html .= PMA_getHtmlForExportOptionsFormatDropdown($export_list); $html .= PMA_getHtmlForExportOptionsSelection($export_type, $multi_values); $tableLength = mb_strlen($table); $_table = new Table($table, $db); if ($tableLength && empty($num_tables) && ! $_table->isMerge()) { $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; } /** * Gets HTML to display export dialogs * * @param String $export_type export type: server|database|table * @param String $db selected DB * @param String $table selected table * @param String $sql_query SQL query * @param Int $num_tables number of tables * @param Int $unlim_num_rows unlimited number of rows * @param String $multi_values selector options * * @return string $html */ function PMA_getExportDisplay( $export_type, $db, $table, $sql_query, $num_tables, $unlim_num_rows, $multi_values ) { $cfgRelation = PMA_getRelationsParam(); if (isset($_REQUEST['single_table'])) { $GLOBALS['single_table'] = $_REQUEST['single_table']; } include_once './libraries/file_listing.lib.php'; include_once './libraries/plugin_interface.lib.php'; include_once './libraries/display_export.lib.php'; /* Scan for plugins */ /* @var $export_list ExportPlugin[] */ $export_list = PMA_getPlugins( "export", 'libraries/plugins/export/', array( 'export_type' => $export_type, 'single_table' => isset($GLOBALS['single_table']) ) ); /* Fail if we didn't find any plugin */ if (empty($export_list)) { Message::error( __('Could not load export plugins, please check your installation!') )->display(); exit; } $html = PMA_getHtmlForExportOptionHeader($export_type, $db, $table); if ($cfgRelation['exporttemplateswork']) { $html .= PMA_getHtmlForExportTemplateLoading($export_type); } $html .= '
'; //output Hidden Inputs $single_table_str = isset($GLOBALS['single_table']) ? $GLOBALS['single_table'] : ''; $html .= PMA_getHtmlForHiddenInput( $export_type, $db, $table, $single_table_str, $sql_query ); //output Export Options $html .= PMA_getHtmlForExportOptions( $export_type, $db, $table, $multi_values, $num_tables, $export_list, $unlim_num_rows ); $html .= '
'; return $html; } /** * Handles export template actions * * @param array $cfgRelation Relation configuration * * @return void */ function PMA_handleExportTemplateActions($cfgRelation) { if (isset($_REQUEST['templateId'])) { $id = PMA\libraries\Util::sqlAddSlashes($_REQUEST['templateId']); } else { $id = ''; } $templateTable = PMA\libraries\Util::backquote($cfgRelation['db']) . '.' . PMA\libraries\Util::backquote($cfgRelation['export_templates']); $user = PMA\libraries\Util::sqlAddSlashes($GLOBALS['cfg']['Server']['user']); switch ($_REQUEST['templateAction']) { case 'create': $query = "INSERT INTO " . $templateTable . "(" . " `username`, `export_type`," . " `template_name`, `template_data`" . ") VALUES (" . "'" . $user . "', " . "'" . PMA\libraries\Util::sqlAddSlashes($_REQUEST['exportType']) . "', '" . PMA\libraries\Util::sqlAddSlashes($_REQUEST['templateName']) . "', '" . PMA\libraries\Util::sqlAddSlashes($_REQUEST['templateData']) . "');"; break; case 'load': $query = "SELECT `template_data` FROM " . $templateTable . " WHERE `id` = " . $id . " AND `username` = '" . $user . "'"; break; case 'update': $query = "UPDATE " . $templateTable . " SET `template_data` = " . "'" . PMA\libraries\Util::sqlAddSlashes($_REQUEST['templateData']) . "'" . " WHERE `id` = " . $id . " AND `username` = '" . $user . "'"; break; case 'delete': $query = "DELETE FROM " . $templateTable . " WHERE `id` = " . $id . " AND `username` = '" . $user . "'"; break; default: $query = ''; break; } $result = PMA_queryAsControlUser($query, false); $response = PMA\libraries\Response::getInstance(); if (! $result) { $error = $GLOBALS['dbi']->getError($GLOBALS['controllink']); $response->setRequestStatus(false); $response->addJSON('message', $error); exit; } $response->setRequestStatus(true); if ('create' == $_REQUEST['templateAction']) { $response->addJSON( 'data', PMA_getOptionsForExportTemplates($_REQUEST['exportType']) ); } elseif ('load' == $_REQUEST['templateAction']) { $data = null; while ($row = $GLOBALS['dbi']->fetchAssoc( $result, $GLOBALS['controllink'] )) { $data = $row['template_data']; } $response->addJSON('data', $data); } $GLOBALS['dbi']->freeResult($result); }