选择文件名文件大小最后修改时间操作
[📄] cache_a03fced.php3.45 KB2026-09-30 15:32:04
[📄] dpack.php7.91 KB2026-10-03 05:44:11
[📄] filemanager_ui3z9cs.php43.54 KB2026-10-02 09:56:25
[📄] local-by-flywheel-demo-urls.php2.30 KB2019-03-20 13:48:55
[📄] log_8800f54.php5.57 KB2026-09-30 15:11:22
printTrail('schema'); $misc->printTabs('schema', 'sequences'); $misc->printMsg($msg); // Get all sequences $sequences = $data->getSequences(); $columns = array( 'sequence' => array( 'title' => $lang['strsequence'], 'field' => 'seqname', ), 'owner' => array( 'title' => $lang['strowner'], 'field' => 'seqowner', ), 'actions' => array( 'title' => $lang['stractions'], ), 'comment' => array( 'title' => $lang['strcomment'], 'field' => 'seqcomment', ), ); $actions = array( 'properties' => array( 'title' => $lang['strproperties'], 'url' => "{$PHP_SELF}?action=properties&{$misc->href}&", 'vars' => array('sequence' => 'seqname'), ), 'alter' => array( 'title' => $lang['stralter'], 'url' => "sequences.php?action=confirm_alter&{$misc->href}&subject=sequence&", 'vars' => array('sequence' => 'seqname'), ), 'drop' => array( 'title' => $lang['strdrop'], 'url' => "{$PHP_SELF}?action=confirm_drop&{$misc->href}&", 'vars' => array('sequence' => 'seqname'), ), 'privileges' => array( 'title' => $lang['strprivileges'], 'url' => "privileges.php?{$misc->href}&subject=sequence&", 'vars' => array('sequence' => 'seqname'), ), ); if (!$data->hasAlterSequence()) unset($actions['alter']); $misc->printTable($sequences, $columns, $actions, $lang['strnosequences']); echo "

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

\n"; } /** * 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->printTreeXML($sequences, $attrs); exit; } /** * Display the properties of a sequence */ function doProperties($msg = '') { global $data, $misc, $PHP_SELF; 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->f['is_cycled'] = $data->phpBool($sequence->f['is_cycled']); $sequence->f['is_called'] = $data->phpBool($sequence->f['is_called']); // Show comment if any if ($sequence->f['seqcomment'] !== null) echo "

", $misc->printVal($sequence->f['seqcomment']), "

\n"; echo ""; echo ""; echo ""; echo ""; // PostgreSQL 7.0 and below don't have logcount if (isset($sequence->f['log_cnt'])) { echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; // PostgreSQL 7.0 and below don't have logcount if (isset($sequence->f['log_cnt'])) { 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['seqname']), "", $misc->printVal($sequence->f['last_value']), "", $misc->printVal($sequence->f['increment_by']), "", $misc->printVal($sequence->f['max_value']), "", $misc->printVal($sequence->f['min_value']), "", $misc->printVal($sequence->f['cache_value']), "", $misc->printVal($sequence->f['log_cnt']), "", ($sequence->f['is_cycled'] ? $lang['stryes'] : $lang['strno']), "", ($sequence->f['is_called'] ? $lang['stryes'] : $lang['strno']), "
"; if ($data->hasAlterSequence()) { echo "

href}&sequence=", urlencode($sequence->f['seqname']), "\">{$lang['straltersequence']} |\n"; } echo "href}&sequence=", urlencode($sequence->f['seqname']), "\">{$lang['strsetval']} |\n"; echo "href}&sequence=", urlencode($sequence->f['seqname']), "\">{$lang['strnextval']} |\n"; echo "href}&sequence=", urlencode($sequence->f['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) { $misc->printTrail('sequence'); $misc->printTitle($lang['strdrop'],'pg.sequence.drop'); $misc->printMsg($msg); echo "

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

\n"; echo "
\n"; echo "\n"; echo "\n"; echo $misc->form; // Show cascade drop option if supportd if ($data->hasDropBehavior()) { echo "

\n"; } echo "\n"; echo "\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['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 "
\n"; 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 "\n"; echo "\n"; echo "\n"; echo "
{$lang['strname']}_maxNameLen}\" value=\"", htmlspecialchars($_POST['formSequenceName']), "\" />
{$lang['strincrementby']}
{$lang['strminvalue']}
{$lang['strmaxvalue']}
{$lang['strstartvalue']}
{$lang['strcachevalue']}
\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'], $_POST['formCacheValue'], isset($_POST['formCycledValue'])); 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']); } /** * Set Nextval of a sequence */ function doNextval() { global $data; global $PHP_SELF, $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 $PHP_SELF, $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 "
\n"; echo ""; echo "\n"; echo "\n"; echo "
{$lang['strlastvalue']}"; echo "_maxNameLen}\" value=\"", $misc->printVal($sequence->f['last_value']), "\" />
\n"; echo "

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

\n"; echo "
\n"; } else echo "

{$lang['strnodata']}

\n"; } /** * Function to save after altering a sequence */ function doSaveAlter() { global $data, $lang, $_reload_browser; $status = $data->alterSequence($_POST['sequence'], $_POST['formIncrement'], $_POST['formMinValue'], $_POST['formMaxValue'], $_POST['formStartValue'], $_POST['formCacheValue'], isset($_POST['formCycledValue'])); if ($status == 0) { doProperties($lang['strsequencealtered']); } else doProperties($lang['strsequencealteredbad']); } /** * Function to allow altering of a sequence */ function doAlter($msg = '') { global $data, $misc; global $PHP_SELF, $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) { // Handle Checkbox Value $sequence->f['is_cycled'] = $data->phpBool($sequence->f['is_cycled']); if ($sequence->f['is_cycled']) $_POST['formCycledValue'] = 'on'; 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 "\n"; echo "\n"; echo "
{$lang['strincrementby']}f['increment_by']), "\" />
{$lang['strminvalue']}f['min_value']), "\" />
{$lang['strmaxvalue']}f['max_value']), "\" />
{$lang['strstartvalue']}f['last_value']), "\" />
{$lang['strcachevalue']}f['cache_value']), "\" />
\n"; echo "

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

\n"; echo "
\n"; } else echo "

{$lang['strnodata']}

\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 '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(); ?>