<?php

	$server = "YDAWBH006";
	$database_naam = "ml";
	$gebruikersnaam = "mailing";
	$wachtwoord = "mailing123";
	$datum_vandaag = date('Y-m-d');
	$jaar = date('Y');
	$maand = date('m');
	$dag = date('d');
	
	$conn_send=mysql_connect('YDAWBH006', 'mailing', 'mailing123');
	mysql_select_db('ml');

	require_once '../phpmailer/class.phpmailer.php';
	
	$query_adressen = "SELECT kes_send_table.send_id, kes_send_table.afzender_emailadres, kes_send_table.afzender_naam, kes_send_table.ontvanger_emailadres, kes_send_table.ontvanger_naam, kes_send_table.onderwerp, kes_send_table.inhoud, kes_send_table.verzend_datum FROM kes_send_table WHERE YEAR(kes_send_table.verzend_datum) <= '$jaar' AND MONTH(kes_send_table.verzend_datum) <= '$maand' AND DAY(kes_send_table.verzend_datum) <= '$dag' ORDER BY kes_send_table.verzend_datum ASC LIMIT 0,2";
		
	$res_adressen = mysql_query($query_adressen);
	
	$counter = 0;
	
	if($res_adressen){
	
		$mail                = new PHPMailer();

		$mail->IsSMTP(); 						// telling the class to use SMTP
   	 	$mail->Host       = "mail.yodahosting.nl"; // SMTP server
		$mail->SMTPKeepAlive = true;           	// SMTP connection will not close after each email sent
		$mail->SMTPAuth   = true;                  // enable SMTP authentication
		$mail->Host       = "mail.yodahosting.nl"; // sets the SMTP server
		$mail->Port       = 587;                    // set the SMTP port for the GMAIL server
		$mail->Username   = "mailservice@komma-mediadesign.nl"; // SMTP account username
		$mail->Password   = "ODK4m7fC";        // SMTP account password
		
		$eerste = true;

		while ($row = mysql_fetch_array($res_adressen)) {
			
			if($eerste){
				$eerste = false;
				$org_verzend_datum = $row['verzend_datum'];
			}			
			
			$mail->SetFrom($row['afzender_emailadres'], $row['afzender_naam']);
			$mail->AddReplyTo($row['afzender_emailadres'], $row['afzender_naam']);
			
			$mail->Subject = $row['onderwerp'];
			$mail->MsgHTML($row['inhoud']);
			$mail->AddAddress($row['ontvanger_emailadres'], $row['ontvanger_naam']);
		
			if( $mail->Send() ){
				$query_delete = sprintf("DELETE FROM kes_send_table WHERE kes_send_table.send_id = '%s'", $row['send_id']);
				$res_delete = mysql_query($query_delete);
				$counter = $counter + 1;
			}else{
				
				$datum = date("Y-m-d");
				$tijd = date("H:i:s");
				
				$query_error = sprintf("INSERT INTO kes_send_errors (afzender_emailadres, afzender_naam, ontvanger_emailadres, ontvanger_naam, onderwerp, inhoud, verzend_datum, invoeg_datum, tijd) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", 
					$row['afzender_emailadres'],
					$row['afzender_naam'],
					$row['ontvanger_emailadres'],
					$row['ontvanger_naam'],
					$row['onderwerp'],
					$row['inhoud'],
					$row['verzend_datum'],
					$datum,
					$tijd);
				
				$query_delete = sprintf("DELETE FROM kes_send_table WHERE kes_send_table.send_id = '%s'", $row[0]);
				$res_delete = mysql_query($query_delete);
				
				$error_counter = $error_counter + 1;
					
			}
			
			// Clear all addresses and attachments for next loop
			$mail->ClearAddresses();
			$mail->ClearAttachments();
			
			echo($row['ontvanger_emailadres']);
			
			sleep(3); // delay in seconden
				
		}
		
		$datum = date("Y-m-d");
		$tijd = date("H:i:s");  
		
		if($counter > 0 || $error_counter > 0){
			$query_history = sprintf("INSERT INTO kes_send_history(aantal, niet_verzonden, verzend_datum, werkelijke_datum, tijd) VALUES ('%s', '%s', '%s', '%s', '%s')", $counter, $error_counter, $org_verzend_datum, $datum, $tijd);
			$res_history = mysql_query($query_history);
		}
	}
?>