<?php
require '../config.php';
// STEP 1: Read POST data

// reading posted data from directly from $_POST causes serialization 
// issues with array data in POST
// reading raw POST data from input stream instead. 
$raw_post_data = file_get_contents('php://input');
$raw_post_array = explode('&', $raw_post_data);
$myPost = array();
foreach ($raw_post_array as $keyval) {
  $keyval = explode ('=', $keyval);
  if (count($keyval) == 2)
     $myPost[$keyval[0]] = urldecode($keyval[1]);
}
// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';
if(function_exists('get_magic_quotes_gpc')) {
   $get_magic_quotes_exists = true;
} 
foreach ($myPost as $key => $value) {        
   if($get_magic_quotes_exists == true && get_magic_quotes_gpc() == 1) { 
        $value = urlencode(stripslashes($value)); 
   } else {
        $value = urlencode($value);
   }
   $req .= "&$key=$value";
}

 
// STEP 2: Post IPN data back to paypal to validate

$ch = curl_init('https://www.sandbox.paypal.com/cgi-bin/webscr');
//$ch = curl_init('https://www.paypal.com/cgi-bin/webscr');
curl_setopt($ch, CURLOPT_HTTP_VERSION, CURL_HTTP_VERSION_1_1);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $req);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
curl_setopt($ch, CURLOPT_FORBID_REUSE, 1);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Connection: Close'));

// In wamp like environments that do not come bundled with root authority certificates,
// please download 'cacert.pem' from "http://curl.haxx.se/docs/caextract.html" and set the directory path 
// of the certificate as shown below.
curl_setopt($ch, CURLOPT_CAINFO, dirname(__FILE__) . '/cacert.pem');
if( !($res = curl_exec($ch)) ) {
    error_log("Got " . curl_error($ch) . " when processing IPN data");
    curl_close($ch);
    exit;
}
curl_close($ch);
 

// STEP 3: Inspect IPN validation result and act accordingly
str_replace('\n', '', $res);
//debug info
$ps="not set";
$txn="not set";
$in="not set";
$re="not set";
$pa="not set";
$pc="not set";
$rc="not set";
$rc2="not set";
$debugkey="not set";
$resdb="not set";
//end of debug info
if (strcmp ($res, "VERIFIED") == 0) {
	$resdb=$res;
    // check whether the payment_status is Completed
    // check that txn_id has not been previously processed
    // check that receiver_email is your Primary PayPal email
    // check that payment_amount/payment_currency are correct
    // process payment
    // assign posted variables to local variables
	$item_name = $_POST['item_name'];
	$item_number = $_POST['item_number'];
	$payment_status = $_POST['payment_status'];
	$payment_amount = $_POST['mc_gross'];
	$payment_currency = $_POST['mc_currency'];
	$txn_id = $_POST['txn_id'];
	$receiver_email = $_POST['receiver_email'];
	$payer_email = $_POST['payer_email'];
	$cpuid = $_POST['option_selection1'];
	$datetime = $_POST['payment_date'];
	$paidby = $_POST['custom'];
	//this query works fine.
	mysql_query("INSERT INTO `debug` (id, postdata, date) VALUES ('', '".json_encode($_POST)."', '".$_POST['payment_date']."')");



	if($payment_status=="Completed"){
		$ps=$payment_status;
		$txn_id_check = mysql_query("SELECT `tid` FROM `transactions` WHERE `tid` LIKE '".$txn_id."'");
		if(mysql_num_rows($txn_id_check) == false || mysql_num_rows($txn_id_check) == 0){
			$txn=mysql_num_rows($txn_id_check);
			if($item_number=="1"){
				$in=$item_number;
				if($receiver_email=='dr.gli_1350281693_biz@glitchware.tk'){
					$re=$receiver_email;
					if($payment_amount=='15.00' && $payment_currency=='USD'){
						$pa=$payment_amount;
						$pc=$payment_currency;
						//this query is not working, and it's not reporting any errors...
						mysql_query("INSERT INTO transactions (id, tid, amountpaid, pid, buyeremail, user, date) VALUES ('', '$txn_id', '$item_number', '$paidby',  '$datetime')");
						//keygen(22);
						$valid=2;
						$newkey="nothing";
						while($valid > 0){
							$newkey=keygen(22);
							$resultkeycheck=mysql_query("SELECT `key` FROM `keys` WHERE `key` LIKE '$newkey'");
							$rc = "".mysql_num_rows($resultkeycheck)."|validkey=$valid";
							if(mysql_num_rows($resultkeycheck)==0 || mysql_num_rows($resultkeycheck) == false){
								$valid=0;
								$rc2=$valid;
								//this query is not working, and it's not reporting any errors...
								mysql_query("INSERT INTO `keys` (id, key, computerid, owner, pid) VALUES ('', '$newkey', '$cpuid', '$paidby', '$item_number')");
							}
						$debugkey=$newkey;
						}
					}
				}
			}
		}
	}
} else if (strcmp ($res, "INVALID") == 0) {
    // log for manual investigation
	$item_name = $_POST['item_name'];
    $item_number = $_POST['item_number'];
    $payment_status = $_POST['payment_status'];
    $payment_amount = $_POST['mc_gross'];
    $payment_currency = $_POST['mc_currency'];
    $txn_id = $_POST['txn_id'];
    $receiver_email = $_POST['receiver_email'];
    $payer_email = $_POST['payer_email'];
	$cpuid = $_POST['option_selection1'];
	$cuser = $_POST['custom'];
	//i don't know if this query works or not...
	mysql_query("INSERT INTO `failedtransactions` (id, tid, email, user, pid) VALUES ('', '$txn_id', '$payer_email', '$cuser', '$item_number')");
}

function keygen($length=10){

		$key = '';
		list($usec, $sec) = explode(' ', microtime());
		mt_srand((float) $sec + ((float) $usec * 100000));
		
		$inputs = array_merge(range('z','a'),range(0,9),range('A','Z'));
	
		for($i=0; $i<$length; $i++)
		{
			$key .= $inputs{mt_rand(0,61)};
		}
		return $key;
}
$logdata="Res=$resdb|Payment Status=$ps|Transaction id Check=$txn|Item Number=$in|Reciever Email=$re|Payment Amount=$pa|Payment Currency=$pc|Result Check=$rc|Valid Key=$rc2|Generated Key=$debugkey";
//this query works fine.
mysql_query("INSERT INTO `debug2` (id, data) VALUES ('', '$logdata')");
mysql_close();
?>


Post values:
mc_gross=15.00
protection_eligibility=Ineligible
payer_id=MT8TB8YUV9X6G
tax=0.00
payment_date= 03:10:33 Dec 17 2012 PST
payment_status=Completed
charset=windows-1252
first_name=Nunya
option_selection1=COMPUTERID
mc_fee=0.74
notify_version=3.7
custom=DrGlitch
payer_status=verified
business=dr.gli_1350281693_biz@glitchware.tk
quantity=1
verify_sign=AFcWxV21C7fd0v3bYYYRCpSSRl31AP56-pfFemnm-uwtgYqEAheezyLC
payer_email=devuse_1350281425_per@glitchware.tk
option_name1=Computer ID:
txn_id=9R718433UD6865159
payment_type=instant
btn_id=2668284
last_name=Dayumbuisness
receiver_email=dr.gli_1350281693_biz@glitchware.tk
payment_fee=0.74
shipping_discount=0.00
insurance_amount=0.00
receiver_id=VDA9HXGB87U2E
txn_type=web_accept
item_name=Test Item
discount=0.00
mc_currency=USD
item_number=1
residence_country=US
test_ipn=1
handling_amount=0.00
shipping_method=Default
transaction_subject=DrGlitch
payment_gross=15.00
shipping=0.00
ipn_track_id=50c5dd4eb116d