array( "Back to access cntrl" => "accesscontrol-main.php" ), )); # Display change screen if ($_POST['frmaction'] == "change") { # Check a access control was selected if (isset($_POST['accesscontrol_id'])) { # Prepare statement $stmt = $db->prepare(" SELECT ${DB_TABLE_PREFIX}access_control.ID, ${DB_TABLE_PREFIX}access_control.PolicyID, ${DB_TABLE_PREFIX}access_control.Name, ${DB_TABLE_PREFIX}access_control.Verdict, ${DB_TABLE_PREFIX}access_control.Data, ${DB_TABLE_PREFIX}access_control.Comment, ${DB_TABLE_PREFIX}access_control.Disabled, ${DB_TABLE_PREFIX}policies.Name AS PolicyName FROM ${DB_TABLE_PREFIX}access_control, ${DB_TABLE_PREFIX}policies WHERE ${DB_TABLE_PREFIX}access_control.ID = ? AND ${DB_TABLE_PREFIX}policies.ID = ${DB_TABLE_PREFIX}access_control.PolicyID "); ?>

Update Access Control

execute(array($_POST['accesscontrol_id'])); $row = $stmt->fetchObject(); $stmt->closeCursor(); ?>
Old Value New Value
Name name ?>
Link to policy policyname ?>
Verdict verdict ?>
Data data ?>
Comment comment ?>
Disabled disabled ? 'yes' : 'no' ?>

No access control selected

Access Control Update Results

quote($_POST['accesscontrol_policyid'])); } if (!empty($_POST['accesscontrol_name'])) { array_push($updates,"Name = ".$db->quote($_POST['accesscontrol_name'])); } if (!empty($_POST['accesscontrol_verdict'])) { array_push($updates,"Verdict = ".$db->quote($_POST['accesscontrol_verdict'])); } if (!empty($_POST['accesscontrol_data'])) { array_push($updates,"Data = ".$db->quote($_POST['accesscontrol_data'])); } if (!empty($_POST['accesscontrol_comment'])) { array_push($updates,"Comment = ".$db->quote($_POST['accesscontrol_comment'])); } if (isset($_POST['accesscontrol_disabled']) && $_POST['accesscontrol_disabled'] != "") { array_push($updates ,"Disabled = ".$db->quote($_POST['accesscontrol_disabled'])); } # Check if we have updates if (sizeof($updates) > 0) { $updateStr = implode(', ',$updates); $res = $db->exec("UPDATE ${DB_TABLE_PREFIX}access_control SET $updateStr WHERE ID = ".$db->quote($_POST['accesscontrol_id'])); if ($res) { ?>
Access control updated
Error updating access control!
errorInfo()) ?>
No changes made to access control
Invalid invocation