Server IP : 85.214.239.14 / Your IP : 3.129.194.30 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/2/task/2/cwd/var/www/wordpress/phpMyAdmin/libraries/classes/Display/ |
Upload File : |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * functions for displaying server, database and table export * * @package PhpMyAdmin */ declare(strict_types=1); namespace PhpMyAdmin\Display; use PhpMyAdmin\Core; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Encoding; use PhpMyAdmin\Message; use PhpMyAdmin\Plugins; use PhpMyAdmin\Plugins\ExportPlugin; use PhpMyAdmin\Relation; use PhpMyAdmin\Response; use PhpMyAdmin\Table; use PhpMyAdmin\Template; use PhpMyAdmin\Util; use Throwable; use Twig_Error_Loader; use Twig_Error_Runtime; use Twig_Error_Syntax; /** * PhpMyAdmin\Display\Export class * * @package PhpMyAdmin */ class Export { /** * @var Relation */ private $relation; /** * @var Template */ public $template; /** * Constructor */ public function __construct() { $this->relation = new Relation($GLOBALS['dbi']); $this->template = new Template(); } /** * Outputs appropriate checked statement for checkbox. * * @param string $str option name * * @return boolean */ private function checkboxCheck($str) { return isset($GLOBALS['cfg']['Export'][$str]) && $GLOBALS['cfg']['Export'][$str]; } /** * Prints Html For Export Selection Options * * @param string $tmpSelect Tmp selected method of export * * @return string */ public function getHtmlForSelectOptions($tmpSelect = '') { // Check if the selected databases are defined in $_POST // (from clicking Back button on export.php) if (isset($_POST['db_select'])) { $_POST['db_select'] = urldecode($_POST['db_select']); $_POST['db_select'] = explode(",", $_POST['db_select']); } $databases = []; foreach ($GLOBALS['dblist']->databases as $currentDb) { if ($GLOBALS['dbi']->isSystemSchema($currentDb, true)) { continue; } $isSelected = false; if (isset($_POST['db_select'])) { if (in_array($currentDb, $_POST['db_select'])) { $isSelected = true; } } elseif (! empty($tmpSelect)) { if (mb_strpos( ' ' . $tmpSelect, '|' . $currentDb . '|' )) { $isSelected = true; } } else { $isSelected = true; } $databases[] = [ 'name' => $currentDb, 'is_selected' => $isSelected, ]; } return $this->template->render('display/export/select_options', [ 'databases' => $databases, ]); } /** * Prints Html For Export Hidden Input * * @param string $exportType Selected Export Type * @param string $db Selected DB * @param string $table Selected Table * @param string $singleTable Single Table * @param string $sqlQuery SQL Query * * @return string */ public function getHtmlForHiddenInputs( $exportType, $db, $table, $singleTable, $sqlQuery ) { global $cfg; // If the export method was not set, the default is quick if (isset($_POST['export_method'])) { $cfg['Export']['method'] = $_POST['export_method']; } elseif (! isset($cfg['Export']['method'])) { $cfg['Export']['method'] = 'quick'; } if (empty($sqlQuery) && isset($_POST['sql_query'])) { $sqlQuery = $_POST['sql_query']; } return $this->template->render('display/export/hidden_inputs', [ 'db' => $db, 'table' => $table, 'export_type' => $exportType, 'export_method' => $cfg['Export']['method'], 'single_table' => $singleTable, 'sql_query' => $sqlQuery, 'template_id' => isset($_POST['template_id']) ? $_POST['template_id'] : '', ]); } /** * Returns HTML for the options in template dropdown * * @param string $exportType export type - server, database, or table * * @return string HTML for the options in teplate dropdown */ private function getOptionsForTemplates($exportType) { // Get the relation settings $cfgRelation = $this->relation->getRelationsParam(); $query = "SELECT `id`, `template_name` FROM " . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['export_templates']) . " WHERE `username` = " . "'" . $GLOBALS['dbi']->escapeString($GLOBALS['cfg']['Server']['user']) . "' AND `export_type` = '" . $GLOBALS['dbi']->escapeString($exportType) . "'" . " ORDER BY `template_name`;"; $result = $this->relation->queryAsControlUser($query); $templates = []; if ($result !== false) { while ($row = $GLOBALS['dbi']->fetchAssoc($result, DatabaseInterface::CONNECT_CONTROL)) { $templates[] = [ 'name' => $row['template_name'], 'id' => $row['id'], ]; } } return $this->template->render('display/export/template_options', [ 'templates' => $templates, 'selected_template' => ! empty($_POST['template_id']) ? $_POST['template_id'] : null, ]); } /** * Prints Html For Export Options Method * * @return string */ private function getHtmlForOptionsMethod() { global $cfg; if (isset($_POST['quick_or_custom'])) { $exportMethod = $_POST['quick_or_custom']; } else { $exportMethod = $cfg['Export']['method']; } return $this->template->render('display/export/method', [ 'export_method' => $exportMethod, ]); } /** * Prints Html For Export Options Selection * * @param string $exportType Selected Export Type * @param string $multiValues Export Options * * @return string */ private function getHtmlForOptionsSelection($exportType, $multiValues) { return $this->template->render('display/export/selection', [ 'export_type' => $exportType, 'multi_values' => $multiValues, ]); } /** * Prints Html For Export Options Format dropdown * * @param ExportPlugin[] $exportList Export List * * @return string */ private function getHtmlForOptionsFormatDropdown($exportList) { $dropdown = Plugins::getChoice('Export', 'what', $exportList, 'format'); return $this->template->render('display/export/format_dropdown', [ 'dropdown' => $dropdown, ]); } /** * Prints Html For Export Options Format-specific options * * @param ExportPlugin[] $exportList Export List * * @return string */ private function getHtmlForOptionsFormat($exportList) { global $cfg; $options = Plugins::getOptions('Export', $exportList); return $this->template->render('display/export/options_format', [ 'options' => $options, 'can_convert_kanji' => Encoding::canConvertKanji(), 'exec_time_limit' => $cfg['ExecTimeLimit'], ]); } /** * Prints Html For Export Options Rows * * @param string $db Selected DB * @param string $table Selected Table * @param string $unlimNumRows Num of Rows * * @return string */ private function getHtmlForOptionsRows($db, $table, $unlimNumRows) { $tableObject = new Table($table, $db); $numberOfRows = $tableObject->countRecords(); return $this->template->render('display/export/options_rows', [ 'allrows' => isset($_POST['allrows']) ? $_POST['allrows'] : null, 'limit_to' => isset($_POST['limit_to']) ? $_POST['limit_to'] : null, 'limit_from' => isset($_POST['limit_from']) ? $_POST['limit_from'] : null, 'unlim_num_rows' => $unlimNumRows, 'number_of_rows' => $numberOfRows, ]); } /** * Prints Html For Export Options Quick Export * * @return string */ private function getHtmlForOptionsQuickExport() { global $cfg; $saveDir = Util::userDir($cfg['SaveDir']); $exportIsChecked = $this->checkboxCheck( 'quick_export_onserver' ); $exportOverwriteIsChecked = $this->checkboxCheck( 'quick_export_onserver_overwrite' ); return $this->template->render('display/export/options_quick_export', [ 'save_dir' => $saveDir, 'export_is_checked' => $exportIsChecked, 'export_overwrite_is_checked' => $exportOverwriteIsChecked, ]); } /** * Prints Html For Export Options Save Dir * * @return string */ private function getHtmlForOptionsOutputSaveDir() { global $cfg; $saveDir = Util::userDir($cfg['SaveDir']); $exportIsChecked = $this->checkboxCheck( 'onserver' ); $exportOverwriteIsChecked = $this->checkboxCheck( 'onserver_overwrite' ); return $this->template->render('display/export/options_output_save_dir', [ 'save_dir' => $saveDir, 'export_is_checked' => $exportIsChecked, 'export_overwrite_is_checked' => $exportOverwriteIsChecked, ]); } /** * Prints Html For Export Options * * @param string $exportType Selected Export Type * * @return string */ private function getHtmlForOptionsOutputFormat($exportType) { $trans = new Message(); $trans->addText(__('@SERVER@ will become the server name')); if ($exportType == 'database' || $exportType == 'table') { $trans->addText(__(', @DATABASE@ will become the database name')); if ($exportType == 'table') { $trans->addText(__(', @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->addParamHtml( '<a href="' . Core::linkURL(Core::getPHPDocLink('function.strftime.php')) . '" target="documentation" title="' . __('Documentation') . '">' ); $msg->addParamHtml('</a>'); $msg->addParam($trans); $docUrl = Util::getDocuLink('faq', 'faq6-27'); $msg->addParamHtml( '<a href="' . $docUrl . '" target="documentation">' ); $msg->addParamHtml('</a>'); if (isset($_POST['filename_template'])) { $filenameTemplate = $_POST['filename_template']; } else { if ($exportType == 'database') { $filenameTemplate = $GLOBALS['PMA_Config']->getUserValue( 'pma_db_filename_template', $GLOBALS['cfg']['Export']['file_template_database'] ); } elseif ($exportType == 'table') { $filenameTemplate = $GLOBALS['PMA_Config']->getUserValue( 'pma_table_filename_template', $GLOBALS['cfg']['Export']['file_template_table'] ); } else { $filenameTemplate = $GLOBALS['PMA_Config']->getUserValue( 'pma_server_filename_template', $GLOBALS['cfg']['Export']['file_template_server'] ); } } return $this->template->render('display/export/options_output_format', [ 'message' => $msg->getMessage(), 'filename_template' => $filenameTemplate, 'is_checked' => $this->checkboxCheck('remember_file_template'), ]); } /** * Prints Html For Export Options Charset * * @return string */ private function getHtmlForOptionsOutputCharset() { global $cfg; return $this->template->render('display/export/options_output_charset', [ 'encodings' => Encoding::listEncodings(), 'export_charset' => $cfg['Export']['charset'], ]); } /** * Prints Html For Export Options Compression * * @return string */ private function getHtmlForOptionsOutputCompression() { global $cfg; if (isset($_POST['compression'])) { $selectedCompression = $_POST['compression']; } elseif (isset($cfg['Export']['compression'])) { $selectedCompression = $cfg['Export']['compression']; } else { $selectedCompression = 'none'; } // Since separate files export works with ZIP only if (isset($cfg['Export']['as_separate_files']) && $cfg['Export']['as_separate_files'] ) { $selectedCompression = 'zip'; } // zip and gzip encode features $isZip = ($cfg['ZipDump'] && function_exists('gzcompress')); $isGzip = ($cfg['GZipDump'] && function_exists('gzencode')); return $this->template->render('display/export/options_output_compression', [ 'is_zip' => $isZip, 'is_gzip' => $isGzip, 'selected_compression' => $selectedCompression, ]); } /** * Prints Html For Export Options Radio * * @return string */ private function getHtmlForOptionsOutputRadio() { return $this->template->render('display/export/options_output_radio', [ 'has_repopulate' => isset($_POST['repopulate']), 'export_asfile' => $GLOBALS['cfg']['Export']['asfile'], ]); } /** * Prints Html For Export Options Checkbox - Separate files * * @param string $exportType Selected Export Type * * @return string */ private function getHtmlForOptionsOutputSeparateFiles($exportType) { $isChecked = $this->checkboxCheck('as_separate_files'); return $this->template->render('display/export/options_output_separate_files', [ 'is_checked' => $isChecked, 'export_type' => $exportType, ]); } /** * Prints Html For Export Options * * @param string $exportType Selected Export Type * * @return string */ private function getHtmlForOptionsOutput($exportType) { global $cfg; $hasAliases = isset($_SESSION['tmpval']['aliases']) && ! Core::emptyRecursive($_SESSION['tmpval']['aliases']); unset($_SESSION['tmpval']['aliases']); $isCheckedLockTables = $this->checkboxCheck('lock_tables'); $isCheckedAsfile = $this->checkboxCheck('asfile'); $optionsOutputSaveDir = ''; if (isset($cfg['SaveDir']) && ! empty($cfg['SaveDir'])) { $optionsOutputSaveDir = $this->getHtmlForOptionsOutputSaveDir(); } $optionsOutputFormat = $this->getHtmlForOptionsOutputFormat($exportType); $optionsOutputCharset = ''; if (Encoding::isSupported()) { $optionsOutputCharset = $this->getHtmlForOptionsOutputCharset(); } $optionsOutputCompression = $this->getHtmlForOptionsOutputCompression(); $optionsOutputSeparateFiles = ''; if ($exportType == 'server' || $exportType == 'database') { $optionsOutputSeparateFiles = $this->getHtmlForOptionsOutputSeparateFiles( $exportType ); } $optionsOutputRadio = $this->getHtmlForOptionsOutputRadio(); return $this->template->render('display/export/options_output', [ 'has_aliases' => $hasAliases, 'export_type' => $exportType, 'is_checked_lock_tables' => $isCheckedLockTables, 'is_checked_asfile' => $isCheckedAsfile, 'repopulate' => isset($_POST['repopulate']), 'lock_tables' => isset($_POST['lock_tables']), 'save_dir' => isset($cfg['SaveDir']) ? $cfg['SaveDir'] : null, 'is_encoding_supported' => Encoding::isSupported(), 'options_output_save_dir' => $optionsOutputSaveDir, 'options_output_format' => $optionsOutputFormat, 'options_output_charset' => $optionsOutputCharset, 'options_output_compression' => $optionsOutputCompression, 'options_output_separate_files' => $optionsOutputSeparateFiles, 'options_output_radio' => $optionsOutputRadio, ]); } /** * Prints Html For Export Options * * @param string $exportType Selected Export Type * @param string $db Selected DB * @param string $table Selected Table * @param string $multiValues Export selection * @param string $numTables number of tables * @param ExportPlugin[] $exportList Export List * @param string $unlimNumRows Number of Rows * * @return string */ public function getHtmlForOptions( $exportType, $db, $table, $multiValues, $numTables, $exportList, $unlimNumRows ) { global $cfg; $html = $this->getHtmlForOptionsMethod(); $html .= $this->getHtmlForOptionsFormatDropdown($exportList); $html .= $this->getHtmlForOptionsSelection($exportType, $multiValues); $tableObject = new Table($table, $db); if (strlen($table) > 0 && empty($numTables) && ! $tableObject->isMerge()) { $html .= $this->getHtmlForOptionsRows($db, $table, $unlimNumRows); } if (isset($cfg['SaveDir']) && ! empty($cfg['SaveDir'])) { $html .= $this->getHtmlForOptionsQuickExport(); } $html .= $this->getHtmlForAliasModalDialog(); $html .= $this->getHtmlForOptionsOutput($exportType); $html .= $this->getHtmlForOptionsFormat($exportList); return $html; } /** * Generate Html For currently defined aliases * * @return string * @throws Throwable * @throws Twig_Error_Loader * @throws Twig_Error_Runtime * @throws Twig_Error_Syntax */ private function getHtmlForCurrentAlias() { $result = '<table id="alias_data"><thead><tr><th colspan="4">' . __('Defined aliases') . '</th></tr></thead><tbody>'; $template = $this->template->load('export/alias_item'); if (isset($_SESSION['tmpval']['aliases'])) { foreach ($_SESSION['tmpval']['aliases'] as $db => $dbData) { if (isset($dbData['alias'])) { $result .= $template->render([ 'type' => _pgettext('Alias', 'Database'), 'name' => $db, 'field' => 'aliases[' . $db . '][alias]', 'value' => $dbData['alias'], ]); } if (! isset($dbData['tables'])) { continue; } foreach ($dbData['tables'] as $table => $tableData) { if (isset($tableData['alias'])) { $result .= $template->render([ 'type' => _pgettext('Alias', 'Table'), 'name' => $db . '.' . $table, 'field' => 'aliases[' . $db . '][tables][' . $table . '][alias]', 'value' => $tableData['alias'], ]); } if (! isset($tableData['columns'])) { continue; } foreach ($tableData['columns'] as $column => $columnName) { $result .= $template->render([ 'type' => _pgettext('Alias', 'Column'), 'name' => $db . '.' . $table . '.' . $column, 'field' => 'aliases[' . $db . '][tables][' . $table . '][colums][' . $column . ']', 'value' => $columnName, ]); } } } } // Empty row for javascript manipulations $result .= '</tbody><tfoot class="hide">' . $template->render([ 'type' => '', 'name' => '', 'field' => 'aliases_new', 'value' => '', ]) . '</tfoot>'; return $result . '</table>'; } /** * Generate Html For Alias Modal Dialog * * @return string */ public function getHtmlForAliasModalDialog() { $title = __('Rename exported databases/tables/columns'); $html = '<div id="alias_modal" class="hide" title="' . $title . '">'; $html .= $this->getHtmlForCurrentAlias(); $html .= $this->template->render('export/alias_add'); $html .= '</div>'; return $html; } /** * Gets HTML to display export dialogs * * @param string $exportType export type: server|database|table * @param string $db selected DB * @param string $table selected table * @param string $sqlQuery SQL query * @param int $numTables number of tables * @param int $unlimNumRows unlimited number of rows * @param string $multiValues selector options * * @return string */ public function getDisplay( $exportType, $db, $table, $sqlQuery, $numTables, $unlimNumRows, $multiValues ) { $cfgRelation = $this->relation->getRelationsParam(); if (isset($_POST['single_table'])) { $GLOBALS['single_table'] = $_POST['single_table']; } // Export a single table if (isset($_GET['single_table'])) { $GLOBALS['single_table'] = $_GET['single_table']; } /* Scan for plugins */ /** @var ExportPlugin[] $exportList */ $exportList = Plugins::getPlugins( "export", 'libraries/classes/Plugins/Export/', [ 'export_type' => $exportType, 'single_table' => isset($GLOBALS['single_table']), ] ); /* Fail if we didn't find any plugin */ if (empty($exportList)) { Message::error( __('Could not load export plugins, please check your installation!') )->display(); exit; } $html = $this->template->render('display/export/option_header', [ 'export_type' => $exportType, 'db' => $db, 'table' => $table, ]); if ($cfgRelation['exporttemplateswork']) { $html .= $this->template->render('display/export/template_loading', [ 'options' => $this->getOptionsForTemplates($exportType), ]); } $html .= '<form method="post" action="export.php" ' . ' name="dump" class="disableAjax">'; //output Hidden Inputs $singleTableStr = isset($GLOBALS['single_table']) ? $GLOBALS['single_table'] : ''; $html .= $this->getHtmlForHiddenInputs( $exportType, $db, $table, $singleTableStr, $sqlQuery ); //output Export Options $html .= $this->getHtmlForOptions( $exportType, $db, $table, $multiValues, $numTables, $exportList, $unlimNumRows ); $html .= '</form>'; return $html; } /** * Handles export template actions * * @param array $cfgRelation Relation configuration * * @return void */ public function handleTemplateActions(array $cfgRelation) { if (isset($_POST['templateId'])) { $id = $GLOBALS['dbi']->escapeString($_POST['templateId']); } else { $id = ''; } $templateTable = Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['export_templates']); $user = $GLOBALS['dbi']->escapeString($GLOBALS['cfg']['Server']['user']); switch ($_POST['templateAction']) { case 'create': $query = "INSERT INTO " . $templateTable . "(" . " `username`, `export_type`," . " `template_name`, `template_data`" . ") VALUES (" . "'" . $user . "', " . "'" . $GLOBALS['dbi']->escapeString($_POST['exportType']) . "', '" . $GLOBALS['dbi']->escapeString($_POST['templateName']) . "', '" . $GLOBALS['dbi']->escapeString($_POST['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` = " . "'" . $GLOBALS['dbi']->escapeString($_POST['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 = $this->relation->queryAsControlUser($query, false); $response = Response::getInstance(); if (! $result) { $error = $GLOBALS['dbi']->getError(DatabaseInterface::CONNECT_CONTROL); $response->setRequestStatus(false); $response->addJSON('message', $error); exit; } $response->setRequestStatus(true); if ('create' == $_POST['templateAction']) { $response->addJSON( 'data', $this->getOptionsForTemplates($_POST['exportType']) ); } elseif ('load' == $_POST['templateAction']) { $data = null; while ($row = $GLOBALS['dbi']->fetchAssoc( $result, DatabaseInterface::CONNECT_CONTROL )) { $data = $row['template_data']; } $response->addJSON('data', $data); } $GLOBALS['dbi']->freeResult($result); } }