select(sprintf("SELECT min(`id`), trans_id FROM `%sCubeCart_transactions` WHERE order_id = %s and `status` = 'SUCCESS' GROUP BY `id`",$glob['dbprefix'],$db->MySQLSafe($order_id)));
$authorizationID = trim($_POST['authorizationID']);
$amount = sprintf("%.2f",trim($_POST['amount']));
$note = trim($_POST['note']);
$finalCapture = $_POST['CompleteCodeType']=="Complete" ? "Y" : "N";
$nvpStr = "&ORIGID[".strlen($authorizationID)."]=".$authorizationID."&AMT[".strlen($amount)."]=".$amount."&COMMENT1[".strlen($note)."]=".$note."&CAPTURECOMPLETE[".strlen($finalCapture)."]=".$finalCapture;
$request_id = md5($authorizationID.date('YmdGis')."1");
$resArray = hash_call($_POST['TENDER'],"D",$nvpStr,$request_id);
$ack = $resArray["RESULT"] == 0 ? "SUCCESS" : "FAIL";
if($ack!=="SUCCESS"){
$errorMsg = paypalErrors($resArray);
$transNotes = "Error: ".$errorMsg["admin"]."
PayPal Response: ".$errorMsg["paypal"];
$ppMsg = "".nl2br($transNotes)."
";
} else {
$transNotes = priceFormat($amount,true)." of authorization ID ".$authorizationID." captured successfully.";
$ppMsg = "".$transNotes."
";
$query = "UPDATE ".$glob['dbprefix']."CubeCart_transactions SET `remainder` = `remainder` + ".$amount." WHERE `id` = '".$_POST['id']."';";
$db->misc($query);
}
$transData['customer_id'] = $orderSum[0]["customer_id"];
$transData['gateway'] = "PayPal Website Payments Pro (DoCapture)";
$transData['extra'] = $_POST['TENDER'];
$transData['trans_id'] = $resArray['PNREF'];
$transData['order_id'] = $orderSum[0]['cart_order_id'];
$transData['amount'] = $amount;
$transData['status'] = $ack;
$transData['notes'] = $transNotes;
$order->storeTrans($transData);
?>