array( "Back to greylisting" => "greylisting-main.php" ), )); # Display change screen if ($_POST['frmaction'] == "change") { # Check a ${DB_TABLE_PREFIX}greylisting was selected if (isset($_POST['greylisting_id'])) { # Prepare statement $stmt = $db->prepare(" SELECT ${DB_TABLE_PREFIX}greylisting.ID, ${DB_TABLE_PREFIX}greylisting.PolicyID, ${DB_TABLE_PREFIX}greylisting.Name, ${DB_TABLE_PREFIX}greylisting.UseGreylisting, ${DB_TABLE_PREFIX}greylisting.GreylistPeriod, ${DB_TABLE_PREFIX}greylisting.Track, ${DB_TABLE_PREFIX}greylisting.GreylistAuthValidity, ${DB_TABLE_PREFIX}greylisting.GreylistUnAuthValidity, ${DB_TABLE_PREFIX}greylisting.useAutoWhitelist, ${DB_TABLE_PREFIX}greylisting.AutoWhitelistPeriod, ${DB_TABLE_PREFIX}greylisting.AutoWhitelistCount, ${DB_TABLE_PREFIX}greylisting.AutoWhitelistPercentage, ${DB_TABLE_PREFIX}greylisting.useAutoBlacklist, ${DB_TABLE_PREFIX}greylisting.AutoBlacklistPeriod, ${DB_TABLE_PREFIX}greylisting.AutoBlacklistCount, ${DB_TABLE_PREFIX}greylisting.AutoBlacklistPercentage, ${DB_TABLE_PREFIX}greylisting.Comment, ${DB_TABLE_PREFIX}greylisting.Disabled, ${DB_TABLE_PREFIX}policies.Name AS PolicyName FROM ${DB_TABLE_PREFIX}greylisting, ${DB_TABLE_PREFIX}policies WHERE ${DB_TABLE_PREFIX}greylisting.ID = ? AND ${DB_TABLE_PREFIX}policies.ID = ${DB_TABLE_PREFIX}greylisting.PolicyID "); ?>

Update Greylisting

execute(array($_POST['greylisting_id'])); $row = $stmt->fetchObject(); $stmt->closeCursor(); ?>
Old Value New Value
Name name ?>
Link to policy policyname ?>
Greylisting
Use Greylisting usegreylisting) { case null: echo "Inherit"; break; case 0: echo "No"; break; case 1: echo "Yes"; break; default: echo "UNKNOWN"; break; } ?>
Greylist Period greylistperiod) ? '*inherited*' : $row->greylistperiod ?>
Track track ?>
Greylist Auth Validity greylistauthvalidity) ? '*inherited*' : $row->greylistauthvalidity ?>
Greylist UnAuth Validity greylistunauthvalidity) ? '*inherited*' : $row->greylistunauthvalidity ?>
Auto-Whitelisting
Use AWL useautowhitelist) { case null: echo "Inherit"; break; case 0: echo "No"; break; case 1: echo "Yes"; break; default: echo "UNKNOWN"; break; } ?>
AWL Period autowhitelistperiod) ? '*inherited*' : $row->autowhitelistperiod ?>
AWL After Count autowhitelistcount)) { echo '*inherited*'; } elseif ($row->autowhitelistcount == "0") { echo '*disabled*'; } else { echo $row->autowhitelistcount; } ?>
AWL After Percentage autowhitelistpercentage)) { echo '*inherited*'; } elseif ($row->autowhitelistpercentage == "0") { echo '*disabled*'; } else { echo $row->autowhitelistpercentage; } ?>
Auto-Blacklisting
Use ABL useautoblacklist) { case null: echo "Inherit"; break; case 0: echo "No"; break; case 1: echo "Yes"; break; default: echo "UNKNOWN"; break; } ?>
ABL Period autoblacklistperiod) ? '*inherited*' : $row->autoblacklistperiod ?>
ABL After Count autoblacklistcount)) { echo '*inherited*'; } elseif ($row->autoblacklistcount == "0") { echo '*disabled*'; } else { echo $row->autoblacklistcount; } ?>
ABL After Percentage autoblacklistpercentage)) { echo '*inherited*'; } elseif ($row->autoblacklistpercentage == "0") { echo '*disabled*'; } else { echo $row->autoblacklistpercentage; } ?>
 
Comment comment ?>
Disabled disabled ? 'yes' : 'no' ?>

No Greylisting check selected

Greylisting Update Results

quote($_POST['greylisting_policyid'])); } if (!empty($_POST['greylisting_name'])) { array_push($updates,"Name = ".$db->quote($_POST['greylisting_name'])); } if (!empty($_POST['greylisting_usegreylisting'])) { if ($_POST['greylisting_usegreylisting'] == "1") { $usegreylisting = "NULL"; } elseif ($_POST['greylisting_usegreylisting'] == "2") { $usegreylisting = $db->quote(1); } elseif ($_POST['greylisting_usegreylisting'] == "3") { $usegreylisting = $db->quote(0); } array_push($updates,"UseGreylisting = $usegreylisting"); } if (!empty($_POST['greylisting_period_m'])) { if ($_POST['greylisting_period_m'] == "1") { $period = "NULL"; } elseif ($_POST['greylisting_period_m'] == "2") { $period = $db->quote($_POST['greylisting_period']); } array_push($updates,"GreylistPeriod = $period"); } if (!empty($_POST['greylisting_track'])) { if ($_POST['greylisting_track'] == "SenderIP") { $track = sprintf('%s:%s',$_POST['greylisting_track'],$_POST['greylisting_trackextra']); } else { $track = $_POST['greylisting_track']; } array_push($updates,"Track = ".$db->quote($track)); } if (!empty($_POST['greylisting_authvalidity_m'])) { if ($_POST['greylisting_authvalidity_m'] == "1") { $validity = "NULL"; } elseif ($_POST['greylisting_authvalidity_m'] == "2") { $validity = $db->quote($_POST['greylisting_authvalidity']); } array_push($updates,"GreylistAuthValidity = $validity"); } if (!empty($_POST['greylisting_unauthvalidity_m'])) { if ($_POST['greylisting_unauthvalidity_m'] == "1") { $validity = "NULL"; } elseif ($_POST['greylisting_unauthvalidity_m'] == "2") { $validity = $db->quote($_POST['greylisting_unauthvalidity']); } array_push($updates,"GreylistUnAuthValidity = $validity"); } # Autowhitelist if (!empty($_POST['greylisting_useawl'])) { if ($_POST['greylisting_useawl'] == "1") { $useawl = "NULL"; } elseif ($_POST['greylisting_useawl'] == "2") { $useawl = $db->quote(1); } elseif ($_POST['greylisting_useawl'] == "3") { $useawl = $db->quote(0); } array_push($updates,"UseAutoWhitelist = $useawl"); } if (!empty($_POST['greylisting_awlperiod_m'])) { if ($_POST['greylisting_awlperiod_m'] == "1") { $awlperiod = "NULL"; } elseif ($_POST['greylisting_awlperiod_m'] == "2") { $awlperiod = $db->quote($_POST['greylisting_awlperiod']); } array_push($updates,"AutoWhitelistPeriod = $awlperiod"); } # AWL Count if (!empty($_POST['greylisting_awlcount_m'])) { if ($_POST['greylisting_awlcount_m'] == "0") { $awlcount = $db->quote(0); } elseif ($_POST['greylisting_awlcount_m'] == "1") { $awlcount = "NULL"; } elseif ($_POST['greylisting_awlcount_m'] == "2") { $awlcount = $db->quote($_POST['greylisting_awlcount']); } array_push($updates,"AutoWhitelistCount = $awlcount"); } # AWL Percentage if (!empty($_POST['greylisting_awlpercentage_m'])) { if ($_POST['greylisting_awlpercentage_m'] == "0") { $awlpercentage = $db->quote(0); } elseif ($_POST['greylisting_awlpercentage_m'] == "1") { $awlpercentage = "NULL"; } elseif ($_POST['greylisting_awlpercentage_m'] == "2") { $awlpercentage = $db->quote($_POST['greylisting_awlpercentage']); } array_push($updates,"AutoWhitelistPercentage = $awlpercentage"); } # Autoblacklist if (!empty($_POST['greylisting_useabl'])) { if ($_POST['greylisting_useabl'] == "1") { $useabl = "NULL"; } elseif ($_POST['greylisting_useabl'] == "2") { $useabl = $db->quote(1); } elseif ($_POST['greylisting_useabl'] == "3") { $useabl = $db->quote(0); } array_push($updates,"UseAutoBlacklist = $useabl"); } if (!empty($_POST['greylisting_ablperiod_m'])) { if ($_POST['greylisting_ablperiod_m'] == "1") { $ablperiod = "NULL"; } elseif ($_POST['greylisting_ablperiod_m'] == "2") { $ablperiod = $db->quote($_POST['greylisting_ablperiod']); } array_push($updates,"AutoBlacklistPeriod = $ablperiod"); } # ABL Count if (!empty($_POST['greylisting_ablcount_m'])) { if ($_POST['greylisting_ablcount_m'] == "0") { $ablcount = $db->quote(0); } elseif ($_POST['greylisting_ablcount_m'] == "1") { $ablcount = "NULL"; } elseif ($_POST['greylisting_ablcount_m'] == "2") { $ablcount = $db->quote($_POST['greylisting_ablcount']); } array_push($updates,"AutoBlacklistCount = $ablcount"); } # ABL Percentage if (!empty($_POST['greylisting_ablpercentage_m'])) { if ($_POST['greylisting_ablpercentage_m'] == "0") { $ablpercentage = $db->quote(0); } elseif ($_POST['greylisting_ablpercentage_m'] == "1") { $ablpercentage = "NULL"; } elseif ($_POST['greylisting_ablpercentage_m'] == "2") { $ablpercentage = $db->quote($_POST['greylisting_ablpercentage']); } array_push($updates,"AutoBlacklistPercentage = $ablpercentage"); } if (!empty($_POST['greylisting_comment'])) { array_push($updates,"Comment = ".$db->quote($_POST['greylisting_comment'])); } if (isset($_POST['greylisting_disabled']) && $_POST['greylisting_disabled'] != "") { array_push($updates ,"Disabled = ".$db->quote($_POST['greylisting_disabled'])); } # Check if we have updates if (sizeof($updates) > 0) { $updateStr = implode(', ',$updates); $res = $db->exec("UPDATE ${DB_TABLE_PREFIX}greylisting SET $updateStr WHERE ID = ".$db->quote($_POST['greylisting_id'])); if ($res) { ?>
Greylisting updated
Error updating Greylisting!
errorInfo()) ?>
No changes made to Greylisting
Invalid invocation