<?php
 
 include "../config.php";
 
 $today = date('Y-m-d',strtotime("now"));

 //Prune
 $sql = mysql_query("SELECT * FROM `members` WHERE `verified` = 0 AND `joindate` < '".date('Y-m-d',time()-24*60*60)."' and deleted=''");
 
 while($each = mysql_fetch_array($sql)) {  
 
		delete_account($each['userid']);
 
 }

 
 
 //Autoresponder
 $sql = mysql_query("SELECT * FROM autoresponder WHERE message != '' AND subject != ''");
 while($auto = mysql_fetch_array($sql)) {
 
 	if($auto['memtype'] != "All") $sql2 = mysql_query("SELECT * FROM members WHERE confirmed = '".date('Y-m-d',time()-$auto['days']*24*60*60-60*60)."' AND memtype='".$auto['memtype']."' and deleted=''");
 	else $sql2 = mysql_query("SELECT * FROM members WHERE confirmed = '".date('Y-m-d',time()-$auto['days']*24*60*60-60*60)."' and deleted=''");
 	
 	$Subjectold = $auto['subject'];
     $Messageold = $auto['message'];
 
     while ($line = mysql_fetch_array($sql2)) {
 		$name = $line["name"];
         $userid = $line['userid'];
         $password = $line['pword'];
         $contactemail = $line["contact_email"];
 
         //reset values.
         $headers = "";
         $Subject = $Subjectold;
         $Message = $Messageold;
 
         //replace the merge fields.
         $Subject = stripslashes($Subject);
 	$Subject = str_replace("~userid~",$userid,$Subject);
         $Subject = str_replace("~name~",$name,$Subject);
         $Subject = str_replace("~password~",$password,$Subject);
 
         $Message = stripslashes($Message);
 	$Message = str_replace("~userid~",$userid,$Message);
         $Message = str_replace("~name~",$name,$Message);
         $Message = str_replace("~password~",$password,$Message);
         $Message = str_replace("~email~",$contactemail,$Message);
 		
 		$name = trim($name);
 		if(strpos($name, " ")) $firstname = substr($name , 0, strpos($name, " "));
 		else $firstname = $name;
 		
 		$Message = str_replace("~fname~",$firstname,$Message);
         $Subject = str_replace("~fname~",$firstname,$Subject);
 		
 		$Message = "*********************\nAs a valued member of $sitename you have agreed to receive\ncontact from us. If you no longer want our messages, follow the instructions at the bottom.\n*********************\n\n".$Message."\n\n*********************\nYou are receiving this as you are a member of $sitename. You can opt out of receiving emails only by deleting your account, click here to delete your account.\n\n$domain/delete.php?userid=$userid&code=".md5($password)."\n\n$sitename\n$adminaddress";
 
         $headers .= "From: $sitename<$adminemail>\n";
 		$headers .= "Reply-To: <$adminemail>\n";
 		$headers .= "X-Sender: <$adminemail>\n";
 		$headers .= "X-Mailer: PHP4\n";
 		$headers .= "X-Priority: 3\n";
 		$headers .= "Return-Path: <$adminemail>\n";
		
		echo "Emailed $userid";
 
 		mail($contactemail, $Subject, $Message,$headers);
 	}
 	
 }

 
 
 
 mysql_close($dblink);
 
 ?>