Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

v156 with Reward Points v2.5f

I've been updating my site from 155e to v156 and see that my points are being added and all apparently works as it should. But when I try to access admin/reward_points.php page which is under the catalog menu, I get the following error:

Quote:

---

PHP Fatal error: require(): Failed opening required 'includes/modules/prod_cat_header_code.php'

---

But when I check my files, I have no such file since it seems to have been removed with this new udpate. I've also searched this thread for this and an Advanced search of the site... and can't find what I am looking for. Any ideas?

What is the rest of the error?

It wants to go to the prod_cat_header_code.php file because on line 13 of the admin/reward_points.php it says this:
require(DIR_WS_MODULES . 'prod_cat_header_code.php');

But that file isn't in the latest version of the cart so I'm presuming that this code needs to be changed but sadly, my presuming ends here. lol

Quote:

---

PHP Warning: require(includes/modules/prod_cat_header_code.php): failed to open stream: No such file or directory in /home/.../public_html/shop/admin/reward_points.php on line 13.

[11-Mar-2019 22:45:45 America/Montreal] PHP Fatal error: require(): Failed opening required 'includes/modules/prod_cat_header_code.php' (include_path='.:/opt/alt/php71/usr/share/pear') in /home/.../public_html/shop/admin/reward_points.php on line 13

---

[QUOTE=jeking;1355837]What is the rest of the error?[/Q

This is installed on a client site which was upgraded so includes/modules/prod_cat_header_code.php is still there. By all reports, it's working fine.

I just went and redowloaded v1.5.6 in case I had goofed and nope, that file is no longer there. And in all appearances, this plug in is still working. The only 2 things that aren't is access to the page under the catalog menu and also, even if I have it configured to calculate the points on the subtotal meaning after sale and discounts, it is awarding the points on regular price. ex: reg price 45$, sale price is 22.50... the cart is giving 45 points instead of 22.5 like it used to.

Quote:

---

Originally Posted by jeking

This is installed on a client site which was upgraded so includes/modules/prod_cat_header_code.php is still there. By all reports, it's working fine.

---

oops my bad, there was a new setting to me that I overlooked. It is now calculating properly. Still can't get to the catalog Reward Points page.

Quote:

---

Originally Posted by mariemeh

I just went and redowloaded v1.5.6 in case I had goofed and nope, that file is no longer there. And in all appearances, this plug in is still working. The only 2 things that aren't is access to the page under the catalog menu and also, even if I have it configured to calculate the points on the subtotal meaning after sale and discounts, it is awarding the points on regular price. ex: reg price 45$, sale price is 22.50... the cart is giving 45 points instead of 22.5 like it used to.

---

Hi, I am using this on ZC 1.5.5f and it works really great. My question is: Is there a way to make it so that rewards points can not be redeemed in the purchase of a gift card? Perhaps there is some coding which can be changed to prevent this. This is based on my test account, I awarded 100 pts and when I go in to purchase a $10 gift card, it allows me to redeem $5 of rewards (based on my settings) at the time of that purchase.

Quote:

---

Originally Posted by izar74

Hi again,

I've got this error:

HTML Code:

---

[25-May-2015 15:22:01] PHP Fatal error:  1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2')
                                OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id A' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute
                                FROM reward_master prp, products p, products_to_categories p2c
                                WHERE p.products_id='101'"'
                                AND p2c.products_id='101'"'
                                AND ((prp.scope_id=p.products_id AND prp.scope='2')
                                OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1')
                                OR (prp.scope='0'))
                                ORDER BY prp.scope DESC LIMIT 1; ==> (as called by) /var/www/vhosts/.../httpdocs/includes/functions/extra_functions/reward_points_functions.php on line 62 <== in /var/www/vhosts/.../httpdocs/includes/classes/db/mysql/query_factory.php on line 155

---

Check the file but it seem all fine... the line 51 to 62 of reward_points_functions.php look like this:

PHP Code:

---

if(zen_get_products_price_is_free($products_id)==false || REWARD_POINTS_ALLOW_ON_FREE=='1') // Allow RP on free items (Admin settable)
    {
        $sql = "SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute 
                FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c 
                WHERE p.products_id='" . $products_id . "'
                AND p2c.products_id='" . $products_id . "'
                AND ((prp.scope_id=p.products_id AND prp.scope='".SCOPE_PRODUCT."') 
                OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='".SCOPE_CATEGORY."')
                OR (prp.scope='".SCOPE_GLOBAL."'))
                ORDER BY prp.scope DESC LIMIT 1;";

        $result=$db->Execute($sql); 


---

The specific of the server are:
Database: MySQL 5.1.73
Versione PHP: 5.3.3 (Zend: 2.3.0) PHP Memory Limit: 128M

I'm a little bit unsure of what that error could be... any guess would be helpful :smile:

---

I'm getting a similar error. ZC 1.5.6a. fresh installation. Any ideas?

PHP Code:

---

PHP Fatal error: 1146:Table 'XXX.TABLE_REWARD_MASTER' doesn't exist :: 
SELECT prp.point_ratio FROM TABLE_REWARD_MASTER prp WHERE prp.scope='SCOPE_GLOBAL' LIMIT 1; ==> 
(as called by) /includes/functions/extra_functions/reward_points_functions.php on line 119 
<== in /includes/classes/db/mysql/query_factory.php on line 171. 


---

For anyone that is having the same issue. Re-upload the files in the same order. It seems that somehow I managed to get the files "mixed" and in the wrong place. All is good! =)

Help me please.
I am an user of zen1.3.0.2. Now I want to make new install zen1.55
After install zen1.55, installed Reward Points Full Suite v2.5.
I set Admin->Customer->Reward Points then occured an error at Customers->Orders.
---------------------------------------------------------------------------------
"LEGEND: Billing and Shipping does not match Billing and Shipping does not match
WARNING: An Error occurred, please refresh the page and try again."
---------------------------------------------------------------------------------

logs as follow:
---------------------------------------------------------------------------------
[18-Apr-2019 18:56:24 Asia/Tokyo] Request URI: /shop155/cAtch-utS-fLour/orders.php, IP address: ::1
#1 trigger_error() called at [C:\xampp\htdocs\shop155\includes\classes\db\mysql\query_factory.php:171]
#2 queryFactory->show_error() called at [C:\xampp\htdocs\shop155\includes\classes\db\mysql\query_factory.php:143]
#3 queryFactory->set_error() called at [C:\xampp\htdocs\shop155\includes\classes\db\mysql\query_factory.php:270]
#4 queryFactory->Execute() called at [C:\xampp\htdocs\shop155\cAtch-utS-fLour\orders.php:844]
[18-Apr-2019 18:56:24 Asia/Tokyo] PHP Fatal error: 1054:Unknown column 'o.customers_wholesale' in 'field list' :: SELECT o.orders_id, s.orders_status_name, o.customers_wholesale, opa.orders_id, opa.products_options, opa.options_values_price, opa.options_values_price_w FROM orders_products_attributes opa left join orders o LEFT JOIN orders_status s on (o.orders_status = s.orders_status_id and s.language_id = 1) ON (opa.orders_id = o.orders_id) WHERE opa.products_options = 'CORE Charge' ==> (as called by) C:\xampp\htdocs\shop155\cAtch-utS-fLour\orders.php on line 844 <== in C:\xampp\htdocs\shop155\includes\classes\db\mysql\query_factory.php on line 171
---------------------------------------------------------------------------------

I still not have done any customizations.
Have I made anything wrong ?
Win10 64bit, Xampp7.0.3, zencart:zen-cart-v1.5.5f-12312017b
Reward Points :Reward_Points_Full_Suite_25g_for_155f.zip

The error is due to a missing column, customers_wholesale. This is not part of the Rewards Point plugin. There is a Dual Pricing plugin that uses a similar name, but not that.

Are you using any wholesale plugins?
Look at your cAtch-utS-fLour\orders.php file compared to the 1.5.5 default version. customers_wholesale is not mentioned in the default or this plugins' version of that file.

Thank you for your reply.

I was able to install with past version reward_point_full_suite_2.5f.
I tried to install several times and operated it and confirmed the duplicability.

This is brand new install of zen155 and reward_point.
I also tried to install reward_point_full_suite_2.5g On the basis of XAMPP7.1.18 and zen1.55f.
It occured same error "WARNING: An Error occurred, please refresh the page and try again.".
I wonder it concern with php version.
Because of my ability, I give up on pursuing the installation of 2.5g even 2.5f have some inconsistencies.

Thank you.

Hello everyone!

I'm running into a possibly minor issue (?). New install 1.5.6a, customer just first placed an order and on the admin I see reward points earned with this order as $0.00 when it should be 6. Any ideas on how to fix this one??

And also, I'm giving customers 100 points for signing in, they are not added to their accounts.

Any help would be appreciated.

For anyone running ZC 1.5.6a getting either a blank page or a $ on admin/orders.php I was able to make it work.

Locate

PHP Code:

---

                    <tr>
                      <td class="<?php echo str_replace('_', '-', $order->totals[$i]['class']); ?>-Text text-right">
                          <?php echo $order->totals[$i]['title']; ?>
                      </td>
                      <td class="<?php echo str_replace('_', '-', $order->totals[$i]['class']); ?>-Amount text-right">
                          <?php echo $currencies->format($order->totals[$i]['value'], true, $order->info['currency'], $order->info['currency_value']); ?>
                      </td>
                    </tr>

---

Replace for

PHP Code:

---

<!-- bof Reward Points -->
<?php
      if ($order_total['class'] = "ot_reward_points_display") { ?>
                    <tr>
                      <td class="<?php echo str_replace('_', '-', $order->totals[$i]['class']); ?>-Text text-right">
                          <?php echo $order->totals[$i]['title']; ?>
                      </td>
                      <td class="<?php echo str_replace('_', '-', $order->totals[$i]['class']); ?>-Amount text-right">
                          <?php echo $order->totals[$i]['text']; ?>
                      </td>
                    </tr>
<?php } else { ?>
<!-- eof Reward Points -->
                    <tr>
                      <td class="<?php echo str_replace('_', '-', $order->totals[$i]['class']); ?>-Text text-right">
                          <?php echo $order->totals[$i]['title']; ?>
                      </td>
                      <td class="<?php echo str_replace('_', '-', $order->totals[$i]['class']); ?>-Amount text-right">
                          <?php echo $currencies->format($order->totals[$i]['value'], true, $order->info['currency'], $order->info['currency_value']); ?>
                      </td>
                    </tr>
                    <?php
//<!-- bof Reward Points -->
                    }
//<!-- eof Reward Points -->

---

Still haven't figure out why the Reward Points aren't awarded when opening an account.

I someone going to upgrade this for 1.5.6c? I have a customer who is needing something like this but I know just about enough about coding to get me into dangerous waters! LOL

I can try to update it but don't want to step on anyone's toes.

Quote:

---

Originally Posted by stellarweb

I someone going to upgrade this for 1.5.6c? I have a customer who is needing something like this but I know just about enough about coding to get me into dangerous waters! LOL

I can try to update it but don't want to step on anyone's toes.

---

I am working on it.. or you can make a github repo.. when I get time

I thought I posted it before. Maybe I didnt as I don see a post from me lately, so I'll post it again.

I'm still at ZC 1.5.5f with Reward Point Full Suite Version: 2.5f. Is the current 2.5f and 2.5g versions definitively compatible with ZC 1.5.6c ? With or without hackery?

Thanks

While this worked seamlessly with my ZC 155f it doesn't even work at all in ZC156c is anyone planning to update?

Oof..

Guess Im going to hold off in upgrading to ZC 156* Im not going to say to my customers: "All your points are gone. LOL"

Quote:

---

Originally Posted by sammirah

While this worked seamlessly with my ZC 155f it doesn't even work at all in ZC156c is anyone planning to update?

---

I have downloaded v2.5 twice and when opening docs/RewardPoints_Readme it opens the overview page but all the hot links from Installation, How to use etc. just go to a blank blocked page even when they are from a downloaded file on my own system and I configure Chrome to ask then allow Flash

What am I doing wrong please

Quote:

---

Originally Posted by montanag

I have downloaded v2.5 twice and when opening docs/RewardPoints_Readme it opens the overview page but all the hot links from Installation, How to use etc. just go to a blank blocked page even when they are from a downloaded file on my own system and I configure Chrome to ask then allow Flash

What am I doing wrong please

---

Thank you, never mind - figured it out, had not extracted folder fully, sorry for the trouble

So can you confirm that this plugin will work with ZC 1.5.6.a or b? I am currently using 1.5.5f where it definitely works, but I am trying to stop being stubborn and move into the new age and need to know it will work for at least those versions. I know it doesn't work at all on 1.5.6c something is wrong with the admin section.

Hi there, I have just installed this module for version 1.5.6c (a fresh install - no customers, orders or anything as yet) and the following page doesn't render at all so I can't set up the ratios etc: .....zcadmin/reward_points.php

I have been using the module for years in my old store that's 1.5.5 without issue.

The page is completely blank in the new installation. Will it work once I import the data from my old store or is there something that needs to be changed on that page specifically or something else I need to do?

I have checked the installation and everything is in place. The one script I haven't run however is the one entitled remove_multiple_config_items - I can't see any notes as to what its for or when it is supposed to be run - is this perhaps the issue?

I'm working on a version for 1.56c now with corrections to the known bugs and integration points for commonly installed modules.
Donations are welcomed!
:cheers:

Quote:

---

Originally Posted by twitchtoo

I'm working on a version for 1.56c now with corrections to the known bugs and integration points for commonly installed modules.
Donations are welcomed!
:cheers:

---

This would be of interest, and would make donation for your work. Not sure if 1.56c is much different to the 1.57 version. Still currently doing upgrade at the moment.

Quote:

---

Originally Posted by HeathenMagic

This would be of interest, and would make donation for your work. Not sure if 1.56c is much different to the 1.57 version. Still currently doing upgrade at the moment.

---

It appears everything will need to meet the 1.56c coding step before being merged with 1.57, which is also becoming an upgrade coding step.

A polished public version for 1.56c may be ready for the end of August with the current schedule/funding support - Thanks!

1.5.6c
PHP Version: 7.3.21

Code:

---

[02-Sep-2020 14:22:19 Europe/London] Request URI: /log-in?action=process, IP address:
#1  RewardPoints->update() called at [/home/site/public_html/includes/classes/class.base.php:103]
#2  base->notify() called at [/home/site/public_html/includes/modules/pages/login/header_php.php:260]
#3  require(/home/site/public_html/includes/modules/pages/login/header_php.php) called at [/home/site/public_html/index.php:36]
--> PHP Warning: Use of undefined constant NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER - assumed 'NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER' (this will throw an Error in a future version of PHP) in /home/site/public_html/includes/classes/observers/class.reward_points.php on line 32.

[02-Sep-2020 14:22:19 Europe/London] Request URI: /log-in?action=process, IP address:
#1  RewardPoints->update() called at [/home/site/public_html/includes/classes/class.base.php:103]
#2  base->notify() called at [/home/site/public_html/includes/modules/pages/login/header_php.php:260]
#3  require(/home/site/public_html/includes/modules/pages/login/header_php.php) called at [/home/site/public_html/index.php:36]
--> PHP Warning: Use of undefined constant NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_CUSTOMER_RECORD - assumed 'NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_CUSTOMER_RECORD' (this will throw an Error in a future version of PHP) in /home/site/public_html/includes/classes/observers/class.reward_points.php on line 36.

[02-Sep-2020 14:22:19 Europe/London] Request URI: /log-in?action=process, IP address:
#1  RewardPoints->update() called at [/home/site/public_html/includes/classes/class.base.php:103]
#2  base->notify() called at [/home/site/public_html/includes/modules/pages/login/header_php.php:260]
#3  require(/home/site/public_html/includes/modules/pages/login/header_php.php) called at [/home/site/public_html/index.php:36]
--> PHP Warning: Use of undefined constant NOTIFY_LOGIN_SUCCESS - assumed 'NOTIFY_LOGIN_SUCCESS' (this will throw an Error in a future version of PHP) in /home/site/public_html/includes/classes/observers/class.reward_points.php on line 44.

---

Code:

---

[02-Sep-2020 14:30:05 Europe/London] Request URI: /index.php?main_page=checkout_process, IP address:
#1  RewardPoints->update() called at [/home/site/public_html/includes/classes/class.base.php:103]
#2  base->notify() called at [/home/site/public_html/includes/classes/order.php:713]
#3  order->create() called at [/home/site/public_html/includes/modules/checkout_process.php:95]
#4  require(/home/site/public_html/includes/modules/checkout_process.php) called at [/home/site/public_html/includes/modules/pages/checkout_process/header_php.php:14]
#5  require(/home/site/public_html/includes/modules/pages/checkout_process/header_php.php) called at [/home/site/public_html/index.php:36]
--> PHP Warning: Use of undefined constant NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER - assumed 'NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER' (this will throw an Error in a future version of PHP) in /home/site/public_html/includes/classes/observers/class.reward_points.php on line 32.

---

Code:

---

[02-Sep-2020 14:25:24 Europe/London] Request URI: /create-account, IP address:
#1  RewardPoints->update() called at [/home/site/public_html/includes/classes/class.base.php:103]
#2  base->notify() called at [/home/site/public_html/includes/modules/create_account.php:594]
#3  include(/home/site/public_html/includes/modules/create_account.php) called at [/home/site/public_html/includes/modules/pages/create_account/header_php.php:17]
#4  require(/home/site/public_html/includes/modules/pages/create_account/header_php.php) called at [/home/site/public_html/index.php:36]
--> PHP Warning: Use of undefined constant NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER - assumed 'NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER' (this will throw an Error in a future version of PHP) in /home/site/public_html/includes/classes/observers/class.reward_points.php on line 32.

[02-Sep-2020 14:25:24 Europe/London] Request URI: /create-account, IP address:
#1  RewardPoints->update() called at [/home/site/public_html/includes/classes/class.base.php:103]
#2  base->notify() called at [/home/site/public_html/includes/modules/create_account.php:594]
#3  include(/home/site/public_html/includes/modules/create_account.php) called at [/home/site/public_html/includes/modules/pages/create_account/header_php.php:17]
#4  require(/home/site/public_html/includes/modules/pages/create_account/header_php.php) called at [/home/site/public_html/index.php:36]
--> PHP Warning: Use of undefined constant NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_CUSTOMER_RECORD - assumed 'NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_CUSTOMER_RECORD' (this will throw an Error in a future version of PHP) in /home/site/public_html/includes/classes/observers/class.reward_points.php on line 36.

---

Any idea on a timeframe for 1.5.7 compatibility?

Quote:

---

Originally Posted by twitchtoo

I'm working on a version for 1.56c now with corrections to the known bugs and integration points for commonly installed modules.
Donations are welcomed!
:cheers:

---

Cant wait. We're grossly behind on this module since 1.56 is already out and most of us who uses this mod is stuck on 1.5.5f
I sure wouldn't mind throwing a few coins your way if you're able to publish a proper working release.

For those who hasn't bothered to read the pervious pages of posts on this thread:
As of Now, Oct 5th 2020. Reward Points Full Suite does not work out of the box for ZC 1.5.6c and definitely does not work at all on 1.5.7

Thanks for this wee update - I have Rewards Points on my old 1.3.7 version and I'm currently writing a new site with 1.5.7 and it's a popular tool with my clients :) Happy to donate to this as well.

Quote:

---

Originally Posted by ROQSOLID

.....zcadmin/reward_points.php

I have been using the module for years in my old store that's 1.5.5 without issue.

The page is completely blank in the new installation.

---

remove line 13 from admin/reward_points.php and the page will load. The file is trying to pull in another file that was removed a couple Zen-Cart versions back.

Quote:

---

Originally Posted by DigitalShadow

Code:

---

[02-Sep-2020 14:25:24 Europe/London] Request URI: /create-account, IP address:
#1  RewardPoints->update() called at [/home/site/public_html/includes/classes/class.base.php:103]
#2  base->notify() called at [/home/site/public_html/includes/modules/create_account.php:594]
#3  include(/home/site/public_html/includes/modules/create_account.php) called at [/home/site/public_html/includes/modules/pages/create_account/header_php.php:17]
#4  require(/home/site/public_html/includes/modules/pages/create_account/header_php.php) called at [/home/site/public_html/index.php:36]
--> PHP Warning: Use of undefined constant NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER - assumed 'NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER' (this will throw an Error in a future version of PHP) in /home/site/public_html/includes/classes/observers/class.reward_points.php on line 32.

[02-Sep-2020 14:25:24 Europe/London] Request URI: /create-account, IP address:
#1  RewardPoints->update() called at [/home/site/public_html/includes/classes/class.base.php:103]
#2  base->notify() called at [/home/site/public_html/includes/modules/create_account.php:594]
#3  include(/home/site/public_html/includes/modules/create_account.php) called at [/home/site/public_html/includes/modules/pages/create_account/header_php.php:17]
#4  require(/home/site/public_html/includes/modules/pages/create_account/header_php.php) called at [/home/site/public_html/index.php:36]
--> PHP Warning: Use of undefined constant NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_CUSTOMER_RECORD - assumed 'NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_CUSTOMER_RECORD' (this will throw an Error in a future version of PHP) in /home/site/public_html/includes/classes/observers/class.reward_points.php on line 36.

---

---

Change lines 32-44 to look like the below. All that has been added is single apostrophe's at the beginning and end of those debug call outs. These changes were provided by swguy:

Code:

---

case 'NOTIFY_ORDER_DURING_CREATE_ADDED_ORDER_HEADER':
    $this->StoreRewardPoints($customer_id);
    break;
 
  case 'NOTIFY_MODULE_CREATE_ACCOUNT_ADDED_CUSTOMER_RECORD':
    if(REWARD_POINTS_NEW_ACCOUNT_REWARD!=0)
    if(REWARD_POINTS_NEW_ACCOUNT_REWARD>0 && !HasRewardPoints($customer_id))
      $this->AddRewardPoints($customer_id,REWARD_POINTS_NEW_ACCOUNT_REWARD);
    else
    if(REWARD_POINTS_NEW_ACCOUNT_REWARD<0 && !HasPendingPoints($customer_id))
      $this->AddPendingPoints($customer_id,abs(REWARD_POINTS_NEW_ACCOUNT_REWARD));
 
  case 'NOTIFY_LOGIN_SUCCESS':

---

Quote:

---

Originally Posted by chibipaw

For those who hasn't bothered to read the pervious pages of posts on this thread:
As of Now, Oct 5th 2020. Reward Points Full Suite does not work out of the box for ZC 1.5.6c and definitely does not work at all on 1.5.7

---

I have this working on ZC 1.5.6c in production (and am about to test on 1.5.7), what part of it is not working for you? (also see my last 2 posts)

I am working on an upgrade to ZC 1.5.7. My clients customers really love the rewards. Any progress on a version that works on ZC 1.5.7?

BTW I have been trying to make Rewards 2g work with no success.

Quote:

---

Originally Posted by osulywan

I am working on an upgrade to ZC 1.5.7. My clients customers really love the rewards. Any progress on a version that works on ZC 1.5.7?

BTW I have been trying to make Rewards 2g work with no success.

---

A 1.56c version is working I haven't packed it up for public release just yet. At this point the 1.57 version will be out early 2021 if charitable or commercial funding continues :)

Thanks to the folks that continue to support our coding efforts!

Quote:

---

Originally Posted by twitchtoo

A 1.56c version is working I haven't packed it up for public release just yet. At this point the 1.57 version will be out early 2021 if charitable or commercial funding continues :)

Thanks to the folks that continue to support our coding efforts!

---

Thanks for the update Twitchtoo. I'll pass this on to my client.

Hey Twitchtoo - I think I may have found a serious "bug" with the how the module interacts with another plugin. I am still working on isolating it, but here's what I suspect.

We are using your Reward Points alongside the One Page Checkout plugin (which allows customers to checkout using a global Guest Account).

I think what is happening is that if Customer A checks out as a guest and earns reward points, it's being assigned to this particular Guest Account. The next customer (Customer B) comes to the site, and when he checks out as a guest, he now has available reward points to use even though he's never shopped here before.

Can you tell me where in your code I can hardcode something that says, "If the Customer ID matches 1234, then don't assign any reward points?"

I think that is the easiest workaround for us. Basically, I can plugin the ID for the Guest Customer (which is always the same), so that if an order is placed using that Customer ID, then no reward points will be rewarded into that account. That way, the next anonymous person who uses it won't get free credit to use.

Thanks in advance.

EDIT - Another option might be to only display reward points to customers if they are logged in. But for now, I need a quick solution to not give away credit to anonymous Guest checkouts (which apparently has been happening in our store for months unnoticed until now).

Currently, I am having a CRON job run a database update every few minutes to zero out any pending/earned points for that Guest Account customer_id, but that's not ideal.

Quote:

---

Originally Posted by Jeff_Mash

Hey Twitchtoo - I think I may have found a serious "bug" with the how the module interacts with another plugin. I am still working on isolating it, but here's what I suspect.

We are using your Reward Points alongside the One Page Checkout plugin (which allows customers to checkout using a global Guest Account).

I think what is happening is that if Customer A checks out as a guest and earns reward points, it's being assigned to this particular Guest Account. The next customer (Customer B) comes to the site, and when he checks out as a guest, he now has available reward points to use even though he's never shopped here before.

Can you tell me where in your code I can hardcode something that says, "If the Customer ID matches 1234, then don't assign any reward points?"

I think that is the easiest workaround for us. Basically, I can plugin the ID for the Guest Customer (which is always the same), so that if an order is placed using that Customer ID, then no reward points will be rewarded into that account. That way, the next anonymous person who uses it won't get free credit to use.

Thanks in advance.

EDIT - Another option might be to only display reward points to customers if they are logged in. But for now, I need a quick solution to not give away credit to anonymous Guest checkouts (which apparently has been happening in our store for months unnoticed until now).

Currently, I am having a CRON job run a database update every few minutes to zero out any pending/earned points for that Guest Account customer_id, but that's not ideal.

---

Noting that, as of zc156, there's now a function (zen_in_guest_checkout()) that returns a (bool)true/false to indicate whether/not the checkout is being performed by a guest. The reward_points' order-totals could use that as a clue to 'not enable' if (bool)true is returned.

Quote:

---

Originally Posted by lat9

Noting that, as of zc156, there's now a function (zen_in_guest_checkout()) that returns a (bool)true/false to indicate whether/not the checkout is being performed by a guest. The reward_points' order-totals could use that as a clue to 'not enable' if (bool)true is returned.

---

That's a very good suggestion, Cindy. Now I just need Twitchtoo to let me know where to put that function in his module so that it can be used to disable the rewards from being assigned during the checkout process. I'm sure it's just a matter of finding where he updates the database to insert the points during checkout......but I don't have the time to dig through and figure out where that might be.

Quote:

---

Originally Posted by Jeff_Mash

That's a very good suggestion, Cindy. Now I just need Twitchtoo to let me know where to put that function in his module so that it can be used to disable the rewards from being assigned during the checkout process. I'm sure it's just a matter of finding where he updates the database to insert the points during checkout......but I don't have the time to dig through and figure out where that might be.

---

Just for documentation purposes, here is what I did.

I edited the tpl_modules_opc_credit_selections.php file, and added the following code after Line 47:

Code:

---

if(zen_in_guest_checkout() && !strcmp($ot_class,"Reward_points"))
                                continue;

---

What this does is it removes the Reward Points block from being displayed on a Guest account. Again, the reason why this was necessary is because the guest account was accumulating Reward Points.........so a new guest customer could potentially checkout and use free earned credit that they didn't pay for.

So hopefully, this little custom modification will resolve the issue for us, because it won't display the Reward Points box to any "guest" to apply any points. Might not be the best workaround but I think it might accomplish what we need.

Quote:

---

Originally Posted by Jeff_Mash

Just for documentation purposes, here is what I did.

I edited the tpl_modules_opc_credit_selections.php file, and added the following code after Line 47:

Code:

---

if(zen_in_guest_checkout() && !strcmp($ot_class,"Reward_points"))
                continue;

---

What this does is it removes the Reward Points block from being displayed on a Guest account. Again, the reason why this was necessary is because the guest account was accumulating Reward Points.........so a new guest customer could potentially checkout and use free earned credit that they didn't pay for.

So hopefully, this little custom modification will resolve the issue for us, because it won't display the Reward Points box to any "guest" to apply any points. Might not be the best workaround but I think it might accomplish what we need.

---

These changes will be considered or included in the new version when it is released publicly. Thanks!

Quote:

---

Originally Posted by Jeff_Mash

Just for documentation purposes, here is what I did.

I edited the tpl_modules_opc_credit_selections.php file, and added the following code after Line 47:

Code:

---

if(zen_in_guest_checkout() && !strcmp($ot_class,"Reward_points"))
                continue;

---

What this does is it removes the Reward Points block from being displayed on a Guest account. Again, the reason why this was necessary is because the guest account was accumulating Reward Points.........so a new guest customer could potentially checkout and use free earned credit that they didn't pay for.

So hopefully, this little custom modification will resolve the issue for us, because it won't display the Reward Points box to any "guest" to apply any points. Might not be the best workaround but I think it might accomplish what we need.

---

If OPC is working correctly, you should be able to do this with a change to the admin menu and not need to change any coding. The OPC Config menu has a section called Guest Checkout: Disallowed Credit Class Order-Totals

In that spot put: ot_gv,ot_reward_points

I've just updated my site to 157c and reward points is working nicely. There is just one little minor snag that is not affecting the operation of the site:

In the admin customers orders section, when viewing order details, the final summary of charges and credits appears twice. The first time reward point earned shows as 0 dollars, and the second time it shows with the correct number of reward points earned for that order.

I haven't definitely narrowed this down to the Reward Points module, but it seems a likely guess.

Attachment 19486

Hello everyone once the plugin is installed, on the checkout payment page, the amounts relating to the loyalty points are not calculated. What can affect? Thanks
Attachment 19502

Where can I find the Reward Points plugin for ZC 1.5.7? If there is a version for ZC 1.5.6c, that could work, too

Although the new Reward Points for 1.56c/1.57c module has not been funded there is an important correction to make here:

includes/modules/order_total/ot_reward_points_display.php

old:
$this->output[] = array('title' => $this->title . ':',
'text' => $reward_points,
'value' => 0);


new:
$this->output[] = array('title' => $this->title . ':',
'text' => $reward_points,
'value' => $reward_points);


This will allow Edit Orders 4.xx to 4.6.0 to see the Reward Points value as it will be recorded in the correct field in the database.

Reward Point Mode -> 1 (Reward Points are calculated on the Order Total or Subtotal)
Allow Redeem of Reward Points on Order Total or Subtotal -> set on Order Total

Let's say that 1 point = 1 $. I have 10 available reward points, that I decide to redeem at checkout. E.g.:

Sub-total: $50
Value of Redeemed Reward Points: -$10
Total: $40

Reward points earned: $reward_points=GetRewardPoints($order->products) --> 40 (the earned points are calculated against the order total, which already includes the redeemed points discount)

However, later on in the code:

Code:

---

if(isset($_SESSION['redeem_value']))
{
    $reward_points = $reward_points - ($GlobalRewardPointRatio * $_SESSION['redeem_value']);
}

---

In this case, $_SESSION['redeem_value'] = $10 (the value of the points that I redeemed), therefore $reward_points is now 40 - 10 = 30. Basically I'm earning 30 points instead of 40, because the redeem value is being subtracted twice.
The second part should not be necessary in this case, because the order total already includes the redeemed points discount. Am I missing something?

I've fully installed this plugin to my shop with no problems on the storefront or the backend. However I ran into the problem of opening the Catalog > Reward Points page. I'm wondering if my installation has gone wrong somewhere. I currently have zc157b.

Can anyone confirm this module is working with ZC 1.5.7 and OPC?

Any changes required?

thank you

Hi, I've run into a 500 fatal error on my site. I got this in my error log

PHP Code:

---

PHP Fatal error:  Unparenthesized `a ? b : c ? d : e` is not supported. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /website/url/admin/includes/functions/extra_functions/reward_points_functions.php on line 387 


---

I found this code around line 387

PHP Code:

---

{
    if($value==0)
     return TEXT_NO_NEW_ACCOUNT_AWARD;
    else
     if($value>0)
      return abs((int)$value).TEXT_NEW_ACCOUNT_EARNED_AWARD;
     else
      return abs((int)$value).TEXT_NEW_ACCOUNT_PENDING_AWARD;
} 


---

Quote:

---

Originally Posted by twitchtoo

These changes will be considered or included in the new version when it is released publicly. Thanks!

---

Any plans on updating this to 1.5.8? I'm slowly working through it but php is not my strongest subject. thanks

Quote:

---

Originally Posted by southshorepizza

Any plans on updating this to 1.5.8? I'm slowly working through it but php is not my strongest subject. thanks

---

how much did you get done?

Quote:

---

Originally Posted by mito0930

Hi, I've run into a 500 fatal error on my site. I got this in my error log

PHP Code:

---

PHP Fatal error:  Unparenthesized `a ? b : c ? d : e` is not supported. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /website/url/admin/includes/functions/extra_functions/reward_points_functions.php on line 387 


---

I found this code around line 387

PHP Code:

---

{
    if($value==0)
     return TEXT_NO_NEW_ACCOUNT_AWARD;
    else
     if($value>0)
      return abs((int)$value).TEXT_NEW_ACCOUNT_EARNED_AWARD;
     else
      return abs((int)$value).TEXT_NEW_ACCOUNT_PENDING_AWARD;
} 


---

---

replace the file /your-admin/includes/functions/extra_functions/reward_points_functions.php
with attached:

that got my admin working but front end has a error but I'll post the fixe when I have one.

replace the file /includes/functions/extra_functions/reward_points_functions.php
with attached: (do not mix the 2 files up)

that got my front-end working

cross fingers, so far other then the 2 files above, it all seems to be work as expected.

Also i did not do the admin order total file as it didn't seem like anything really happening, it was not showing point's so i left it.

ToDo - Need to see if it is showing the points used on a order and on the invoice.

This software has been abandoned for some time.
Unless you have (or are) a developer, you might want to consider migrating to Cindy's solution to this problem, Customer Loyalty Discount.

https://www.zen-cart.com/downloads.php?do=file&id=1917

Quote:

---

Originally Posted by swguy

This software has been abandoned for some time.
Unless you have (or are) a developer, you might want to consider migrating to Cindy's solution to this problem, Customer Loyalty Discount.

https://www.zen-cart.com/downloads.php?do=file&id=1917

---

I'll carry on tying to fix this one as customer loyalty discount is not what I'm looking for I need a points system a totally different type of system

OK. If you're skilled enough to take over support, that would be great; please upload your fixes periodically (monthly not daily) to the Plugin Library so others can benefit. Thanks.

Quote:

---

Originally Posted by swguy

OK. If you're skilled enough to take over support, that would be great; please upload your fixes periodically (monthly not daily) to the Plugin Library so others can benefit. Thanks.

---

I have decided as i really need a points system for the short time I will step my new store install back to ZC v1.5.7d to get a working store and then do a dev site with ZC v1.5.8a and rewrite a new points system with some new ideas, which will bring it in-line with what the big-boys are doing with points and rewards now days in eCommerce.

Thank you for posting. I need this as well. I have had zero luck so far. I'm excited that someone else is actually working on this.

Has anyone tried it on 1.5.8a?