XtCommerce Integration for Lead and Sale

XtCommerce

Integration with XtCommerce is made by changing checkout_success.php file.

1 Edit template

Find and open checkout_success.php file.

2 Integration

Put the following code right before line "if (DOWNLOAD_ENABLED == 'true')".

//--------------------------------------------------------------------------
 // Affiliate Network Pro code
 // The code below will get the order_id and total value of recent order
 // from the database and displays invisible image that registers the sale
 // for affiliate (if some affiliate referred this visitor)
 //--------------------------------------------------------------------------
   $sql = "select orders_id from ".TABLE_ORDERS." where customers_id='".$_SESSION['customer_id']."' order by orders_id desc limit 1";
   $pap_orders_query = xtc_db_query($sql);
   $pap_orders = xtc_db_fetch_array($pap_orders_query);
   $order_id = $pap_orders['orders_id'];
 
   // get total amount of order
   $sql = "select value from ".TABLE_ORDERS_TOTAL.
          " where orders_id='".(int)$order_id."'";
   $pap_orders_total_query = xtc_db_query($sql);
   $pap_orders_total = xtc_db_fetch_array($pap_orders_total_query);
   $total_value = $pap_orders_total['value'];
 
   // draw sale tracking code to register sale
   if($total_value != "" && $order_id != "")
   { 
      $smarty->assign('ANP_sale_tracking',"<script language=\"JavaScript\" type=\"text/javascript\"   
src=\"http://www.blizsoft.com/affiliate/trackingcode_sale.php?mid=xxx&sec_id=xxx&sale=&orderId=\">
</script>");
   }
 //--------------------------------------------------------------------------
 // END of Affiliate Network Pro code
 //------------------------------------------------------------------

3 Edit template

Find and open /templates/xtc4/module/checkout_success.html file.

4 Integration

Put the following code right before line " {if $downloads_content neq '}".