/**
* Drop a sequence
*/
function doDrop($confirm, $msg = '')
{
global $data, $misc;
global $lang;
if (empty($_REQUEST['sequence']) && empty($_REQUEST['ma'])) {
doDefault($lang['strspecifysequencetodrop']);
exit;
}
if ($confirm) {
$misc->printTrail('sequence');
$misc->printTitle($lang['strdrop'], 'pg.sequence.drop');
$misc->printMsg($msg);
echo "<form action=\"sequences.php\" method=\"post\">\n";
//If multi drop
if (isset($_REQUEST['ma'])) {
foreach ($_REQUEST['ma'] as $v) {
$a = unserialize(htmlspecialchars_decode($v, ENT_QUOTES));
echo "<p>", sprintf($lang['strconfdropsequence'], $misc->printVal($a['sequence'])), "</p>\n";
printf('<input type="hidden" name="sequence[]" value="%s" />', htmlspecialchars($a['sequence']));
}
} else {
echo "<p>", sprintf($lang['strconfdropsequence'], $misc->printVal($_REQUEST['sequence'])), "</p>\n";
echo "<input type=\"hidden\" name=\"sequence\" value=\"", htmlspecialchars($_REQUEST['sequence']), "\" />\n";
}
echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$lang['strcascade']}</label></p>\n";
echo "<p><input type=\"hidden\" name=\"action\" value=\"drop\" />\n";
echo $misc->form;
echo "<input type=\"submit\" name=\"drop\" value=\"{$lang['strdrop']}\" />\n";
echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
echo "</form>\n";
} else {
if (is_array($_POST['sequence'])) {
$msg = '';
$status = $data->beginTransaction();
if ($status == 0) {
foreach ($_POST['sequence'] as $s) {
$status = $data->dropSequence($s, isset($_POST['cascade']));
if ($status == 0) {
$msg .= sprintf('%s: %s<br />', htmlentities($s), $lang['strsequencedropped']);
} else {
$data->endTransaction();
doDefault(sprintf('%s%s: %s<br />', $msg, htmlentities($s), $lang['strsequencedroppedbad']));
return;
}
}
}
if ($data->endTransaction() == 0) {
// Everything went fine, back to the Default page....
$_reload_browser = true;
doDefault($msg);
} else {
doDefault($lang['strsequencedroppedbad']);
}
} else {
$status = $data->dropSequence($_POST['sequence'], isset($_POST['cascade']));
if ($status == 0) {
$_reload_browser = true;
doDefault($lang['strsequencedropped']);
} else {
doDrop(true, $lang['strsequencedroppedbad']);
}
}
}
}
} else {
doSaveCreate();
}
break;
case 'create':
doCreate();
break;
case 'drop':
if (isset($_POST['drop'])) {
doDrop(false);
} else {
doDefault();
}
break;
case 'confirm_drop':
doDrop(true);
break;
case 'save_edit':
if (isset($_POST['cancel'])) {
doDefault();
} else {
doSaveEdit();
}
break;
case 'edit':
doEdit();
break;
case 'properties':
doProperties();
break;
default:
case 'alter':
doAlter();
break;
case 'save_alter':
if (isset($_POST['alter'])) {
doSaveAlter();
} else {
doDefault();
}
break;
case 'confirm_drop':
doDrop(true);
break;
case 'drop':
if (isset($_POST['drop'])) {
doDrop(false);
} else {
doDefault();
}
break;
case 'properties':
doProperties();
break;
case 'confchangepassword':
doChangePassword(true);
break;
case 'changepassword':
if (isset($_REQUEST['ok'])) {
doChangePassword(false);
} else {
doAccount();
