<?php
include('db.php');
function checkEmail($email) {
$db = opendb();
$sql = "select email from email where email='".$email."';";
$res = mysql_fetch_array(mysql_query($sql));
if($res){
closedb($db);
return 0;
}
 if(preg_match("/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/" , $email)){
  list($username,$domain) = split('@', $email);
  if(!checkdnsrr($domain,'MX')){
   closedb($db);
   return false;
  }
  closedb($db);
  return true;
 }
 closedb($db);
 return false;
}

function addEmail($email, $ip) {
$db = opendb();
$sql = "insert into email (email, ip, date) values 
        ('".$email."', '".$ip."', '".date('Y-m-d')."')";
mysql_query($sql);
closedb($db);
}

function checkIP($ip) {
$db = opendb();
$today = date('Y-m-d');
$sql = "select count(id) from email where ip='".$ip."' and date='".$today."';";
$res = mysql_fetch_array(mysql_query($sql));

if($res and $res[0] >= 100){
    closedb($db);
    return 0;
}
closedb($db);
return 1;
}
?>