选择文件名文件大小最后修改时间操作
[📄] 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
alterTrigger($_POST['table'], $_POST['trigger'], $_POST['name']); if ($status == 0) doDefault($lang['strtriggeraltered']); else doAlter($lang['strtriggeralteredbad']); } /** * Function to allow altering of a trigger */ function doAlter($msg = '') { global $data, $misc; global $PHP_SELF, $lang; $misc->printTrail('trigger'); $misc->printTitle($lang['stralter'],'pg.trigger.alter'); $misc->printMsg($msg); $triggerdata = $data->getTrigger($_REQUEST['table'], $_REQUEST['trigger']); if ($triggerdata->recordCount() > 0) { if (!isset($_POST['name'])) $_POST['name'] = $triggerdata->f['tgname']; echo "
\n"; echo "\n"; echo "\n"; echo "
{$lang['strname']}"; echo "_maxNameLen}\" value=\"", htmlspecialchars($_POST['name']), "\" />\n"; echo "
\n"; echo "

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

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

{$lang['strnodata']}

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

", sprintf($lang['strconfdroptrigger'], $misc->printVal($_REQUEST['trigger']), $misc->printVal($_REQUEST['table'])), "

\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->dropTrigger($_POST['trigger'], $_POST['table'], isset($_POST['cascade'])); if ($status == 0) doDefault($lang['strtriggerdropped']); else doDefault($lang['strtriggerdroppedbad']); } } /** * Show confirmation of enable trigger and perform enabling the trigger */ function doEnable($confirm) { global $data, $misc; global $PHP_SELF, $lang; if ($confirm) { $misc->printTrail('trigger'); $misc->printTitle($lang['strenable'],'pg.table.alter'); echo "

", sprintf($lang['strconfenabletrigger'], $misc->printVal($_REQUEST['trigger']), $misc->printVal($_REQUEST['table'])), "

\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo $misc->form; echo "\n"; echo "\n"; echo "
\n"; } else { $status = $data->enableTrigger($_POST['trigger'], $_POST['table']); if ($status == 0) doDefault($lang['strtriggerenabled']); else doDefault($lang['strtriggerenabledbad']); } } /** * Show confirmation of disable trigger and perform disabling the trigger */ function doDisable($confirm) { global $data, $misc; global $PHP_SELF, $lang; if ($confirm) { $misc->printTrail('trigger'); $misc->printTitle($lang['strdisable'],'pg.table.alter'); echo "

", sprintf($lang['strconfdisabletrigger'], $misc->printVal($_REQUEST['trigger']), $misc->printVal($_REQUEST['table'])), "

\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo $misc->form; echo "\n"; echo "\n"; echo "
\n"; } else { $status = $data->disableTrigger($_POST['trigger'], $_POST['table']); if ($status == 0) doDefault($lang['strtriggerdisabled']); else doDefault($lang['strtriggerdisabledbad']); } } /** * Let them create s.th. */ function doCreate($msg = '') { global $data, $misc; global $PHP_SELF, $lang; $misc->printTrail('table'); $misc->printTitle($lang['strcreatetrigger'],'pg.trigger.create'); $misc->printMsg($msg); // Get all the functions that can be used in triggers $funcs = $data->getTriggerFunctions(); if ($funcs->recordCount() == 0) { doDefault($lang['strnofunctions']); return; } /* Populate functions */ $sel0 = new XHTML_Select('formFunction'); while (!$funcs->EOF) { $sel0->add(new XHTML_Option($funcs->f['proname'])); $funcs->moveNext(); } /* Populate times */ $sel1 = new XHTML_Select('formExecTime'); $sel1->set_data($data->triggerExecTimes); /* Populate events */ $sel2 = new XHTML_Select('formEvent'); $sel2->set_data($data->triggerEvents); /* Populate occurences */ $sel3 = new XHTML_Select('formFrequency'); $sel3->set_data($data->triggerFrequency); 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 " \n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
{$lang['strname']}{$lang['strwhen']}
", $sel1->fetch(), "
{$lang['strevent']}{$lang['strforeach']}
", $sel2->fetch(), " ", $sel3->fetch(), "
{$lang['strfunction']} {$lang['strarguments']}
", $sel0->fetch(), "()
\n"; echo "

\n"; echo "

\n"; echo "\n"; echo "\n"; echo $misc->form; echo "
\n"; } /** * Actually creates the new trigger in the database */ function doSaveCreate() { global $data; global $PHP_SELF, $lang; // Check that they've given a name and a definition if ($_POST['formFunction'] == '') doCreate($lang['strtriggerneedsfunc']); elseif ($_POST['formTriggerName'] == '') doCreate($lang['strtriggerneedsname']); elseif ($_POST['formEvent'] == '') doCreate(); else { $status = $data->createTrigger($_POST['formTriggerName'], $_POST['table'], $_POST['formFunction'], $_POST['formExecTime'], $_POST['formEvent'], $_POST['formFrequency'], $_POST['formTriggerArgs']); if ($status == 0) doDefault($lang['strtriggercreated']); else doCreate($lang['strtriggercreatedbad']); } } /** * List all the triggers on the table */ function doDefault($msg = '') { global $data, $misc, $database; global $PHP_SELF; global $lang; function tgPre(&$rowdata) { global $data, $lang; // Nasty hack to support pre-7.4 PostgreSQL $rowdata->f['+tgdef'] = $rowdata->f['tgdef'] !== null ? $rowdata->f['tgdef'] : $data->getTriggerDef($rowdata->f); } $misc->printTrail('table'); $misc->printTabs('table','triggers'); $misc->printMsg($msg); $triggers = $data->getTriggers($_REQUEST['table']); $columns = array( 'trigger' => array( 'title' => $lang['strname'], 'field' => 'tgname', ), 'definition' => array( 'title' => $lang['strdefinition'], 'field' => '+tgdef', ), 'actions' => array( 'title' => $lang['stractions'], ), ); $actions = array( 'alter' => array( 'title' => $lang['stralter'], 'url' => "{$PHP_SELF}?action=confirm_alter&{$misc->href}&table=".urlencode($_REQUEST['table'])."&", 'vars' => array('trigger' => 'tgname'), ), 'drop' => array( 'title' => $lang['strdrop'], 'url' => "{$PHP_SELF}?action=confirm_drop&{$misc->href}&table=".urlencode($_REQUEST['table'])."&", 'vars' => array('trigger' => 'tgname'), ), ); if($data->hasDisableTriggers()) { if(!$data->phpBool($triggers->fields["tgenabled"])) { $actions['enable'] = array( 'title' => $lang['strenable'], 'url' => "{$PHP_SELF}?action=confirm_enable&{$misc->href}&table=".urlencode($_REQUEST['table'])."&", 'vars' => array('trigger' => 'tgname'), ); } else { $actions['disable'] = array( 'title' => $lang['strdisable'], 'url' => "{$PHP_SELF}?action=confirm_disable&{$misc->href}&table=".urlencode($_REQUEST['table'])."&", 'vars' => array('trigger' => 'tgname'), ); } } if (!$data->hasAlterTrigger()) unset($actions['alter']); $misc->printTable($triggers, $columns, $actions, $lang['strnotriggers'], 'tgPre'); echo "

href}&table=", urlencode($_REQUEST['table']), "\">{$lang['strcreatetrigger']}

\n"; } $misc->printHeader($lang['strtables'] . ' - ' . $_REQUEST['table'] . ' - ' . $lang['strtriggers']); $misc->printBody(); switch ($action) { case 'alter': if (isset($_POST['alter'])) doSaveAlter(); else doDefault(); break; case 'confirm_alter': doAlter(); break; case 'confirm_enable': doEnable(true); break; case 'confirm_disable': doDisable(true); break; case 'save_create': if (isset($_POST['cancel'])) doDefault(); else doSaveCreate(); break; case 'create': doCreate(); break; case 'drop': if (isset($_POST['yes'])) doDrop(false); else doDefault(); break; case 'confirm_drop': doDrop(true); break; case 'enable': if (isset($_POST['yes'])) doEnable(false); else doDefault(); break; case 'disable': if (isset($_POST['yes'])) doDisable(false); else doDefault(); break; default: doDefault(); break; } $misc->printFooter(); ?>