Files
Testing/signedout/banners/ipn.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

657 lines
34 KiB
PHP

<?php
if (isset($_GET['debug'])) error_reporting(-1);
else error_reporting(0);
include_once(dirname(__FILE__).'/inc/config.php');
include_once(dirname(__FILE__).'/inc/settings.php');
include_once(dirname(__FILE__).'/inc/icdb.php');
include_once(dirname(__FILE__).'/inc/functions.php');
$icdb = new ICDB(DB_HOST, DB_HOST_PORT, DB_NAME, DB_USER, DB_PASSWORD, TABLE_PREFIX);
install();
get_options();
$url_base = ((empty($_SERVER["HTTPS"]) || $_SERVER["HTTPS"] == 'off') ? 'http://' : 'https://').$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"];
$filename = basename(__FILE__);
if (($pos = strpos($url_base, $filename)) !== false) $url_base = substr($url_base, 0, $pos);
$type_title = 'Unknown Banner Type';
$banner_title = 'Unknown Banner';
if (!isset($_REQUEST['method'])) exit;
switch ($_REQUEST['method']) {
case 'payza':
if (!isset($_POST['token'])) exit;
$token = "token=".urlencode($_POST['token']);
$response = '';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, ($options['payza_sandbox'] == 'on' ? "https://sandbox.payza.com/sandbox/IPN2.ashx" : "https://secure.payza.com/ipn2.ashx"));
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $token);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HEADER, false);
curl_setopt($ch, CURLOPT_TIMEOUT, 60);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$response = curl_exec($ch);
curl_close($ch);
if(strlen($response) > 0) {
if(urldecode($response) == "INVALID TOKEN") {
//the token is not valid
} else {
$response = urldecode($response);
$aps = explode("&", $response);
$info = array();
foreach ($aps as $ap) {
$ele = explode("=", $ap);
$info[$ele[0]] = $ele[1];
}
$item_number = intval(str_replace("ID", "", $info['ap_itemcode']));
$item_name = $info['ap_itemname'];
$payment_status = $info['ap_status'];
$transaction_type = $info['ap_transactiontype'];
$txn_id = $info['ap_referencenumber'];
$seller_id = $info['ap_merchant'];
$payer_id = $info['ap_custemailaddress'];
$gross_total = $info['ap_totalamount'];
$mc_currency = $info['ap_currency'];
$payer_name = $info['ap_custfirstname'].' '.$info['ap_custlastname'];
$payer_email = $payer_id;
if ($payment_status == "Success") {
$banner_details = $icdb->get_row("SELECT t1.*, t2.title AS type_title FROM ".$icdb->prefix."banners t1 LEFT JOIN ".$icdb->prefix."types t2 ON t1.type_id = t2.id WHERE t1.id = '".$item_number."'");
if ($banner_details) {
$type_title = $banner_details["type_title"];
$banner_title = $banner_details["title"];
}
if (!$banner_details) $payment_status = "Unrecognized";
else {
$payer_email = $banner_details["email"];
if (strtolower($seller_id) != strtolower($options['payza_id'])) $payment_status = "Unrecognized";
else {
if (floatval($gross_total) < floatval($banner_details["amount"]) || $mc_currency != $banner_details["currency"]) $payment_status = "Unrecognized";
}
}
}
$sql = "INSERT INTO ".$icdb->prefix."transactions (
banner_id, payer_name, payer_email, gross, currency, payment_status, transaction_type, txn_id, details, created) VALUES (
'".$item_number."',
'".$icdb->escape_string($payer_name)."',
'".$icdb->escape_string($payer_id)."',
'".floatval($gross_total)."',
'".$mc_currency."',
'".$payment_status."',
'Payza: ".$transaction_type."',
'".$txn_id."',
'".$icdb->escape_string($response)."',
'".time()."'
)";
$icdb->query($sql);
if ($payment_status == "Success") {
$registered = time();
if ($options['enable_approval'] == 'on') $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".$registered."', blocked = '".$registered."' WHERE id = '".$item_number."'");
else $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_ACTIVE."', registered = '".$registered."', blocked = '0' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, date("Y-m-d H:i:s")." (server time)", "Payza");
send_thanksgiving_email($tags, $vals, $payer_email);
} else {
$icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".time()."', blocked = '".time()."' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{payment_status}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, $payment_status, date("Y-m-d H:i:s")." (server time)", "Payza");
send_failed_email($tags, $vals, $payer_email);
}
}
}
exit;
break;
case 'egopay':
if (!isset($_POST['product_id'])) exit;
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "https://www.egopay.com/api/request");
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS,
"product_id=".urlencode($_POST['product_id'])
."&security_password=".urlencode($options['egopay_store_pass'])
."&store_id=".urlencode($options['egopay_store_id'])
);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HEADER, false);
curl_setopt($ch, CURLOPT_TIMEOUT, 20);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$response = curl_exec($ch);
curl_close($ch);
if ($response == 'INVALID') die();
$info = array();
parse_str($response, $info);
$item_number = intval($info['cf_1']);
$payment_status = $info['sStatus'];
$transaction_type = $info['sType'];
$txn_id = $info['sId'];
$payer_id = $info['sEmail'];
$gross_total = $info['fAmount'];
$mc_currency = $info['sCurrency'];
$payer_name = $info['sEmail'];
$payer_email = $info['sEmail'];
if ($payment_status == 'TEST SUCCESS') $payment_status = "Completed";
if ($payment_status == "Completed") {
$banner_details = $icdb->get_row("SELECT t1.*, t2.title AS type_title FROM ".$icdb->prefix."banners t1 LEFT JOIN ".$icdb->prefix."types t2 ON t1.type_id = t2.id WHERE t1.id = '".$item_number."'");
if ($banner_details) {
$type_title = $banner_details["type_title"];
$banner_title = $banner_details["title"];
}
if (!$banner_details) $payment_status = "Unrecognized";
else {
$payer_email = $banner_details["email"];
if (floatval($gross_total) < floatval($banner_details["amount"]) || $mc_currency != $banner_details["currency"]) $payment_status = "Unrecognized";
}
}
$sql = "INSERT INTO ".$icdb->prefix."transactions (
banner_id, payer_name, payer_email, gross, currency, payment_status, transaction_type, txn_id, details, created) VALUES (
'".$item_number."',
'".$icdb->escape_string($payer_name)."',
'".$icdb->escape_string($payer_id)."',
'".floatval($gross_total)."',
'".$mc_currency."',
'".$payment_status."',
'EgoPay: ".$transaction_type."',
'".$txn_id."',
'".$icdb->escape_string($response)."',
'".time()."'
)";
$icdb->query($sql);
if ($payment_status == "Completed") {
$registered = time();
if ($options['enable_approval'] == 'on') $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".$registered."', blocked = '".$registered."' WHERE id = '".$item_number."'");
else $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_ACTIVE."', registered = '".$registered."', blocked = '0' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, date("Y-m-d H:i:s")." (server time)", "EgoPay");
send_thanksgiving_email($tags, $vals, $payer_email);
} else {
$icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".time()."', blocked = '".time()."' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{payment_status}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, $payment_status, date("Y-m-d H:i:s")." (server time)", "EgoPay");
send_failed_email($tags, $vals, $payer_email);
}
exit;
break;
case 'perfect':
if (empty($_POST['PAYMENT_ID']) || empty($_POST['PAYEE_ACCOUNT'])) die();
$response = "";
foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$response .= "&".$key."=".$value;
}
$str = $_POST['PAYMENT_ID'].':'.$_POST['PAYEE_ACCOUNT'].':'.
$_POST['PAYMENT_AMOUNT'].':'.$_POST['PAYMENT_UNITS'].':'.
$_POST['PAYMENT_BATCH_NUM'].':'.
$_POST['PAYER_ACCOUNT'].':'.strtoupper(md5($options['perfect_passphrase'])).':'.
$_POST['TIMESTAMPGMT'];
$hash = strtoupper(md5($str));
$item_number = intval($_POST['PAYMENT_ID']);
$payment_status = "Completed";
$transaction_type = "payment";
$txn_id = stripslashes($_POST['PAYMENT_BATCH_NUM']);
$seller_id = stripslashes($_POST['PAYEE_ACCOUNT']);
$v2_hash = stripslashes($_POST['V2_HASH']);
$gross_total = stripslashes($_POST['PAYMENT_AMOUNT']);
$mc_currency = stripslashes($_POST['PAYMENT_UNITS']);
$payer_name = stripslashes($_POST['PAYER_ACCOUNT']);
$payer_email = '';
$banner_details = $icdb->get_row("SELECT t1.*, t2.title AS type_title FROM ".$icdb->prefix."banners t1 LEFT JOIN ".$icdb->prefix."types t2 ON t1.type_id = t2.id WHERE t1.id = '".$item_number."'");
if ($banner_details) {
$type_title = $banner_details["type_title"];
$banner_title = $banner_details["title"];
}
if (!$banner_details) $payment_status = "Unrecognized";
else {
$payer_email = $banner_details["email"];
if ($v2_hash != $hash) $payment_status = "Invalid HASH";
else if (floatval($gross_total) < floatval($banner_details["amount"]) || $mc_currency != $banner_details["currency"] || $seller_id != $options['perfect_account_id']) $payment_status = "Unrecognized";
}
$sql = "INSERT INTO ".$icdb->prefix."transactions (
banner_id, payer_name, payer_email, gross, currency, payment_status, transaction_type, txn_id, details, created) VALUES (
'".$item_number."',
'".$icdb->escape_string($payer_name)."',
'".$icdb->escape_string($payer_email)."',
'".floatval($gross_total)."',
'".$mc_currency."',
'".$payment_status."',
'PM: ".$transaction_type."',
'".$txn_id."',
'".$icdb->escape_string($response)."',
'".time()."'
)";
$icdb->query($sql);
if ($payment_status == "Completed") {
$registered = time();
if ($options['enable_approval'] == 'on') $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".$registered."', blocked = '".$registered."' WHERE id = '".$item_number."'");
else $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_ACTIVE."', registered = '".$registered."', blocked = '0' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_email, $gross_total, $mc_currency, $type_title, $banner_title, date("Y-m-d H:i:s")." (server time)", "Perfect Money");
send_thanksgiving_email($tags, $vals, $payer_email);
} else {
$icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".time()."', blocked = '".time()."' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{payment_status}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_email, $gross_total, $mc_currency, $type_title, $banner_title, $payment_status, date("Y-m-d H:i:s")." (server time)", "Perfect Money");
send_failed_email($tags, $vals, $payer_email);
}
exit;
break;
case 'skrill':
if (empty($_POST['pay_to_email']) || empty($_POST['pay_from_email'])) die();
$response = "";
foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$response .= "&".$key."=".$value;
}
$item_number = intval($_POST['banner_id']);
$txn_id = stripslashes($_POST['mb_transaction_id']);
$seller_id = stripslashes($_POST['pay_to_email']);
$payer_id = stripslashes($_POST['pay_from_email']);
$gross_total = stripslashes($_POST['amount']);
$mc_currency = stripslashes($_POST['currency']);
$payment_status = stripslashes($_POST['status']);
$transaction_type = "donation";
$md5sig = stripslashes($_POST['md5sig']);
$payer_name = stripslashes($_POST['pay_from_email']);
$payer_email = stripslashes($_POST['pay_from_email']);
if ($payment_status == 2) $payment_status = 'Completed';
else if ($payment_status == 0) $payment_status = 'Pending';
else if ($payment_status == -1) $payment_status = 'Cancelled';
else if ($payment_status == -2) $payment_status = 'Failed';
else if ($payment_status == -3) $payment_status = 'Chargeback';
$hash = strtoupper(md5($_POST['merchant_id'].$_POST['transaction_id'].strtoupper(md5($options['skrill_secret_word'])).$_POST['mb_amount'].$_POST['mb_currency'].$_POST['status']));
$banner_details = $icdb->get_row("SELECT t1.*, t2.title AS type_title FROM ".$icdb->prefix."banners t1 LEFT JOIN ".$icdb->prefix."types t2 ON t1.type_id = t2.id WHERE t1.id = '".$item_number."'");
if ($banner_details) {
$type_title = $banner_details["type_title"];
$banner_title = $banner_details["title"];
}
if (!$banner_details) $payment_status = "Unrecognized";
else {
$payer_email = $banner_details["email"];
if (strtolower($seller_id) != strtolower($options['skrill_id']) || $md5sig != $hash) $payment_status = "Unrecognized";
else if (floatval($gross_total) < floatval($banner_details["amount"]) || $mc_currency != $banner_details["currency"]) $payment_status = "Unrecognized";
}
$sql = "INSERT INTO ".$icdb->prefix."transactions (
banner_id, payer_name, payer_email, gross, currency, payment_status, transaction_type, txn_id, details, created) VALUES (
'".$item_number."',
'".$icdb->escape_string($payer_name)."',
'".$icdb->escape_string($payer_id)."',
'".floatval($gross_total)."',
'".$mc_currency."',
'".$payment_status."',
'Skrill: ".$transaction_type."',
'".$txn_id."',
'".$icdb->escape_string($response)."',
'".time()."'
)";
$icdb->query($sql);
if ($payment_status == "Completed") {
$registered = time();
if ($options['enable_approval'] == 'on') $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".$registered."', blocked = '".$registered."' WHERE id = '".$item_number."'");
else $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_ACTIVE."', registered = '".$registered."', blocked = '0' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, date("Y-m-d H:i:s")." (server time)", "Skrill");
send_thanksgiving_email($tags, $vals, $payer_email);
} else {
$icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".time()."', blocked = '".time()."' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{payment_status}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, $payment_status, date("Y-m-d H:i:s")." (server time)", "Skrill");
send_failed_email($tags, $vals, $payer_email);
}
exit;
break;
case 'bitpay':
$json = file_get_contents("php://input");
if (empty($json)) die();
$post = json_decode($json, true);
if (!is_array($post)) die();
$txn_id = stripslashes($post['id']);
$curl = curl_init('https://bitpay.com/api/invoice/'.$txn_id);
$header = array(
'Content-Type: application/json',
'Content-Length: 0',
'Authorization: Basic '.base64_encode($options['bitpay_key']),
);
curl_setopt($curl, CURLOPT_PORT, 443);
curl_setopt($curl, CURLOPT_HTTPHEADER, $header);
curl_setopt($curl, CURLOPT_TIMEOUT, 10);
curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_BASIC ) ;
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 1); // verify certificate
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 2); // check existence of CN and verify that it matches hostname
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl, CURLOPT_FORBID_REUSE, 1);
curl_setopt($curl, CURLOPT_FRESH_CONNECT, 1);
$json = curl_exec($curl);
curl_close($curl);
if ($json === false) die();
$post = json_decode($json, true);
if (!$post) die();
if (isset($post['error'])) die();
$response = "";
foreach ($post as $key => $value) {
$value = urlencode(stripslashes($value));
$response .= "&".$key."=".$value;
}
$posData = json_decode($post['posData'], true);
$payment_status = stripslashes($post['status']);
$item_number = intval($posData['banner_id']);
$payer_id = $posData['payer_email'];
$payer_email = $posData['payer_email'];
$transaction_type = "bitcoins";
$payer_name = $posData['payer_email'];
$gross_total = number_format($post['price'], 8, '.', '');
$mc_currency = $post['currency'];
$banner_details = $icdb->get_row("SELECT t1.*, t2.title AS type_title FROM ".$icdb->prefix."banners t1 LEFT JOIN ".$icdb->prefix."types t2 ON t1.type_id = t2.id WHERE t1.id = '".$item_number."'");
if ($banner_details) {
$type_title = $banner_details["type_title"];
$banner_title = $banner_details["title"];
}
if (!$banner_details) $payment_status = "Unrecognized";
else {
if (floatval($gross_total) < floatval($banner_details["amount"]) || $mc_currency != $banner_details["currency"]) $payment_status = "Unrecognized";
}
$sql = "INSERT INTO ".$icdb->prefix."transactions (
banner_id, payer_name, payer_email, gross, currency, payment_status, transaction_type, txn_id, details, created) VALUES (
'".$item_number."',
'".$icdb->escape_string($payer_name)."',
'".$icdb->escape_string($payer_id)."',
'".floatval($gross_total)."',
'".$mc_currency."',
'".$payment_status."',
'BitPay: ".$transaction_type."',
'".$txn_id."',
'".$icdb->escape_string($response)."',
'".time()."'
)";
$icdb->query($sql);
if ($payment_status == "confirmed" || $payment_status == "complete") {
$registered = time();
if ($options['enable_approval'] == 'on') $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".$registered."', blocked = '".$registered."' WHERE id = '".$item_number."'");
else $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_ACTIVE."', registered = '".$registered."', blocked = '0' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, date("Y-m-d H:i:s")." (server time)", "BitPay");
send_thanksgiving_email($tags, $vals, $payer_email);
} else {
$icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".time()."', blocked = '".time()."' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{payment_status}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, $payment_status, date("Y-m-d H:i:s")." (server time)", "BitPay");
send_failed_email($tags, $vals, $payer_email);
}
exit;
break;
case 'authnet':
$request = "";
foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$request .= "&".$key."=".$value;
}
if(strlen($request) == 0) die();
$item_number = str_replace("ID", "", stripslashes($_POST['x_invoice_num']));
if (($pos = strpos($item_number, "N")) !== false) $item_number = substr($item_number, 0, $pos);
$item_number = intval($item_number);
$item_name = stripslashes($_POST['x_description']);
$payment_status = stripslashes($_POST['x_response_code']);
$transaction_type = stripslashes($_POST['x_card_type']);
$txn_id = stripslashes($_POST['x_trans_id']);
$seller_id = stripslashes($_POST['x_login']);
$payer_id = stripslashes($_POST['x_email']);
$gross_total = stripslashes($_POST['x_amount']);
$mc_currency = "USD";
$payer_name = trim(stripslashes($_POST['x_first_name']).' '.stripslashes($_POST['x_last_name']));
$test_mode = strtolower(stripslashes($_POST['x_test_request']));
$md5hash = strtolower(stripslashes($_POST['x_MD5_Hash']));
if (empty($payer_name)) {
$payer_name = $payer_id;
}
$payer_email = stripslashes($_POST['x_email']);
if ($payment_status == "1") $payment_status = "Completed";
if ($payment_status == "Completed") {
$banner_details = $icdb->get_row("SELECT t1.*, t2.title AS type_title FROM ".$icdb->prefix."banners t1 LEFT JOIN ".$icdb->prefix."types t2 ON t1.type_id = t2.id WHERE t1.id = '".$item_number."'");
if ($banner_details) {
$type_title = $banner_details["type_title"];
$banner_title = $banner_details["title"];
}
if (!$banner_details) $payment_status = "Unrecognized";
else {
$payer_email = $banner_details["email"];
if ($test_mode == "true" && $options['authnet_sandbox'] != 'on') $payment_status = "Test mode";
if (floatval($gross_total) < floatval($banner_details["amount"]) || $mc_currency != $banner_details["currency"]) $payment_status = "Unrecognized";
else {
$md5source = $options["authnet_md5hash"] . $options["authnet_login"] . $txn_id . $gross_total;
$md5 = strtolower(md5($md5source));
if ($md5 != $md5hash) $payment_status = "Invalid MD5 Hash";
}
}
}
$sql = "INSERT INTO ".$icdb->prefix."transactions (
banner_id, payer_name, payer_email, gross, currency, payment_status, transaction_type, txn_id, details, created) VALUES (
'".$item_number."',
'".$icdb->escape_string($payer_name)."',
'".$icdb->escape_string($payer_id)."',
'".floatval($gross_total)."',
'".$mc_currency."',
'".$payment_status."',
'Autorize.Net: ".$transaction_type."',
'".$txn_id."',
'".$icdb->escape_string($request)."',
'".time()."'
)";
$icdb->query($sql);
if (isset($banner_details["details"])) {
$return_url = $banner_details["details"];
if (!preg_match('|^http(s)?://[a-z0-9-]+(.[a-z0-9-]+)*(:[0-9]+)?(/.*)?$|i', $return_url) || strlen($return_url) == 0) $return_url = '#';
} else $return_url = '#';
if ($payment_status == "Completed") {
$registered = time();
if ($options['enable_approval'] == 'on') $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".$registered."', blocked = '".$registered."' WHERE id = '".$item_number."'");
else $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_ACTIVE."', registered = '".$registered."', blocked = '0' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, date("Y-m-d H:i:s")." (server time)", "Authorize.Net");
send_thanksgiving_email($tags, $vals, $payer_email);
echo '<!DOCTYPE html><html><head><meta charset="utf-8"><title>Transaction completed</title>'.get_auth_style().'</head><body><div class="page ubm_returnbox">Payment successfully completed.<br /><a class="ubm_return" href="'.$return_url.'">Return to Merchant</a></div></body></html>';
} else {
$icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".time()."', blocked = '".time()."' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{payment_status}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, $payment_status, date("Y-m-d H:i:s")." (server time)", "Authorize.Net");
send_failed_email($tags, $vals, $payer_email);
echo '<!DOCTYPE html><html><head><meta charset="utf-8"><title>Error</title>'.get_auth_style().'</head><body><div class="page ubm_returnbox">Payment failed. Please contact Merchant about transaction <strong>'.$txn_id.'</strong>.<br /><a class="ubm_return" href="'.$return_url.'">Return to Merchant</a></div></body></html>';
}
exit;
break;
case 'interkassa':
if (isset($_POST['ik_co_id'])) {
$request = '';
$data = array();
foreach ($_POST as $key => $value) {
$request .= "&".$key."=".$value;
if (strtolower(substr($key, 0, 3)) == 'ik_' && $key != 'ik_sign') $data[$key] = $value;
}
$item_number = $_POST['ik_pm_no'];
if (($pos = strpos($item_number, "-")) !== false) $item_number = intval(substr($item_number, 0, $pos));
$item_name = $_POST['ik_desc'];
$payment_status = $_POST['ik_inv_st'];
$transaction_type = $_POST['ik_pw_via'];
$txn_id = $_POST['ik_co_prs_id'];
$seller_id = $_POST['ik_co_id'];
$payer_id = $_POST['ik_x_email'];
$payer_email = $_POST['ik_x_email'];
$payer_name = $_POST['ik_x_email'];
$gross_total = $_POST['ik_am'];
$mc_currency = $_POST['ik_cur'];
if ($payment_status == "success") {
$banner_details = $icdb->get_row("SELECT t1.*, t2.title AS type_title FROM ".$icdb->prefix."banners t1 LEFT JOIN ".$icdb->prefix."types t2 ON t1.type_id = t2.id WHERE t1.id = '".$item_number."'");
if ($banner_details) {
$payer_email = $banner_details["email"];
$type_title = $banner_details["type_title"];
$banner_title = $banner_details["title"];
}
if (intval($banner_details["id"]) == 0) $payment_status = "Unrecognized: N01";
else if (strtolower($seller_id) != strtolower($options['interkassa_checkout_id'])) $payment_status = "Unrecognized: N02";
else if (floatval($gross_total) < floatval($banner_details["amount"])) $payment_status = "Unrecognized: N03";
else if (!empty($mc_currency) && $mc_currency != $banner_details["currency"]) $payment_status = "Unrecognized: N04";
else {
ksort($data, SORT_STRING);
array_push($data, $options['interkassa_secret_key']);
$signString = implode(':', $data);
$sign = base64_encode(md5($signString, true));
if ($_POST['ik_sign'] != $sign) $payment_status = "Unrecognized: N05";
}
}
$sql = "INSERT INTO ".$icdb->prefix."transactions (
banner_id, payer_name, payer_email, gross, currency, payment_status, transaction_type, txn_id, details, created) VALUES (
'".$item_number."',
'".$icdb->escape_string($payer_name)."',
'".$icdb->escape_string($payer_id)."',
'".floatval($gross_total)."',
'".$mc_currency."',
'".$payment_status."',
'InterKassa: ".$transaction_type."',
'".$txn_id."',
'".$icdb->escape_string($request)."',
'".time()."'
)";
$icdb->query($sql);
if ($payment_status == "success") {
$registered = time();
if ($options['enable_approval'] == 'on') $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".$registered."', blocked = '".$registered."' WHERE id = '".$item_number."'");
else $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_ACTIVE."', registered = '".$registered."', blocked = '0' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, date("Y-m-d H:i:s")." (server time)", "InterKassa");
send_thanksgiving_email($tags, $vals, $payer_email);
} else {
$icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".time()."', blocked = '".time()."' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{payment_status}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, $payment_status, date("Y-m-d H:i:s")." (server time)", "InterKassa");
send_failed_email($tags, $vals, $payer_email);
}
}
exit;
break;
case 'paypal':
$request = "cmd=_notify-validate";
foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$request .= "&".$key."=".$value;
}
$paypalurl = 'https://www.paypal.com/cgi-bin/webscr';
$ch = curl_init($paypalurl);
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, $request);
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'));
$result = curl_exec($ch);
curl_close($ch);
if (substr(trim($result), 0, 8) != "VERIFIED") die();
$item_number = intval($_POST['item_number']);
$item_name = stripslashes($_POST['item_name']);
$payment_status = stripslashes($_POST['payment_status']);
$transaction_type = stripslashes($_POST['txn_type']);
$txn_id = stripslashes($_POST['txn_id']);
$seller_paypal = stripslashes($_POST['business']);
$seller_id = stripslashes($_POST['receiver_id']);
$payer_id = stripslashes($_POST['payer_email']);
$payer_email = stripslashes($_POST['custom']);
$gross_total = stripslashes($_POST['mc_gross']);
$mc_currency = stripslashes($_POST['mc_currency']);
$payer_name = stripslashes($_POST['first_name']).' '.stripslashes($_POST['last_name']);
$payer_status = stripslashes($_POST['payer_status']);
if ($transaction_type == "web_accept" && $payment_status == "Completed") {
$banner_details = $icdb->get_row("SELECT t1.*, t2.title AS type_title FROM ".$icdb->prefix."banners t1 LEFT JOIN ".$icdb->prefix."types t2 ON t1.type_id = t2.id WHERE t1.id = '".$item_number."'");
if ($banner_details) {
$type_title = $banner_details["type_title"];
$banner_title = $banner_details["title"];
}
if (!$banner_details) $payment_status = "Unrecognized";
else {
$payer_email = $banner_details["email"];
if (empty($seller_paypal)) {
$tx_details = $icdb->get_row("SELECT * FROM ".$icdb->prefix."transactions WHERE details LIKE '%txn_id=".$txn_id."%' AND payment_status != 'Unrecognized'");
if ($tx_details) $seller_paypal = $options['paypal_id'];
}
if ((strtolower($seller_paypal) != strtolower($options['paypal_id'])) && (strtolower($seller_id) != strtolower($options['paypal_id']))) $payment_status = "Unrecognized";
else {
if (floatval($gross_total) < floatval($banner_details["amount"]) || $mc_currency != $banner_details["currency"]) $payment_status = "Unrecognized";
}
}
}
$sql = "INSERT INTO ".$icdb->prefix."transactions (
banner_id, payer_name, payer_email, gross, currency, payment_status, transaction_type, txn_id, details, created) VALUES (
'".$item_number."',
'".$icdb->escape_string($payer_name)."',
'".$icdb->escape_string($payer_id)."',
'".floatval($gross_total)."',
'".$mc_currency."',
'".$payment_status."',
'PayPal: ".$transaction_type."',
'".$txn_id."',
'".$icdb->escape_string($request)."',
'".time()."'
)";
$icdb->query($sql);
if ($transaction_type == "web_accept") {
if ($payment_status == "Completed") {
$registered = time();
if ($options['enable_approval'] == 'on') $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".$registered."', blocked = '".$registered."' WHERE id = '".$item_number."'");
else $icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_ACTIVE."', registered = '".$registered."', blocked = '0' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, date("Y-m-d H:i:s")." (server time)", "PayPal");
send_thanksgiving_email($tags, $vals, $payer_email);
} else {
$icdb->query("UPDATE ".$icdb->prefix."banners SET status = '".STATUS_PENDING."', registered = '".time()."', blocked = '".time()."' WHERE id = '".$item_number."'");
$tags = array("{payer_name}", "{payer_email}", "{amount}", "{currency}", "{type_title}", "{banner_title}", "{payment_status}", "{transaction_date}", "{gateway}");
$vals = array($payer_name, $payer_id, $gross_total, $mc_currency, $type_title, $banner_title, $payment_status, date("Y-m-d H:i:s")." (server time)", "PayPal");
send_failed_email($tags, $vals, $payer_email);
}
}
exit;
break;
default:
break;
}
?>