Files
Testing/phil/mail/smtp_validate_bak.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

68 lines
1.8 KiB
PHP

<?php
require_once('smtp_validate.class.php');
$msg="";
// the email to validate
//$email = 'porembaphilip@gmail.com';
if(isset($_GET["emailaddress"]))
{
$email=$_GET["emailaddress"];
}
else
{
//exit();
}
function dbconnect2()
{
$emsg="Ok";
$mhostname = "66.85.148.34";
$mdatabase = "bateworld";
$musername = "dolphin";
$mpassword = "dolphin";
mysql_connect($mhostname, $musername, $mpassword) or $emsg="Host Connect Error";
if($emsg=="Ok"){mysql_select_db($mdatabase) or $emsg="Database Connection Error";}
return($emsg);
}
$dbcon=dbconnect2();
$sql="SELECT `se_users`.`user_id`,
`se_users`.`user_email`
FROM `se_users`
WHERE 1>0 AND user_email like '%yahoo.com%'
ORDER BY `se_users`.`user_id` DESC LIMIT 1 OFFSET 0";
$result= mysql_query($sql) or $em=$em.mysql_error();
while ($row = mysql_fetch_assoc($result)) {
$email=trim($row["user_email"]);
// an optional sender
//$sender = 'host@bateworld.com';
// instantiate the class
$SMTP_Validator = new SMTP_validateEmail();
// turn on debugging if you want to view the SMTP transaction
$SMTP_Validator->debug = false;
// do the validation
$results = $SMTP_Validator->validate(array($email), $sender);
// view results
//echo $email.' is '.($results[$email] ? 'valid' : 'invalid')."\n";
// send email?
if ($results[$email]) {
$sqlup="UPDATE se_users SET user_pdp_evc = 1 WHERE user_email = '".$email."'";
$rup = mysql_query($sqlup) or $em=$em.mysql_error();
echo "<div>".$row["user_email"]." ".$row["user_id"]." cool</div>";
//mail($email, 'Confirm Email', 'Please reply to this email to confirm', 'From:'.$sender."\r\n"); // send email
} else {
$sqldown="UPDATE se_users SET user_pdp_evc = 0 WHERE user_email = '".$row["user_email"]."'";
$rup = mysql_query($sqldown) or $em=$em.mysql_error();
echo "<div>".$row["user_email"]." ".$row["user_id"]." not cool</div>";
var_dump($results);
}
}
exit();
?>