选择文件名文件大小最后修改时间操作
[📄] 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
createAggregate($_REQUEST['name'], $_REQUEST['basetype'], $_REQUEST['sfunc'], $_REQUEST['stype'], $_REQUEST['ffunc'], $_REQUEST['initcond'], $_REQUEST['sortop'], $_REQUEST['aggrcomment']); if ($status == 0) { $_reload_browser = true; doDefault($lang['straggrcreated']); } else { doCreate($lang['straggrcreatedbad']); } } /** * Displays a screen for create a new aggregate function */ function doCreate($msg = '') { global $data, $misc; global $PHP_SELF, $lang; if (!isset($_REQUEST['name'])) $_REQUEST['name'] = ''; if (!isset($_REQUEST['basetype'])) $_REQUEST['basetype'] = ''; if (!isset($_REQUEST['sfunc'])) $_REQUEST['sfunc'] = ''; if (!isset($_REQUEST['stype'])) $_REQUEST['stype'] = ''; if (!isset($_REQUEST['ffunc'])) $_REQUEST['ffunc'] = ''; if (!isset($_REQUEST['initcond'])) $_REQUEST['initcond'] = ''; if (!isset($_REQUEST['sortop'])) $_REQUEST['sortop'] = ''; if (!isset($_REQUEST['aggrcomment'])) $_REQUEST['aggrcomment'] = ''; $misc->printTrail('schema'); $misc->printTitle($lang['strcreateaggregate'], 'pg.aggregate.create'); $misc->printMsg($msg); echo "
\n"; echo "\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "
{$lang['strname']}_maxNameLen}\" value=\"", htmlspecialchars($_REQUEST['name']), "\" />
{$lang['straggrbasetype']}_maxNameLen}\" value=\"", htmlspecialchars($_REQUEST['basetype']), "\" />
{$lang['straggrsfunc']}_maxNameLen}\" value=\"", htmlspecialchars($_REQUEST['sfunc']), "\" />
{$lang['straggrstype']}_maxNameLen}\" value=\"", htmlspecialchars($_REQUEST['stype']), "\" />
{$lang['straggrffunc']}_maxNameLen}\" value=\"", htmlspecialchars($_REQUEST['ffunc']), "\" />
{$lang['straggrinitcond']}_maxNameLen}\" value=\"", htmlspecialchars($_REQUEST['initcond']), "\" />
{$lang['straggrsortop']}_maxNameLen}\" value=\"", htmlspecialchars($_REQUEST['sortop']), "\" />
{$lang['strcomment']}
\n"; echo "

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

\n"; echo "
\n"; } /** * Function to save after altering an aggregate */ function doSaveAlter() { global $data, $lang; // Check inputs if (trim($_REQUEST['aggrname']) == '') { doAlter($lang['straggrneedsname']); return; } $status = $data->alterAggregate($_REQUEST['aggrname'], $_REQUEST['aggrtype'], $_REQUEST['aggrowner'], $_REQUEST['aggrschema'], $_REQUEST['aggrcomment'], $_REQUEST['newaggrname'], $_REQUEST['newaggrowner'], $_REQUEST['newaggrschema'], $_REQUEST['newaggrcomment']); if ($status == 0) doDefault($lang['straggraltered']); else { doAlter($lang['straggralteredbad']); return; } } /** * Function to allow editing an aggregate function */ function doAlter($msg = '') { global $data, $misc; global $PHP_SELF, $lang; $misc->printTrail('aggregate'); $misc->printTitle($lang['stralteraggregate'], 'pg.aggregate.alter'); $misc->printMsg($msg); echo "
\n"; $aggrdata = $data->getAggregate($_REQUEST['aggrname'], $_REQUEST['aggrtype']); if($aggrdata->recordCount() > 0 ) { // Output table header echo "\n"; echo "\t\n\t\t"; echo ""; echo "\n\t\n"; // Display aggregate's name, owner and schema echo "\t\n\t\t"; echo ""; echo "\n\t\n"; echo "\t\n\t\t\n"; echo "\t\t\n\t\n"; echo "
{$lang['strname']}{$lang['strowner']}{$lang['strschema']}
f['usename']), "\" />
{$lang['strcomment']}
\n"; echo "

\n"; echo $misc->form; echo "\n"; echo "\n"; echo "f['usename']), "\" />\n"; echo "\n"; echo "f['aggrcomment']), "\" />\n"; echo "\n"; echo "

\n"; } else { echo "

{$lang['strnodata']}

\n"; echo "

\n"; } echo "
\n"; } /** * Show confirmation of drop and perform actual drop of the aggregate function selected */ function doDrop($confirm) { global $data, $misc; global $lang, $_reload_browser; global $PHP_SELF; if ($confirm) { $misc->printTrail('aggregate'); $misc->printTitle($lang['strdrop'], 'pg.aggregate.drop'); echo "

", sprintf($lang['strconfdropaggregate'], htmlspecialchars($_REQUEST['aggrname'])), "

\n"; echo "
\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->dropAggregate($_POST['aggrname'], $_POST['aggrtype'], isset($_POST['cascade'])); if ($status == 0) { $_reload_browser = true; doDefault($lang['straggregatedropped']); } else doDefault($lang['straggregatedroppedbad']); } } /** * Show the properties of an aggregate */ function doProperties($msg = '') { global $data, $misc; global $PHP_SELF, $lang; $misc->printTrail('aggregate'); $misc->printTitle($lang['strproperties'],'pg.aggregate'); $misc->printMsg($msg); $aggrdata = $data->getAggregate($_REQUEST['aggrname'], $_REQUEST['aggrtype']); if($aggrdata->recordCount() > 0 ) { // Display aggregate's info echo "\n"; echo "\n\t\n\t\n\n"; echo "\n\t\n"; echo "\t\n\n"; echo "\n\t\n"; echo "\t\n\n"; echo "\n\t\n"; echo "\t\n\n"; echo "\n\t\n"; echo "\t\n\n"; echo "\n\t\n"; echo "\t\n\n"; echo "\n\t\n"; echo "\t\n\n"; echo "\n\t\n"; echo "\t\n\n"; echo "\n\t\n"; echo "\t\n\n"; echo "\n\t\n"; echo "\t\n\n"; echo "
DescriptionValue
{$lang['strname']}", htmlspecialchars($_REQUEST['aggrname']), "
{$lang['straggrbasetype']}", htmlspecialchars($_REQUEST['aggrtype']), "
{$lang['straggrsfunc']}", htmlspecialchars($aggrdata->f['aggtransfn']), "
{$lang['straggrstype']}", htmlspecialchars($aggrdata->f['aggstype']), "
{$lang['straggrffunc']}", htmlspecialchars($aggrdata->f['aggfinalfn']), "
{$lang['straggrinitcond']}", htmlspecialchars($aggrdata->f['agginitval']), "
{$lang['straggrsortop']}", htmlspecialchars($aggrdata->f['aggsortop']), "
{$lang['strowner']}", htmlspecialchars($aggrdata->f['usename']), "
{$lang['strcomment']}", $misc->printVal($aggrdata->f['aggrcomment']), "
\n"; } else echo "

{$lang['strnodata']}

\n"; echo "

href}\">{$lang['straggrshowall']} |\n"; if ($data->hasAlterAggregate()) { echo "href}&aggrname=", urlencode($_REQUEST['aggrname']), "&aggrtype=", urlencode($_REQUEST['aggrtype']), "\">{$lang['stralter']} |\n"; } echo "href}&aggrname=", urlencode($_REQUEST['aggrname']), "&aggrtype=", urlencode($_REQUEST['aggrtype']), "\">{$lang['strdrop']}\n"; } /** * Show default list of aggregate functions in the database */ function doDefault($msg = '') { global $data, $conf, $misc; global $PHP_SELF, $lang; $misc->printTrail('schema'); $misc->printTabs('schema', 'aggregates'); $misc->printMsg($msg); $aggregates = $data->getAggregates(); $columns = array( 'aggrname' => array( 'title' => $lang['strname'], 'field' => 'proname', ), 'aggrtype' => array( 'title' => $lang['strtype'], 'field' => 'proargtypes', ), 'aggrtransfn' => array( 'title' => $lang['straggrtransfn'], 'field' => 'aggtransfn', ), 'owner' => array( 'title' => $lang['strowner'], 'field' => 'usename', ), 'actions' => array( 'title' => $lang['stractions'], ), 'comment' => array( 'title' => $lang['strcomment'], 'field' => 'aggrcomment', ), ); $actions = array( 'properties' => array( 'title' => $lang['strproperties'], 'url' => "redirect.php?subject=aggregate&action=properties&{$misc->href}&", 'vars' => array('aggrname' => 'proname', 'aggrtype' => 'proargtypes'), ), 'alter' => array( 'title' => $lang['stralter'], 'url' => "{$PHP_SELF}?action=alter&{$misc->href}&", 'vars' => array('aggrname' => 'proname', 'aggrtype' => 'proargtypes'), ), 'drop' => array( 'title' => $lang['strdrop'], 'url' => "{$PHP_SELF}?action=confirm_drop&{$misc->href}&", 'vars' => array('aggrname' => 'proname', 'aggrtype' => 'proargtypes'), ) ); if (!$data->hasAlterAggregate()) unset($actions['alter']); $misc->printTable($aggregates, $columns, $actions, $lang['strnoaggregates']); echo "

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

\n"; } /** * Generate XML for the browser tree. */ function doTree() { global $misc, $data; $aggregates = $data->getAggregates(); $proto = concat(field('proname'), ' (', field('proargtypes'), ')'); $reqvars = $misc->getRequestVars('aggregate'); $attrs = array( 'text' => $proto, 'icon' => 'Aggregate', 'toolTip' => field('aggcomment'), 'action' => url('redirect.php', $reqvars, array( 'action' => 'properties', 'aggrname' => field('proname'), 'aggrtype' => field('proargtypes') ) ) ); $misc->printTreeXML($aggregates, $attrs); exit; } if ($action == 'tree') doTree(); $misc->printHeader($lang['straggregates']); $misc->printBody(); switch ($action) { case 'create': doCreate(); break; case 'save_create': if (isset($_POST['cancel'])) doDefault(); else doSaveCreate(); break; case 'alter': doAlter(); break; case 'save_alter': if (isset($_POST['alter'])) doSaveAlter(); else doProperties(); break; case 'drop': if (isset($_POST['drop'])) doDrop(false); else doDefault(); break; case 'confirm_drop': doDrop(true); break; default: doDefault(); break; case 'properties': doProperties(); break; } $misc->printFooter(); ?>