<h2>Editing File: /usr/local/cpanel/3rdparty/share/phpPgAdmin/triggers.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php

	/**
	 * List triggers on a table
	 *
	 * $Id: triggers.php,v 1.37 2007/09/19 14:42:12 ioguix Exp $
	 */

	// Include application functions
	include_once('./libraries/lib.inc.php');
	include_once('./classes/class.select.php');
	
	$action = (isset($_REQUEST['action'])) ? $_REQUEST['action'] : '';

	/** 
	 * Function to save after altering a trigger
	 */
	function doSaveAlter() {
		global $data, $lang;
		
		$status = $data-&gt;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 $lang;
		
		$misc-&gt;printTrail('trigger');
		$misc-&gt;printTitle($lang['stralter'],'pg.trigger.alter');
		$misc-&gt;printMsg($msg);
		
		$triggerdata = $data-&gt;getTrigger($_REQUEST['table'], $_REQUEST['trigger']);
		
		if ($triggerdata-&gt;recordCount() &gt; 0) {
			
			if (!isset($_POST['name'])) $_POST['name'] = $triggerdata-&gt;fields['tgname'];
			
			echo &quot;&lt;form action=\&quot;triggers.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;table&gt;\n&quot;;
			echo &quot;&lt;tr&gt;&lt;th class=\&quot;data\&quot;&gt;{$lang['strname']}&lt;/th&gt;\n&quot;;
			echo &quot;&lt;td class=\&quot;data1\&quot;&gt;&quot;;
			echo &quot;&lt;input name=\&quot;name\&quot; size=\&quot;32\&quot; maxlength=\&quot;{$data-&gt;_maxNameLen}\&quot; value=\&quot;&quot;, 
				htmlspecialchars($_POST['name']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;&lt;/table&gt;\n&quot;;
			echo &quot;&lt;p&gt;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;alter\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['table']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;trigger\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['trigger']), &quot;\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;alter\&quot; value=\&quot;{$lang['strok']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;cancel\&quot; value=\&quot;{$lang['strcancel']}\&quot; /&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
		}
		else echo &quot;&lt;p&gt;{$lang['strnodata']}&lt;/p&gt;\n&quot;;
	}
	
	/**
	 * Show confirmation of drop and perform actual drop
	 */
	function doDrop($confirm) {
		global $data, $misc;
		global $lang;

		if ($confirm) {
			$misc-&gt;printTrail('trigger');
			$misc-&gt;printTitle($lang['strdrop'],'pg.trigger.drop');

			echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfdroptrigger'], $misc-&gt;printVal($_REQUEST['trigger']),
				$misc-&gt;printVal($_REQUEST['table'])), &quot;&lt;/p&gt;\n&quot;;

			echo &quot;&lt;form action=\&quot;triggers.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;drop\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['table']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;trigger\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['trigger']), &quot;\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;p&gt;&lt;input type=\&quot;checkbox\&quot; id=\&quot;cascade\&quot; name=\&quot;cascade\&quot; /&gt; &lt;label for=\&quot;cascade\&quot;&gt;{$lang['strcascade']}&lt;/label&gt;&lt;/p&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;yes\&quot; value=\&quot;{$lang['stryes']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;no\&quot; value=\&quot;{$lang['strno']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
		}
		else {
			$status = $data-&gt;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 $lang;

		if ($confirm) {
			$misc-&gt;printTrail('trigger');
			$misc-&gt;printTitle($lang['strenable'],'pg.table.alter');

			echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfenabletrigger'], $misc-&gt;printVal($_REQUEST['trigger']),
				$misc-&gt;printVal($_REQUEST['table'])), &quot;&lt;/p&gt;\n&quot;;

			echo &quot;&lt;form action=\&quot;triggers.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;enable\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['table']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;trigger\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['trigger']), &quot;\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;yes\&quot; value=\&quot;{$lang['stryes']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;no\&quot; value=\&quot;{$lang['strno']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
		}
		else {
			$status = $data-&gt;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 $lang;

		if ($confirm) {
			$misc-&gt;printTrail('trigger');
			$misc-&gt;printTitle($lang['strdisable'],'pg.table.alter');

			echo &quot;&lt;p&gt;&quot;, sprintf($lang['strconfdisabletrigger'], $misc-&gt;printVal($_REQUEST['trigger']),
				$misc-&gt;printVal($_REQUEST['table'])), &quot;&lt;/p&gt;\n&quot;;

			echo &quot;&lt;form action=\&quot;triggers.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;disable\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['table']), &quot;\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;trigger\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['trigger']), &quot;\&quot; /&gt;\n&quot;;
			echo $misc-&gt;form;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;yes\&quot; value=\&quot;{$lang['stryes']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;no\&quot; value=\&quot;{$lang['strno']}\&quot; /&gt;\n&quot;;
			echo &quot;&lt;/form&gt;\n&quot;;
		}
		else {
			$status = $data-&gt;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 $lang;
		
		$misc-&gt;printTrail('table');
		$misc-&gt;printTitle($lang['strcreatetrigger'],'pg.trigger.create');
		$misc-&gt;printMsg($msg);
		
		// Get all the functions that can be used in triggers
		$funcs = $data-&gt;getTriggerFunctions();
		if ($funcs-&gt;recordCount() == 0) {
			doDefault($lang['strnofunctions']);
			return;
		}

		/* Populate functions */
		$sel0 = new XHTML_Select('formFunction');
		while (!$funcs-&gt;EOF) {
			$sel0-&gt;add(new XHTML_Option($funcs-&gt;fields['proname']));
			$funcs-&gt;moveNext();
		}

		/* Populate times */
		$sel1 = new XHTML_Select('formExecTime');
		$sel1-&gt;set_data($data-&gt;triggerExecTimes);

		/* Populate events */
		$sel2 = new XHTML_Select('formEvent');
		$sel2-&gt;set_data($data-&gt;triggerEvents);
		
		/* Populate occurrences */
		$sel3 = new XHTML_Select('formFrequency');
		$sel3-&gt;set_data($data-&gt;triggerFrequency);
		
		echo &quot;&lt;form action=\&quot;triggers.php\&quot; method=\&quot;post\&quot;&gt;\n&quot;;
		echo &quot;&lt;table&gt;\n&quot;;
		echo &quot;&lt;tr&gt;\n&quot;;
		echo &quot;		&lt;th class=\&quot;data\&quot;&gt;{$lang['strname']}&lt;/th&gt;\n&quot;;
		echo &quot;		&lt;th class=\&quot;data\&quot;&gt;{$lang['strwhen']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;/tr&gt;\n&quot;;
		echo &quot;&lt;tr&gt;\n&quot;;
		echo &quot;		&lt;td class=\&quot;data1\&quot;&gt; &lt;input type=\&quot;text\&quot; name=\&quot;formTriggerName\&quot; size=\&quot;32\&quot; /&gt;&lt;/td&gt;\n&quot;;
		echo &quot;		&lt;td class=\&quot;data1\&quot;&gt; &quot;, $sel1-&gt;fetch(), &quot;&lt;/td&gt;\n&quot;;
		echo &quot;&lt;/tr&gt;\n&quot;;
		echo &quot;&lt;tr&gt;\n&quot;;
		echo &quot;    &lt;th class=\&quot;data\&quot;&gt;{$lang['strevent']}&lt;/th&gt;\n&quot;;
		echo &quot;    &lt;th class=\&quot;data\&quot;&gt;{$lang['strforeach']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;/tr&gt;\n&quot;;
		echo &quot;&lt;tr&gt;\n&quot;;
		echo &quot;     &lt;td class=\&quot;data1\&quot;&gt; &quot;, $sel2-&gt;fetch(), &quot;&lt;/td&gt;\n&quot;;
		echo &quot;     &lt;td class=\&quot;data1\&quot;&gt; &quot;, $sel3-&gt;fetch(), &quot;&lt;/td&gt;\n&quot;;
		echo &quot;&lt;/tr&gt;\n&quot;;
		echo &quot;&lt;tr&gt;&lt;th class=\&quot;data\&quot;&gt; {$lang['strfunction']}&lt;/th&gt;\n&quot;;
		echo &quot;&lt;th class=\&quot;data\&quot;&gt; {$lang['strarguments']}&lt;/th&gt;&lt;/tr&gt;\n&quot;;
		echo &quot;&lt;tr&gt;&lt;td class=\&quot;data1\&quot;&gt;&quot;, $sel0-&gt;fetch(), &quot;&lt;/td&gt;\n&quot;;
		echo &quot;&lt;td class=\&quot;data1\&quot;&gt;(&lt;input type=\&quot;text\&quot; name=\&quot;formTriggerArgs\&quot; size=\&quot;32\&quot; /&gt;)&lt;/td&gt;\n&quot;;
		echo &quot;&lt;/tr&gt;&lt;/table&gt;\n&quot;;
		echo &quot;&lt;p&gt;&lt;input type=\&quot;submit\&quot; value=\&quot;{$lang['strcreate']}\&quot; /&gt;\n&quot;;
		echo &quot;&lt;input type=\&quot;submit\&quot; name=\&quot;cancel\&quot; value=\&quot;{$lang['strcancel']}\&quot; /&gt;&lt;/p&gt;\n&quot;;
		echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;action\&quot; value=\&quot;save_create\&quot; /&gt;\n&quot;;
		echo &quot;&lt;input type=\&quot;hidden\&quot; name=\&quot;table\&quot; value=\&quot;&quot;, htmlspecialchars($_REQUEST['table']), &quot;\&quot; /&gt;\n&quot;;
		echo $misc-&gt;form;
		echo &quot;&lt;/form&gt;\n&quot;;
	}
	
	/**
	 * Actually creates the new trigger in the database
	 */
	function doSaveCreate() {
		global $data;
		global $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-&gt;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 $lang;

		function tgPre(&amp;$rowdata,$actions) {
			global $data;
			// toggle enable/disable trigger per trigger
			if( ! $data-&gt;phpBool( $rowdata-&gt;fields[&quot;tgenabled&quot;] ) ) {
				unset( $actions['disable'] );
			}
			else{
				unset( $actions['enable'] );
			}

			return $actions;
		}
		
		$misc-&gt;printTrail('table');
		$misc-&gt;printTabs('table','triggers');
		$misc-&gt;printMsg($msg);

		$triggers = $data-&gt;getTriggers($_REQUEST['table']);

		$columns = array(
			'trigger' =&gt; array(
				'title' =&gt; $lang['strname'],
				'field' =&gt; field('tgname'),
			),
			'definition' =&gt; array(
				'title' =&gt; $lang['strdefinition'],
				'field' =&gt; field('tgdef'),
			),
			'function' =&gt; array(
				'title' =&gt; $lang['strfunction'],
				'field' =&gt; field('proproto'),
				'url' =&gt; &quot;functions.php?action=properties&amp;amp;server={$_REQUEST['server']}&amp;amp;database={$_REQUEST['database']}&amp;amp;&quot;,
				'vars' =&gt; array(
					'schema' =&gt; 'pronamespace',
					'function' =&gt; 'proproto',
					'function_oid' =&gt; 'prooid',
				),
			),
			'actions' =&gt; array(
				'title' =&gt; $lang['stractions'],
			),
		);

		$actions = array(
			'alter' =&gt; array(
				'content' =&gt; $lang['stralter'],
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; 'triggers.php',
							'urlvars' =&gt; array (
								'action' =&gt; 'confirm_alter',
								'table' =&gt; $_REQUEST['table'],
								'trigger' =&gt; field('tgname')
							)
						)
					)
			),
			'drop' =&gt; array(
				'content' =&gt; $lang['strdrop'],
					'attr'=&gt; array (
						'href' =&gt; array (
							'url' =&gt; 'triggers.php',
							'urlvars' =&gt; array (
								'action' =&gt; 'confirm_drop',
								'table' =&gt; $_REQUEST['table'],
								'trigger' =&gt; field('tgname')
							)
						)
					)
			),
		);
		if($data-&gt;hasDisableTriggers()) {
			$actions['enable'] = array(
				'content' =&gt; $lang['strenable'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'triggers.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'confirm_enable',
							'table' =&gt; $_REQUEST['table'],
							'trigger' =&gt; field('tgname')
						)
					)
				)
			);
			$actions['disable'] = array(
				'content' =&gt; $lang['strdisable'],
				'attr'=&gt; array (
					'href' =&gt; array (
						'url' =&gt; 'triggers.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'confirm_disable',
							'table' =&gt; $_REQUEST['table'],
							'trigger' =&gt; field('tgname')
						)
					)
				)
			);
		}

		$misc-&gt;printTable($triggers, $columns, $actions, 'triggers-triggers', $lang['strnotriggers'], 'tgPre');
		
		$misc-&gt;printNavLinks(array ('create' =&gt; array (
				'attr'=&gt; array (
					'href' =&gt; array (
					'url' =&gt; 'triggers.php',
						'urlvars' =&gt; array (
							'action' =&gt; 'create',
							'server' =&gt; $_REQUEST['server'],
							'database' =&gt; $_REQUEST['database'],
							'schema' =&gt; $_REQUEST['schema'],
							'table' =&gt; $_REQUEST['table']
						)
					)
				),
				'content' =&gt; $lang['strcreatetrigger']
			)), 'triggers-triggers', get_defined_vars());
	}

	function doTree() {

		global $misc, $data;

		$triggers = $data-&gt;getTriggers($_REQUEST['table']);

		$reqvars = $misc-&gt;getRequestVars('table');
		
		$attrs = array(
			'text'   =&gt; field('tgname'),
			'icon'   =&gt; 'Trigger',
		);

		$misc-&gt;printTree($triggers, $attrs, 'triggers');
		exit;
	}

	if ($action == 'tree') doTree();

	$misc-&gt;printHeader($lang['strtables'] . ' - ' . $_REQUEST['table'] . ' - ' . $lang['strtriggers']);
	$misc-&gt;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-&gt;printFooter();

?&gt;
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2F3rdparty%2Fshare%2FphpPgAdmin'>Back to Directory</a>