<?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");
include_once("functions.php");

	$hash = $_GET['h'];
	$nieuwsbrief_id = $_GET['n'];
	$url = $_GET['u'];
	$link_id = $_GET['i'];
	$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))); 
	$url = mysql_real_escape_string(trim(urldecode($url))); 
	$link_id = mysql_real_escape_string(trim(urldecode($link_id))); 
	
	$hash = checkData($hash);
	$nieuwsbrief_id = checkData($nieuwsbrief_id);
	$url = checkData($url);
	$link_id = checkData($link_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);
	
	if(empty($link_id)){ $link_id = "0"; }
			
	$email_id = $rec_id['email_id'];
	
	$q_track = sprintf("INSERT INTO kes_track_link(email_id, nieuwsbrief_id, link_id, url, datum, tijd, ip) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s')", 
		$email_id,
		$nieuwsbrief_id,
		$link_id,
		$url,
		$datum, 
		$tijd,
		$ip);
		
	$r_track = mysql_query($q_track);

header("Location: " .$url);
return;

?>