How to integrate affiliate program into OSC

[dowser]

I'm using Idevaffiliate and Moneris and Paypal standard as payment options (not counting check & money orders) and have problem with integrating the affiliate script to work correctly. From the Idevaffiliate I get following code to insert into checkout_success.php:

 

$idevtotal = tep_db_query("SELECT value FROM " . TABLE_ORDERS_TOTAL . " WHERE orders_id = '" . (int)$orders['orders_id'] . "' AND class = 'ot_subtotal'");

$idevtotal = tep_db_fetch_array($idevtotal);

$idev_osc_1 = (number_format($idevtotal['value'],2));

$idev_osc_2 = $orders['orders_id'];

include("/home/xxxx/public_html/xxxx/sale.php");

 

The parh is correct, yet there is an error when the order comes through and the sale is not credited.

 

Can you find anything that would cause it?

 

Paypal has a different setup, so I don't want to go there now.