/** * Build HTML-Selectbox from saved SQL-Commands * * @param string $when Before backup = 0, After Backup =1 * @param integer $index Index of database * @return string HTML as string */ function getCommandDumpComboBox($when, $index, $db_name) { global $SQL_ARRAY, $databases, $lang; if (count($SQL_ARRAY) == 0) { if ($when == 0) { $r = '<input type="hidden" name="command_before_' . $index . '" value="" />'; } else { $r = '<input type="hidden" name="command_after_' . $index . '" value="" />'; } } else { if ($when == 0) { $r = '<select class="SQLCombo select noleftmargin" name="command_before_' . $index . '" />'; $csql = trim($databases[$db_name]['command_before_dump']); } else { $r = '<select class="SQLCombo select noleftmargin" name="command_after_' . $index . '" />'; $csql = trim($databases[$db_name]['command_after_dump']); } $r .= '<option value=""' . Html::getSelected($csql, '') . ' /> </option>' . "\n"; for ($i = 0; $i < count($SQL_ARRAY); $i++) { $s = trim(getQueryFromSqlLibrary($i)); $r .= '<option value="' . $i . '"'; $r .= Html::getSelected($s, $csql); $r .= '>' . getQueryNameFromSqlLibrary($i) . ' </option>' . "\n"; } $r .= '</select>'; } return $r; }
getSqlLibrary(); if (isset($_POST['save'])) { if (count($databases) > 0) { $i = 0; foreach ($databases as $dbName => $val) { $databases[$dbName]['prefix'] = ''; if (isset($_POST['dbpraefix_' . $i])) { $databases[$dbName]['prefix'] = $_POST['dbpraefix_' . $i]; } $databases[$dbName]['command_before_dump'] = ''; if (!empty($_POST['command_before_' . $i])) { $databases[$dbName]['command_before_dump'] = getQueryFromSqlLibrary($_POST['command_before_' . $i]); } $databases[$dbName]['command_after_dump'] = ''; if (!empty($_POST['command_after_' . $i])) { $databases[$dbName]['command_after_dump'] = getQueryFromSqlLibrary($_POST['command_after_' . $i]); } if (isset($_POST['db_multidump_' . $i]) && $_POST['db_multidump_' . $i] == "db_multidump_{$i}") { $databases[$dbName]['dump'] = 1; } else { $databases[$dbName]['dump'] = 0; } $i++; } } if ($config['dbhost'] != $_POST['dbhost'] || $config['dbuser'] != $_POST['dbuser'] || $config['dbpass'] != $_POST['dbpass'] || $config['dbport'] != $_POST['dbport'] || $config['dbsocket'] != $_POST['dbsocket']) { //neue Verbindungsparameter $blendInConnectionParams = true; //alte Parameter sichern $old['dbhost'] = $config['dbhost']; $old['dbuser'] = $config['dbuser'];