+ else if (isset($_POST['action']) && $_POST['action'] == 'Modify Service')
+ {
+ $obj_srv_res = pg_exec($this->database, "SELECT * from object_service WHERE objectid='" . $_GET['oid']
+ . "' AND servicecode='" . $_POST['servcode'] . "'");
+
+ if (pg_numrows($obj_srv_res) == 0)
+ {
+ // Add a new service for this object
+ if (isset($_POST['servused']))
+ {
+ $qry = "INSERT INTO object_service (objectid, servicecode, expected_interval) ";
+ $qry .= "VALUES ('" . $_GET['oid'] . "', '" . $_POST['servcode'] . "', '";
+ $qry .= $_POST['expinterval'] . "')";
+
+ pg_exec($this->database, $qry);
+ }
+ }
+ else
+ {
+ // Modify or remove the service for this object
+ if (isset($_POST['servused']))
+ {
+ // Service is still used; update some values.
+ $qry = "UPDATE object_service SET expected_interval='" . $_POST['expinterval'];
+ $qry .= "' WHERE objectid='" . $_GET['oid'];
+ $qry .= "' AND servicecode='" . $_POST['servcode'] . "'";
+ pg_exec($this->database, $qry);
+ }
+ else
+ {
+ // Checkbox was turned off, remove the service
+
+ $qry = "DELETE FROM object_service WHERE objectid='" . $_GET['oid'];
+ $qry .= "' AND servicecode='" . $_POST['servcode'] . "'";
+ pg_exec($this->database, $qry);
+ }
+ }
+ }
+ else if (isset($_POST['action']) && $_POST['action'] == 'Modify User')
+ {
+ $obj_srv_res = pg_exec($this->database, "SELECT * from object_user WHERE objectid='" . $_GET['oid']
+ . "' AND username='" . $_POST['username'] . "'");
+
+ if (pg_numrows($obj_srv_res) == 0)
+ {
+ // Add a new user for this object
+ if (isset($_POST['userused']))
+ {
+ $qry = "INSERT INTO object_user (objectid, username, security_level) ";
+ $qry .= "VALUES ('" . $_GET['oid'] . "', '" . $_POST['username'] . "', '";
+ $qry .= $_POST['seclevel'] . "')";
+
+ pg_exec($this->database, $qry);
+ }
+ }
+ else
+ {
+ // Modify or remove the user for this object
+ if (isset($_POST['userused']))
+ {
+ // Service is still used; update some values.
+ $qry = "UPDATE object_user SET security_level='" . $_POST['seclevel'];
+ $qry .= "' WHERE objectid='" . $_GET['oid'];
+ $qry .= "' AND username='" . $_POST['username'] . "'";
+ pg_exec($this->database, $qry);
+ }
+ else
+ {
+ // Checkbox was turned off, remove the user
+
+ $qry = "DELETE FROM object_user WHERE objectid='" . $_GET['oid'];
+ $qry .= "' AND username='" . $_POST['username'] . "'";
+ pg_exec($this->database, $qry);
+ }
+ }
+ }