Reward Points Module for ZC v13x

[bi11i]

thanks - very much appreciated!

[Jeff_Mash]

Has this been discussed already: I am running the latest version on 1.5.1, but if I put a SPECIAL PRICE on an item, the module is still rewarding points on the original price.

For example, let's say that I have an item for $35.00. Normally, if you add this item to your cart, you would earn +4 Points.

Now if I go to Product's Price Manager, then click INSTALL on the "Special Price Info", and set a price for $4.95, then I'm still seeing the module reward the same +4 points to this item!

In other words, it's giving away money based on the original price.

NOW HERE'S THE KICKER: Under Configuration --> Reward Point Configuration --> Adjust Reward Points for Sales/Specials, I have that value set to "1".

So I have no idea why it's still calculating points based on the normal price, and not the Special Price Info.

[honrheart]

I can't find the uninstall directions for the module (a client wants this removed and it was installed by someone else). I found the install.sql and remove_multiple_config_items.sql files, do I just need to remove them? I know I need to remove the code from tpl_product_info_display.php but is there anything else I need to do other than remove the reward point files???

[KathyG]

I have the Reward Point mod and Edit Orders installed on v1.51, it seems to work well. Until I try to update an order. When I change that the order to delivered (or edit an order), I get a blank screen. The change is actually saved but I have to hit the back button on my browser to get out of the blank screen. Any idea how to fix this?
This is from the error log:

[02-Oct-2013 16:41:37] PHP Fatal error: Call to undefined function GetRewardPoints() in /home/scrappin/public_html/newstore/includes/modules/order_total/ot_reward_points_display.php on line 40

[techvapes]

Hi everyone. I have Super Orders and Edit Orders installed(current) on v1.51, it seems to work well. Until I try to edit an order.

I am able to make edits to an order. But when I try to update and order, I get a blank screen. This is the the error log:
[11-Aug-2013 05:40:33] PHP Fatal error: Call to undefined function getrewardpoints() in /hsphere/local/home/c376292/luxuriouspurse.com/shop/includes/modules/order_total/ot_reward_points_display.php on line 40

However the edits made to the order are actually saved. Any idea how to fix this? Thank you!

I have the Reward Point mod and Edit Orders installed on v1.51, it seems to work well. Until I try to update an order. When I change that the order to delivered (or edit an order), I get a blank screen. The change is actually saved but I have to hit the back button on my browser to get out of the blank screen. Any idea how to fix this?
This is from the error log:

[02-Oct-2013 16:41:37] PHP Fatal error: Call to undefined function GetRewardPoints() in /home/scrappin/public_html/newstore/includes/modules/order_total/ot_reward_points_display.php on line 40

I am having this exact same error. Using ZC 1.5.1, latest Edit Orders, Super Orders, and Reward Point Mod. Everything seemingly worked fine until installing Admin New Order plugin. All installation instructions were followed to the T and double checked. Anyone have any suggestions?

[Coins2012]

Hi All,

I tried to search this thread but couldn't find a work around, take a look at the order below:

1 x XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX $156.78
3 x XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX $83.22
---------
Sub-Total: $240.00
Free Shipping Options (Free Shipping): $0.00
Value of Redeemed Reward Points: -$0.40
Total: $239.61


The problem is that the total supposed to be $239.60 not $239.61. Looking further into this, the Customer had 79 points and I have my ratio setup as .005 so when you convert you get $0.395 I am not sure how this simple calculation is happening in the module but something doesn't seem correct, perhaps the Value of Redeemed Reward Points should be $0.39 but if you look above it shows $0.40 but when this get subtracted from subtotal it's off by a penny.

I know all my products are rounded to 2 decimal points and I am able to verify this, is there a way to fix this issue.

I am using ZC 1.50.

thank you

[southshorepizza]

I need to get the ADMIN>CUSTOMERS>REWARD POINTS table to display email address field. I am trying to modify admin/customers_reward_points.php. I added:

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<table border="0" width="100%" cellspacing="0" cellpadding="0">
 <tr>
  <td width="75%" height="1px"></td>
  <td width="25%" height="1px"></td>
 </tr>
 <tr>
  <td valign="top">
   <table border="0" width="100%" cellspacing="0" cellpadding="0">
    <tr class="dataTableHeadingRow">
     <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_ID; ?></td>
	 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_LAST_NAME; ?></td>
	 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_FIRST_NAME; ?></td>
         <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_EMAIL_ADDRESS; ?</td>
	 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_PENDING_POINTS; ?></td>
	 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_EARNED_POINTS; ?></td>
	 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_PRICING_GROUP; ?></td>
	 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_GROUP_REDEEM_RATIO; ?></td>
	 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?></td>
    </tr>
<?php
 if(isset($_SESSION['search']))
  $where=" WHERE (c.customers_lastname LIKE '%".$_SESSION['search']."%' OR c.customers_firstname LIKE '%".$_SESSION['search']."%' OR c.customers_id LIKE '%".$_SESSION['search']."%' OR c.customers_email_address LIKE '%".$_SESSION['search']."%')";
 else
  if(isset($_SESSION['customer_sort_index']))
   if($_SESSION['customer_sort_order']==1)
    $where=" WHERE c.customers_firstname LIKE '".$_SESSION['customer_sort_index']."%'";
   else
    $where=" WHERE c.customers_lastname LIKE '".$_SESSION['customer_sort_index']."%'";
   else
    $where="";
   
  switch($_SESSION['customer_sort_order']) 
  {
		case (0):
			$order_by=" ORDER BY c.customers_lastname";
			break;
		case (1):
			$order_by=" ORDER BY c.customers_firstname, c.customers_lastname";
			break;
		case (2):
			$order_by=" ORDER BY c.customers_id, c.customers_lastname";
			break;
		case (3):
			$order_by=" ORDER BY gp.group_name, c.customers_lastname";
			break;
		case (4):
			$order_by=" ORDER BY r.pending_points DESC, c.customers_lastname";
			break;
		case (5):
			$order_by=" ORDER BY r.reward_points DESC, c.customers_lastname";
			break;
		case (6):
			$order_by=" ORDER BY o.date_purchased DESC, c.customers_lastname";
			break;
  }
  $group_by="";
  $limit=" LIMIT ".REWARD_POINTS_CUSTOMER_LIMIT;
  $customer_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_pricing, r.pending_points, r.reward_points, gp.group_name, rm.redeem_ratio from ".TABLE_CUSTOMERS." as c LEFT JOIN (".TABLE_REWARD_CUSTOMER_POINTS." as r) ON (r.customers_id=c.customers_id) LEFT JOIN(".TABLE_GROUP_PRICING." as gp) ON (gp.group_id=c.customers_group_pricing) LEFT JOIN(".TABLE_REWARD_MASTER." as rm) ON ((c.customers_group_pricing!=0 AND rm.scope=".SCOPE_GROUP." AND rm.scope_id=c.customers_group_pricing) OR (c.customers_group_pricing=0 AND rm.scope=".SCOPE_GLOBAL." AND rm.scope_id=0))".$index.$where.$group_by.$order_by.$limit.";";
  //echo $customer_query_raw;
  $customers = $db->Execute($customer_query_raw);
  while (!$customers->EOF)
  {
	//$redeem_points=GetRewardPointRecord(SCOPE_GROUP,$customers->fields['customers_group_pricing']);
	if(isset($_GET['id']) && $customers->fields['customers_id']==$_GET['id'])
	{
		echo '    <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\''.zen_href_link(FILENAME_ADMIN_CUSTOMER_REWARD_POINTS,'id='.$customers->fields['customers_id'].'&action=edit').'\'">'."\n";
		$current_customer=$customers->fields;
	}
    else
	 echo '    <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_ADMIN_CUSTOMER_REWARD_POINTS,'id='.$customers->fields['customers_id'].'&action=edit').'\'">'."\n";
?>
                <td class="dataTableContent"><?php echo $customers->fields['customers_id']; ?></td>
                <td class="dataTableContent"><?php echo $customers->fields['customers_lastname']; ?></td>
                <td class="dataTableContent"><?php echo $customers->fields['customers_firstname']; ?></td>
                <td class="dataTableContent"><?php echo $customers->fields['customers_email_address']; ?></td>
                <td class="dataTableContent"><?php echo (int)$customers->fields['pending_points']; ?></td>
                <td class="dataTableContent"><?php echo (int)$customers->fields['reward_points']; ?></td>
				<td class="dataTableContent"><?php echo CheckText($customers-

When I did this I broke the page with error on line 239. Could someone please help me with this. PHP is not my strength.

Thank you!

[southshorepizza]

I found the missing ">" in the line :

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_EMAIL_ADDRESS; ?</td>

[CandleMan]

Does this module work with 1.5.1 or is it still to be tested?

The reason I asked is that I have installed it on 1.5.1 and it works great when people purchase via Paypal but not when they purchase via Nochex Payment Module.

Anyone else had this issue?

[picandnix]

Does this module work with 1.5.1 or is it still to be tested?

The reason I asked is that I have installed it on 1.5.1 and it works great when people purchase via Paypal but not when they purchase via Nochex Payment Module.

Anyone else had this issue?

Have you updated the status of their order? The system is most likely not awarding points until it is marked as 'paid'?