115 lines
4.9 KiB
PHP
115 lines
4.9 KiB
PHP
<?php
|
|
/* ----------------------------------------------------------------------
|
|
|
|
MyOOS [Dumper]
|
|
http://www.oos-shop.de/
|
|
|
|
Copyright (c) 2013 - 2022 by the MyOOS Development Team.
|
|
----------------------------------------------------------------------
|
|
Based on:
|
|
|
|
MySqlDumper
|
|
http://www.mysqldumper.de
|
|
|
|
Copyright (C)2004-2011 Daniel Schlichtholz (admin@mysqldumper.de)
|
|
----------------------------------------------------------------------
|
|
Released under the GNU General Public License
|
|
---------------------------------------------------------------------- */
|
|
|
|
if (!defined('MOD_VERSION')) {
|
|
exit('No direct access.');
|
|
}
|
|
|
|
function nl2null($string)
|
|
{
|
|
$search = ["\r", "\n"];
|
|
$replace = ['', ''];
|
|
|
|
return trim(str_replace($search, $replace, $string));
|
|
}
|
|
|
|
//SQL-Strings
|
|
if (!is_array($SQL_ARRAY)) {
|
|
$SQL_ARRAY = [];
|
|
}
|
|
|
|
echo $aus .= '<h4>'.$lang['L_SQL_BEFEHLE'].' ('.count($SQL_ARRAY).')</h4>';
|
|
echo '<a href="'.$params.'&sqlconfig=1&new=1">'.$lang['L_SQL_BEFEHLNEU'].'</a><br><br>';
|
|
|
|
if (isset($_POST['sqlnewupdate'])) {
|
|
$ind = count($SQL_ARRAY);
|
|
if (count($SQL_ARRAY) > 0) {
|
|
array_push($SQL_ARRAY, $_POST['sqlname'.$ind].'|'.$_POST['sqlstring'.$ind]);
|
|
} else {
|
|
$SQL_ARRAY[0] = htmlspecialchars($_POST['sqlname0'], ENT_COMPAT, 'UTF-8').'|'.$_POST['sqlstring0'];
|
|
}
|
|
WriteSQL();
|
|
echo '<p>'.$lang['L_SQL_BEFEHLSAVED1'].' \''.$_POST['sqlname'.$ind].'\' '.$lang['L_SQL_BEFEHLSAVED2'].'</p>';
|
|
}
|
|
echo '<form name="sqlform" action="sql.php" method="post">
|
|
<input type="hidden" name="context" value="1">
|
|
<input type="hidden" name="sqlconfig" value="1">
|
|
<input type="hidden" name="tablename" value="'.$tablename.'">
|
|
<input type="hidden" name="dbid" value="'.$dbid.'">';
|
|
echo '<table class="bdr" style="width:100%"><tr class="thead"><th>#</th><th>'.$lang['L_NAME'].'</th><th>SQL</th><th>'.$lang['L_COMMAND'].'</th></tr>';
|
|
|
|
$i = 0;
|
|
if (count($SQL_ARRAY) > 0) {
|
|
for ($i = 0; $i < count($SQL_ARRAY); ++$i) {
|
|
if (isset($_POST['sqlupdate'.$i])) {
|
|
echo '<tr><td colspan="4"><p class="success">'.$lang['L_SQL_BEFEHLSAVED1']
|
|
.' \''.htmlspecialchars($_POST['sqlname'.$i], ENT_COMPAT, 'UTF-8').'\' '.$lang['L_SQL_BEFEHLSAVED3'].'</p></td></tr>';
|
|
$SQL_ARRAY[$i] = $_POST['sqlname'.$i].'|'.nl2null($_POST['sqlstring'.$i]);
|
|
WriteSQL();
|
|
}
|
|
if (isset($_POST['sqlmove'.$i])) {
|
|
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 ('trenn' == $sqllib[$j]['sql']) {
|
|
if ($og) {
|
|
echo '</optgroup>';
|
|
}
|
|
echo '<optgroup label="'.$sqllib[$j]['name'].'">';
|
|
$og = true;
|
|
} else {
|
|
echo '<option value="'.$sqllib[$j]['sql'].'">'.$sqllib[$j]['name'].'</option>';
|
|
}
|
|
}
|
|
if ($og) {
|
|
echo '</optgroup>';
|
|
}
|
|
echo '</select></div></td>
|
|
<td><textarea rows="3" cols="40" name="sqlstring'.$i.'" id="sqlstring'.$i.'">SELECT * FROM</textarea></td>
|
|
<td><input class="Formbutton" style="width:80px;" type="submit" name="sqlnewupdate" value="save"></td></tr>';
|
|
}
|
|
echo '</table></form>';
|