Error accessing Gateway -- Innovative Gateway module

[gokeypa]

Hello,

I am trying to install the innovative gateway as well. I see that there has been a lot of issues with them, has anyone got it working and if so, please help me understand what to do. I am NOT a programmer.

thanks.

[dorie]

Hi,
Please backup your Database and all catalog files like includes and your admin folders before you install this payment module. I install Innovative Gateway on payment module by following steps:
1. Register SSL for your dedicated IP
2. UNZip the download file, http://www.zen-cart.com/archived_con...ions1_1_.1.zip
3. Update below codes for the file, innovative.php in /includes/modules/payment/ folder at your local PC, then FTP this file and other files to your corresponding folders on the server.

Change below Code:

$message = sprintf(MODULE_PAYMENT_INNOVATIVE_TEXT_ERROR_MESSAGE, strip_tags($result[1]));
zen_redirect(zen_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode($message), 'SSL', true, false));

To Code:

global $messageStack;
$messageStack->add_session('checkout_payment', MODULE_PAYMENT_INNOVATIVE_TEXT_ERROR_MESSAGE . $result[1], 'error');
zen_redirect(zen_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL', true, false));

4. After FTP files, click Install for Credit Card on Admin-->Modules-->Payment. when done installation, click rightside "edit" to update Payment Server from "http....." to be https://transactions.innovativegatew...ateway.aai.Aai

5. run test, uncomment line 67 (remove //) if ($username == 'gatewaytest')....for file innovative.php under /includes/modules/payment/ and type the gatewaytest userid on Admin-->Modules-->Payment, CC setup for testing setup. Please make sure to comment out line 67 if you run it on live.

My shopcart, www.everytihgmyhouse.com is running this module without no issues. Hopefully above steps could help you!!

[dorie]

5. run test, uncomment line 67 (remove //) if ($username == 'gatewaytest')....for file innovative.php under /includes/modules/payment/ and type the gatewaytest userid on Admin-->Modules-->Payment, CC setup for testing setup. Please make sure to comment out line 67 if you run it on live.

Forget to mention, in addition to step5 for post #22, please make sure to change the real userid on Credit Card setup at Admin-->Modules-->Payment as well as comment out line 67 of file innovative.php when test for a live one.

You may also search "innovative gateway" on "community forum" to get more info! Wish you install them successfully!

my shopcart, correct site is everythingmyhouse.com

[gokeypa]

Hello,

I am running the Innovative Gateway on my Zencart ver.1.3.9. It is all working with one problem, I am trying to add the cvv2 code so that my customers can input it in the gateway, but, innovative customer support is saying that the cvv2 code is NOT coming over to them.
First is there a way for me to process a transaction and view the results with or without it passing to innovative, and second does anyone know how I should have the code written so that innovative gets the cvv2 code.
Here is my code so far.

For me this is from line 30 to 69
function GetGatewayResult($fulltotal, $ordernumber,
$ccname, $baddress, $bcity,
$bstate, $bzip, $bcountry,
$bphone, $email, $trantype,
$username, $password, $ccnumber, $month, $year, $ccidentifier1)
{


$data = "target_app=WebCharge_v5.06&";
$data .= "fulltotal=$fulltotal&";
$data .= "ordernumber=$ordernumber&";
$data .= "ccname=$ccname&";
$data .= "baddress=$baddress&";
$data .= "bcity=$bcity&";
$data .= "bstate=$bstate&";
$data .= "bzip=$bzip&";
$data .= "bcountry=$bcountry&";
$data .= "bphone=$bphone&";
$data .= "email=$email&";
$data .= "trantype=$trantype&";
$data .= "response_mode=simple&";
$data .= "username=$username&";
$data .= "pw=$password&";
$data .= "ccnumber=$ccnumber&";
$data .= "month=$month&";
$data .= "year=$year&";
$data .= "ccidentifier1=$ccidentifier1&";
$data .= "connection_method=POST&";
$data .= "delimited_fmt_field_delimiter==&";
$data .= "delimited_fmt_include_fields=true&";
$data .= "delimited_fmt_value_delimiter=|&";
$data .= "delimitedresponse=Y&";
$data .= "include_extra_field_in_response=N&";
$data .= "last_used_response_num=5&";
$data .= "response_fmt=delimited&";
$data .= "upg_auth=zxcvlkjh&";
$data .= "merch_ip=$REMOTE_ADDR&";
$data .= "upg_version=version&";
if ($username == 'gatewaytest') $data .= "test_override_errors=y&"; // We are testing
$data .= "yes=Y";


Then farther down line 132 to 152
$selection = array('id' => $this->code,
'module' => $this->title,
'fields' => array(array('title' => MODULE_PAYMENT_INNOVATIVE_TEXT_CREDIT_CARD_OWNER,
'field' => zen_draw_input_field('innovative_cc_owner', $order->billing['firstname'] . ' ' . $order->billing['lastname'])),
array('title' => MODULE_PAYMENT_INNOVATIVE_TEXT_CREDIT_CARD_NUMBER,
'field' => zen_draw_input_field('innovative_cc_number')),
array('title' => 'CCV code',
'field' => zen_draw_input_field('innovative_ccidentifier1')),
array('title' => MODULE_PAYMENT_INNOVATIVE_TEXT_CREDIT_CARD_EXPIRES,
'field' => zen_draw_pull_down_menu('innovative_cc_expires_month', $expires_month) . ' ' . zen_draw_pull_down_menu('innovative_cc_expires_year', $expires_year))));

return $selection;
}

function pre_confirmation_check() {
global $_POST;

include(DIR_WS_CLASSES . 'cc_validation.php');

$cc_validation = new cc_validation();
$result = $cc_validation->validate($_POST['innovative_cc_number'], $_POST['innovative_cc_expires_month'], $_POST['innovative_cc_expires_year']);

Please help, BTW I am NOT a coder, so please be gentle.

[gokeypa]

I for got to tell you that for innovative the cvv2 code send over should be ccidentifier1. At least that is what I got from the pdf file.

[manythanks]

I just got this 100% installed thanks to all the notes here.

I even got the CCV # to work thanks to the code on this page as I called Innovative and verified that it was passed over.

After following the code replacement items in prior posts I also provided my i.p. address to innovative as described in this thread.

You also have to update that one field to the https: vs. http as described above.

I still had a problem was when I didn't have the correct cURL path which I got from my isp hostgator and once that was right, it all worked 100%!

THANKS to the Zen Cart forum!

[gokeypa]

I am glad you got it to work, I am still not able to get the cvv code to send over to innovative.

Can you show me the sample code where you inserted the cvv code to transmit to innovative?

[gokeypa]

I need some help.
I have a Innovative gateway (php) interface that currently works and connects to Innovative Gateway. I see in their code where they have a parameter to send the CCV to the API but I don’t see where they pass that variable to the function that calls the API. The missing link is the script does not pass the variable to the function that does the work. I need someone to help me with this, so that I can send my CVV number to the gateway.

Below is the a copy of the php file.

<?php
/*
$Id: innovative.php,v 2.3 2004/03/18 10:20:00 willross Exp $


v2.2MS2(November 2003 or later) - 2.3
to IMS/Innovative Merchant & Gateway Solutions:
*/

class innovative {
var $code, $title, $description, $enabled;

// class constructor
function innovative() {
$this->code = 'innovative';
$this->title = MODULE_PAYMENT_INNOVATIVE_TEXT_TITLE;
$this->description = MODULE_PAYMENT_INNOVATIVE_TEXT_DESCRIPTION;
$this->sort_order = MODULE_PAYMENT_INNOVATIVE_SORT_ORDER;
$this->enabled = ((MODULE_PAYMENT_INNOVATIVE_STATUS == 'True') ? true : false);
}


function GetGatewayResult($fulltotal, $ordernumber,
$ccname, $baddress, $bcity,
$bstate, $bzip, $bcountry,
$bphone, $email, $trantype,
$username, $password, $ccnumber, $month, $year, $ccidentifier1)
{


$data = "target_app=WebCharge_v5.06&";
$data .= "fulltotal=$fulltotal&";
$data .= "ordernumber=$ordernumber&";
$data .= "ccname=$ccname&";
$data .= "baddress=$baddress&";
$data .= "bcity=$bcity&";
$data .= "bstate=$bstate&";
$data .= "bzip=$bzip&";
$data .= "bcountry=$bcountry&";
$data .= "bphone=$bphone&";
$data .= "email=$email&";
$data .= "trantype=$trantype&";
$data .= "response_mode=simple&";
$data .= "username=$username&";
$data .= "pw=$password&";
$data .= "ccnumber=$ccnumber&";
$data .= "month=$month&";
$data .= "year=$year&";
$data .= "ccidentifier1=$ccidentifier1&";
$data .= "connection_method=POST&";
$data .= "delimited_fmt_field_delimiter==&";
$data .= "delimited_fmt_include_fields=true&";
$data .= "delimited_fmt_value_delimiter=|&";
$data .= "delimitedresponse=Y&";
$data .= "include_extra_field_in_response=N&";
$data .= "last_used_response_num=5&";
$data .= "response_fmt=delimited&";
$data .= "upg_auth=zxcvlkjh&";
$data .= "merch_ip=$REMOTE_ADDR&";
$data .= "upg_version=version&";
if ($username == 'gatewaytest') $data .= "test_override_errors=y&"; // We are testing
$data .= "yes=Y";


// replace all whitespace with a plus sign for the query string
$data = ereg_replace(" ", "+", $data);

// post the data
$cmd = MODULE_PAYMENT_INNOVATIVE_CURL . " -d \"$data\" " . MODULE_PAYMENT_INNOVATIVE_URL;
// echo "curl command<br>" . $cmd . "<br>";
exec($cmd, $return_string);

// Set up default error condition
$card_status[0] = "error";
$card_status[1] = "Error accessing gateway";

// split up the results into name=value pairs
$tmp = explode("|", $return_string[0]);
for($i=0;$i<count($tmp);$i++) {
$tmp2 = explode("=", $tmp[$i]);
// echo $tmp2[0] . " = " . $tmp2[1] . "<br>";
if ($tmp2[0] == "approval") {
$card_status[0] = "approved";
$card_status[1] = $tmp2[1];
} elseif ($tmp2[0] == "error") {
$card_status[0] = "error";
$card_status[1] = $tmp2[1];
}
}
return $card_status;
}



// class methods
function javascript_validation() {
$js = ' if (payment_value == "' . $this->code . '") {' . "\n" .
' var cc_owner = document.checkout_payment.innovative_cc_owner.value;' . "\n" .
' var cc_number = document.checkout_payment.innovative_cc_number.value;' . "\n" .
' if (cc_owner == "" || cc_owner.length < ' . CC_OWNER_MIN_LENGTH . ') {' . "\n" .
' error_message = error_message + "' . MODULE_PAYMENT_INNOVATIVE_TEXT_JS_CC_OWNER . '";' . "\n" .
' error = 1;' . "\n" .
' }' . "\n" .
' if (cc_number == "" || cc_number.length < ' . CC_NUMBER_MIN_LENGTH . ') {' . "\n" .
' error_message = error_message + "' . MODULE_PAYMENT_INNOVATIVE_TEXT_JS_CC_NUMBER . '";' . "\n" .
' error = 1;' . "\n" .
' }' . "\n" .
' }' . "\n";

return $js;
}

function selection() {
global $order;

for ($i=1; $i<13; $i++) {
$expires_month[] = array('id' => sprintf('%02d', $i), 'text' => strftime('%B',mktime(0,0,0,$i,1,2000)));
}

$today = getdate();
for ($i=$today['year']; $i < $today['year']+10; $i++) {
$expires_year[] = array('id' => strftime('%y',mktime(0,0,0,1,1,$i)), 'text' => strftime('%Y',mktime(0,0,0,1,1,$i)));
}

$selection = array('id' => $this->code,
'module' => $this->title,
'fields' => array(array('title' => MODULE_PAYMENT_INNOVATIVE_TEXT_CREDIT_CARD_OWNER,
'field' => zen_draw_input_field('innovative_cc_owner', $order->billing['firstname'] . ' ' . $order->billing['lastname'])),
array('title' => MODULE_PAYMENT_INNOVATIVE_TEXT_CREDIT_CARD_NUMBER,
'field' => zen_draw_input_field('innovative_cc_number')),
array('title' => 'CCV code',
'field' => zen_draw_input_field('innovative_ccidentifier1')),
array('title' => MODULE_PAYMENT_INNOVATIVE_TEXT_CREDIT_CARD_EXPIRES,
'field' => zen_draw_pull_down_menu('innovative_cc_expires_month', $expires_month) . '&nbsp;' . zen_draw_pull_down_menu('innovative_cc_expires_year', $expires_year))));

return $selection;
}

function pre_confirmation_check() {
global $_POST;

include(DIR_WS_CLASSES . 'cc_validation.php');

$cc_validation = new cc_validation();
$result = $cc_validation->validate($_POST['innovative_cc_number'], $_POST['innovative_cc_expires_month'], $_POST['innovative_cc_expires_year']);

$error = '';
switch ($result) {
case -1:
$error = sprintf(TEXT_CCVAL_ERROR_UNKNOWN_CARD, substr($cc_validation->cc_number, 0, 4));
break;
case -2:
case -3:
case -4:
$error = TEXT_CCVAL_ERROR_INVALID_DATE;
break;
case false:
$error = TEXT_CCVAL_ERROR_INVALID_NUMBER;
break;
}

if ( ($result == false) || ($result < 1) ) {
$payment_error_return = 'payment_error=' . $this->code . '&error=' . urlencode($error) . '&innovative_cc_owner=' . urlencode($_POST['innovative_cc_owner']) . '&innovative_cc_expires_month=' . $_POST['innovative_cc_expires_month'] . '&innovative_cc_expires_year=' . $_POST['innovative_cc_expires_year'];

// begin modification - handle error message
// zen_redirect(zen_href_link(FILENAME_CHECKOUT_PAYMENT, $payment_error_return, 'SSL', true, false));

global $messageStack;
$messageStack->add_session('checkout_payment', urldecode($error), 'error');
zen_redirect(zen_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL', true, false));
// end modification
}

$this->cc_card_type = $cc_validation->cc_type;
$this->cc_card_number = $cc_validation->cc_number;
$this->cc_expiry_month = $cc_validation->cc_expiry_month;
$this->cc_expiry_year = $cc_validation->cc_expiry_year;
}

function confirmation() {
global $_POST;

// echo "complete " . $this->cc_card_number . "X" . $this->cc_expiry_month . "/" . $this->cc_expiry_year;
$confirmation = array('title' => $this->title . ': ' . $this->cc_card_type,
'fields' => array(array('title' => MODULE_PAYMENT_INNOVATIVE_TEXT_CREDIT_CARD_OWNER,
'field' => $_POST['innovative_cc_owner']),
array('title' => MODULE_PAYMENT_INNOVATIVE_TEXT_CREDIT_CARD_NUMBER,
'field' => substr($this->cc_card_number, 0, 4) . str_repeat('X', (strlen($this->cc_card_number) - 8)) . substr($this->cc_card_number, -4)),
array('title' => MODULE_PAYMENT_INNOVATIVE_TEXT_CREDIT_CARD_EXPIRES,
'field' => strftime('%B, %Y', mktime(0,0,0,$_POST['innovative_cc_expires_month'], 1, '20' . $_POST['innovative_cc_expires_year'])))));

return $confirmation;
}

function process_button() {
global $_POST;

// $process_button_string = zen_draw_hidden_field('cc_owner', $_POST['innovative_cc_owner']) .
// zen_draw_hidden_field('cc_number', $this->cc_card_number) .
// zen_draw_hidden_field('cc_month', $this->cc_expiry_month) .
// zen_draw_hidden_field('cc_year', $this->cc_expiry_year);

$process_button_string = zen_draw_hidden_field('cc_owner', $_POST['innovative_cc_owner']) .
zen_draw_hidden_field('cc_number', $this->cc_card_number) .
zen_draw_hidden_field('cc_month', $this->cc_expiry_month) .
zen_draw_hidden_field('cc_year', $this->cc_expiry_year) .
zen_draw_hidden_field('cc_ccv', $_POST['innovative_ccidentifier1']);

$process_button_string .= zen_draw_hidden_field(zen_session_name(), zen_session_id());

return $process_button_string;
}

function before_process() {
global $_POST, $order;

// echo "complete " . $this->cc_card_number . "X" . $this->cc_expiry_month . "/" . $this->cc_expiry_year;
// $result = $this->GetGatewayResult(number_format($order->info['total'], 2, '.', ''), 0, $_POST['cc_owner'],
// $order->billing['street_address'], $order->billing['city'], $order->billing['state'],
// $order->billing['postcode'], $order->billing['country'],
// $order->customer['telephone'], $order->customer['email_address'],
// 'sale', MODULE_PAYMENT_INNOVATIVE_USERID, MODULE_PAYMENT_INNOVATIVE_PASSWORD,
// $_POST['cc_number'], $_POST['cc_month'], $_POST['cc_year']);

$result = $this->GetGatewayResult(number_format($order->info['total'], 2, '.', ''), 0, $_POST['cc_owner'],
$order->billing['street_address'], $order->billing['city'], $order->billing['state'],
$order->billing['postcode'], $order->billing['country'],
$order->customer['telephone'], $order->customer['email_address'],
'sale', MODULE_PAYMENT_INNOVATIVE_USERID, MODULE_PAYMENT_INNOVATIVE_PASSWORD,
$_POST['cc_number'], $_POST['cc_month'], $_POST['cc_year'], $_POST['cc_ccv']);

// echo "Result = " . $result[0] . " " . strip_tags($result[1]);
if ($result[0] <> "approved") {
global $messageStack;
$messageStack->add_session('checkout_payment', MODULE_PAYMENT_INNOVATIVE_TEXT_ERROR_MESSAGE . $result[1], 'error');
zen_redirect(zen_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL', true, false)); }
}

function after_process() {
return false;
}

function get_error() {
global $HTTP_GET_VARS;

$error = array('title' => MODULE_PAYMENT_INNOVATIVE_TEXT_ERROR,
'error' => stripslashes(urldecode($HTTP_GET_VARS['error'])));

return $error;
}

function check() {
global $db;
if (!isset($this->_check)) {
$check_query = $db->Execute("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_INNOVATIVE_STATUS'");
$this->_check = $check_query->RecordCount();
}
return $this->_check;
}

function install() {
global $db;
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Innovative Module', 'MODULE_PAYMENT_INNOVATIVE_STATUS', 'True', 'Do you want to accept Innovative payments?', '6', '0', 'zen_cfg_select_option(array(\'True\', \'False\'), ', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Userid on Gateway', 'MODULE_PAYMENT_INNOVATIVE_USERID', 'gatewaytest', 'Contact payment processor to get a userid', '6', '0', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Password on Gateway', 'MODULE_PAYMENT_INNOVATIVE_PASSWORD', 'GateTest2002', 'Contact payment processor to get a password', '6', '0', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Payment Server', 'MODULE_PAYMENT_INNOVATIVE_URL', 'http://transactions.innovativegateway.com/servlet/com.gateway.aai.Aai', 'URL of the payment processor', '6', '0', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Path to cURL', 'MODULE_PAYMENT_INNOVATIVE_CURL', '/usr/local/bin/curl', 'Path to the curl command on the serves', '6', '0', now())");
$db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_PAYMENT_INNOVATIVE_SORT_ORDER', '0', 'Sort Order of this method', '6', '0', now())");
}

function remove() {
global $db;
$db->Execute("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
}

function keys() {
return array('MODULE_PAYMENT_INNOVATIVE_STATUS', 'MODULE_PAYMENT_INNOVATIVE_USERID', 'MODULE_PAYMENT_INNOVATIVE_PASSWORD', 'MODULE_PAYMENT_INNOVATIVE_URL', 'MODULE_PAYMENT_INNOVATIVE_CURL', 'MODULE_PAYMENT_INNOVATIVE_SORT_ORDER');
}
}
?>