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

Update Accounting

execute(array($_POST['accounting_id'])); $row = $stmt->fetchObject(); $stmt->closeCursor(); ?> accountingperiod == "0") { $accountingperiod = "Daily"; } elseif ($row->accountingperiod == "1") { $accountingperiod = "Weekly"; } elseif ($row->accountingperiod == "2") { $accountingperiod = "Monthly"; } ?>
Old Value New Value
Name name ?>
Link to policy policyname ?>
Track track ?>
Period
Message Count Limit messagecountlimit ? $row->messagecountlimit : '-none-' ?>
Message Cumulative Size Limit messagecumulativesizelimit ? $row->messagecumulativesizelimit : '-none-' ?> Kbyte
Verdict verdict ?>
Data data ?>
Stop processing here lastaccounting ? 'yes' : 'no' ?>
Comment comment ?>
Disabled disabled ? 'yes' : 'no' ?>

No accounting selected

Accounting Update Results

quote($_POST['accounting_policyid'])); } if (!empty($_POST['accounting_name'])) { array_push($updates,"Name = ".$db->quote($_POST['accounting_name'])); } if (!empty($_POST['accounting_track'])) { if ($_POST['accounting_track'] == "SenderIP") { $accountingTrack = sprintf('%s:%s',$_POST['accounting_track'],$_POST['accounting_trackextra']); } else { $accountingTrack = $_POST['accounting_track']; } array_push($updates,"Track = ".$db->quote($accountingTrack)); } if (isset($_POST['accounting_period']) && $_POST['accounting_period'] != "") { array_push($updates,"AccountingPeriod = ".$db->quote($_POST['accounting_period'])); } if (!empty($_POST['accounting_messagecountlimit'])) { array_push($updates,"MessageCountLimit = ".$db->quote($_POST['accounting_messagecountlimit'])); } if (!empty($_POST['accounting_messagecumulativesizelimit'])) { array_push($updates,"MessageCumulativeSizeLimit = ".$db->quote($_POST['accounting_messagecumulativesizelimit'])); } if (!empty($_POST['accounting_verdict'])) { array_push($updates,"Verdict = ".$db->quote($_POST['accounting_verdict'])); } if (!empty($_POST['accounting_data'])) { array_push($updates,"Data = ".$db->quote($_POST['accounting_data'])); } if (!empty($_POST['accounting_lastaccounting'])) { array_push($updates,"LastAccounting = ".$db->quote($_POST['accounting_lastaccounting'])); } if (!empty($_POST['accounting_comment'])) { array_push($updates,"Comment = ".$db->quote($_POST['accounting_comment'])); } if (isset($_POST['accounting_disabled']) && $_POST['accounting_disabled'] != "") { array_push($updates ,"Disabled = ".$db->quote($_POST['accounting_disabled'])); } # Check if we have updates if (sizeof($updates) > 0) { $updateStr = implode(', ',$updates); $res = $db->exec("UPDATE ${DB_TABLE_PREFIX}accounting SET $updateStr WHERE ID = ".$db->quote($_POST['accounting_id'])); if ($res) { ?>
Accounting updated
Error updating accounting!
errorInfo()) ?>
No changes made to accounting
Invalid invocation