<?php

	require('../includes/config.inc.php');

	$MemberID = addslashes($_REQUEST['MemberID']);
	$SendID   = addslashes($_REQUEST['SendID']);
	$emailtype = addslashes($_REQUEST['Type']);

	$member_check_result = mysql_query("SELECT COUNT(*) FROM " . $TABLEPREFIX . "members WHERE MemberID='".$MemberID."'");
	$member_check = mysql_result($member_check_result, 0, 0);

	if ($member_check <= 0) exit();

	switch($emailtype) {
		case 'Auto':
			$send_check_result = mysql_query("SELECT COUNT(*) FROM " . $TABLEPREFIX . "autoresponders WHERE AutoresponderID='".$SendID."'");
		break;
		default:
			$send_check_result = mysql_query("SELECT COUNT(*) FROM " . $TABLEPREFIX . "sends WHERE SendID='".$SendID."'");
	}
	$send_check = mysql_result($send_check_result, 0, 0);

	if ($send_check <= 0) exit();

	// Has this open already been tracked?
	$alreadyTracked = mysql_result(mysql_query("SELECT COUNT(*) FROM " . $TABLEPREFIX . "email_opens WHERE MemberID='".$MemberID."' and SendID='".$SendID."' AND EmailType='".$emailtype."'"), 0, 0) > 0 ? true : false;

	if(!$alreadyTracked) {
		mysql_query("INSERT INTO " . $TABLEPREFIX . "email_opens SET MemberID='".$MemberID."', SendID='".$SendID."', TimeStamp='".addslashes($SYSTEMTIME)."', EmailType='" . $emailtype . "'");
	}

?>