Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

729 lines (643 sloc) 23.978 kb
<?php
/**
* Manage sequences in a database
*
* $Id: sequences.php,v 1.49 2007/12/15 22:21:54 ioguix Exp $
*/
// Include application functions
include_once('./libraries/lib.inc.php');
$action = (isset($_REQUEST['action'])) ? $_REQUEST['action'] : '';
if (!isset($msg)) $msg = '';
/**
* Display list of all sequences in the database/schema
*/
function doDefault($msg = '') {
global $data, $conf, $misc;
global $lang;
$misc->printTrail('schema');
$misc->printTabs('schema', 'sequences');
$misc->printMsg($msg);
// Get all sequences
$sequences = $data->getSequences();
$columns = array(
'sequence' => array(
'title' => $lang['strsequence'],
'field' => field('seqname'),
'url' => "sequences.php?action=properties&amp;{$misc->href}&amp;",
'vars' => array('sequence' => 'seqname'),
),
'owner' => array(
'title' => $lang['strowner'],
'field' => field('seqowner'),
),
'actions' => array(
'title' => $lang['stractions'],
),
'comment' => array(
'title' => $lang['strcomment'],
'field' => field('seqcomment'),
),
);
$actions = array(
'multiactions' => array(
'keycols' => array('sequence' => 'seqname'),
'url' => 'sequences.php',
),
'alter' => array(
'content' => $lang['stralter'],
'attr'=> array (
'href' => array (
'url' => 'sequences.php',
'urlvars' => array (
'action' => 'confirm_alter',
'subject' => 'sequence',
'sequence' => field('seqname')
)
)
)
),
'drop' => array(
'content' => $lang['strdrop'],
'attr'=> array (
'href' => array (
'url' => 'sequences.php',
'urlvars' => array (
'action' => 'confirm_drop',
'sequence' => field('seqname')
)
)
),
'multiaction' => 'confirm_drop',
),
'privileges' => array(
'content' => $lang['strprivileges'],
'attr'=> array (
'href' => array (
'url' => 'privileges.php',
'urlvars' => array (
'subject' => 'sequence',
'sequence' => field('seqname')
)
)
)
),
);
$misc->printTable($sequences, $columns, $actions, 'sequences-sequences', $lang['strnosequences']);
$misc->printNavLinks(array ('create' => array (
'attr'=> array (
'href' => array (
'url' => 'sequences.php',
'urlvars' => array (
'action' => 'create',
'server' => $_REQUEST['server'],
'database' => $_REQUEST['database'],
'schema' => $_REQUEST['schema']
)
)
),
'content' => $lang['strcreatesequence']
)), 'sequences-sequences', get_defined_vars());
}
/**
* Generate XML for the browser tree.
*/
function doTree() {
global $misc, $data;
$sequences = $data->getSequences();
$reqvars = $misc->getRequestVars('sequence');
$attrs = array(
'text' => field('seqname'),
'icon' => 'Sequence',
'toolTip'=> field('seqcomment'),
'action' => url('sequences.php',
$reqvars,
array (
'action' => 'properties',
'sequence' => field('seqname')
)
)
);
$misc->printTree($sequences, $attrs, 'sequences');
exit;
}
/**
* Display the properties of a sequence
*/
function doProperties($msg = '') {
global $data, $misc;
global $lang;
$misc->printTrail('sequence');
$misc->printTitle($lang['strproperties'],'pg.sequence');
$misc->printMsg($msg);
// Fetch the sequence information
$sequence = $data->getSequence($_REQUEST['sequence']);
if (is_object($sequence) && $sequence->recordCount() > 0) {
$sequence->fields['is_cycled'] = $data->phpBool($sequence->fields['is_cycled']);
$sequence->fields['is_called'] = $data->phpBool($sequence->fields['is_called']);
// Show comment if any
if ($sequence->fields['seqcomment'] !== null)
echo "<p class=\"comment\">", $misc->printVal($sequence->fields['seqcomment']), "</p>\n";
echo "<table border=\"0\">";
echo "<tr><th class=\"data\">{$lang['strname']}</th>";
if ($data->hasAlterSequenceStart()) {
echo "<th class=\"data\">{$lang['strstartvalue']}</th>";
}
echo "<th class=\"data\">{$lang['strlastvalue']}</th>";
echo "<th class=\"data\">{$lang['strincrementby']}</th>";
echo "<th class=\"data\">{$lang['strmaxvalue']}</th>";
echo "<th class=\"data\">{$lang['strminvalue']}</th>";
echo "<th class=\"data\">{$lang['strcachevalue']}</th>";
echo "<th class=\"data\">{$lang['strlogcount']}</th>";
echo "<th class=\"data\">{$lang['strcancycle']}</th>";
echo "<th class=\"data\">{$lang['striscalled']}</th></tr>";
echo "<tr>";
echo "<td class=\"data1\">", $misc->printVal($sequence->fields['seqname']), "</td>";
if ($data->hasAlterSequenceStart()) {
echo "<td class=\"data1\">", $misc->printVal($sequence->fields['start_value']), "</td>";
}
echo "<td class=\"data1\">", $misc->printVal($sequence->fields['last_value']), "</td>";
echo "<td class=\"data1\">", $misc->printVal($sequence->fields['increment_by']), "</td>";
echo "<td class=\"data1\">", $misc->printVal($sequence->fields['max_value']), "</td>";
echo "<td class=\"data1\">", $misc->printVal($sequence->fields['min_value']), "</td>";
echo "<td class=\"data1\">", $misc->printVal($sequence->fields['cache_value']), "</td>";
echo "<td class=\"data1\">", $misc->printVal($sequence->fields['log_cnt']), "</td>";
echo "<td class=\"data1\">", ($sequence->fields['is_cycled'] ? $lang['stryes'] : $lang['strno']), "</td>";
echo "<td class=\"data1\">", ($sequence->fields['is_called'] ? $lang['stryes'] : $lang['strno']), "</td>";
echo "</tr>";
echo "</table>";
$navlinks = array (
'alter' => array (
'attr'=> array (
'href' => array (
'url' => 'sequences.php',
'urlvars' => array (
'action' => 'confirm_alter',
'server' => $_REQUEST['server'],
'database' => $_REQUEST['database'],
'schema' => $_REQUEST['schema'],
'sequence' => $sequence->fields['seqname']
)
)
),
'content' => $lang['stralter']
),
'setval' => array (
'attr'=> array (
'href' => array (
'url' => 'sequences.php',
'urlvars' => array (
'action' => 'confirm_setval',
'server' => $_REQUEST['server'],
'database' => $_REQUEST['database'],
'schema' => $_REQUEST['schema'],
'sequence' => $sequence->fields['seqname']
)
)
),
'content' => $lang['strsetval']
),
'nextval' => array (
'attr'=> array (
'href' => array (
'url' => 'sequences.php',
'urlvars' => array (
'action' => 'nextval',
'server' => $_REQUEST['server'],
'database' => $_REQUEST['database'],
'schema' => $_REQUEST['schema'],
'sequence' => $sequence->fields['seqname']
)
)
),
'content' => $lang['strnextval']
),
'restart' => array (
'attr'=> array (
'href' => array (
'url' => 'sequences.php',
'urlvars' => array (
'action' => 'restart',
'server' => $_REQUEST['server'],
'database' => $_REQUEST['database'],
'schema' => $_REQUEST['schema'],
'sequence' => $sequence->fields['seqname']
)
)
),
'content' => $lang['strrestart']
),
'reset' => array (
'attr'=> array (
'href' => array (
'url' => 'sequences.php',
'urlvars' => array (
'action' => 'reset',
'server' => $_REQUEST['server'],
'database' => $_REQUEST['database'],
'schema' => $_REQUEST['schema'],
'sequence' => $sequence->fields['seqname']
)
)
),
'content' => $lang['strreset']
),
'showall' => array (
'attr'=> array (
'href' => array (
'url' => 'sequences.php',
'urlvars' => array (
'server' => $_REQUEST['server'],
'database' => $_REQUEST['database'],
'schema' => $_REQUEST['schema']
)
)
),
'content' => $lang['strshowallsequences']
)
);
if (! $data->hasAlterSequenceStart())
unset($navlinks['restart']);
$misc->printNavLinks($navlinks, 'sequences-properties', get_defined_vars());
}
else echo "<p>{$lang['strnodata']}</p>\n";
}
/**
* 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, ENT_QUOTES, 'UTF-8'), $lang['strsequencedropped']);
else {
$data->endTransaction();
doDefault(sprintf('%s%s: %s<br />', $msg, htmlentities($s, ENT_QUOTES, 'UTF-8'), $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']);
}
}
}
/**
* Displays a screen where they can enter a new sequence
*/
function doCreateSequence($msg = '') {
global $data, $misc;
global $lang;
if (!isset($_POST['formSequenceName'])) $_POST['formSequenceName'] = '';
if (!isset($_POST['formIncrement'])) $_POST['formIncrement'] = '';
if (!isset($_POST['formMinValue'])) $_POST['formMinValue'] = '';
if (!isset($_POST['formMaxValue'])) $_POST['formMaxValue'] = '';
if (!isset($_POST['formStartValue'])) $_POST['formStartValue'] = '';
if (!isset($_POST['formCacheValue'])) $_POST['formCacheValue'] = '';
$misc->printTrail('schema');
$misc->printTitle($lang['strcreatesequence'],'pg.sequence.create');
$misc->printMsg($msg);
echo "<form action=\"sequences.php\" method=\"post\">\n";
echo "<table>\n";
echo "<tr><th class=\"data left required\">{$lang['strname']}</th>\n";
echo "<td class=\"data1\"><input name=\"formSequenceName\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
htmlspecialchars($_POST['formSequenceName']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strincrementby']}</th>\n";
echo "<td class=\"data1\"><input name=\"formIncrement\" size=\"5\" value=\"",
htmlspecialchars($_POST['formIncrement']), "\" /> </td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strminvalue']}</th>\n";
echo "<td class=\"data1\"><input name=\"formMinValue\" size=\"5\" value=\"",
htmlspecialchars($_POST['formMinValue']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strmaxvalue']}</th>\n";
echo "<td class=\"data1\"><input name=\"formMaxValue\" size=\"5\" value=\"",
htmlspecialchars($_POST['formMaxValue']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strstartvalue']}</th>\n";
echo "<td class=\"data1\"><input name=\"formStartValue\" size=\"5\" value=\"",
htmlspecialchars($_POST['formStartValue']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strcachevalue']}</th>\n";
echo "<td class=\"data1\"><input name=\"formCacheValue\" size=\"5\" value=\"",
htmlspecialchars($_POST['formCacheValue']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left\"><label for=\"formCycledValue\">{$lang['strcancycle']}</label></th>\n";
echo "<td class=\"data1\"><input type=\"checkbox\" id=\"formCycledValue\" name=\"formCycledValue\" ",
(isset($_POST['formCycledValue']) ? ' checked="checked"' : ''), " /></td></tr>\n";
echo "</table>\n";
echo "<p><input type=\"hidden\" name=\"action\" value=\"save_create_sequence\" />\n";
echo $misc->form;
echo "<input type=\"submit\" name=\"create\" value=\"{$lang['strcreate']}\" />\n";
echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
echo "</form>\n";
}
/**
* Actually creates the new sequence in the database
*/
function doSaveCreateSequence() {
global $data;
global $lang;
// Check that they've given a name and at least one column
if ($_POST['formSequenceName'] == '') doCreateSequence($lang['strsequenceneedsname']);
else {
$status = $data->createSequence($_POST['formSequenceName'],
$_POST['formIncrement'], $_POST['formMinValue'],
$_POST['formMaxValue'], $_POST['formStartValue'],
$_POST['formCacheValue'], isset($_POST['formCycledValue']));
if ($status == 0) {
doDefault($lang['strsequencecreated']);
} else {
doCreateSequence($lang['strsequencecreatedbad']);
}
}
}
/**
* Restarts a sequence
*/
function doRestart() {
global $data;
global $lang;
$status = $data->restartSequence($_REQUEST['sequence']);
if ($status == 0)
doProperties($lang['strsequencerestart']);
else
doProperties($lang['strsequencerestartbad']);
}
/**
* Resets a sequence
*/
function doReset() {
global $data;
global $lang;
$status = $data->resetSequence($_REQUEST['sequence']);
if ($status == 0)
doProperties($lang['strsequencereset']);
else
doProperties($lang['strsequenceresetbad']);
}
/**
* Set Nextval of a sequence
*/
function doNextval() {
global $data;
global $lang;
$status = $data->nextvalSequence($_REQUEST['sequence']);
if ($status == 0)
doProperties($lang['strsequencenextval']);
else
doProperties($lang['strsequencenextvalbad']);
}
/**
* Function to save after 'setval'ing a sequence
*/
function doSaveSetval() {
global $data, $lang, $_reload_browser;
$status = $data->setvalSequence($_POST['sequence'], $_POST['nextvalue']);
if ($status == 0)
doProperties($lang['strsequencesetval']);
else
doProperties($lang['strsequencesetvalbad']);
}
/**
* Function to allow 'setval'ing of a sequence
*/
function doSetval($msg = '') {
global $data, $misc;
global $lang;
$misc->printTrail('sequence');
$misc->printTitle($lang['strsetval'], 'pg.sequence');
$misc->printMsg($msg);
// Fetch the sequence information
$sequence = $data->getSequence($_REQUEST['sequence']);
if (is_object($sequence) && $sequence->recordCount() > 0) {
echo "<form action=\"sequences.php\" method=\"post\">\n";
echo "<table border=\"0\">";
echo "<tr><th class=\"data left required\">{$lang['strlastvalue']}</th>\n";
echo "<td class=\"data1\">";
echo "<input name=\"nextvalue\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
$misc->printVal($sequence->fields['last_value']), "\" /></td></tr>\n";
echo "</table>\n";
echo "<p><input type=\"hidden\" name=\"action\" value=\"setval\" />\n";
echo "<input type=\"hidden\" name=\"sequence\" value=\"", htmlspecialchars($_REQUEST['sequence']), "\" />\n";
echo $misc->form;
echo "<input type=\"submit\" name=\"setval\" value=\"{$lang['strsetval']}\" />\n";
echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
echo "</form>\n";
}
else echo "<p>{$lang['strnodata']}</p>\n";
}
/**
* Function to save after altering a sequence
*/
function doSaveAlter() {
global $data, $lang, $_reload_browser, $misc;
if (!isset($_POST['owner'])) $_POST['owner'] = null;
if (!isset($_POST['newschema'])) $_POST['newschema'] = null;
if (!isset($_POST['formIncrement'])) $_POST['formIncrement'] = null;
if (!isset($_POST['formMinValue'])) $_POST['formMinValue'] = null;
if (!isset($_POST['formMaxValue'])) $_POST['formMaxValue'] = null;
if (!isset($_POST['formStartValue'])) $_POST['formStartValue'] = null;
if (!isset($_POST['formRestartValue'])) $_POST['formRestartValue'] = null;
if (!isset($_POST['formCacheValue'])) $_POST['formCacheValue'] = null;
if (!isset($_POST['formCycledValue'])) $_POST['formCycledValue'] = null;
$status = $data->alterSequence($_POST['sequence'], $_POST['name'], $_POST['comment'], $_POST['owner'],
$_POST['newschema'], $_POST['formIncrement'], $_POST['formMinValue'], $_POST['formMaxValue'],
$_POST['formRestartValue'], $_POST['formCacheValue'], isset($_POST['formCycledValue']), $_POST['formStartValue']);
if ($status == 0) {
if ($_POST['sequence'] != $_POST['name']) {
// Jump them to the new view name
$_REQUEST['sequence'] = $_POST['name'];
// Force a browser reload
$_reload_browser = true;
}
if (!empty($_POST['newschema']) && ($_POST['newschema'] != $data->_schema)) {
// Jump them to the new sequence schema
$misc->setCurrentSchema($_POST['newschema']);
$_reload_browser = true;
}
doProperties($lang['strsequencealtered']);
}
else
doProperties($lang['strsequencealteredbad']);
}
/**
* Function to allow altering of a sequence
*/
function doAlter($msg = '') {
global $data, $misc;
global $lang;
$misc->printTrail('sequence');
$misc->printTitle($lang['stralter'], 'pg.sequence.alter');
$misc->printMsg($msg);
// Fetch the sequence information
$sequence = $data->getSequence($_REQUEST['sequence']);
if (is_object($sequence) && $sequence->recordCount() > 0) {
if (!isset($_POST['name'])) $_POST['name'] = $_REQUEST['sequence'];
if (!isset($_POST['comment'])) $_POST['comment'] = $sequence->fields['seqcomment'];
if (!isset($_POST['owner'])) $_POST['owner'] = $sequence->fields['seqowner'];
if (!isset($_POST['newschema'])) $_POST['newschema'] = $sequence->fields['nspname'];
// Handle Checkbox Value
$sequence->fields['is_cycled'] = $data->phpBool($sequence->fields['is_cycled']);
if ($sequence->fields['is_cycled']) $_POST['formCycledValue'] = 'on';
echo "<form action=\"sequences.php\" method=\"post\">\n";
echo "<table>\n";
echo "<tr><th class=\"data left required\">{$lang['strname']}</th>\n";
echo "<td class=\"data1\">";
echo "<input name=\"name\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
htmlspecialchars($_POST['name']), "\" /></td></tr>\n";
if ($data->isSuperUser()) {
// Fetch all users
$users = $data->getUsers();
echo "<tr><th class=\"data left required\">{$lang['strowner']}</th>\n";
echo "<td class=\"data1\"><select name=\"owner\">";
while (!$users->EOF) {
$uname = $users->fields['usename'];
echo "<option value=\"", htmlspecialchars($uname), "\"",
($uname == $_POST['owner']) ? ' selected="selected"' : '', ">", htmlspecialchars($uname), "</option>\n";
$users->moveNext();
}
echo "</select></td></tr>\n";
}
if ($data->hasAlterSequenceSchema()) {
$schemas = $data->getSchemas();
echo "<tr><th class=\"data left required\">{$lang['strschema']}</th>\n";
echo "<td class=\"data1\"><select name=\"newschema\">";
while (!$schemas->EOF) {
$schema = $schemas->fields['nspname'];
echo "<option value=\"", htmlspecialchars($schema), "\"",
($schema == $_POST['newschema']) ? ' selected="selected"' : '', ">", htmlspecialchars($schema), "</option>\n";
$schemas->moveNext();
}
echo "</select></td></tr>\n";
}
echo "<tr><th class=\"data left\">{$lang['strcomment']}</th>\n";
echo "<td class=\"data1\">";
echo "<textarea rows=\"3\" cols=\"32\" name=\"comment\">",
htmlspecialchars($_POST['comment']), "</textarea></td></tr>\n";
if ($data->hasAlterSequenceStart()) {
echo "<tr><th class=\"data left\">{$lang['strstartvalue']}</th>\n";
echo "<td class=\"data1\"><input name=\"formStartValue\" size=\"5\" value=\"",
htmlspecialchars($sequence->fields['start_value']), "\" /></td></tr>\n";
}
echo "<tr><th class=\"data left\">{$lang['strrestartvalue']}</th>\n";
echo "<td class=\"data1\"><input name=\"formRestartValue\" size=\"5\" value=\"",
htmlspecialchars($sequence->fields['last_value']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strincrementby']}</th>\n";
echo "<td class=\"data1\"><input name=\"formIncrement\" size=\"5\" value=\"",
htmlspecialchars($sequence->fields['increment_by']), "\" /> </td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strmaxvalue']}</th>\n";
echo "<td class=\"data1\"><input name=\"formMaxValue\" size=\"5\" value=\"",
htmlspecialchars($sequence->fields['max_value']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strminvalue']}</th>\n";
echo "<td class=\"data1\"><input name=\"formMinValue\" size=\"5\" value=\"",
htmlspecialchars($sequence->fields['min_value']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left\">{$lang['strcachevalue']}</th>\n";
echo "<td class=\"data1\"><input name=\"formCacheValue\" size=\"5\" value=\"",
htmlspecialchars($sequence->fields['cache_value']), "\" /></td></tr>\n";
echo "<tr><th class=\"data left\"><label for=\"formCycledValue\">{$lang['strcancycle']}</label></th>\n";
echo "<td class=\"data1\"><input type=\"checkbox\" id=\"formCycledValue\" name=\"formCycledValue\" ",
( isset($_POST['formCycledValue']) ? ' checked="checked"' : ''), " /></td></tr>\n";
echo "</table>\n";
echo "<p><input type=\"hidden\" name=\"action\" value=\"alter\" />\n";
echo $misc->form;
echo "<input type=\"hidden\" name=\"sequence\" value=\"", htmlspecialchars($_REQUEST['sequence']), "\" />\n";
echo "<input type=\"submit\" name=\"alter\" value=\"{$lang['stralter']}\" />\n";
echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
echo "</form>\n";
}
else echo "<p>{$lang['strnodata']}</p>\n";
}
if ($action == 'tree') doTree();
// Print header
$misc->printHeader($lang['strsequences']);
$misc->printBody();
switch($action) {
case 'create':
doCreateSequence();
break;
case 'save_create_sequence':
if (isset($_POST['create'])) doSaveCreateSequence();
else doDefault();
break;
case 'properties':
doProperties();
break;
case 'drop':
if (isset($_POST['drop'])) doDrop(false);
else doDefault();
break;
case 'confirm_drop':
doDrop(true);
break;
case 'restart':
doRestart();
break;
case 'reset':
doReset();
break;
case 'nextval':
doNextval();
break;
case 'setval':
if (isset($_POST['setval'])) doSaveSetval();
else doDefault();
break;
case 'confirm_setval':
doSetval();
break;
case 'alter':
if (isset($_POST['alter'])) doSaveAlter();
else doDefault();
break;
case 'confirm_alter':
doAlter();
break;
default:
doDefault();
break;
}
// Print footer
$misc->printFooter();
?>
Jump to Line
Something went wrong with that request. Please try again.