<?
require_once("conn.php");
require_once("includes.php");

if(empty($_GET[SelectedPackage]))
{
	header("location:prices.php?e=1&PaymentGateway=$_GET[PaymentGateway]");
}
else
{
	//get the price details
	$q1 = "select * from yellow_prices where PriceID = '$_GET[SelectedPackage]' ";
	$r1 = mysql_query($q1) or die(mysql_error());
	$a1 = mysql_fetch_array($r1);

	//update the advertiser's record/credits
	$aexp =  mktime(0,0,0,date(m) + $a1[Duration],date(d),date(Y));

	//get the agent details
	$q1 = "select * from yellow_agents where AgentID = '$_SESSION[NewAgent]' ";
	$r1 = mysql_query($q1) or die(mysql_error());
	$a1 = mysql_fetch_array($r1);

	//get the price details
	$q2 = "select * from yellow_prices, yellow_priority where yellow_prices.PriceID = '$_GET[SelectedPackage]' and yellow_prices.PriorityLevel = yellow_priority.PriorityLevel ";
	$r2 = mysql_query($q2) or die(mysql_error());
	$a2 = mysql_fetch_array($r2);

	if($a2[PriceValue] == '0')
	{
		$q1 = "update yellow_agents set PriorityLevel = '$a1[PriorityLevel]',  ExpDate = '$aexp' where AgentID = '$_SESSION[NewAgent]' ";
		mysql_query($q1) or die(mysql_error());

		$q1 = "update yellow_agents set AccountStatus = 'active' where AgentID = '$_SESSION[NewAgent]' ";
		mysql_query($q1) or die(mysql_error());

		//send an email to the admin
		$to = $a1[email];
		$subject = "Your account at $_SERVER[HTTP_HOST]";
		$message = "Hello $a1[FirstName] $a1[LastName],\nthank you for your registration at $_SERVER[HTTP_HOST]\nHere is your login info:\n";
		$message .= "Username: $a1[username]\nPassword: $a1[password]\nSelected Package: $a2[PackageName] $a2[PriorityName], $a2[Duration] months, $a2[offers] offers\n\n";

		$headers = "MIME-Version: 1.0\n"; 
		$headers .= "Content-type: text/plain; charset=iso-8859-1\n";
		$headers .= "Content-Transfer-Encoding: 8bit\n"; 
		$headers .= "From: $_SERVER[HTTP_POST] <$aset[ContactEmail]>\n"; 
		$headers .= "X-Priority: 1\n"; 
		$headers .= "X-MSMail-Priority: High\n"; 
		$headers .= "X-Mailer: PHP/" . phpversion()."\n"; 

		mail($to, $subject, $message, $headers);	

		header("location:login.php");
		exit();
	}

	header("location:https://www.paypal.com/xclick?business=$aset[PayPalEmail]&item_name=$a2[PackageName] for $a1[CompanyName] ($a1[username])&first_name=$a1[FirstName]&last_name=$a1[LastName]&email=$a1[email]&item_number=1&custom=$_SESSION[NewAgent]|$_GET[SelectedPackage]&amount=$a2[PriceValue]&notify_url=http://$_SERVER[HTTP_HOST]/yellow/notify.php&return=http://$_SERVER[HTTP_HOST]/yellow/login.php");

	exit();

}

?>