array( "Back to SPF checks" => "checkspf-main.php" ), )); # Display change screen if ($_POST['frmaction'] == "change") { # Check a SPF check was selected if (isset($_POST['checkspf_id'])) { # Prepare statement $stmt = $db->prepare(" SELECT ${DB_TABLE_PREFIX}checkspf.ID, ${DB_TABLE_PREFIX}checkspf.PolicyID, ${DB_TABLE_PREFIX}checkspf.Name, ${DB_TABLE_PREFIX}checkspf.UseSPF, ${DB_TABLE_PREFIX}checkspf.RejectFailedSPF, ${DB_TABLE_PREFIX}checkspf.AddSPFHeader, ${DB_TABLE_PREFIX}checkspf.Comment, ${DB_TABLE_PREFIX}checkspf.Disabled, ${DB_TABLE_PREFIX}policies.Name AS PolicyName FROM ${DB_TABLE_PREFIX}checkspf, ${DB_TABLE_PREFIX}policies WHERE ${DB_TABLE_PREFIX}checkspf.ID = ? AND ${DB_TABLE_PREFIX}policies.ID = ${DB_TABLE_PREFIX}checkspf.PolicyID "); ?>
Update SPF Check
SPF Check Update Results
quote($_POST['checkspf_policyid'])); } if (!empty($_POST['checkspf_name'])) { array_push($updates,"Name = ".$db->quote($_POST['checkspf_name'])); } if (!empty($_POST['checkspf_usespf'])) { if ($_POST['checkspf_usespf'] == "1") { $usespf = null; } elseif ($_POST['checkspf_usespf'] == "2") { $usespf = 1; } elseif ($_POST['checkspf_usespf'] == "3") { $usespf = 2; } array_push($updates,"UseSPF = ".$db->quote($usespf)); } if (!empty($_POST['checkspf_rejectfailed'])) { if ($_POST['checkspf_rejectfailed'] == "1") { $rejectfailed = null; } elseif ($_POST['checkspf_rejectfailed'] == "2") { $rejectfailed = 1; } elseif ($_POST['checkspf_rejectfailed'] == "3") { $rejectfailed = 2; } array_push($updates,"RejectFailedSPF = ".$db->quote($rejectfailed)); } if (!empty($_POST['checkspf_addheader'])) { if ($_POST['checkspf_addheader'] == "1") { $addheader = null; } elseif ($_POST['checkspf_addheader'] == "2") { $addheader = 1; } elseif ($_POST['checkspf_addheader'] == "3") { $addheader = 2; } array_push($updates,"AddSPFHeader = ".$db->quote($addheader)); } if (!empty($_POST['checkspf_comment'])) { array_push($updates,"Comment = ".$db->quote($_POST['checkspf_comment'])); } if (isset($_POST['checkspf_disabled']) && $_POST['checkspf_disabled'] != "") { array_push($updates ,"Disabled = ".$db->quote($_POST['checkspf_disabled'])); } # Check if we have updates if (sizeof($updates) > 0) { $updateStr = implode(', ',$updates); $res = $db->exec("UPDATE ${DB_TABLE_PREFIX}checkspf SET $updateStr WHERE ID = ".$db->quote($_POST['checkspf_id'])); if ($res) { ?>