Begging for help from stores with NOCHEX APC installed!!!!

[Guest]

Could someone who has the NOCHEX APC module installed check that the code below (checkout_success.php) matches theirs please? Install said to "paste this block of code BEFORE the $breadcrumb", the breadcrumb is shown at the bottom is that correct?

 

 

$nochex_query = tep_db_query("select o.orders_status,p.* from " . TABLE_ORDERS . " o LEFT JOIN " . TABLE_NOCHEX_APC_TXN . " p on p.nc_order_id = o.orders_id AND o.customers_id = '" . (int)$customer_id . "' order by o.date_purchased desc limit 1");

$nochex_apc = tep_db_fetch_array($nochex_query);

 

if ($nochex_apc['nochex_reponse']=='AUTHORISED') {

$NAVBAR_TITLE_2 = NOCHEX_NAVBAR_TITLE_2_OK;

$HEADING_TITLE = NOCHEX_HEADING_TITLE_OK;

$TEXT_SUCCESS = NOCHEX_TEXT_SUCCESS_OK;

$cart->reset(TRUE);

} else if ($nochex_apc['nochex_response']=='DECLINED') {

$NAVBAR_TITLE_2 = NOCHEX_NAVBAR_TITLE_2_FAILED;

$HEADING_TITLE = NOCHEX_HEADING_TITLE_FAILED;

$TEXT_SUCCESS = NOCHEX_TEXT_SUCCESS_FAILED;

} else if ($nochex_apc['orders_status']==50000) {

$NAVBAR_TITLE_2 = NOCHEX_NAVBAR_TITLE_2_PENDING;

$HEADING_TITLE = NOCHEX_HEADING_TITLE_PENDING;

$TEXT_SUCCESS = NOCHEX_TEXT_SUCCESS_PENDING;

} else {

$NAVBAR_TITLE_2 = NAVBAR_TITLE_2;

$HEADING_TITLE = HEADING_TITLE;

$TEXT_SUCCESS = TEXT_SUCCESS;

};

 

$breadcrumb->add(NAVBAR_TITLE_1);

$breadcrumb->add($NAVBAR_TITLE_2);

 

 

Did I fluff it up?

 

Thanks

 

Colin G.

[Guest]

Please can someome compare this code to theirs?

 

Thanks

 

Colin G.

[gbacon]

Please can someome compare this code to theirs?

 

Thanks

 

Colin G.

 

 

Colin,

 

Your code is correct and placed in the same position as my own code. What is the problem you're having?

 

Gary

[Guest]

Gary,

Thanks for the response, after I installed the contrib, run a test payment, and at the point of confirming payment, I got the following-

 

1146 - Table 'mysite_osc1.TABLE_NOCHEX_APC_TXN' doesn't exist

 

select o.orders_status,p.* from orders o LEFT JOIN TABLE_NOCHEX_APC_TXN p on p.nc_order_id = o.orders_id AND o.customers_id = '6' order by o.date_purchased desc limit 1

 

[TEP STOP]

 

The thing that is confusing me is that there is no table called TABLE_NOCHEX_APC_TXN mentioned in the install so what does this mean?

 

Thanks

 

Colin G.