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

Update Quota

execute(array($_POST['quota_id'])); $row = $stmt->fetchObject(); $stmt->closeCursor(); ?>
Old Value New Value
Name name ?>
Link to policy policyname ?>
Track track ?>
Period period ?>
Verdict verdict ?>
Data data ?>
Stop processing here lastquota ? 'yes' : 'no' ?>
Comment comment ?>
Disabled disabled ? 'yes' : 'no' ?>

No quota selected

Access Control Update Results

quote($_POST['quota_policyid'])); } if (!empty($_POST['quota_name'])) { array_push($updates,"Name = ".$db->quote($_POST['quota_name'])); } if (!empty($_POST['quota_track'])) { if ($_POST['quota_track'] == "SenderIP") { $quotaTrack = sprintf('%s:%s',$_POST['quota_track'],$_POST['quota_trackextra']); } else { $quotaTrack = $_POST['quota_track']; } array_push($updates,"Track = ".$db->quote($quotaTrack)); } if (!empty($_POST['quota_period'])) { array_push($updates,"Period = ".$db->quote($_POST['quota_period'])); } if (!empty($_POST['quota_verdict'])) { array_push($updates,"Verdict = ".$db->quote($_POST['quota_verdict'])); } if (!empty($_POST['quota_data'])) { array_push($updates,"Data = ".$db->quote($_POST['quota_data'])); } if (isset($_POST['quota_lastquota']) && $_POST['quota_lastquota'] != "") { array_push($updates,"LastQuota = ".$db->quote($_POST['quota_lastquota'])); } if (!empty($_POST['quota_comment'])) { array_push($updates,"Comment = ".$db->quote($_POST['quota_comment'])); } if (isset($_POST['quota_disabled']) && $_POST['quota_disabled'] != "") { array_push($updates ,"Disabled = ".$db->quote($_POST['quota_disabled'])); } # Check if we have updates if (sizeof($updates) > 0) { $updateStr = implode(', ',$updates); $res = $db->exec("UPDATE ${DB_TABLE_PREFIX}quotas SET $updateStr WHERE ID = ".$db->quote($_POST['quota_id'])); if ($res) { ?>
Quota updated
Error updating quota!
errorInfo()) ?>
No changes made to quota
Invalid invocation