Reward Points Module for ZC v13x

[prettyeyes1]

Here are my settings under Configuration/Reward Points:

Reward Point Mode 0
Reward Point Sidebox Display 0
Reward Point Status Track Simple
Reward Point Sunrise Period 0
Reward Point Redeem Minimum 0
Reward Point Redeem Maximum 0
Reward Point Rounding 0.0
Max Transactions to Display in Customer Admin 12
Delete Old Reward Transactions Period 90
Adjust Reward Points for Sales/Specials 1
Allow Reward Points on Free Products 0
Allow Redeem of Reward Points on Order Total or Subtotal 1
Set Minimum Order Value to Redeem Points Against 0
Limit Maximum Customers on Listings 50
Display Products Reward Points When Zero 1
Set New Account Reward Points 5 points added to earned
Advanced Reward Point Calculation Rules Advanced Rules Enabled

Nobody has pending points. I just had another order and no points were added this time.

[countrycharm]

Alright, dug into this the subject a little deeper today. Looks like Zen Cart 1.5.x out of box does not allow one to view orders in the admin with a currency other than the store default... I remember a discussion of this somewhere on the forums in the past, but do not remember what was decided...

So your change should not make a difference for the majority of users of Zen Cart 1.5.x (only those who may have for some reason wanted to see localized pricing for a different country in the admin and made changes)... I still believe it would be even better to at least add some conditional code to check which "order total" module (in "/admin/orders.php") is being displayed and ONLY skip the format function on the "Reward Points display" order total module... Or replace the "Reward Points display" order total module completely.


I currently have many other ongoing projects, so will not be able to spend any time on this project. Just was browsing this thread (have poked in here from time to time since it crossed my path) and decided to share some thoughts.

Thank you for sharing some of your thoughts they are well appreciated for sure. If you ever get some extra time feel fee to do some more poking.

[izar74]

The configuration seems fine.
The last thing i can ask is if the modules under Modules/Order Total are installed, expecially:
Reward points
and one between Rewards Point earned and Rewards Points Tiered Discont

If it's all installed, I suggest that You uninstall and reinstall the module from scratch.
After setting all the way you want check if errors log are generated.
If not and hte module still wont work report the following thing:

Zencart version
If You have other modules installed othen then reward point, expecially if they modify total order
PHP version
Mysql version

[izar74]

Alright, dug into this the subject a little deeper today. Looks like Zen Cart 1.5.x out of box does not allow one to view orders in the admin with a currency other than the store default... I remember a discussion of this somewhere on the forums in the past, but do not remember what was decided...
So your change should not make a difference for the majority of users of Zen Cart 1.5.x (only those who may have for some reason wanted to see localized pricing for a different country in the admin and made changes)... I still believe it would be even better to at least add some conditional code to check which "order total" module (in "/admin/orders.php") is being displayed and ONLY skip the format function on the "Reward Points display" order total module... Or replace the "Reward Points display" order total module completely.

I currently have many other ongoing projects, so will not be able to spend any time on this project. Just was browsing this thread (have poked in here from time to time since it crossed my path) and decided to share some thoughts.

Thanks so muck for the information, as already said feel free to poke, It's always a pleasure when people share knowledge ;-)

[countrycharm]

Thanks so muck for the information, as already said feel free to poke, It's always a pleasure when people share knowledge ;-)

Don't think your not appreciated you are. It's Always good to have 2 or 3 heads working in the same thread to accomplish new and improved things.

[DivaVocals]

Thank you for sharing some of your thoughts they are well appreciated for sure. If you ever get some extra time feel fee to do some more poking.

I'm sure lhungil will if and when one of his clients requires Rewards Points.. Personally all of my contributions are linked to something I've done for a client versus the "just for the heck of it" kinds of contributions..

[izar74]

I'm sure lhungil will if and when one of his clients requires Rewards Points.. Personally all of my contributions are linked to something I've done for a client versus the "just for the heck of it" kinds of contributions..

I'm hoping very strongly that one of your clients require the integration of this module and Edit Order

Just kidding . The only thing that I would welcome it is that if you see an error in the codes i posted that could compromise the functionality of Edit Order please advise

[southshorepizza]

Rewards point module broke last night. I tried reinstalling it. now I get the follow error log:
[26-Nov-2013 10:41:19] StoreRewardPoints called but SESSION['REWARD_POINTS_EARNED'] not found

I am on Zen-Cart 1.5.1 Latest rewards points module. It was working great. Not sure what happened. I have reinstalled a fresh copy overwriting the files. I have tried reinstalling from my backup site. Both have not fixed the problem. They did change the error log from:
[25-Nov-2013 22:54:49] 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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1 :: SELECT rewards_id, orders_id, date, reward_points, status FROM zen_reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12; in /home4/w57dsjmm/public_html/order/includes/classes/db/mysql/query_factory.php on line 120

But just to be clear my current error log is:
[26-Nov-2013 10:41:19] StoreRewardPoints called but SESSION['REWARD_POINTS_EARNED'] not found

Thank for the help. It worked great since October 10th. So I started advertising it yesterday. Of course it stopped working hours later.

[southshorepizza]

I went into admin and uninstalled the modules and then reinstalled. I did a test order and it seems to work. Any ideas what happened and how to avoid?

Although it applied the points to points pending so I could award them I also generated an error log.
[26-Nov-2013 11:18:06] 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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1 :: SELECT rewards_id, orders_id, date, reward_points, status FROM zen_reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12; in /home4/w57dsjmm/public_html/order/includes/classes/db/mysql/query_factory.php on line 120

[solo_400]

Today I have observed an order where points was added to total order value . Do you know if there is a bug or something to check ?

thx