<?php

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

	if (!isset($_GET['MemberID']) || !isset($_GET['SendID']) || !isset($_GET['Type'])) {
		DisplayImage();
		exit();
	}

	$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) {
		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) {
			// 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 . "'");
			}
		}
	}

DisplayImage();

function DisplayImage() {
	global $ROOTDIR;
	// open the file in a binary mode
	$name = $ROOTDIR . 'admin/images/open.gif';
	$fp = fopen($name, 'rb');

	// send the right headers
	header("Content-Type: image/gif");
	header("Content-Length: " . filesize($name));

	// dump the picture and stop the script
	fpassthru($fp);
	exit(0);
}
?>