Ejemplo n.º 1
0
function ComboCommandDump($when, $index)
{
    global $SQL_ARRAY, $nl, $databases, $lang;
    if (count($SQL_ARRAY) == 0) {
        $r = '<a href="sql.php?context=1" class="uls">' . $lang['sql_befehle'] . '</a>';
        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" name="command_before_' . $index . '">';
            $csql = $databases['command_before_dump'][$index];
        } else {
            $r = '<select class="SQLCombo" name="command_after_' . $index . '">';
            $csql = $databases['command_after_dump'][$index];
        }
        $r .= '<option value="" ' . ($csql == "" ? "selected" : "") . '>&nbsp;</option>';
        if (count($SQL_ARRAY) > 0) {
            for ($i = 0; $i < count($SQL_ARRAY); $i++) {
                $s = str_replace('"', "'", SQL_String($i));
                $r .= '<option value="' . $s . '" ' . ($csql == $s ? "selected" : "") . '>' . SQL_Name($i) . '</option>' . $nl;
            }
        }
        $r .= '</select>';
    }
    return $r;
}
Ejemplo n.º 2
0
function ComboCommandDump($when, $index)
{
    global $SQL_ARRAY, $nl, $databases, $lang;
    if (count($SQL_ARRAY) == 0) {
        $r = '<a href="sql.php?context=1" class="uls">' . $lang['L_SQL_BEFEHLE'] . '</a>';
        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" name="command_before_' . $index . '">';
            $csql = $databases['command_before_dump'][$index];
        } else {
            $r = '<select class="SQLCombo" name="command_after_' . $index . '">';
            $csql = $databases['command_after_dump'][$index];
        }
        $r .= '<option value="" ' . ($csql == '' ? ' selected="selected"' : '') . '>&nbsp;</option>' . "\n";
        if (count($SQL_ARRAY) > 0) {
            for ($i = 0; $i < count($SQL_ARRAY); $i++) {
                $s = trim(SQL_String($i));
                $r .= '<option value="' . htmlspecialchars($s) . '" ' . ($csql == $s ? ' selected="selected"' : '') . '>' . SQL_Name($i) . '</option>' . "\n";
            }
        }
        $r .= '</select>';
    }
    return $r;
}
Ejemplo n.º 3
0
            echo '<tr><td colspan="4"><p class="success">' . $lang['L_SQL_BEFEHLSAVED1'] . ' \'' . $_POST['sqlname' . $i] . '\' ' . $lang['L_SQL_BEFEHLSAVED4'] . '</p></td></tr>';
            $a[] = $SQL_ARRAY[$i];
            array_splice($SQL_ARRAY, $i, 1);
            $SQL_ARRAY = array_merge($a, $SQL_ARRAY);
            WriteSQL();
        }
        if (isset($_POST['sqldelete' . $i])) {
            echo '<tr><td colspan="4"><p class="success">' . $lang['L_SQL_BEFEHLSAVED1'] . ' \'' . $_POST['sqlname' . $i] . '\' ' . $lang['L_SQL_BEFEHLSAVED5'] . '</p></td></tr>';
            array_splice($SQL_ARRAY, $i, 1);
            WriteSQL();
        }
    }
    for ($i = 0; $i < count($SQL_ARRAY); $i++) {
        $cl = $i % 2 ? "dbrow" : "dbrow1";
        echo '<tr class="' . $cl . '"><td>' . ($i + 1) . '.</td><td>';
        echo '<input type="text" class="text" name="sqlname' . $i . '" value="' . htmlspecialchars(SQL_Name($i), ENT_COMPAT, 'UTF-8') . '"></td>';
        echo '<td><textarea rows="4" cols="80" style="width:100%;" name="sqlstring' . $i . '">' . stripslashes(SQL_String($i)) . '</textarea></td>';
        echo '<td><input class="Formbutton" style="width:80px;" type="submit" name="sqlupdate' . $i . '" value="save"><br>
			<input class="Formbutton" style="width:80px;" type="submit" name="sqlmove' . $i . '" value="move up"><br>
			<input class="Formbutton" style="width:80px;"  type="submit" name="sqldelete' . $i . '" value="delete"></td></tr>';
    }
}
if (isset($_GET['new'])) {
    $cl = $i % 2 ? "dbrow" : "dbrow1";
    echo '<tr class="' . $cl . '"><td>' . ($i + 1) . '</td><td>';
    echo '<input type="text" class="text" name="sqlname' . $i . '" id="sqlname' . $i . '" value="SQL ' . ($i + 1) . '"><br><div class="small" align="center">' . $lang['L_SQL_LIBRARY'] . '<br>';
    echo '<select id="sqllib" name="sqllib" onChange="InsertLib(' . $i . ');" class="small">';
    echo '<option value=""></option>';
    $og = false;
    for ($j = 0; $j < count($sqllib); $j++) {
        if ($sqllib[$j]['sql'] == "trenn") {
Ejemplo n.º 4
0
                echo '<p class="success">' . $lang['sql_befehlsaved1'] . ' \'' . $_POST['sqlname' . $i] . '\' ' . $lang['sql_befehlsaved4'] . '</p>';
                $a[] = $SQL_ARRAY[$i];
                array_splice($SQL_ARRAY, $i, 1);
                $SQL_ARRAY = array_merge($a, $SQL_ARRAY);
                WriteSQL();
            }
            if (isset($_POST['sqldelete' . $i])) {
                echo '<p class="success">' . $lang['sql_befehlsaved1'] . ' \'' . $_POST['sqlname' . $i] . '\' ' . $lang['sql_befehlsaved5'] . '</p>';
                array_splice($SQL_ARRAY, $i, 1);
                WriteSQL();
            }
        }
        for ($i = 0; $i < count($SQL_ARRAY); $i++) {
            $cl = $i % 2 ? "dbrow" : "dbrow1";
            echo '<tr class="' . $cl . '"><td>' . ($i + 1) . '</td><td>';
            echo '<input type="text" class="text" name="sqlname' . $i . '" value="' . SQL_Name($i) . '"></td>';
            echo '<td><textarea rows="3" cols="40" name="sqlstring' . $i . '">' . stripslashes(SQL_String($i)) . '</textarea></td>';
            echo '<td><input class="SQLbutton" style="width:80px;" type="submit" name="sqlupdate' . $i . '" value="save"><br>
			<input class="SQLbutton" style="width:80px;" type="submit" name="sqlmove' . $i . '" value="move up"><br>
			<input class="SQLbutton" style="width:80px;"  type="submit" name="sqldelete' . $i . '" value="delete"></td></tr>';
        }
    }
    if (isset($_GET['new'])) {
        $cl = $i % 2 ? "dbrow" : "dbrow1";
        echo '<tr class="' . $cl . '"><td>' . ($i + 1) . '</td><td>';
        echo '<input type="text" class="text" name="sqlname' . $i . '" id="sqlname' . $i . '" value="SQL ' . ($i + 1) . '"><br><div class="small" align="center">' . $lang['sql_library'] . '<br>';
        echo '<select id="sqllib" name="sqllib" onChange="InsertLib(' . $i . ');" class="small">';
        echo '<option value=""></option>';
        $og = false;
        for ($j = 0; $j < count($sqllib); $j++) {
            if ($sqllib[$j]['sql'] == "trenn") {