array( "Back to HELO checks" => "checkhelo-main.php" ), )); # Display change screen if ($_POST['frmaction'] == "change") { # Check a helo check was selected if (isset($_POST['checkhelo_id'])) { # Prepare statement $stmt = $db->prepare(" SELECT ${DB_TABLE_PREFIX}checkhelo.ID, ${DB_TABLE_PREFIX}checkhelo.PolicyID, ${DB_TABLE_PREFIX}checkhelo.Name, ${DB_TABLE_PREFIX}checkhelo.UseBlacklist, ${DB_TABLE_PREFIX}checkhelo.BlacklistPeriod, ${DB_TABLE_PREFIX}checkhelo.UseHRP, ${DB_TABLE_PREFIX}checkhelo.HRPPeriod, ${DB_TABLE_PREFIX}checkhelo.HRPLimit, ${DB_TABLE_PREFIX}checkhelo.RejectInvalid, ${DB_TABLE_PREFIX}checkhelo.RejectIP, ${DB_TABLE_PREFIX}checkhelo.RejectUnresolvable, ${DB_TABLE_PREFIX}checkhelo.Comment, ${DB_TABLE_PREFIX}checkhelo.Disabled, ${DB_TABLE_PREFIX}policies.Name AS PolicyName FROM ${DB_TABLE_PREFIX}checkhelo, ${DB_TABLE_PREFIX}policies WHERE ${DB_TABLE_PREFIX}checkhelo.ID = ? AND ${DB_TABLE_PREFIX}policies.ID = ${DB_TABLE_PREFIX}checkhelo.PolicyID "); ?>
Update HELO/EHLO Check
HELO/EHLO Update Results
quote($_POST['checkhelo_policyid'])); } if (!empty($_POST['checkhelo_name'])) { array_push($updates,"Name = ".$db->quote($_POST['checkhelo_name'])); } if (!empty($_POST['checkhelo_useblacklist'])) { if ($_POST['checkhelo_useblacklist'] == "1") { $useblacklist = null; } elseif ($_POST['checkhelo_useblacklist'] == "2") { $useblacklist = 1; } elseif ($_POST['checkhelo_useblacklist'] == "3") { $useblacklist = 0; } array_push($updates,"UseBlacklist = ".$db->quote($useblacklist)); } if (!empty($_POST['checkhelo_blacklistperiod_m'])) { if ($_POST['checkhelo_blacklistperiod_m'] == "1") { $blacklistperiod = null; } elseif ($_POST['checkhelo_blacklistperiod_m'] == "2") { $blacklistperiod = $_POST['checkhelo_blacklistperiod']; } array_push($updates,"BlacklistPeriod = ".$db->quote($blacklistperiod)); } if (!empty($_POST['checkhelo_usehrp'])) { if ($_POST['checkhelo_usehrp'] == "1") { $usehrp = null; } elseif ($_POST['checkhelo_usehrp'] == "2") { $usehrp = 1; } elseif ($_POST['checkhelo_usehrp'] == "3") { $usehrp = 0; } array_push($updates,"UseHRP = ".$db->quote($usehrp)); } if (!empty($_POST['checkhelo_hrpperiod_m'])) { if ($_POST['checkhelo_hrpperiod_m'] == "1") { $hrpperiod = null; } elseif ($_POST['checkhelo_hrpperiod_m'] == "2") { $hrpperiod = $_POST['checkhelo_hrpperiod']; } array_push($updates,"HRPPeriod = ".$db->quote($hrpperiod)); } if (!empty($_POST['checkhelo_hrplimit_m'])) { if ($_POST['checkhelo_hrplimit_m'] == "1") { $hrplimit = null; } elseif ($_POST['checkhelo_hrplimit_m'] == "2") { $hrplimit = $_POST['checkhelo_hrplimit']; } array_push($updates,"HRPLimit = ".$db->quote($hrplimit)); } if (!empty($_POST['checkhelo_rejectinvalid'])) { if ($_POST['checkhelo_rejectinvalid'] == "1") { $rejectinvalid = null; } elseif ($_POST['checkhelo_rejectinvalid'] == "2") { $rejectinvalid = 1; } elseif ($_POST['checkhelo_rejectinvalid'] == "3") { $rejectinvalid = 0; } array_push($updates,"RejectInvalid = ".$db->quote($rejectinvalid)); } if (!empty($_POST['checkhelo_rejectip'])) { if ($_POST['checkhelo_rejectip'] == "1") { $rejectip = null; } elseif ($_POST['checkhelo_rejectip'] == "2") { $rejectip = 1; } elseif ($_POST['checkhelo_rejectip'] == "3") { $rejectip = 0; } array_push($updates,"RejectIP = ".$db->quote($rejectip)); } if (!empty($_POST['checkhelo_rejectunresolvable'])) { if ($_POST['checkhelo_rejectunresolvable'] == "1") { $rejectunresolvable = null; } elseif ($_POST['checkhelo_rejectunresolvable'] == "2") { $rejectunresolvable = 1; } elseif ($_POST['checkhelo_rejectunresolvable'] == "3") { $rejectunresolvable = 0; } array_push($updates,"RejectUnresolvable = ".$db->quote($rejectunresolvable)); } if (!empty($_POST['checkhelo_comment'])) { array_push($updates,"Comment = ".$db->quote($_POST['checkhelo_comment'])); } if (isset($_POST['checkhelo_disabled']) && $_POST['checkhelo_disabled'] != "") { array_push($updates ,"Disabled = ".$db->quote($_POST['checkhelo_disabled'])); } # Check if we have updates if (sizeof($updates) > 0) { $updateStr = implode(', ',$updates); $res = $db->exec("UPDATE ${DB_TABLE_PREFIX}checkhelo SET $updateStr WHERE ID = ".$db->quote($_POST['checkhelo_id'])); if ($res) { ?>