", $misc->printVal($_REQUEST['database']), ": {$lang['strsequences']}\n"; $misc->printMsg($msg); // Get all sequences $sequences = &$data->getSequences(); if (is_object($sequences) && $sequences->recordCount() > 0) { echo "\n"; echo ""; echo "\n"; $i = 0; while (!$sequences->EOF) { $id = (($i % 2) == 0 ? '1' : '2'); echo ""; echo ""; echo "\n"; echo "\n"; echo "\n"; $sequences->movenext(); $i++; } echo "

{$lang['strname']}	{$lang['strowner']}	{$lang['stractions']}
", $misc->printVal($sequences->f[$data->sqFields['seqname']]), "	", $misc->printVal($sequences->f[$data->sqFields['seqowner']]), "	"; echo "href}&sequence=", urlencode($sequences->f[$data->sqFields['seqname']]), "\">{$lang['strproperties']}	"; echo "href}&sequence=", urlencode($sequences->f[$data->sqFields['seqname']]), "\">{$lang['strdrop']}	"; echo "href}&object=", urlencode($sequences->f[$data->sqFields['seqname']]), "&type=sequence\">{$lang['strprivileges']}

\n"; } else echo "

{$lang['strnosequences']}

\n"; echo "

href}\">{$lang['strcreatesequence']}

\n"; } /** * Display the properties of a sequence */ function doProperties($msg = '') { global $data, $misc, $PHP_SELF; global $lang; echo "

", $misc->printVal($_REQUEST['database']), ": {$lang['strsequences']} : ", $misc->printVal($_REQUEST['sequence']), ": {$lang['strproperties']}

\n"; $misc->printMsg($msg); // Fetch the sequence information $sequence = &$data->getSequence($_REQUEST['sequence']); if (is_object($sequence) && $sequence->recordCount() > 0) { $sequence->f[$data->sqFields['iscycled']] = $data->phpBool($sequence->f[$data->sqFields['iscycled']]); $sequence->f[$data->sqFields['iscalled']] = $data->phpBool($sequence->f[$data->sqFields['iscalled']]); echo ""; echo ""; echo ""; echo ""; // PostgreSQL 7.0 and below don't have logcount if (isset($sequence->f[$data->sqFields['logcount']])) { echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // PostgreSQL 7.0 and below don't have logcount if (isset($sequence->f[$data->sqFields['logcount']])) { echo ""; } echo ""; echo ""; echo ""; echo "

{$lang['strname']}	{$lang['strlastvalue']}	{$lang['strincrementby']}	{$lang['strmaxvalue']}	{$lang['strminvalue']}	{$lang['strcachevalue']}	{$lang['strlogcount']}	{$lang['striscycled']}	{$lang['striscalled']}
", $misc->printVal($sequence->f[$data->sqFields['seqname']]), "	", $misc->printVal($sequence->f[$data->sqFields['lastvalue']]), "	", $misc->printVal($sequence->f[$data->sqFields['incrementby']]), "	", $misc->printVal($sequence->f[$data->sqFields['maxvalue']]), "	", $misc->printVal($sequence->f[$data->sqFields['minvalue']]), "	", $misc->printVal($sequence->f[$data->sqFields['cachevalue']]), "	", $misc->printVal($sequence->f[$data->sqFields['logcount']]), "	", (($sequence->f[$data->sqFields['iscycled']]) ? $lang['stryes'] : $lang['strno']), "	", (($sequence->f[$data->sqFields['iscalled']]) ? $lang['stryes'] : $lang['strno']), "

"; echo "

href}&sequence=", urlencode($sequence->f[$data->sqFields['seqname']]), "\">{$lang['strreset']} |\n"; echo "href}\">{$lang['strshowallsequences']}

\n"; } else echo "

{$lang['strnodata']}.

\n"; } /** * Drop a sequence */ function doDrop($confirm, $msg = '') { global $data, $misc; global $PHP_SELF, $lang; if ($confirm) { echo "

", $misc->printVal($_REQUEST['database']), ": {$lang['strsequences']} : ", $misc->printVal($_REQUEST['sequence']), ": {$lang['strdrop']}

\n"; $misc->printMsg($msg); echo "

", sprintf($lang['strconfdropsequence'], $misc->printVal($_REQUEST['sequence'])), "

\n"; echo "\n"; } else { $status = $data->dropSequence($_POST['sequence'], isset($_POST['cascade'])); if ($status == 0) 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 $PHP_SELF, $lang; if (!isset($_POST['formSequenceName'])) $_POST['formSequenceName'] = ''; if (!isset($_POST['formIncrement'])) $_POST['formIncrement'] = ''; if (!isset($_POST['formStartValue'])) $_POST['formStartValue'] = ''; if (!isset($_POST['formMinValue'])) $_POST['formMinValue'] = ''; if (!isset($_POST['formMaxValue'])) $_POST['formMaxValue'] = ''; echo "

", $misc->printVal($_REQUEST['database']), ": {$lang['strsequences']} : {$lang['strcreatesequence']}

\n"; $misc->printMsg($msg); echo "

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

{$lang['strname']}	_maxNameLen}\" value=\"", htmlspecialchars($_POST['formSequenceName']), "\" />
{$lang['strincrementby']}
{$lang['strstartvalue']}
{$lang['strminvalue']}
{$lang['strmaxvalue']}

\n"; echo "

\n"; echo $misc->form; echo "\n"; echo "\n"; echo "

\n"; echo "

\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']); if ($status == 0) { doDefault($lang['strsequencecreated']); } else { doCreateSequence($lang['strsequencecreatedbad']); } } } /** * Resets a sequence */ function doReset() { global $data; global $PHP_SELF, $lang; $status = $data->resetSequence($_REQUEST['sequence']); if ($status == 0) doProperties($lang['strsequencereset']); else doProperties($lang['strsequenceresetbad']); } // 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 'reset': doReset(); break; default: doDefault(); break; } // Print footer $misc->printFooter(); ?>