Installation / Quick Start Guide

Product Release Information

Product:	Enhanced Coupon for Affiliate for CRELoaded 6.2
Release Number:	1.0.1
Release Date:	Nov 18, 2008
Customer Support:	For more information or support, please visit our website or contact us from the online form

Introduction

This document describes how to install and get started with Enhanced Coupon for Affiliate Module.

Features of the Enhanced Coupon for Affiliate module:

Allow user to use coupon before login.
Attach a affiliat person to each coupon, affiliat person can get commision after the coupon was redeemed
Have coupon usage report in admin, gives the detail info for the usage of each coupon

Minimal System Requirements

System requirements are described in the release notes.

Installation

What other software must be installed first?

Before you can install this product, you must obtain access to a web server with the following:

PHP 4.x with :

GD Library
mCrypt
Register Globals set to On via httpd.conf, php.ini or .htaccess

The Apache Webserver
MySQL database
The Linux / Unix Operating System
CRE Loaded 6.2 or later

How do I install CRE Loaded : Enhanced Coupon for Affiliate Module?

Please follow these steps:

Upload the files to your catalog directory on the webserver.

Open includes\modules\order_total\ot_coupon.php file, change:
function get_error() { global $HTTP_GET_VARS; $error = array('title' => MODULE_ORDER_TOTAL_COUPON_TEXT_ERROR, 'error' => stripslashes(urldecode($HTTP_GET_VARS['error']))); return $error; }
to:
function get_error() { global $HTTP_GET_VARS; $error = array('title' => MODULE_ORDER_TOTAL_COUPON_TEXT_ERROR, 'error' => isset($HTTP_GET_VARS['error']) ? stripslashes(urldecode($HTTP_GET_VARS['error'])) : stripslashes(urldecode($HTTP_GET_VARS['error_code']))); return $error; }

Open includes\modules\order_total\ot_coupon.php file, after:
if ($HTTP_POST_VARS['submit_redeem_coupon_x']) tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'payment_error='.$this->code.'&error=' . urlencode(ERROR_NO_REDEEM_CODE), 'SSL')); }
add:
function collect_posts_incart() { global $HTTP_POST_VARS, $customer_id, $currencies, $cc_id; if ($HTTP_POST_VARS['gv_redeem_code']) { // get some info from the coupon table $coupon_query=tep_db_query("select coupon_id, coupon_amount, coupon_type, coupon_minimum_order,uses_per_coupon, uses_per_user, restrict_to_products,restrict_to_categories from " . TABLE_COUPONS . " where coupon_code='".tep_db_input($HTTP_POST_VARS['gv_redeem_code'])."' and coupon_active='Y'"); $coupon_result=tep_db_fetch_array($coupon_query); if ($coupon_result['coupon_type'] != 'G') { if (tep_db_num_rows($coupon_query) == 0) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'payment_error='.$this->code.'&error_code=' . urlencode(ERROR_NO_INVALID_REDEEM_COUPON), 'SSL')); } $date_query=tep_db_query("select coupon_start_date from " . TABLE_COUPONS . " where coupon_start_date <= now() and coupon_code='".tep_db_input($HTTP_POST_VARS['gv_redeem_code'])."'"); if (tep_db_num_rows($date_query)==0) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'payment_error='.$this->code.'&error_code=' . urlencode(ERROR_INVALID_STARTDATE_COUPON), 'SSL')); } $date_query=tep_db_query("select coupon_expire_date from " . TABLE_COUPONS . " where coupon_expire_date >= now() and coupon_code='".tep_db_input($HTTP_POST_VARS['gv_redeem_code'])."'"); if (tep_db_num_rows($date_query)==0) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'payment_error='.$this->code.'&error_code=' . urlencode(ERROR_INVALID_FINISDATE_COUPON), 'SSL')); } $coupon_count = tep_db_query("select coupon_id from " . TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . $coupon_result['coupon_id']."'"); //$coupon_count_customer = tep_db_query("select coupon_id from " . TABLE_COUPON_REDEEM_TRACK . " where coupon_id = '" . $coupon_result['coupon_id']."' and customer_id = '" . $customer_id . "'"); if (tep_db_num_rows($coupon_count)>=$coupon_result['uses_per_coupon'] && $coupon_result['uses_per_coupon'] > 0) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'payment_error='.$this->code.'&error_code=' . urlencode(ERROR_INVALID_USES_COUPON . $coupon_result['uses_per_coupon'] . TIMES ), 'SSL')); } /*if (tep_db_num_rows($coupon_count_customer)>=$coupon_result['uses_per_user'] && $coupon_result['uses_per_user'] > 0) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'payment_error='.$this->code.'&error_code=' . urlencode(ERROR_INVALID_USES_USER_COUPON . $coupon_result['uses_per_user'] . TIMES ), 'SSL')); }*/ /* if ($coupon_result['coupon_type'] == 'S') { $coupon_amount = $order->info['shipping_cost']; } else { $coupon_amount = $currencies->format($coupon_result['coupon_amount']) . ' '; } if ($coupon_result['coupon_type'] == 'P') $coupon_amount = $coupon_result['coupon_amount'] . '% '; if ($coupon_result['coupon_minimum_order'] > 0) $coupon_amount .= 'XXon orders greater than ' . $coupon_result['coupon_minimum_order']; if (!tep_session_is_registered('cc_id')) tep_session_register('cc_id'); //Fred - this was commented out before $cc_id = $coupon_result['coupon_id']; //Fred ADDED, set the global and session variable tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'payment_error='.$this->code.'&error_code=' . urlencode(ERROR_REDEEMED_AMOUNT), 'SSL')); // Added in v5.13a by Rigadin */ global $order,$ot_coupon,$currency,$cc_id; if (!tep_session_is_registered('cc_id')) tep_session_register('cc_id'); $cc_id = $coupon_result['coupon_id']; $coupon_amount= tep_round($ot_coupon->pre_confirmation_check($order->info['subtotal']), $currencies->currencies[$currency]['decimal_places']); // $cc_id /* you will need to uncomment this if your tax order total module is AFTER shipping eg you have all of your tax, including tax from shipping module, in your tax total. if ($coupon_result['coupon_type']=='S') { //if not zero rated add vat to shipping $coupon_amount = tep_add_tax($coupon_amount, '17.5'); } */ $coupon_amount_out = $currencies->format($coupon_amount) . ' '; if ($coupon_result['coupon_minimum_order']>0) $coupon_amount_out .= 'on orders greater than ' . $currencies->format($coupon_result['coupon_minimum_order']); if ( strlen($cc_id) > 0 && $coupon_amount == 0 ) { $err_msg = ERROR_REDEEMED_AMOUNT_ZERO; } else { $err_msg = ERROR_REDEEMED_AMOUNT.$coupon_amount_out; } tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'payment_error='.$this->code.'&error_code=' . urlencode($err_msg), 'SSL')); //**si** 09-11-05 end // $_SESSION['cc_id'] = $coupon_result['coupon_id']; //Fred commented out, do not use $_SESSION[] due to backward comp. Reference the global var instead. } // ENDIF valid coupon code } // ENDIF code entered // v5.13a If no code entered and coupon redeem button pressed, give an alarm if ($HTTP_POST_VARS['submit_redeem_coupon_x']) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'payment_error='.$this->code.'&error_code=' . urlencode(ERROR_NO_REDEEM_CODE), 'SSL')); } }

Open includes\modules\order_total\ot_coupon.php file, change:
function apply_credit() { global $insert_id, $customer_id, $REMOTE_ADDR, $cc_id; //$cc_id = $_SESSION['cc_id']; //Fred commented out, do not use $_SESSION[] due to backward comp. Reference the global var instead. if ($this->deduction !=0) { tep_db_query("insert into " . TABLE_COUPON_REDEEM_TRACK . " (coupon_id, redeem_date, redeem_ip, customer_id, order_id) values ('" . $cc_id . "', now(), '" . $REMOTE_ADDR . "', '" . $customer_id . "', '" . $insert_id . "')"); } tep_session_unregister('cc_id'); }
to:
function apply_credit() { global $insert_id, $customer_id, $REMOTE_ADDR, $cc_id, $order, $languages_id; if ($this->deduction !=0) { tep_db_query("insert into " . TABLE_COUPON_REDEEM_TRACK . " (coupon_id, redeem_date, redeem_ip, customer_id, order_id) values ('" . $cc_id . "', now(), '" . $REMOTE_ADDR . "', '" . $customer_id . "', '" . $insert_id . "')"); $coupon_get = tep_db_query("SELECT c.*, cd.coupon_name FROM " . TABLE_COUPONS ." c, " . TABLE_COUPONS_DESCRIPTION ." cd WHERE c.coupon_id = '". $cc_id . "' AND c.coupon_id = cd.coupon_id AND cd.language_id = '" . $languages_id . "'"); $get_result = tep_db_fetch_array($coupon_get); if ($get_result['sales_id']) { $products_query = tep_db_query("SELECT * FROM orders_products WHERE orders_id = " . $insert_id); $products_array = array(); while($products_temp = tep_db_fetch_array($products_query)) { $products_array[] = $products_temp; } $orders_products_ids = ''; $products_total = 0; if ($get_result['restrict_to_products'] || $get_result['restrict_to_categories']) { $i = -1; foreach($products_array as $products) { $i++; if ($get_result['restrict_to_categories']) { $cat_ids = split("[,]", $get_result['restrict_to_categories']); $my_path = tep_get_product_path($products['products_id']); $sub_cat_ids = split("[_]", $my_path); for ($iii = 0; $iii < count($sub_cat_ids); $iii++) { for ($ii = 0; $ii < count($cat_ids); $ii++) { if ($sub_cat_ids[$iii] == $cat_ids[$ii]) { $orders_products_ids .= $products['orders_products_id'] . ','; $products_total += $products['final_price'] * $products['products_quantity']; continue 3; } } } } if ($get_result['restrict_to_products']) { $pr_ids = split("[,]", $get_result['restrict_to_products']); for ($ii = 0; $ii < count($pr_ids); $ii++) { if ($pr_ids[$ii] == $products['products_id']) { $orders_products_ids .= $products['orders_products_id'] . ','; $products_total += $products['final_price'] * $products['products_quantity']; continue 2; } } } } } else { foreach($products_array as $products) { $orders_products_ids .= $products['orders_products_id'] . ','; $products_total += $products['final_price'] * $products['products_quantity']; } $orders_products_ids = substr($orders_products_ids, 0, -1); } $order_total = $this->get_order_total(); $sales_coupon_data = array('orders_id' => $insert_id , 'orders_products_ids' => $orders_products_ids , 'coupon_id' => $cc_id , 'coupon_code' => $get_result['coupon_code'] , 'coupon_name' => $get_result['coupon_name'] , 'sales_id' => $get_result['sales_id'] , 'commission_rate' => $get_result['commission_rate'] , 'commission_type' => $get_result['commission_type'] , 'coupon_discount' => $this->deduction , 'date_redeem' => 'now()' ); tep_db_perform('sales_coupon_redeem_record', $sales_coupon_data); } } tep_session_unregister('cc_id'); }

Open includes\modules\order_total\ot_coupon.php file, change:
$pr_c = $this->product_price(tep_get_prid($order->products[$i]['id']));
to:
$pr_c = $this->product_price($order->products[$i]['id']);

Open includes\modules\order_total\ot_coupon.php file, change:
$pr_c = $this->product_price($pr_ids[$ii]);
to:
$pr_c = $this->product_price($order->products[$i]['id']);

Delete includes\runtime\applicationtop\couponfix_applicationtop_bottom.php file.

Open shopping_cart.php file, after:
if (!$valid_to_checkout) { // $messageStack->add_session('header', 'Please update your order ...', 'error'); // tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); } // EOF: WebMakers.com Added: Attributes Sorter and Copier and Quantity Controller
add:
require(DIR_WS_CLASSES . 'order.php'); $order = new order; require(DIR_WS_LANGUAGES . $language . '/modules/order_total/ot_coupon.php'); require(DIR_WS_MODULES . '/order_total/ot_coupon.php'); $ot_coupon = new ot_coupon(); if (isset($_POST['coupon_redeem']) && $_POST['coupon_redeem'] == '1') { if (tep_not_null($_POST['gv_redeem_code'])) { tep_session_register('post_gv_redeem_code'); $post_gv_redeem_code = $_POST['gv_redeem_code']; tep_session_unregister('cc_id'); $ot_coupon->collect_posts_incart(); } else { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART, 'payment_error=ot_coupon&error_code=' . urlencode(ERROR_EMPTY_REDEEM_COUPON), 'SSL')); } } else if (tep_session_is_registered('cart_changed') && $cart_changed == 1 && tep_session_is_registered('cc_id') && tep_session_is_registered('post_gv_redeem_code')) { tep_session_unregister('cart_changed'); tep_session_unregister('cc_id'); //tep_session_unregister('post_gv_redeem_code'); $HTTP_POST_VARS['gv_redeem_code'] = $_POST['gv_redeem_code'] = $post_gv_redeem_code; $ot_coupon->collect_posts_incart(); }

Open templates\content\shopping_cart.tpl.php file, after:
<?php }else{ $header_text = HEADING_TITLE; } ?>
add:
<?php if (isset($_GET['payment_error']) && is_object(${$_GET['payment_error']}) && ($error = ${$_GET['payment_error']}->get_error())) { ?> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBoxNotice"> <tr class="infoBoxNoticeContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="3"><b><?php echo tep_output_string_protected($error['title']); ?></b></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main" width="100%" valign="top"><?php echo tep_output_string_protected($error['error']); ?></td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?>

Open logoff.php file, after:
tep_session_unregister('cc_id');
add:
tep_session_unregister('post_gv_redeem_code');

Open admin\includes\languages\english.php file, before:
?>
add:
define('BOX_SALES_ADMIN','Sales'); define('BOX_COUPON_USAGE_SUMMARY','Coupon Usage Summary'); define('BOX_COUPON_USAGE_DETAILS','Coupon Usage Details');

Open admin\includes\languages\english\coupon_admin.php file, before:
?>
add:
define('COUPON_COMMISSION_TYPE', 'Sales Commission Type'); define('COUPON_COMMISSION_RATE', 'Sales Commission Rate'); define('COUPON_SALES_ID', 'Sales'); define('COUPON_COMMISSION_TYPE_HELP', 'Type of commission for sales.'); define('COUPON_COMMISSION_RATE_HELP', 'The value of the commission for the sales.'); define('COUPON_SALES_ID_HELP', 'The sales of this coupon.'); define('COUPON_COMMISSION_TYPE_1', 'percentage of order'); define('COUPON_COMMISSION_TYPE_2', 'percentage of product'); define('TEXT_NO_SALES', 'No Sales Specified');

Open includes\languages\english\modules\order_total\ot_coupon.php file, before:
?>
add:
define('ERROR_EMPTY_REDEEM_COUPON', 'Please input your redeem code.');

Open admin\coupon_admin.php file, after:
'restrict_to_categories' => tep_db_prepare_input($HTTP_POST_VARS['coupon_categories']),
add:
'commission_type' => (int)$HTTP_POST_VARS['commission_type'], 'commission_rate' => (int)$HTTP_POST_VARS['commission_rate'], 'sales_id' => (int)$HTTP_POST_VARS['sales_id'],

Open admin\coupon_admin.php file, after:
<td align="left"><?php echo $finish_date; ?></td> </tr>
add:
<tr> <td align="left"><?php echo COUPON_COMMISSION_TYPE; ?></td> <td align="left"><?php echo constant('COUPON_COMMISSION_TYPE_' . (int)$HTTP_POST_VARS['commission_type']); ?></td> </tr> <tr> <td align="left"><?php echo COUPON_COMMISSION_RATE; ?></td> <td align="left"><?php echo (int)$HTTP_POST_VARS['commission_rate'] . '%'; ?></td> </tr> <?php $sales_query = tep_db_query('select * from affiliate_affiliate where affiliate_id = ' . (int)$HTTP_POST_VARS['sales_id']); $sales = tep_db_fetch_array($sales_query); ?> <tr> <td align="left"><?php echo COUPON_SALES_ID; ?></td> <td align="left"><?php echo $sales['affiliate_firstname'] . ' ' . $sales['affiliate_lastname']; ?></td> </tr>

Open admin\coupon_admin.php file, after:
echo tep_draw_hidden_field('coupon_categories', $HTTP_POST_VARS['coupon_categories']);
add:
echo tep_draw_hidden_field('commission_type', $HTTP_POST_VARS['commission_type']); echo tep_draw_hidden_field('commission_rate', $HTTP_POST_VARS['commission_rate']); echo tep_draw_hidden_field('sales_id', $HTTP_POST_VARS['sales_id']);

Open admin\coupon_admin.php file, change:
$coupon_query=tep_db_query("select coupon_active, coupon_code, coupon_amount, coupon_type, coupon_minimum_order, coupon_start_date, coupon_expire_date, date_created, uses_per_coupon, uses_per_user, restrict_to_products, restrict_to_categories from " . TABLE_COUPONS . " where coupon_id = '" . $HTTP_GET_VARS['cid'] . "'");
to:
$coupon_query=tep_db_query("select coupon_active, coupon_code, coupon_amount, coupon_type, coupon_minimum_order, coupon_start_date, coupon_expire_date, date_created, uses_per_coupon, uses_per_user, restrict_to_products, restrict_to_categories, commission_type, commission_rate, sales_id from " . TABLE_COUPONS . " where coupon_id = '" . $HTTP_GET_VARS['cid'] . "'");

Open admin\coupon_admin.php file, after:
$coupon_categories = $coupon['restrict_to_categories'];
add:
$commission_type = $coupon['commission_type']; $commission_rate = $coupon['commission_rate']; $sales_id = $coupon['sales_id'];

Open admin\coupon_admin.php file, after:
<tr> <td align="left" class="main"><?php echo COUPON_FINISHDATE; ?></td> <td align="left"><?php echo tep_draw_date_selector('coupon_finishdate', mktime(0,0,0, $coupon_finishdate[1], $coupon_finishdate[2], $coupon_finishdate[0], 0)); ?></td> <td align="left" class="main"><?php echo COUPON_FINISHDATE_HELP; ?></td> </tr>
add:
<?php $commission_rate_array = array(array('id' => '1', 'text' => COUPON_COMMISSION_TYPE_1), array('id' => '2', 'text' => COUPON_COMMISSION_TYPE_2)); $sales_query = tep_db_query('select * from affiliate_affiliate'); $sales_array = array(); $sales_array[] = array('id' => '0', 'text' => TEXT_NO_SALES); while ($sales = tep_db_fetch_array($sales_query)) { $sales_array[] = array('id' => $sales['affiliate_id'], 'text' => $sales['affiliate_firstname'] . ' ' . $sales['affiliate_lastname']); } ?> <tr> <td align="left" class="main"><?php echo COUPON_COMMISSION_TYPE; ?></td> <td align="left"><?php echo tep_draw_pull_down_menu('commission_type', $commission_rate_array, $commission_type); ?></td> <td align="left" class="main"><?php echo COUPON_COMMISSION_TYPE_HELP; ?></td> </tr> <tr> <td align="left" class="main"><?php echo COUPON_COMMISSION_RATE; ?></td> <td align="left"><?php echo tep_draw_input_field('commission_rate', $commission_rate); ?>%</td> <td align="left" class="main"><?php echo COUPON_COMMISSION_RATE_HELP; ?></td> </tr> <tr> <td align="left" class="main"><?php echo COUPON_SALES_ID; ?></td> <td align="left"><?php echo tep_draw_pull_down_menu('sales_id', $sales_array, $sales_id); ?></td> <td align="left" class="main"><?php echo COUPON_SALES_ID_HELP; ?></td> </tr>

Open admin\coupon_admin.php file, change:
if ($status == 'Y' || $status == 'N') { $cc_query_raw = "select coupon_active, coupon_id, coupon_code, coupon_amount, coupon_minimum_order, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified from " . TABLE_COUPONS ." where coupon_active='" . tep_db_input($status) . "' and coupon_type != 'G'"; } else { $cc_query_raw = "select coupon_active, coupon_id, coupon_code, coupon_amount, coupon_minimum_order, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified from " . TABLE_COUPONS . " where coupon_type != 'G'"; }
to:
if ($status == 'Y' || $status == 'N') { $cc_query_raw = "select coupon_active, coupon_id, coupon_code, coupon_amount, coupon_minimum_order, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified, commission_type, commission_rate, sales_id from " . TABLE_COUPONS ." where coupon_active='" . tep_db_input($status) . "' and coupon_type != 'G'"; } else { $cc_query_raw = "select coupon_active, coupon_id, coupon_code, coupon_amount, coupon_minimum_order, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified, commission_type, commission_rate, sales_id from " . TABLE_COUPONS . " where coupon_type != 'G'"; }

Open admin\coupon_admin.php file, after:
$coupon_name_query = tep_db_query("select coupon_name from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id = '" . $cInfo->coupon_id . "' and language_id = '" . $languages_id . "'"); $coupon_name = tep_db_fetch_array($coupon_name_query);
add:
$sales_query = tep_db_query('select * from affiliate_affiliate where affiliate_id = ' . (int)$cInfo->sales_id); $sales = tep_db_fetch_array($sales_query);

Open admin\coupon_admin.php file, after:
COUPON_CATEGORIES . ' : ' . $cat_details . '<br>' .
add:
COUPON_COMMISSION_TYPE . ' : ' . (defined('COUPON_COMMISSION_TYPE_' . (int)$cInfo->commission_type) ? constant('COUPON_COMMISSION_TYPE_' . (int)$cInfo->commission_type) : '') . '<br>' . COUPON_COMMISSION_RATE . ' : ' . $cInfo->commission_rate . '<br>' . COUPON_SALES_ID . ' : ' . $sales['affiliate_firstname'] . ' ' . $sales['affiliate_lastname'] . '<br>' .

Open affiliate_signup.php file, after:
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_AFFILIATE_SIGNUP);
add:
function gen_sales_code() { $sales_code = ''; $flag = true; while ($flag) { for ($i = 0; $i < 6; $i++) { $sales_code .= chr(tep_rand(97, 122)); } if (tep_db_num_rows(tep_db_query("SELECT affiliate_id FROM " . TABLE_AFFILIATE . " WHERE sales_code = '" . $sales_code . "'")) > 0) { $sales_code = ''; } else { $flag = false; } } return $sales_code; }

Open affiliate_signup.php file, after:
'affiliate_agb' => '1',
add:
'sales_code' => gen_sales_code(),

Open admin\affiliate_affiliates.php file, replace:
$info_query = tep_db_query("select affiliate_commission_percent, affiliate_date_account_created as date_account_created, affiliate_date_account_last_modified as date_account_last_modified, affiliate_date_of_last_logon as date_last_logon, affiliate_number_of_logons as number_of_logons from " . TABLE_AFFILIATE . " where affiliate_id = '" . $affiliate['affiliate_id'] . "'");
with:
$info_query = tep_db_query("select affiliate_commission_percent, affiliate_date_account_created as date_account_created, affiliate_date_account_last_modified as date_account_last_modified, affiliate_date_of_last_logon as date_last_logon, affiliate_number_of_logons as number_of_logons, sales_code from " . TABLE_AFFILIATE . " where affiliate_id = '" . $affiliate['affiliate_id'] . "'");

Open admin\affiliate_affiliates.php file, after:
$contents[] = array('text' => '' . TEXT_INFO_AFFILIATE_TOTAL . ' ' . $currencies->display_price($affiliate_sales['payment'],''));
add:
$contents[] = array('text' => SALES_CODE . ' ' . $aInfo->sales_code);

Open admin\includes\languages\english\affiliate_affiliates.php file, before last:
?>
add:
define('SALES_CODE', 'Sales Code: ');

Run SQL statement in phpMyAdmin:
ALTER TABLE `coupons` ADD `commission_type` INT( 1 ) NOT NULL , ADD `commission_rate` INT( 3 ) NOT NULL , ADD `sales_id` INT( 11 ) NOT NULL ; ALTER TABLE `affiliate_affiliate` ADD `sales_code` VARCHAR( 10 ) NOT NULL ; INSERT INTO `configuration` VALUES ( NULL, 'New Coupons Display', 'MAX_NEW_COUPON_DISPLAY', '5', 'Maximum Number of New Coupons to Display', 3, 1000, NULL , '0000-00-00 00:00:00', NULL , NULL ); CREATE TABLE `sales_coupon_redeem_record` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `orders_id` INT( 11 ) NOT NULL , `orders_products_ids` VARCHAR( 225 ) NOT NULL , `coupon_id` INT( 11 ) NOT NULL , `coupon_code` VARCHAR( 32 ) NOT NULL, `coupon_name` VARCHAR( 32 ) NOT NULL, `sales_id` INT( 11 ) NOT NULL , `commission_rate` INT( 3 ) NOT NULL , `commission_type` INT( 1 ) NOT NULL , `coupon_discount` DECIMAL( 10, 4 ) NOT NULL , `date_redeem` DATETIME NOT NULL ) ENGINE = MYISAM ;

delete the file:includes\runtime\applicationtop\couponfix_applicationtop_bottom.php

How can I uninstall CRE Loaded : Enhanced Coupon for Affiliate Module?

Delete all files that you added

Change all modified files back

What if I encounter problems?

Please see the troubleshooting section in the FAQ.

Company Proprietary