コード例 #1
0
/**
 * 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, '') . ' />&nbsp;&nbsp;</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) . '&nbsp;</option>' . "\n";
        }
        $r .= '</select>';
    }
    return $r;
}
コード例 #2
0
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'];