<?php
header("Cache-Control: no-cache, must-revalidate");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");

include_once("config/all_kes_con.php");

	$hash = $_GET['h'];
	$nieuwsbrief_id = $_GET['n'];
	$datum = date("Y-m-d");
	$tijd = date("H:i:s"); 
	$ip = "0000";
	
	$hash = mysql_real_escape_string(trim(urldecode($hash))); 
	$nieuwsbrief_id = mysql_real_escape_string(trim(urldecode($nieuwsbrief_id))); 
	
	$hash = checkData($hash);
	$nieuwsbrief_id = checkData($nieuwsbrief_id);
			
	$q_id = sprintf("SELECT kes_emailadressen.email_id FROM kes_emailadressen WHERE kes_emailadressen.hash='%s' LIMIT 0,1", $hash);
	$r_id = mysql_query($q_id);
	$rec_id = mysql_fetch_assoc($r_id);
			
	$email_id = $rec_id['email_id'];
	
	$q_track = sprintf("INSERT INTO kes_track_email(email_id, nieuwsbrief_id, datum, tijd, ip) VALUES ('%s', '%s', '%s', '%s', '%s')", 
		$email_id,
		$nieuwsbrief_id,
		$datum, 
		$tijd,
		$ip);
		
	$r_track = mysql_query($q_track);

header("Location: ".$config['kes']['locatie_spacer']."spacer.gif");
return;

?>