1 Star 0 Fork 0

mamh-mixed/phppgadmin

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
克隆/下载
sequences.php 23.42 KB
一键复制 编辑 原始数据 按行查看 历史
Robert Treat 提交于 2014-07-20 19:43 . make blank msg lines consistent
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728
<?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();
?>
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/mamh-mixed/phppgadmin.git
git@gitee.com:mamh-mixed/phppgadmin.git
mamh-mixed
phppgadmin
phppgadmin
master

搜索帮助

23e8dbc6 1850385 7e0993f3 1850385