From 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab Mon Sep 17 00:00:00 2001 From: Charles Cabergs Date: Mon, 27 Jul 2020 10:05:23 +0200 Subject: Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my familly --- .../libraries/classes/Display/Export.php | 825 --------------------- 1 file changed, 825 deletions(-) delete mode 100644 srcs/phpmyadmin/libraries/classes/Display/Export.php (limited to 'srcs/phpmyadmin/libraries/classes/Display/Export.php') diff --git a/srcs/phpmyadmin/libraries/classes/Display/Export.php b/srcs/phpmyadmin/libraries/classes/Display/Export.php deleted file mode 100644 index db02a5e..0000000 --- a/srcs/phpmyadmin/libraries/classes/Display/Export.php +++ /dev/null @@ -1,825 +0,0 @@ -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( - '' - ); - $msg->addParamHtml(''); - $msg->addParam($trans); - $docUrl = Util::getDocuLink('faq', 'faq6-27'); - $msg->addParamHtml( - '' - ); - $msg->addParamHtml(''); - - 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 = ''; - - $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 .= '' . $template->render([ - 'type' => '', - 'name' => '', - 'field' => 'aliases_new', - 'value' => '', - ]) . ''; - - return $result . '
' - . __('Defined aliases') - . '
'; - } - - /** - * Generate Html For Alias Modal Dialog - * - * @return string - */ - public function getHtmlForAliasModalDialog() - { - $title = __('Rename exported databases/tables/columns'); - - $html = '
'; - $html .= $this->getHtmlForCurrentAlias(); - $html .= $this->template->render('export/alias_add'); - - $html .= '
'; - 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 .= '
'; - - //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 .= '
'; - 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); - } -} -- cgit