How to integrate FraudLabs Pro fraud detection with 2Checkout payment

Description: This tutorial demonstrates how to integrate FraudLabs Pro fraud detection service into 2Checkout payment process. Below we show you the step-by-step instructions using the PHP language.

Using PHP

Create a new table to store the transaction value of FraudLabs Pro and 2Checkout payment processing. This table will be used during the settlement, void or refund process.

CREATE TABLE `fraudlabs_pro` (
	`flp_transaction_id` CHAR(15) NOT NULL,
	`flp_status` VARCHAR(10) NOT NULL,
	`twocheckout_sale_id` VARCHAR(30) NOT NULL,
	PRIMARY KEY (`flp_transaction_id`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;

Download FraudLabs Pro PHP class from https://github.com/fraudlabspro/fraudlabspro-php/releases

Integrate FraudLabs Pro fraud detection logic with your 2Checkout code. This code will perform a simple validation check of one credit card purchase and perform the appropriate action based on the fraud validation result.

// Include FraudLabs Pro library
require_once 'PATH_TO_FRAUDLABSPRO/lib/FraudLabsPro.php';

// Include 2Checkout library
require_once("/path/to/2checkout-php/lib/Twocheckout.php");

Twocheckout::privateKey('your_2checkout_private_key');
Twocheckout::sellerId('your_2checkout_seller_id');

FraudLabsPro\Configuration::apiKey('your_fraudlabspro_api_key');

// Check this transaction for possible fraud. FraudLabs Pro support comprehensive validation check,
// and for this example, we only perform the IP address, BIN and billing country validation.
// For complete validation, please check our developer page at http://www.fraudlabspro.com/developer
$orderDetails = [
	'order'		=> [
		'amount'	=> $_POST['amount'],
	],
	'billing'	=> [
		'country'	=> $_POST['country'],
	],
];

// Sends the order details to FraudLabs Pro
$fraudResult = FraudLabsPro\Order::validate($orderDetails);

// This transaction is legitimate, let's submit to 2Checkout
if ($fraudResult->fraudlabspro_status == 'APPROVE') {
	try {
		$charge = Twocheckout_Charge::auth(array(
			"sellerId" => 'your_2checkout_seller_id',
			"token" => $_POST['twoCheckoutToken'],
			"currency" => 'USD',
			"total" => $_POST['amount']
		));
	} catch (Twocheckout_Error $e) {
		echo $e->getMessage();
	}
}

// Transaction has been rejected by FraudLabs Pro based on your custom validation rules.
elseif ($fraudResult->fraudlabspro_status == 'REJECT') {
	/*
	Do something here, try contact the customer for verification
	*/
}

// Transaction is marked for a manual review by FraudLabs Pro based on your custom validation rules.
elseif ($fraudResult->fraudlabspro_status == 'REVIEW') {
	try {
		$charge = Twocheckout_Charge::auth(array(
			"sellerId" => 'your_2checkout_seller_id',
			"token" => $_POST['twoCheckoutToken'],
			"currency" => 'USD',
			"total" => $_POST['amount']
		));
		$twocheckoutSaleId = $charge['response']['orderNumber'];

		try{
			// Initial MySQL connection
			$db = new PDO('mysql:host=your_database_host;dbname=your_database_name;charset=utf8', 'your_database_user', 'your_database_password');
			$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

			// Store the transaction information for decision making
			$st = $db->prepare('INSERT INTO `fraudlabs_pro` (flp_transaction_id, flp_status, twocheckout_sale_id) VALUES (:flpId, :flpStatus, :twocheckoutId)');
			$st->execute(array(
				':flpId'=>$fraudResult->fraudlabspro_id,
				':flpStatus'=>$fraudResult->fraudlabspro_status,
				':twocheckoutId'=>$twocheckoutSaleId
			));
		}
		catch(PDOException $e){
			// MySQL error
			die($e->getFile() . ':' . $e->getLine() . ' ' . $e->getMessage());
		}
	} catch (Twocheckout_Error $e) {
		echo $e->getMessage();
	}
}

Now, we are going to create a callback page to receive the review action, APPROVE or REJECT, performed by the merchant.

Note: You need to configure the callback URL at the FraudLabs Pro merchant area->settings page. It has to be pointed to the location where you hosted this “fraudlabspro-callback.php” file. Below is the sample code for fraudlabspro-callback.php

// Include 2Checkout library
require_once("/path/to/2checkout-php/lib/Twocheckout.php");

$id = (isset($_POST['id'])) ? $_POST['id'] : '';
$action = (isset($_POST['action'])) ? $_POST['action'] : '';

if($id && in_array($action, array('APPROVE', 'REJECT'))){
	try{
		// Initial MySQL connection
		$db = new PDO('mysql:host=your_database_host;dbname=your_database_name;charset=utf8', 'your_database_user', 'your_database_password');
		$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

		// Get the 2Checkout Transaction ID
		$st = $db->prepare('SELECT * FROM `fraudlabs_pro` WHERE `flp_transaction_id`=:flpId AND `flp_status`=\'REVIEW\'');
		$st->execute(array(
			':flpId'=>$id
		));

		if($st->rowCount() == 1){
			$row = $st->fetch(PDO::FETCH_ASSOC);

			Twocheckout::username('your_2checkout_username');
			Twocheckout::password('your_2checkout_password');

			if($action == 'REJECT'){
				// Merchant rejected the order. Void the transaction in 2Checkout
				$params = array(
					'sale_id' => $row['twocheckout_sale_id']
				);
				try {
					Twocheckout_Sale::stop($params);

					// Update database
					$st = $db->prepare('UPDATE `fraudlabs_pro` SET `flp_status`=:action WHERE `flp_transaction_id`=:flpId');
					$st->execute(array(
						':flpId'=>$id,
						':action'=>$action
					));
				} catch (Twocheckout_Error $e) {
					echo $e->getMessage();
				}
			}
			else{
				// Merchant approved the order. No action on 2Checkout as the transaction will be auto-captured
				// Update database
				$st = $db->prepare('UPDATE `fraudlabs_pro` SET `flp_status`=:action WHERE `flp_transaction_id`=:flpId');
				$st->execute(array(
					':flpId'=>$id,
					':action'=>$action
				));
			}
		}
	}
	catch(PDOException $e){
		// MySQL error
		die($e->getFile() . ':' . $e->getLine() . ' ' . $e->getMessage());
	}
}

If there is a need to issue a refund of a settled transaction, below is the sample code of how to accomplish it.

// Include 2Checkout library
require_once("/path/to/2checkout-php/lib/Twocheckout.php");

try{
	// Initial MySQL connection
	$db = new PDO('mysql:host=your_database_host;dbname=your_database_name;charset=utf8', 'your_database_user', 'your_database_password');
	$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

	// Get the 2Checkout sale ID based on the FraudLabs Pro ID
	$st = $db->prepare('SELECT * FROM `fraudlabs_pro` WHERE `flp_transaction_id`=:flpId');
	$st->execute(array(
		':flpId'=>$_POST['flpId']
	));

	if($st->rowCount() == 1){
		$row = $st->fetch(PDO::FETCH_ASSOC);

		Twocheckout::username('your_2checkout_username');
		Twocheckout::password('your_2checkout_password');

		$params = array(
			'sale_id' => $row['twocheckout_sale_id']
		);
		try {
			Twocheckout_Sale::refund($params);

			// Update database
			$st = $db->prepare('UPDATE `fraudlabs_pro` SET `flp_status`=\'REFUNDED\' WHERE `flp_transaction_id`=:flpId');
			$st->execute(array(
				':flpId'=>$_POST['flpId']
			));
		} catch (Twocheckout_Error $e) {
			echo $e->getMessage();
		}
	}
}
catch(PDOException $e){
	// MySQL error
	die($e->getFile() . ':' . $e->getLine() . ' ' . $e->getMessage());
}