/src/beheer/mailaanmeldingen.php

<?php
/*	$items = explode(",", $_POST["mailitems"]);

	$aanvragen2mail = "0";
	for($i = 0; $i < count($items); $i++){
		if(isset($_POST["mailitem".$items[$i]])) {
			$aanvragen2mail = $aanvragen2mail.",".$items[$i];
		}
	}

*/
	$aanvragen2mail = $_POST["aanvragen2mail"];
	
	mysql_query( "UPDATE aanvragen SET datumgemaild='".date("d-m-Y")."' WHERE aanvraag_id IN (".$aanvragen2mail.")" );
	
	$sql = "SELECT aanvragen.*, aanbieders.bedrijfsnaam bedrijfsnaam
			  FROM aanvragen, aanbieders
			  WHERE aanbieders.id = aanvragen.aanbieder
			    AND aanvraag_id IN (".$aanvragen2mail.")";

	$conn = mysql_connect('91.184.10.91', 'mysqlgratisgolf', 'g0lfp0l1s');
	mysql_select_db('gratisgolfpolis', $conn);
	
	$maillist = mysql_query( $sql );
	
	$result = mysql_query("SELECT * FROM applicatie");
	$approw = mysql_fetch_array($result);
	
	while($row = mysql_fetch_array( $maillist ))
	{

$to = $row["email"];
$subject = 'uw gratis-golfpolis eindigt binnenkort!'; 
$random_hash = md5(date('r', time())); 
$headers = "From: info@gratis-golfpolis.nl\r\nReply-To: info@gratis-golfpolis.nl\r\nBcc: einde@gratisgolfpolis.nl";
$headers .= "\r\nContent-Type: text/html; charset=\"iso-8859-1\"; boundary=\"PHP-alt-".$random_hash."\""; 
ob_start(); //Turn on output buffering

$mailcontents = str_replace("{choice::geslacht}","{".$row["geslacht"]."}", $approw["content_email"]);
?>

<table width="650">
<tr><td width="650" align="right"><img src="http://www.gratisgolfpolis.nl/images/logo_intergolf.png"/></td></tr>
</table>
<?

echo str_replace("{euml}"  		  , "&euml;"           ,
	 str_replace("{EUML}"  		  , "&Euml;"           ,
	 str_replace("{EURO}"  		  , "&euro;"           ,
	 str_replace("{reg}"   		  , "&reg;"            , 
	 str_replace("{man}"   		  , "heer"             ,
	 str_replace("{vrouw}" 		  , "mevrouw"          ,
	 str_replace("{achternaam}"   , $row["achternaam"] ,
	 str_replace("{aanbiedernaam}", $row["bedrijfsnaam"] ,
	 str_replace("{aankoopdatum}" , createFullDate($row["aankoopdag"],$row["aankoopmaand"],$row["aankoopjaar"] ) ,
	 str_replace("{afloopdatum}"  , getAfloopdatum($row["aankoopdag"],$row["aankoopmaand"],$row["aankoopjaar"]) ,
	 $mailcontents ))))))))));
	 
//	 str_replace("{aankoopdatum}" , $row["aankoopdag"]."-".$row["aankoopmaand"]."-".$row["aankoopjaar"] ,



//copy current buffer contents into $message variable and delete current output buffer
$message = ob_get_clean();
//send the email
$mail_sent = @mail( $to, $subject, $message, $headers );

}

function getAfloopdatum($day,$month,$year){
	$dob1=$day."/".$month."/".$year;
	list($d, $m, $y) = explode('/', $dob1);
	$mk=mktime(0, 0, 0, $m, $d, $y);
	$dob_disp1=strftime('%Y-%m-%d',$mk);
	
	$end = date("j-n-Y", strtotime($dob_disp1 . "+99 day"));
	list($d, $m, $y) = explode('-', $end);
	
	return createFullDate($d, $m, $y );
}

function createFullDate($day,$month,$year,$notation) {
	$result = "";

	$months = Array(  "januari"
	                , "februari"
	                , "maart"
	                , "april"
	                , "mei"
	                , "juni"
	                , "juli"
	                , "augustus"
	                , "september"
	                , "oktober"
	                , "november"
	                , "december" );
	
	if($notation == "dd mmmm yyyy") {
		if($day<10) { $result =  "0"; }
		$result = $result.$day." ".$months[$month-1]." ".$year;
	} elseif ($notation == "d mmmm yyyy") {
		$result = $day." ".$months[$month-1]." ".$year;
	} elseif ($notation == "d-m-yyyy") {
		$result = $day."-".$month."-".$year;
	} else {
	
		if($day<10) { $result =  "0"; }
		$result = $result.$day."-";
		
		if($month<10) { $result =  $result."0"; }
		$result = $result.$month."-".$year;
	}

	return $result;
}
?>

<table width="1000" style="background-color:#eeeeee; color:#000000; font-family:Arial, Helvetica, sans-serif; font-size:11px; font-weight:normal; border-color:#CCCCCC;" border="1" cellpadding="1" cellspacing="0">
	<tr><td>&nbsp;</td></tr>
    <tr>
    	<td>
        	<b>&nbsp;&nbsp;Ondestaande emailadressen zijn gemaild:</b><br />
            <ul>
<?php
	$maillist = mysql_query( $sql );
	
	while($row = mysql_fetch_array( $maillist ))
	{
    	echo "<li>".$row["voorletters"]." ".$row["achternaam"]." - ".$row["email"]."</li>";
	}
?>
            </ul>
        </td>
    </tr>
    <tr><td>&nbsp;</td></tr>
</table>