68 lines
1.8 KiB
PHP
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();
|
|
?>
|