database, "INSERT INTO service (servicecode, servicename, default_priority, max_priority) VALUES ('" . $_POST['servcode'] . "','" . $_POST['servname'] . "','" . $_POST['defprior'] . "','" . $_POST['maxprior'] . "')"); } if (isset($_POST['action']) && $_POST['action'] == 'Remove' && !empty($_POST['servcode'])) { pg_exec($this->database, "DELETE FROM service WHERE servicecode='" . $_POST['servcode'] . "'"); } if (isset($_GET['servcode'])) { echo "
"; if (isset($_POST['action']) && $_POST['action'] == 'Save Changes') { $qry = "UPDATE service SET servicename='" . $_POST['servname'] . "'"; $qry .= ", default_priority='" . $_POST['defprior'] . "'"; $qry .= ", max_priority='" . $_POST['maxprior'] . "'"; $qry .= " WHERE servicecode='" . $_GET['servcode'] . "'"; pg_exec($this->database, $qry); } if (isset($_POST['action']) && $_POST['action'] == 'Add') { $qry = "INSERT INTO service_pattern VALUES ('". $_GET['servcode'] . "'"; $qry .= ", '" . $_POST['Rank'] . "'"; $qry .= ", '" . $_POST['Pattern'] . "'"; $qry .= ", '" . $_POST['Pat_Action'] . "'"; $qry .= ", '" . $_POST['Argument'] . "')"; pg_exec($this->database, $qry); } if (isset($_POST['action']) && $_POST['action'] == 'Change') { $qry = "UPDATE service_pattern SET rank = '" . $_POST['Rank'] . "'"; $qry .= ", pattern = '" . $_POST['Pattern'] . "'"; $qry .= ", action = '" . $_POST['Pat_Action'] . "'"; $qry .= ", argument = '" . $_POST['Argument'] . "'"; $qry .= " WHERE service = '" . $_GET['servcode'] . "' AND rank = '" . $_POST['Rank'] . "'"; pg_exec($this->database, $qry); } if (isset($_POST['action']) && $_POST['action'] == 'Delete') { $qry = "DELETE FROM service_pattern WHERE service = '". $_GET['servcode'] . "'"; $qry .= " AND rank = '" . $_POST['Rank'] . "'"; pg_exec($this->database, $qry); } $res = pg_exec($this->database, "SELECT * FROM service WHERE servicecode='" . $_GET['servcode'] . "'"); $srv = pg_fetch_object($res, 0); echo "
"; echo "
"; echo "
Service name
"; echo "
Default priority
"; for ($prior = 1; $prior < 6; $prior++) { echo "
default_priority) { echo " SELECTED"; } echo ">$prior
\n"; } echo "
"; echo "
Maximum priority
"; for ($prior = 1; $prior < 6; $prior++) { echo "
max_priority) { echo " SELECTED"; } echo ">$prior
\n"; } echo "
"; echo "
"; echo "
"; echo "
"; echo "
Patterns to check logs of " . $srv->servicename . "
\n"; echo "
"; echo "
Rank
Pattern
Action
"; echo "
Argument
\n"; $pat_res = pg_exec($this->database, "SELECT * FROM service_pattern WHERE service = '" . $srv->servicecode . "' ORDER BY rank"); for ($pat_row = 0; $pat_row < pg_numrows($pat_res); $pat_row++) { $pat = pg_fetch_object($pat_res, $pat_row); echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; //echo "
"; echo "
"; echo "
action =='ignore') echo ' selected'; echo ">ignore"; echo "
action =='notify') echo ' selected'; echo ">notify"; echo "
action =='abuse') echo ' selected'; echo ">abuse"; echo "
action =='forgive') echo ' selected'; echo ">forgive"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; } echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; //echo "
"; echo "
"; echo "
ignore
"; echo "
notify
"; echo "
abuse
"; echo "
forgive
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; } else { echo "
"; $res = pg_exec($this->database, "SELECT * FROM service ORDER BY servicecode"); echo "
"; echo "
Service code
Name
Priority
Max priority
"; $srv = 0; while ($srv < pg_numrows($res)) { $u = pg_fetch_object($res, $srv); ?>
servicecode ?>
servicename ?>
default_priority ?>
max_priority ?>
"; ?>
Create new service:
Service code:
Service name:
Default priority:
1
2
3
4
5
Maximum priority:
1
2
3
4
5
Showpage(); ?>
