<?php require_once('Connections/connsqli.php'); ?>
<?php require_once('webassist/mysqli/queryobj.php'); ?>
<?php
require "paypal_integration_class/paypal.class.php";
require "config.php";
$p = new paypal_class;
$p->paypal_url = $payPalURL;
if ($p->validate_ipn()) {
if($p->ipn_data['payment_status']=='Completed')
{
$amount = $p->ipn_data['mc_gross'] - $p->ipn_data['mc_fee'];
?>
<?php
if (true) {
$InsertQuery = new WA_MySQLi_Query($connsqli);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "paypal_transactions";
$InsertQuery->bindColumn("transaction_ID", "s", "".$p->ipn_data['txn_id']."", "WA_DEFAULT");
$InsertQuery->bindColumn("first_name", "s", "".$p->ipn_data['first_name']."", "WA_DEFAULT");
$InsertQuery->bindColumn("last_name", "s", "".$p->ipn_data['last_name']."", "WA_DEFAULT");
$InsertQuery->bindColumn("email1", "s", "".$p->ipn_data['payer_email']."", "WA_DEFAULT");
$InsertQuery->bindColumn("address1", "s", "".$p->ipn_data['address1']."", "WA_DEFAULT");
$InsertQuery->bindColumn("address2", "s", "".$p->ipn_data['address2']."", "WA_DEFAULT");
$InsertQuery->bindColumn("city", "s", "".$p->ipn_data['city']."", "WA_DEFAULT");
$InsertQuery->bindColumn("state", "s", "".$p->ipn_data['state']."", "WA_DEFAULT");
$InsertQuery->bindColumn("zip", "s", "".$p->ipn_data['zip']."", "WA_DEFAULT");
$InsertQuery->bindColumn("amount", "d", "".$amount."", "WA_DEFAULT");
$InsertQuery->bindColumn("item_name", "s", "".$p->ipn_data['item_name']."", "WA_DEFAULT");
$InsertQuery->bindColumn("quantity", "i", "".$p->ipn_data['quantity']."", "WA_DEFAULT");
$InsertQuery->bindColumn("payment_gross", "s", "".$p->ipn_data['mc_gross']."", "WA_DEFAULT");
$InsertQuery->bindColumn("payment_fee", "i", "".$p->ipn_data['payment_fee']."", "WA_DEFAULT");
$InsertQuery->bindColumn("special_requests", "s", "".$p->ipn_data['option_selection1']."", "WA_DEFAULT");
$InsertQuery->bindColumn("original_request", "s", "".http_build_query($_POST)."", "WA_DEFAULT");
$InsertQuery->saveInSession("");
$InsertQuery->execute();
$InsertGoTo = "";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
<?php
}
}
?>