666999 - Version 0.4.1

Version Notes

Implements 3D Secure payment feature.

Release Info

Developer	Demac Media
Extension	666999
Version	0.4.1
Comparing to
See all releases

Code changes from version 0.4.0 to 0.4.1

Files changed (30) hide show

app/code/community/Demac/Optimal/Helper/Data.php +28 -10
app/code/community/Demac/Optimal/Model/Method/Hosted.php +2 -0
app/code/community/Demac/Optimal/Model/Observer.php +2 -1
app/code/community/Demac/Optimal/controllers/HandlerController.php +44 -11
app/code/community/Demac/Optimal/etc/config.xml +1 -1
app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.0.php +2 -2
app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.1.php +2 -2
app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.2.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.3.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.4.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.5.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.6.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.7.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.9.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/install-0.3.5.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.0.php +2 -2
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.1.php +2 -2
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.2.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.3.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.4.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.5.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.6.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.7.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.9.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.3.5.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-upgrade-0.1.1-0.2.7.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-upgrade-0.4.1-0.4.2.php +12 -0
app/code/community/Demac/Optimal/sql/optimal_setup/upgrade-0.1.1-0.2.7.php +4 -4
app/code/community/Demac/Optimal/sql/optimal_setup/upgrade-0.4.1-0.4.2.php +12 -0
package.xml +4 -4

app/code/community/Demac/Optimal/Helper/Data.php CHANGED Viewed

	@@ -39,7 +39,7 @@ class Demac_Optimal_Helper_Data extends Mage_Core_Helper_Abstract
39	if($customer_id !== false) {
40	$customer = Mage::getModel('optimal/merchant_customer')->load($customer_id, 'customer_id');
41	if($customer->getMerchantCustomerId()) {
42	- return $this->processMerchantCustomerId($customer~~->getMerchantCustomerId(~~));
43	}
44	}
45
	@@ -49,14 +49,22 @@ class Demac_Optimal_Helper_Data extends Mage_Core_Helper_Abstract
49	}
50	$customer->setDataChanges(true); // force save in case we need to save just the ID.
51	$customer->save();
52	- ~~return $this->processMerchantCustomerId($customer->getMerchantCustomerId());~~





53	}
54
55	- protected function processMerchantCustomerId($~~internal_id~~) {
56	- $~~profileKey~~ = ~~Mage::getStoreConfig~~(~~'payment/optimal_profiles/profile_key'~~);



57	return array(
58	- 'internal_id' => $~~internal_id~~,
59	- 'merchant_customer_id' => md5($~~profileKey~~ . $~~internal_id~~)
60	);
61	}
62
	@@ -98,7 +106,7 @@ class Demac_Optimal_Helper_Data extends Mage_Core_Helper_Abstract
98	$data = array(
99	'totalAmount' => (int) $this->formatAmount($orderData['base_grand_total']),
100	'currencyCode' => (string) $orderData['base_currency_code'],
101	- 'merchantRefNum' => (string) $orderData['increment_id'] . ~~'-' .~~ time(),
102	);
103
104	if(strlen(Mage::getStoreConfig('payment/optimal_hosted/merchant_email')) > 0) {
	@@ -134,7 +142,9 @@ class Demac_Optimal_Helper_Data extends Mage_Core_Helper_Abstract
134	$customerId = Mage::getSingleton('customer/session')->getId();
135	}
136
137	- $~~profile~~ = ~~Mage::getModel('optimal/creditcard')~~->~~load~~($customerId~~, 'customer_id'~~);


138
139	// If not skipping 3D and CreateProfiles is TRUE
140	if (!$skip3d && $profilesEnabled) {
	@@ -143,7 +153,7 @@ class Demac_Optimal_Helper_Data extends Mage_Core_Helper_Abstract
143
144	$customerProfile['id'] = (string) $profile->getProfileId();
145
146	- } elseif (~~!isset~~($merchantCustomerId)) {
147	$merchantCustomerId = $this->getMerchantCustomerId($customerId);
148	$merchantCustomerId = $merchantCustomerId['merchant_customer_id'];
149	$customerProfile['merchantCustomerId'] = $merchantCustomerId;
	@@ -264,6 +274,13 @@ class Demac_Optimal_Helper_Data extends Mage_Core_Helper_Abstract
264	)
265	);
266







267	// Billing Details information
268	$billingDetailsArray = array(
269	'city' => (string) $billingAddress->getCity(),
	@@ -329,6 +346,7 @@ class Demac_Optimal_Helper_Data extends Mage_Core_Helper_Abstract
329	// Shopping Cart Information
330	foreach($orderItems as $item)
331	{

332	$itemArray = array(
333	'amount' => (int) $this->formatAmount($item->getBasePrice()),
334	'quantity' => (int) $item->getQtyOrdered(),
	@@ -356,7 +374,7 @@ class Demac_Optimal_Helper_Data extends Mage_Core_Helper_Abstract
356
357	// Callback information
358	$redirectArray = array();
359	- $returnKeys = array('id', 'transaction.confirmationNumber', 'transaction.status');
360
361	$redirectArray[] = array(
362	'rel' => (string) 'on_success',


39	if($customer_id !== false) {
40	$customer = Mage::getModel('optimal/merchant_customer')->load($customer_id, 'customer_id');
41	if($customer->getMerchantCustomerId()) {
42	+ return $this->processMerchantCustomerId($customer);
43	}
44	}
45

49	}
50	$customer->setDataChanges(true); // force save in case we need to save just the ID.
51	$customer->save();
52	+
53	+ $cData = Mage::getModel('optimal/merchant_customer')->getCollection()
54	+ ->addFieldToFilter('customer_id', $customer_id)
55	+ ->getFirstItem();
56	+
57	+ return $this->processMerchantCustomerId($customer);
58	}
59
60	+ protected function processMerchantCustomerId($merchantCustomer) {
61	+ $internalId = $merchantCustomer->getMerchantCustomerId();
62	+ $customerId = $merchantCustomer->getCustomerId();
63	+ $currentStoreId = Mage::app()->getStore()->getStoreId();
64	+ $apiLoginId = Mage::helper('core')->decrypt(Mage::getStoreConfig('payment/optimal_hosted/login'), $currentStoreId);
65	return array(
66	+ 'internal_id' => $internalId,
67	+ 'merchant_customer_id' => md5($apiLoginId . $internalId . $customerId)
68	);
69	}
70

106	$data = array(
107	'totalAmount' => (int) $this->formatAmount($orderData['base_grand_total']),
108	'currencyCode' => (string) $orderData['base_currency_code'],
109	+ 'merchantRefNum' => (string) $orderData['increment_id'] . time(),
110	);
111
112	if(strlen(Mage::getStoreConfig('payment/optimal_hosted/merchant_email')) > 0) {

142	$customerId = Mage::getSingleton('customer/session')->getId();
143	}
144
145	+ $merchantCustomerId = $this->getMerchantCustomerId($customerId);
146	+ $merchantCustomerId = $merchantCustomerId['merchant_customer_id'];
147	+ $profile = Mage::getModel('optimal/creditcard')->loadByMerchantCustomerId($merchantCustomerId);
148
149	// If not skipping 3D and CreateProfiles is TRUE
150	if (!$skip3d && $profilesEnabled) {

153
154	$customerProfile['id'] = (string) $profile->getProfileId();
155
156	+ } elseif (empty($customerProfile['merchantCustomerId'])) {
157	$merchantCustomerId = $this->getMerchantCustomerId($customerId);
158	$merchantCustomerId = $merchantCustomerId['merchant_customer_id'];
159	$customerProfile['merchantCustomerId'] = $merchantCustomerId;

274	)
275	);
276
277	+ if (!empty($orderData['gift_cards_amount'])) {
278	+ $ancillaryFeesArray[] = array(
279	+ 'amount' => (-100 * $orderData['gift_cards_amount']),
280	+ 'description' => "Gift Cards Amount"
281	+ );
282	+ }
283	+
284	// Billing Details information
285	$billingDetailsArray = array(
286	'city' => (string) $billingAddress->getCity(),

346	// Shopping Cart Information
347	foreach($orderItems as $item)
348	{
349	+ $itemAmountTotal += (float) $item->getBasePrice();
350	$itemArray = array(
351	'amount' => (int) $this->formatAmount($item->getBasePrice()),
352	'quantity' => (int) $item->getQtyOrdered(),

374
375	// Callback information
376	$redirectArray = array();
377	+ $returnKeys = array('id', 'transaction.confirmationNumber', 'transaction.status', 'profile.id', 'profile.paymentToken');
378
379	$redirectArray[] = array(
380	'rel' => (string) 'on_success',

app/code/community/Demac/Optimal/Model/Method/Hosted.php CHANGED Viewed

	@@ -209,6 +209,7 @@ class Demac_Optimal_Model_Method_Hosted extends Mage_Payment_Model_Method_Cc
209	}
210
211	$order = $payment->getOrder();

212	$client = Mage::getModel('optimal/hosted_client');
213	$helper = Mage::helper('optimal');
214
	@@ -225,6 +226,7 @@ class Demac_Optimal_Model_Method_Hosted extends Mage_Payment_Model_Method_Cc
225	$orderData['shipping_address'] = $order->getShippingAddress();
226
227	$orderData['base_tax_amount'] = $order->getBaseTaxAmount();

228	$orderData['base_grand_total'] = $order->getBaseGrandTotal();
229	$orderData['base_currency_code'] = $order->getBaseCurrencyCode();
230	$orderData['base_shipping_amount'] = $order->getBaseShippingAmount();


209	}
210
211	$order = $payment->getOrder();
212	+ $quote = Mage::getModel('sales/quote')->load($order->getQuoteId());
213	$client = Mage::getModel('optimal/hosted_client');
214	$helper = Mage::helper('optimal');
215

226	$orderData['shipping_address'] = $order->getShippingAddress();
227
228	$orderData['base_tax_amount'] = $order->getBaseTaxAmount();
229	+ $orderData['gift_cards_amount'] = $quote->getBaseGiftCardsAmountUsed();
230	$orderData['base_grand_total'] = $order->getBaseGrandTotal();
231	$orderData['base_currency_code'] = $order->getBaseCurrencyCode();
232	$orderData['base_shipping_amount'] = $order->getBaseShippingAmount();

app/code/community/Demac/Optimal/Model/Observer.php CHANGED Viewed

	@@ -22,9 +22,10 @@ class Demac_Optimal_Model_Observer
22	$isCustomerNotified = false; // Customer Notification true/false.
23
24
25	- if ($payment->getMethod() == 'optimal_hosted') {
26	$orderAdditionalInformation = $payment->getAdditionalInformation();
27

28	$transaction = unserialize($orderAdditionalInformation['transaction']);
29
30	if(!empty($transaction->riskReasonCode))


22	$isCustomerNotified = false; // Customer Notification true/false.
23
24
25	+ if ($payment->getMethod() == 'optimal_hosted' && isset($orderAdditionalInformation['transaction'])) {
26	$orderAdditionalInformation = $payment->getAdditionalInformation();
27
28	+ // The Transaction Object is not present mostly when there is a declined transaction
29	$transaction = unserialize($orderAdditionalInformation['transaction']);
30
31	if(!empty($transaction->riskReasonCode))

app/code/community/Demac/Optimal/controllers/HandlerController.php CHANGED Viewed

	@@ -11,14 +11,11 @@ class Demac_Optimal_HandlerController extends Mage_Core_Controller_Front_Action
11	{
12	$params = $this->getRequest()->getParams();
13	$session = Mage::getSingleton('checkout/session');
14	-
15	$status = $params['transaction_status'];
16	- $confirmation = $params['transaction_confirmationNumber'];
17	- $optimalOrderId = $params['id'];
18
19	if ($status != 'success') {
20	$session->addError($this->__('Payment failed, please review your payment information and try again.'));
21	- $this->_handlePaymentFailure();
22	$this->_redirect('checkout/cart');
23	return;
24	}
	@@ -27,7 +24,7 @@ class Demac_Optimal_HandlerController extends Mage_Core_Controller_Front_Action
27	$this->_handlePaymentSuccess($session, $params);
28	} catch (Mage_Core_Exception $e) {
29	Mage::logException($e);
30	- $this->_handlePaymentFailure();
31	$this->_redirect('checkout/onepage/failure');
32	}
33
	@@ -39,13 +36,49 @@ class Demac_Optimal_HandlerController extends Mage_Core_Controller_Front_Action
39	* Cancel Order and attempt to restore cart.
40	*
41	*/
42	- protected function _handlePaymentFailure()
43	{
44	- $~~session~~ = ~~Mage::getSingleton(~~'~~checkout/session~~');




















45
46	if ($session->getLastRealOrderId()) {

















47	try {
48	- $order = Mage::getModel('sales/order')->loadByIncrementId($session->getLastRealOrderId());
49	if ($order->getId()) {
50	$order->cancel()->save();
51	}
	@@ -67,8 +100,6 @@ class Demac_Optimal_HandlerController extends Mage_Core_Controller_Front_Action
67	*/
68	protected function _handlePaymentSuccess($session, $params)
69	{
70	- $status = $params['transaction_status'];
71	- $confirmation = $params['transaction_confirmationNumber'];
72	$optimalOrderId = $params['id'];
73
74	$order = Mage::getModel('sales/order')->loadByIncrementId($session->getLastRealOrderId());
	@@ -99,13 +130,15 @@ class Demac_Optimal_HandlerController extends Mage_Core_Controller_Front_Action
99	$merchantCustomerId = $merchantCustomerId['merchant_customer_id'];
100
101	// this means the CC is not saved
102	- if ~~(empty(~~$profile)~~) {~~

103	$profile = Mage::getModel('optimal/creditcard');
104	}
105
106	// Set Profile Info
107	$profile->setCustomerId($customerId);
108	$profile->setProfileId($orderStatus->profile->id);

109	$profile->setMerchantCustomerId($merchantCustomerId);
110	$profile->setPaymentToken($orderStatus->profile->paymentToken);
111


11	{
12	$params = $this->getRequest()->getParams();
13	$session = Mage::getSingleton('checkout/session');

14	$status = $params['transaction_status'];


15
16	if ($status != 'success') {
17	$session->addError($this->__('Payment failed, please review your payment information and try again.'));
18	+ $this->_handlePaymentFailure($session, $params);
19	$this->_redirect('checkout/cart');
20	return;
21	}

24	$this->_handlePaymentSuccess($session, $params);
25	} catch (Mage_Core_Exception $e) {
26	Mage::logException($e);
27	+ $this->_handlePaymentFailure($session, $params);
28	$this->_redirect('checkout/onepage/failure');
29	}
30

36	* Cancel Order and attempt to restore cart.
37	*
38	*/
39	+ protected function _handlePaymentFailure($session, $params)
40	{
41	+ $status = $params['transaction_status'];
42	+ $confirmation = $params['transaction_confirmationNumber'];
43	+ $optimalOrderId = $params['id'];
44	+ $profileId = $params['profile_id'];
45	+ $paymentToken = $params['profile_paymentToken'];
46	+ $profile = Mage::getModel('optimal/creditcard')->loadByProfileId($profileId);
47	+
48	+ $customerId = Mage::getSingleton('customer/session')->getId();
49	+ $merchantCustomerId = Mage::helper('optimal')->getMerchantCustomerId($customerId);
50	+ $merchantCustomerId = $merchantCustomerId['merchant_customer_id'];
51	+
52	+ // Check if profile exists
53	+ if (!$profile->getId()) {
54	+ // Make one otherwise
55	+ $profile->setCustomerId($customerId);
56	+ $profile->setProfileId($profileId);
57	+ $profile->setPaymentToken($paymentToken);
58	+ $profile->setMerchantCustomerId($merchantCustomerId);
59	+ $profile->setIsDeleted(1);
60	+ $profile->save();
61	+ }
62
63	if ($session->getLastRealOrderId()) {
64	+ $order = Mage::getModel('sales/order')->loadByIncrementId($session->getLastRealOrderId());
65	+ $payment = $order->getPayment();
66	+
67	+ $order->addStatusHistoryComment(
68	+ 'Netbanks Order Id: ' . $optimalOrderId .'<br/>' .
69	+ 'Transaction Id: ' . $confirmation .'<br/>' .
70	+ 'Status: ' . $status .'<br/>'
71	+ );
72	+
73	+ $payment->setStatus('DECLINED');
74	+ $payment->setAdditionalInformation('order', serialize(array('id' => $optimalOrderId)));
75	+
76	+ $payment->setTransactionId($optimalOrderId);
77	+ // magento will automatically close the transaction on auth preventing the invoice from being captured online.
78	+ $payment->setIsTransactionClosed(true);
79	+ $payment->save();
80	+
81	try {

82	if ($order->getId()) {
83	$order->cancel()->save();
84	}

100	*/
101	protected function _handlePaymentSuccess($session, $params)
102	{


103	$optimalOrderId = $params['id'];
104
105	$order = Mage::getModel('sales/order')->loadByIncrementId($session->getLastRealOrderId());

130	$merchantCustomerId = $merchantCustomerId['merchant_customer_id'];
131
132	// this means the CC is not saved
133	+ $profileDbId = $profile->getId();
134	+ if (empty($profileDbId)) {
135	$profile = Mage::getModel('optimal/creditcard');
136	}
137
138	// Set Profile Info
139	$profile->setCustomerId($customerId);
140	$profile->setProfileId($orderStatus->profile->id);
141	+ $lnt = strlen($orderStatus->profile->id);
142	$profile->setMerchantCustomerId($merchantCustomerId);
143	$profile->setPaymentToken($orderStatus->profile->paymentToken);
144

app/code/community/Demac/Optimal/etc/config.xml CHANGED Viewed

	@@ -2,7 +2,7 @@
2	<config>
3	<modules>
4	<Demac_Optimal>
5	- <version>0.4.0</version>
6	</Demac_Optimal>
7	</modules>
8


2	<config>
3	<modules>
4	<Demac_Optimal>
5	+ <version>0.4.1</version>
6	</Demac_Optimal>
7	</modules>
8

app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.0.php CHANGED Viewed

	@@ -14,8 +14,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
14	`nickname` varchar(255) NOT NULL DEFAULT '',
15	`card_expiration` varchar(255) NOT NULL DEFAULT '',
16	`payment_token` varchar(255) NOT NULL DEFAULT '',
17	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
18	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
19	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
20	PRIMARY KEY (`entity_id`),
21	KEY `profile_id` (`profile_id`),


14	`nickname` varchar(255) NOT NULL DEFAULT '',
15	`card_expiration` varchar(255) NOT NULL DEFAULT '',
16	`payment_token` varchar(255) NOT NULL DEFAULT '',
17	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
18	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
19	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
20	PRIMARY KEY (`entity_id`),
21	KEY `profile_id` (`profile_id`),

app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.1.php CHANGED Viewed

	@@ -29,8 +29,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
29	`nickname` varchar(255) NOT NULL DEFAULT '',
30	`card_expiration` varchar(255) NOT NULL DEFAULT '',
31	`payment_token` varchar(255) NOT NULL DEFAULT '',
32	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
33	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
34	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
35	PRIMARY KEY (`entity_id`),
36	KEY `profile_id` (`profile_id`),


29	`nickname` varchar(255) NOT NULL DEFAULT '',
30	`card_expiration` varchar(255) NOT NULL DEFAULT '',
31	`payment_token` varchar(255) NOT NULL DEFAULT '',
32	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
33	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
34	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
35	PRIMARY KEY (`entity_id`),
36	KEY `profile_id` (`profile_id`),

app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.2.php CHANGED Viewed

	@@ -29,8 +29,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
29	`nickname` varchar(255) NOT NULL DEFAULT '',
30	`card_expiration` varchar(255) NOT NULL DEFAULT '',
31	`payment_token` varchar(255) NOT NULL DEFAULT '',
32	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
33	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
34	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
35	PRIMARY KEY (`entity_id`),
36	KEY `profile_id` (`profile_id`),
	@@ -50,10 +50,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
50	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
51
52	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
53	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
54
55	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
56	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
57
58
59


29	`nickname` varchar(255) NOT NULL DEFAULT '',
30	`card_expiration` varchar(255) NOT NULL DEFAULT '',
31	`payment_token` varchar(255) NOT NULL DEFAULT '',
32	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
33	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
34	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
35	PRIMARY KEY (`entity_id`),
36	KEY `profile_id` (`profile_id`),

50	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
51
52	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
53	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
54
55	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
56	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
57
58
59

app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.3.php CHANGED Viewed

	@@ -30,8 +30,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
30	`card_holder` varchar(255) NOT NULL DEFAULT '',
31	`card_expiration` varchar(255) NOT NULL DEFAULT '',
32	`payment_token` varchar(255) NOT NULL DEFAULT '',
33	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
34	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
35	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36	PRIMARY KEY (`entity_id`),
37	KEY `profile_id` (`profile_id`),
	@@ -51,10 +51,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
51	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
52
53	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
54	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59
60


30	`card_holder` varchar(255) NOT NULL DEFAULT '',
31	`card_expiration` varchar(255) NOT NULL DEFAULT '',
32	`payment_token` varchar(255) NOT NULL DEFAULT '',
33	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
34	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
35	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36	PRIMARY KEY (`entity_id`),
37	KEY `profile_id` (`profile_id`),

51	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
52
53	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
54	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59
60

app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.4.php CHANGED Viewed

	@@ -30,8 +30,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
30	`card_holder` varchar(255) NOT NULL DEFAULT '',
31	`card_expiration` varchar(255) NOT NULL DEFAULT '',
32	`payment_token` varchar(255) NOT NULL DEFAULT '',
33	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
34	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
35	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36	PRIMARY KEY (`entity_id`),
37	KEY `profile_id` (`profile_id`),
	@@ -51,10 +51,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
51	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
52
53	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
54	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59
60


30	`card_holder` varchar(255) NOT NULL DEFAULT '',
31	`card_expiration` varchar(255) NOT NULL DEFAULT '',
32	`payment_token` varchar(255) NOT NULL DEFAULT '',
33	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
34	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
35	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36	PRIMARY KEY (`entity_id`),
37	KEY `profile_id` (`profile_id`),

51	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
52
53	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
54	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59
60

app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.5.php CHANGED Viewed

	@@ -31,8 +31,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
35	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
36	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
37	PRIMARY KEY (`entity_id`),
38	KEY `profile_id` (`profile_id`),
	@@ -53,10 +53,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
53	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
54
55	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
56	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
57
58	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
59	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
60
61
62


31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
35	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
36	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
37	PRIMARY KEY (`entity_id`),
38	KEY `profile_id` (`profile_id`),

53	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
54
55	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
56	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
57
58	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
59	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
60
61
62

app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.6.php CHANGED Viewed

	@@ -31,8 +31,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
35	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),
	@@ -54,10 +54,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
61
62
63


31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
35	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),

54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
61
62
63

app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.7.php CHANGED Viewed

	@@ -31,8 +31,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
35	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),
	@@ -54,10 +54,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
61
62
63


31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
35	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),

54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
61
62
63

app/code/community/Demac/Optimal/sql/optimal_setup/install-0.2.9.php CHANGED Viewed

	@@ -31,8 +31,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
35	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),
	@@ -54,10 +54,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
61
62
63


31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
35	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),

54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
61
62
63

app/code/community/Demac/Optimal/sql/optimal_setup/install-0.3.5.php CHANGED Viewed

	@@ -44,8 +44,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
44	`card_nickname` varchar(255) NOT NULL DEFAULT '',
45	`card_expiration` varchar(255) NOT NULL DEFAULT '',
46	`payment_token` varchar(255) NOT NULL DEFAULT '',
47	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
48	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
49	`is_deleted` boolean NOT NULL DEFAULT false,
50	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
51	PRIMARY KEY (`entity_id`),
	@@ -67,10 +67,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
67	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
68
69	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
70	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
71
72	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
73	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
74
75	$table = $installer->getConnection()
76	->newTable($installer->getTable('optimal/merchant_customer'))


44	`card_nickname` varchar(255) NOT NULL DEFAULT '',
45	`card_expiration` varchar(255) NOT NULL DEFAULT '',
46	`payment_token` varchar(255) NOT NULL DEFAULT '',
47	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
48	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
49	`is_deleted` boolean NOT NULL DEFAULT false,
50	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
51	PRIMARY KEY (`entity_id`),

67	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
68
69	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
70	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
71
72	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
73	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
74
75	$table = $installer->getConnection()
76	->newTable($installer->getTable('optimal/merchant_customer'))

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.0.php CHANGED Viewed

	@@ -14,8 +14,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
14	`nickname` varchar(255) NOT NULL DEFAULT '',
15	`card_expiration` varchar(255) NOT NULL DEFAULT '',
16	`payment_token` varchar(255) NOT NULL DEFAULT '',
17	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
18	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
19	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
20	PRIMARY KEY (`entity_id`),
21	KEY `profile_id` (`profile_id`),


14	`nickname` varchar(255) NOT NULL DEFAULT '',
15	`card_expiration` varchar(255) NOT NULL DEFAULT '',
16	`payment_token` varchar(255) NOT NULL DEFAULT '',
17	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
18	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
19	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
20	PRIMARY KEY (`entity_id`),
21	KEY `profile_id` (`profile_id`),

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.1.php CHANGED Viewed

	@@ -29,8 +29,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
29	`nickname` varchar(255) NOT NULL DEFAULT '',
30	`card_expiration` varchar(255) NOT NULL DEFAULT '',
31	`payment_token` varchar(255) NOT NULL DEFAULT '',
32	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
33	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
34	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
35	PRIMARY KEY (`entity_id`),
36	KEY `profile_id` (`profile_id`),


29	`nickname` varchar(255) NOT NULL DEFAULT '',
30	`card_expiration` varchar(255) NOT NULL DEFAULT '',
31	`payment_token` varchar(255) NOT NULL DEFAULT '',
32	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
33	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
34	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
35	PRIMARY KEY (`entity_id`),
36	KEY `profile_id` (`profile_id`),

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.2.php CHANGED Viewed

	@@ -29,8 +29,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
29	`nickname` varchar(255) NOT NULL DEFAULT '',
30	`card_expiration` varchar(255) NOT NULL DEFAULT '',
31	`payment_token` varchar(255) NOT NULL DEFAULT '',
32	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
33	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
34	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
35	PRIMARY KEY (`entity_id`),
36	KEY `profile_id` (`profile_id`),
	@@ -50,10 +50,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
50	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
51
52	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
53	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
54
55	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
56	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
57
58
59


29	`nickname` varchar(255) NOT NULL DEFAULT '',
30	`card_expiration` varchar(255) NOT NULL DEFAULT '',
31	`payment_token` varchar(255) NOT NULL DEFAULT '',
32	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
33	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
34	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
35	PRIMARY KEY (`entity_id`),
36	KEY `profile_id` (`profile_id`),

50	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
51
52	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
53	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
54
55	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
56	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
57
58
59

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.3.php CHANGED Viewed

	@@ -30,8 +30,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
30	`card_holder` varchar(255) NOT NULL DEFAULT '',
31	`card_expiration` varchar(255) NOT NULL DEFAULT '',
32	`payment_token` varchar(255) NOT NULL DEFAULT '',
33	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
34	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
35	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36	PRIMARY KEY (`entity_id`),
37	KEY `profile_id` (`profile_id`),
	@@ -51,10 +51,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
51	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
52
53	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
54	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59
60


30	`card_holder` varchar(255) NOT NULL DEFAULT '',
31	`card_expiration` varchar(255) NOT NULL DEFAULT '',
32	`payment_token` varchar(255) NOT NULL DEFAULT '',
33	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
34	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
35	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36	PRIMARY KEY (`entity_id`),
37	KEY `profile_id` (`profile_id`),

51	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
52
53	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
54	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59
60

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.4.php CHANGED Viewed

	@@ -30,8 +30,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
30	`card_holder` varchar(255) NOT NULL DEFAULT '',
31	`card_expiration` varchar(255) NOT NULL DEFAULT '',
32	`payment_token` varchar(255) NOT NULL DEFAULT '',
33	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
34	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
35	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36	PRIMARY KEY (`entity_id`),
37	KEY `profile_id` (`profile_id`),
	@@ -51,10 +51,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
51	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
52
53	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
54	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59
60


30	`card_holder` varchar(255) NOT NULL DEFAULT '',
31	`card_expiration` varchar(255) NOT NULL DEFAULT '',
32	`payment_token` varchar(255) NOT NULL DEFAULT '',
33	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
34	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
35	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
36	PRIMARY KEY (`entity_id`),
37	KEY `profile_id` (`profile_id`),

51	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
52
53	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
54	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59
60

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.5.php CHANGED Viewed

	@@ -31,8 +31,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
35	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
36	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
37	PRIMARY KEY (`entity_id`),
38	KEY `profile_id` (`profile_id`),
	@@ -53,10 +53,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
53	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
54
55	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
56	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
57
58	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
59	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
60
61
62


31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
35	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
36	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
37	PRIMARY KEY (`entity_id`),
38	KEY `profile_id` (`profile_id`),

53	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
54
55	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
56	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
57
58	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
59	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
60
61
62

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.6.php CHANGED Viewed

	@@ -31,8 +31,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
35	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),
	@@ -54,10 +54,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
61
62
63


31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
35	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),

54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
61
62
63

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.7.php CHANGED Viewed

	@@ -31,8 +31,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
35	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),
	@@ -54,10 +54,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
61
62
63


31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
35	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),

54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
61
62
63

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.2.9.php CHANGED Viewed

	@@ -31,8 +31,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
35	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),
	@@ -54,10 +54,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
61
62
63


31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
35	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),

54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
61
62
63

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-install-0.3.5.php CHANGED Viewed

	@@ -43,8 +43,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
43	`card_nickname` varchar(255) NOT NULL DEFAULT '',
44	`card_expiration` varchar(255) NOT NULL DEFAULT '',
45	`payment_token` varchar(255) NOT NULL DEFAULT '',
46	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
47	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
48	`is_deleted` boolean NOT NULL DEFAULT false,
49	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
50	PRIMARY KEY (`entity_id`),
	@@ -66,10 +66,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
66	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
67
68	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
69	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
70
71	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
72	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
73
74	$table = $installer->getConnection()
75	->newTable($installer->getTable('optimal/merchant_customer'))


43	`card_nickname` varchar(255) NOT NULL DEFAULT '',
44	`card_expiration` varchar(255) NOT NULL DEFAULT '',
45	`payment_token` varchar(255) NOT NULL DEFAULT '',
46	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
47	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
48	`is_deleted` boolean NOT NULL DEFAULT false,
49	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
50	PRIMARY KEY (`entity_id`),

66	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
67
68	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
69	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
70
71	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
72	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
73
74	$table = $installer->getConnection()
75	->newTable($installer->getTable('optimal/merchant_customer'))

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-upgrade-0.1.1-0.2.7.php CHANGED Viewed

	@@ -31,8 +31,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
35	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),
	@@ -54,10 +54,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
61
62
63


31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
35	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),

54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
61
62
63

app/code/community/Demac/Optimal/sql/optimal_setup/mysql4-upgrade-0.4.1-0.4.2.php ADDED Viewed

	@@ -0,0 +1,12 @@


1	+ <?php
2	+
3	+ $installer = $this;
4	+
5	+ $installer->startSetup();
6	+
7	+ $installer->run("
8	+ ALTER TABLE `{$installer->getTable('sales_flat_quote_payment')}` MODIFY `optimal_profile_id` VARCHAR(255) NOT NULL DEFAULT \"\" AFTER `method`;
9	+ ALTER TABLE `{$installer->getTable('sales_flat_order_payment')}` MODIFY `optimal_profile_id` VARCHAR(255) NOT NULL DEFAULT \"\" AFTER `method`;
10	+ ");
11	+
12	+ $installer->endSetup();

app/code/community/Demac/Optimal/sql/optimal_setup/upgrade-0.1.1-0.2.7.php CHANGED Viewed

	@@ -31,8 +31,8 @@ CREATE TABLE IF NOT EXISTS `{$this->getTable('optimal/creditcard')}` (
31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	- `last_four_digits` ~~int~~(4) NOT NULL DEFAULT 0,
35	- `profile_id` ~~int~~(20) NOT NULL DEFAULT 0,
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),
	@@ -54,10 +54,10 @@ $installer->getConnection()->addColumn($installer->getTable('sales_flat_order_pa
54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	- 'optimal_profile_id', '~~INT~~(10) NOT NULL DEFAULT 0 AFTER `method`');
61
62
63


31	`card_nickname` varchar(255) NOT NULL DEFAULT '',
32	`card_expiration` varchar(255) NOT NULL DEFAULT '',
33	`payment_token` varchar(255) NOT NULL DEFAULT '',
34	+ `last_four_digits` varchar(4) NOT NULL DEFAULT '',
35	+ `profile_id` varchar(255) NOT NULL DEFAULT '',
36	`is_deleted` boolean NOT NULL DEFAULT false,
37	`created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
38	PRIMARY KEY (`entity_id`),

54	'optimal_create_profile', 'BOOLEAN NOT NULL AFTER `method`');
55
56	$installer->getConnection()->addColumn($installer->getTable('sales_flat_quote_payment'),
57	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
58
59	$installer->getConnection()->addColumn($installer->getTable('sales_flat_order_payment'),
60	+ 'optimal_profile_id', 'VARCHAR(255) NOT NULL DEFAULT "" AFTER `method`');
61
62
63

app/code/community/Demac/Optimal/sql/optimal_setup/upgrade-0.4.1-0.4.2.php ADDED Viewed

	@@ -0,0 +1,12 @@


1	+ <?php
2	+
3	+ $installer = $this;
4	+
5	+ $installer->startSetup();
6	+
7	+ $installer->run("
8	+ ALTER TABLE `{$installer->getTable('sales_flat_quote_payment')}` MODIFY `optimal_profile_id` VARCHAR(255) NOT NULL DEFAULT \"\" AFTER `method`;
9	+ ALTER TABLE `{$installer->getTable('sales_flat_order_payment')}` MODIFY `optimal_profile_id` VARCHAR(255) NOT NULL DEFAULT \"\" AFTER `method`;
10	+ ");
11	+
12	+ $installer->endSetup();

package.xml CHANGED Viewed

	@@ -1,7 +1,7 @@
1	<?xml version="1.0"?>
2	<package>
3	<name>666999</name>
4	- <version>0.4.0</version>
5	<stability>stable</stability>
6	<license>GPL</license>
7	<channel>community</channel>
	@@ -16,9 +16,9 @@ This integration significantly reduces PCI compliance requirements and liability
16	Through the Optimal integration merchants also have the option to enable Threatmetrix fraud detection and management services. ThreatMetrix works by collecting relevant data about the customer and the order, and validating this information during the checkout. Fully integrated into the NETBANX payment gateway, enabling the ThreatMetrix option will allow merchants to automatically hold and flag suspicious orders, drastically reducing any fraud occurrences. Depending on the Score returned by ThreatMetrix an order can be held and flagged or altogether denied during the checkout.</description>
17	<notes>Implements 3D Secure payment feature.</notes>
18	<authors><author><name>Demac Media</name><user>demacmedia</user><email>support@demacmedia.com</email></author></authors>
19	- <date>2015-02-27</date>
20	- <time>19:37:14</time>
21	- <contents><target name="magecommunity"><dir name="Demac"><dir name="Optimal"><dir name="Block"><dir name="Adminhtml"><dir name="Errorcode"><dir name="Edit"><file name="Form.php" hash="56618ff0cc5f4c674f750412d0606aab"/></dir><file name="Edit.php" hash="8980988ca1324fac229b40f471d745c8"/><file name="Grid.php" hash="2d8ea2f836d380167e9b25a67acefd70"/></dir><file name="Errorcode.php" hash="9f0d3c6b0b51e3bedd239d3b727eff75"/><dir name="Risk"><dir name="Edit"><file name="Form.php" hash="25d4bcb59e33a94799bc9f6cb0509cc3"/><dir name="Tab"><file name="Form.php" hash="3731d284c28ed279eb5e00b41f494810"/></dir><file name="Tabs.php" hash="61a8d2ac9942356db313b423fc3c47c2"/></dir><file name="Edit.php" hash="959e8af1e6aae6d02560c98bcabea5ab"/><file name="Grid.php" hash="e999f01578aac6084520029f86852c09"/></dir><file name="Risk.php" hash="6bf5127ba14f9dd38519c6b62203f1f8"/></dir><dir name="Customer"><dir name="Cards"><file name="Form.php" hash="ce79e221d5caf995a10e47cbb4e51f8b"/><file name="Grid.php" hash="d14eb692082fe1299977e7b3ee75dcf3"/></dir><file name="Cards.php" hash="f99686c2296a850312713f6aadc4d04a"/></dir><dir name="Form"><file name="Creditcard.php" hash="d3642d432409cf55069253680bf9ee34"/></dir><dir name="Info"><file name="Creditcard.php" hash="7ba1df22bade177f4956ce9084fa98c6"/></dir><file name="Navigation.php" hash="d3b7d8765356b8da18d300cc9b1a447e"/><file name="Threat.php" hash="69605e0b8aacc80f47b5ed91e8631248"/></dir><dir name="Helper"><file name="Data.php" hash="~~69b5b351ee4685e4f51e0e3213ecb80e~~"/></dir><dir name="Model"><dir name="Client"><file name="Abstract.php" hash="f83275be8d3b248eb145d45c2a926d84"/></dir><dir name="Config"><file name="Mode.php" hash="798d2a9bab2c0fc2749116ac1a3fc926"/><file name="Status.php" hash="767ba25406456aae4a0bd86b11023b45"/><file name="Transaction.php" hash="e83e8427e4b14c4d3cd83058c68f8965"/></dir><dir name="Creditcard"><file name="Client.php" hash="f1014811d23c1cf5efbccf61c3c6c80c"/></dir><file name="Creditcard.php" hash="4754639f6fb3d4e1f1af0fd429e46092"/><file name="Errorcode.php" hash="dae5fa1abb705961bd9f15abf3d65ec0"/><dir name="Hosted"><file name="Client.php" hash="043fdac7d3c1c4af09424488d5d1cb7f"/><file name="Exception.php" hash="dfca385bc45b1c055bbf2e8e7031230b"/></dir><dir name="Merchant"><file name="Customer.php" hash="be743a5c7aababb9752bf961570b0c27"/></dir><dir name="Method"><file name="Hosted.php" hash="~~9f7da28c1cb5a0a508d33e91cebb81f7~~"/></dir><dir name="Mysql4"><dir name="Creditcard"><file name="Collection.php" hash="700985c287355082a3966d4b3f74838f"/></dir><file name="Creditcard.php" hash="a4e5ea4090d2f127edd19de9d2feb343"/><dir name="Errorcode"><file name="Collection.php" hash="075c7c98b606573f02aad1b096f13899"/></dir><file name="Errorcode.php" hash="0d19835b405402a5a5a7ae7c24a42c97"/><dir name="Merchant"><dir name="Customer"><file name="Collection.php" hash="aa0fbf9c0cc0a3207565443e35ae3779"/></dir><file name="Customer.php" hash="fe991d98537b7b3a07160d5b9b10802d"/></dir><dir name="Profile"><file name="Collection.php" hash="f5cd814fe62d2af8fbcc2214f94bfeb4"/></dir><file name="Profile.php" hash="6944c811248ef955a51357989ca11dd3"/><dir name="Risk"><file name="Collection.php" hash="558dc26690672dc09ae6fbfa8e780302"/></dir><file name="Risk.php" hash="5c77111382678451da4dde209a43b0fa"/></dir><file name="Observer.php" hash="~~cd89f8b6b1275718617c9841a5a1bbfa~~"/><dir name="Profile"><file name="Client.php" hash="4358736ced5bdc7d2a7fbbf53e2ff07d"/></dir><file name="Profile.php" hash="798cef09bbc0556545edf1f00bae9bf0"/><dir name="Resource"><dir name="Mysql4"><file name="Setup.php" hash="e936830d9e4f74badc3b7663f60436dc"/></dir></dir><file name="Risk.php" hash="fab5519b0e257b8ef2f66f5f76d49f2b"/><dir name="Sales"><file name="Order.php" hash="32320888ae209b1ea3208da59312da5c"/></dir><dir name="Source"><file name="Cctype.php" hash="dd21379a29444a4c58e33e90ddeb300e"/></dir><dir name="Web"><file name="Client.php" hash="d565e254fc281e7c246cc9cfe8c2f39d"/></dir></dir><dir name="Test"><dir name="Model"><dir name="Hosted"><file name="Client.php" hash="8aa8bb4bc740daa59be041827f7cf614"/></dir><dir name="Method"><file name="Hosted.php" hash="9d39c78d0617d136c66c4c52185706a7"/></dir><file name="Observer.php" hash="345883a098197f64e2063a97d17e6274"/></dir></dir><dir name="controllers"><dir name="Adminhtml"><file name="ErrorcodesController.php" hash="7149f83536e46413ddf5b159ae4ebf91"/><file name="ThreatController.php" hash="5db39713fbd0ae13e943a891940bb22c"/></dir><dir name="Frontend"><file name="OptimalController.php" hash="b67878eb0dd4310fbb6f84723cd6ce43"/></dir><file name="HandlerController.php" hash="~~b854169efa286fb13918bc2162ffc9e8~~"/></dir><dir name="data"><dir name="optimal_setup"><dir name="csv"><file name="common-codes-0.3.3.csv" hash="e3c9195dbe01cfb5cf341378271b1240"/><file name="webservices-codes-0.3.3.csv" hash="8fc5562ff9bb3e5c3235fa6c7c21c0d5"/></dir><file name="data-upgrade-0.3.4-0.3.5.php" hash="4afe267d997446c46c0a1fcba771d1e1"/></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="30a4af4a510783219bbee940d185fb19"/><file name="config.xml" hash="~~df7d323416f3090868d85fbf049c617a~~"/><file name="system.xml" hash="4e28392139fad2a08d168d0b1381f081"/></dir><dir name="sql"><dir name="optimal_setup"><file name="install-0.1.1.php" hash="422b6afb2d2320f5d9c59cd5bff0dc3d"/><file name="install-0.2.0.php" hash="~~71dbb515c55c34f1910463d72f66f9d2~~"/><file name="install-0.2.1.php" hash="~~0bd65edba72966cffce19dd3c480863b~~"/><file name="install-0.2.2.php" hash="~~33bb51df7561eb747ee07d8e8aa43ce4~~"/><file name="install-0.2.3.php" hash="~~abafde589308828b601c306b45f1aa41~~"/><file name="install-0.2.4.php" hash="~~abafde589308828b601c306b45f1aa41~~"/><file name="install-0.2.5.php" hash="~~9a0bb5235e982cfc1794dd8d0172e26d~~"/><file name="install-0.2.6.php" hash="~~0a8eb965fa5af575593d09722b6712b1~~"/><file name="install-0.2.7.php" hash="~~0a8eb965fa5af575593d09722b6712b1~~"/><file name="install-0.2.9.php" hash="~~0a8eb965fa5af575593d09722b6712b1~~"/><file name="install-0.3.5.php" hash="~~48e60534ab6a2aa1f962648553257dc6~~"/><file name="mysql4-install-0.1.1.php" hash="422b6afb2d2320f5d9c59cd5bff0dc3d"/><file name="mysql4-install-0.2.0.php" hash="~~71dbb515c55c34f1910463d72f66f9d2~~"/><file name="mysql4-install-0.2.1.php" hash="~~0bd65edba72966cffce19dd3c480863b~~"/><file name="mysql4-install-0.2.2.php" hash="~~33bb51df7561eb747ee07d8e8aa43ce4~~"/><file name="mysql4-install-0.2.3.php" hash="~~abafde589308828b601c306b45f1aa41~~"/><file name="mysql4-install-0.2.4.php" hash="~~abafde589308828b601c306b45f1aa41~~"/><file name="mysql4-install-0.2.5.php" hash="~~9a0bb5235e982cfc1794dd8d0172e26d~~"/><file name="mysql4-install-0.2.6.php" hash="~~0a8eb965fa5af575593d09722b6712b1~~"/><file name="mysql4-install-0.2.7.php" hash="~~0a8eb965fa5af575593d09722b6712b1~~"/><file name="mysql4-install-0.2.9.php" hash="~~0de8cd296b0b8aef8e666365cd930ed0~~"/><file name="mysql4-install-0.3.5.php" hash="~~46362c270521956139d6b93e3830ed53~~"/><file name="mysql4-upgrade-0.1.1-0.2.7.php" hash="~~0a8eb965fa5af575593d09722b6712b1~~"/><file name="upgrade-0.1.1-0.2.7.php" hash="~~0a8eb965fa5af575593d09722b6712b1~~"/><file name="upgrade-0.2.9-0.3.0.php" hash="989e6c4043fccfa6cdcba0a09938dd07"/><file name="upgrade-0.3.1-0.3.2.php" hash="aea721b40772c92db786b96fbb9c8bda"/><file name="upgrade-0.3.4-0.3.5.php" hash="5283e3567c7d35e22b4c87bbc89a0eb3"/><file name="upgrade-0.3.7-0.3.8.php" hash="5283e3567c7d35e22b4c87bbc89a0eb3"/></dir></dir></dir><file name=".DS_Store" hash="274a24b68e17a80774c8065fa0e5d839"/></dir></target><target name="magedesign"><dir name="frontend"><dir name="base"><dir name="default"><dir name="layout"><file name="optimal.xml" hash="03c64fd49785bfca34ee3249cc9bc97d"/></dir><dir name="template"><dir name="optimal"><dir name="customer"><dir name="cards"><file name="form.phtml" hash="969544827b5e5765b6bb2bea2f62392a"/><file name="grid.phtml" hash="9a160522aa31ed44eb2f5751f40718c8"/></dir><file name="cards.phtml" hash="ed3f6e56b134674e7d8ddcb6a1deac59"/></dir><dir name="form"><file name="creditcard.phtml" hash="38c3799facc887179afd3efbabf8ec93"/></dir><dir name="info"><file name="creditcard.phtml" hash="8ed46f25ea6bd04a67317743d8502e69"/></dir><file name="threatmeter.phtml" hash="3dd0ea7621038895aa1dd1e322ba7d99"/></dir></dir></dir></dir></dir><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="optimal"><dir name="form"><file name="creditcard.phtml" hash="550c80a4e0dc4224946de029f4c3ecf6"/></dir><dir name="info"><file name="creditcard.phtml" hash="b40291e8e97dbcb6b7cf2f4b8ffb93f5"/></dir></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Demac_Optimal.xml" hash="2ebfc5a3a1c5688639c0cc5eb34fded0"/></dir></target></contents>
22	<compatible/>
23	<dependencies><required><php><min>5.3.0</min><max>5.5.19</max></php></required></dependencies>
24	</package>


1	<?xml version="1.0"?>
2	<package>
3	<name>666999</name>
4	+ <version>0.4.1</version>
5	<stability>stable</stability>
6	<license>GPL</license>
7	<channel>community</channel>

16	Through the Optimal integration merchants also have the option to enable Threatmetrix fraud detection and management services. ThreatMetrix works by collecting relevant data about the customer and the order, and validating this information during the checkout. Fully integrated into the NETBANX payment gateway, enabling the ThreatMetrix option will allow merchants to automatically hold and flag suspicious orders, drastically reducing any fraud occurrences. Depending on the Score returned by ThreatMetrix an order can be held and flagged or altogether denied during the checkout.</description>
17	<notes>Implements 3D Secure payment feature.</notes>
18	<authors><author><name>Demac Media</name><user>demacmedia</user><email>support@demacmedia.com</email></author></authors>
19	+ <date>2015-04-21</date>
20	+ <time>14:59:22</time>
21	+ <contents><target name="magecommunity"><dir name="Demac"><dir name="Optimal"><dir name="Block"><dir name="Adminhtml"><dir name="Errorcode"><dir name="Edit"><file name="Form.php" hash="56618ff0cc5f4c674f750412d0606aab"/></dir><file name="Edit.php" hash="8980988ca1324fac229b40f471d745c8"/><file name="Grid.php" hash="2d8ea2f836d380167e9b25a67acefd70"/></dir><file name="Errorcode.php" hash="9f0d3c6b0b51e3bedd239d3b727eff75"/><dir name="Risk"><dir name="Edit"><file name="Form.php" hash="25d4bcb59e33a94799bc9f6cb0509cc3"/><dir name="Tab"><file name="Form.php" hash="3731d284c28ed279eb5e00b41f494810"/></dir><file name="Tabs.php" hash="61a8d2ac9942356db313b423fc3c47c2"/></dir><file name="Edit.php" hash="959e8af1e6aae6d02560c98bcabea5ab"/><file name="Grid.php" hash="e999f01578aac6084520029f86852c09"/></dir><file name="Risk.php" hash="6bf5127ba14f9dd38519c6b62203f1f8"/></dir><dir name="Customer"><dir name="Cards"><file name="Form.php" hash="ce79e221d5caf995a10e47cbb4e51f8b"/><file name="Grid.php" hash="d14eb692082fe1299977e7b3ee75dcf3"/></dir><file name="Cards.php" hash="f99686c2296a850312713f6aadc4d04a"/></dir><dir name="Form"><file name="Creditcard.php" hash="d3642d432409cf55069253680bf9ee34"/></dir><dir name="Info"><file name="Creditcard.php" hash="7ba1df22bade177f4956ce9084fa98c6"/></dir><file name="Navigation.php" hash="d3b7d8765356b8da18d300cc9b1a447e"/><file name="Threat.php" hash="69605e0b8aacc80f47b5ed91e8631248"/></dir><dir name="Helper"><file name="Data.php" hash="e3c8560496e50ed6981c0f234c718536"/></dir><dir name="Model"><dir name="Client"><file name="Abstract.php" hash="f83275be8d3b248eb145d45c2a926d84"/></dir><dir name="Config"><file name="Mode.php" hash="798d2a9bab2c0fc2749116ac1a3fc926"/><file name="Status.php" hash="767ba25406456aae4a0bd86b11023b45"/><file name="Transaction.php" hash="e83e8427e4b14c4d3cd83058c68f8965"/></dir><dir name="Creditcard"><file name="Client.php" hash="f1014811d23c1cf5efbccf61c3c6c80c"/></dir><file name="Creditcard.php" hash="4754639f6fb3d4e1f1af0fd429e46092"/><file name="Errorcode.php" hash="dae5fa1abb705961bd9f15abf3d65ec0"/><dir name="Hosted"><file name="Client.php" hash="043fdac7d3c1c4af09424488d5d1cb7f"/><file name="Exception.php" hash="dfca385bc45b1c055bbf2e8e7031230b"/></dir><dir name="Merchant"><file name="Customer.php" hash="be743a5c7aababb9752bf961570b0c27"/></dir><dir name="Method"><file name="Hosted.php" hash="4c906977feb4b3927c5e684ea9b52a37"/></dir><dir name="Mysql4"><dir name="Creditcard"><file name="Collection.php" hash="700985c287355082a3966d4b3f74838f"/></dir><file name="Creditcard.php" hash="a4e5ea4090d2f127edd19de9d2feb343"/><dir name="Errorcode"><file name="Collection.php" hash="075c7c98b606573f02aad1b096f13899"/></dir><file name="Errorcode.php" hash="0d19835b405402a5a5a7ae7c24a42c97"/><dir name="Merchant"><dir name="Customer"><file name="Collection.php" hash="aa0fbf9c0cc0a3207565443e35ae3779"/></dir><file name="Customer.php" hash="fe991d98537b7b3a07160d5b9b10802d"/></dir><dir name="Profile"><file name="Collection.php" hash="f5cd814fe62d2af8fbcc2214f94bfeb4"/></dir><file name="Profile.php" hash="6944c811248ef955a51357989ca11dd3"/><dir name="Risk"><file name="Collection.php" hash="558dc26690672dc09ae6fbfa8e780302"/></dir><file name="Risk.php" hash="5c77111382678451da4dde209a43b0fa"/></dir><file name="Observer.php" hash="ce11ba1751b4fb6c6ddf551adca02b4d"/><dir name="Profile"><file name="Client.php" hash="4358736ced5bdc7d2a7fbbf53e2ff07d"/></dir><file name="Profile.php" hash="798cef09bbc0556545edf1f00bae9bf0"/><dir name="Resource"><dir name="Mysql4"><file name="Setup.php" hash="e936830d9e4f74badc3b7663f60436dc"/></dir></dir><file name="Risk.php" hash="fab5519b0e257b8ef2f66f5f76d49f2b"/><dir name="Sales"><file name="Order.php" hash="32320888ae209b1ea3208da59312da5c"/></dir><dir name="Source"><file name="Cctype.php" hash="dd21379a29444a4c58e33e90ddeb300e"/></dir><dir name="Web"><file name="Client.php" hash="d565e254fc281e7c246cc9cfe8c2f39d"/></dir></dir><dir name="Test"><dir name="Model"><dir name="Hosted"><file name="Client.php" hash="8aa8bb4bc740daa59be041827f7cf614"/></dir><dir name="Method"><file name="Hosted.php" hash="9d39c78d0617d136c66c4c52185706a7"/></dir><file name="Observer.php" hash="345883a098197f64e2063a97d17e6274"/></dir></dir><dir name="controllers"><dir name="Adminhtml"><file name="ErrorcodesController.php" hash="7149f83536e46413ddf5b159ae4ebf91"/><file name="ThreatController.php" hash="5db39713fbd0ae13e943a891940bb22c"/></dir><dir name="Frontend"><file name="OptimalController.php" hash="b67878eb0dd4310fbb6f84723cd6ce43"/></dir><file name="HandlerController.php" hash="974dd6f3058671578a02a6ee7c0af6fb"/></dir><dir name="data"><dir name="optimal_setup"><dir name="csv"><file name="common-codes-0.3.3.csv" hash="e3c9195dbe01cfb5cf341378271b1240"/><file name="webservices-codes-0.3.3.csv" hash="8fc5562ff9bb3e5c3235fa6c7c21c0d5"/></dir><file name="data-upgrade-0.3.4-0.3.5.php" hash="4afe267d997446c46c0a1fcba771d1e1"/></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="30a4af4a510783219bbee940d185fb19"/><file name="config.xml" hash="a8b47fca963c28c28ebc2dff77857163"/><file name="system.xml" hash="4e28392139fad2a08d168d0b1381f081"/></dir><dir name="sql"><dir name="optimal_setup"><file name="install-0.1.1.php" hash="422b6afb2d2320f5d9c59cd5bff0dc3d"/><file name="install-0.2.0.php" hash="6a97d7f7b4513bce80c9bf151bd21fdc"/><file name="install-0.2.1.php" hash="2ec1146f6739ff03f90ea07217e9e968"/><file name="install-0.2.2.php" hash="3fdd9863b235b275593893af34abcefb"/><file name="install-0.2.3.php" hash="e07b474749b6ee431e90343a9c79f46b"/><file name="install-0.2.4.php" hash="e07b474749b6ee431e90343a9c79f46b"/><file name="install-0.2.5.php" hash="84228a0ce89a63179095a9790167715d"/><file name="install-0.2.6.php" hash="2986f567d1e7b4dd3e5ebdd8abd612c4"/><file name="install-0.2.7.php" hash="2986f567d1e7b4dd3e5ebdd8abd612c4"/><file name="install-0.2.9.php" hash="2986f567d1e7b4dd3e5ebdd8abd612c4"/><file name="install-0.3.5.php" hash="4abfc294ba5df2e55772e4474af173da"/><file name="mysql4-install-0.1.1.php" hash="422b6afb2d2320f5d9c59cd5bff0dc3d"/><file name="mysql4-install-0.2.0.php" hash="6a97d7f7b4513bce80c9bf151bd21fdc"/><file name="mysql4-install-0.2.1.php" hash="2ec1146f6739ff03f90ea07217e9e968"/><file name="mysql4-install-0.2.2.php" hash="3fdd9863b235b275593893af34abcefb"/><file name="mysql4-install-0.2.3.php" hash="e07b474749b6ee431e90343a9c79f46b"/><file name="mysql4-install-0.2.4.php" hash="e07b474749b6ee431e90343a9c79f46b"/><file name="mysql4-install-0.2.5.php" hash="84228a0ce89a63179095a9790167715d"/><file name="mysql4-install-0.2.6.php" hash="2986f567d1e7b4dd3e5ebdd8abd612c4"/><file name="mysql4-install-0.2.7.php" hash="2986f567d1e7b4dd3e5ebdd8abd612c4"/><file name="mysql4-install-0.2.9.php" hash="30039fc096f8db2a82a3268b467ef856"/><file name="mysql4-install-0.3.5.php" hash="5e98dddfa3303ede96338c1e73f0febe"/><file name="mysql4-upgrade-0.1.1-0.2.7.php" hash="2986f567d1e7b4dd3e5ebdd8abd612c4"/><file name="mysql4-upgrade-0.4.1-0.4.2.php" hash="fa4ffded7147e16c7b07f2aedd1d660b"/><file name="upgrade-0.1.1-0.2.7.php" hash="2986f567d1e7b4dd3e5ebdd8abd612c4"/><file name="upgrade-0.2.9-0.3.0.php" hash="989e6c4043fccfa6cdcba0a09938dd07"/><file name="upgrade-0.3.1-0.3.2.php" hash="aea721b40772c92db786b96fbb9c8bda"/><file name="upgrade-0.3.4-0.3.5.php" hash="5283e3567c7d35e22b4c87bbc89a0eb3"/><file name="upgrade-0.3.7-0.3.8.php" hash="5283e3567c7d35e22b4c87bbc89a0eb3"/><file name="upgrade-0.4.1-0.4.2.php" hash="fa4ffded7147e16c7b07f2aedd1d660b"/></dir></dir></dir><file name=".DS_Store" hash="274a24b68e17a80774c8065fa0e5d839"/></dir></target><target name="magedesign"><dir name="frontend"><dir name="base"><dir name="default"><dir name="layout"><file name="optimal.xml" hash="03c64fd49785bfca34ee3249cc9bc97d"/></dir><dir name="template"><dir name="optimal"><dir name="customer"><dir name="cards"><file name="form.phtml" hash="969544827b5e5765b6bb2bea2f62392a"/><file name="grid.phtml" hash="9a160522aa31ed44eb2f5751f40718c8"/></dir><file name="cards.phtml" hash="ed3f6e56b134674e7d8ddcb6a1deac59"/></dir><dir name="form"><file name="creditcard.phtml" hash="38c3799facc887179afd3efbabf8ec93"/></dir><dir name="info"><file name="creditcard.phtml" hash="8ed46f25ea6bd04a67317743d8502e69"/></dir><file name="threatmeter.phtml" hash="3dd0ea7621038895aa1dd1e322ba7d99"/></dir></dir></dir></dir></dir><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="optimal"><dir name="form"><file name="creditcard.phtml" hash="550c80a4e0dc4224946de029f4c3ecf6"/></dir><dir name="info"><file name="creditcard.phtml" hash="b40291e8e97dbcb6b7cf2f4b8ffb93f5"/></dir></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Demac_Optimal.xml" hash="2ebfc5a3a1c5688639c0cc5eb34fded0"/></dir></target></contents>
22	<compatible/>
23	<dependencies><required><php><min>5.3.0</min><max>5.5.19</max></php></required></dependencies>
24	</package>