<?php

function Error($file, $line)
{
  $recipient = "support@puredev.com";
  $subject = "Avotaynu Error Notification";
  $error = "$subject\n\nError #: ".mysql_errno()."\n\nError Message: ".mysql_error()."\n\nFile: ".$file."\n\nLine #: ".$line;
  $headers = "From: support@puredev.com\nX-Sender: support@puredev.com\nX-Mailer: PHP\nErrors-To: support@puredev.com";

  mail($recipient, $subject, $error, $headers);

  echo "<p><b>An error has occurred and technical support has been notified. Thank you for your patience and please try again later.</b></p>\n";
}

header('Content-type: application/octet-stream');

$email = $_GET["e"];
$name = $_GET["n"];
$serial_num = $_GET["sn"];

if($name == '' || $email == '' || $serial_num == '')
{
	echo "1";
}
else
{
	$connect = mysql_connect("localhost", "avotaynt_user", "8Arde3OXA")
	    or die(Error(__FILE__, __LINE__));
	
	$db = mysql_select_db("avotaynt_apps")
	  or die(Error(__FILE__, __LINE__));
	
	$query_result = mysql_query("SELECT install_count FROM users WHERE serial_num = ".$serial_num)
	  or die(Error(__FILE__, __LINE__));
	
	if($query_row = mysql_fetch_array($query_result))
	{
		if($query_row["install_count"] >= 2)
		{
			echo "3";
	
			$recipient = "inquiry@avotaynu.net";
			//$recipient = "support@puredev.com";
			$subject = "Avotaynu Customer [".$name."] Over Install Limit";
			$message = "Email: ".$email."\nName: ".$name."\nSerial Number: ".$serial_num;
			$headers = "From: ".$email;
	
			mail($recipient, $subject, $message, $headers)
				or die(Error(__FILE__, __LINE__));
		}
		else
		{
			echo "0";
	
			$new_install_count = $query_row["install_count"] + 1;
	
			$insert_result = mysql_query("UPDATE users SET email = \"".$email."\", name = \"".$name."\", install_count = ".$new_install_count." WHERE serial_num = ".$serial_num)
	      or die(Error(__FILE__, __LINE__));
	      
	    $fp = fopen('Avotaynu.lcs', 'rb');
	    
	    fpassthru($fp);
	
			$recipient = "inquiry@avotaynu.net";
			//$recipient = "support@puredev.com";
			$subject = "New Registration [".$name."]";
			$message = "Email: ".$email."\nName: ".$name."\nSerial Number: ".$serial_num;
			$headers = "From: ".$email;
	
			mail($recipient, $subject, $message, $headers)
				or die(Error(__FILE__, __LINE__));
		}	
	}
	else
	{
		echo "2";
	}
}

?>
