Reward Point Mod beta now available

[Rasyr]

uploaded the files and can't get into admin now....this is the error...

<DIV class=systemError>1146 Table 'villscom_zencart.reward_status_track' doesn't exist
in:
[SELECT ph.*, o.orders_status FROM reward_status_track ph, orders o WHERE ph.orders_id=o.orders_id AND ph.date

That sounds like you need to run the sql code -- if you cannot do it from Admin, do you have access to an interface of some sort for the DB like PHPMyAdmin?

[Crzipilot]

Strange, it's fixed now. yes it was looking for the sql to be run it seems, though, it wouldn't let me log into admin. All I had done was copy the files over into zencart. Anyways, I got the sql to run, and everything is normal now....

[fiji]

Andrew, nice work!

I am back to my office today and find you already updated your project.
I test it on local and all working, very nice!!

The only problem was I got an error message in the IE staus when I click the "Customer Reward Points Admin" page. it's show:
line:18
error:'null' is not a project
website :http://127.0.0.1/138a/admin/customers_reward_points.php

This page is still working, just list all customers there. no matter they have pending points or not.

I set Max Transactions to Display in Customer Admin = 20,
so in the "Customer Reward Points Admin", should be only display 20 "pending" customer per page?
But I got all customers showed in that page. if i have 1000+ customer, that will be a long list.

I think maybe that error make this page not working properly.
Someone can confirm this point? or just I have this problem?

again, thank you very much.

[fiji]

another point:

In the check out, the "Value of Redeemed Reward Points" should be "subtraction sign", if can be red, that's better.

otherwise, customer will confusing.
I attach a picture here.

[fiji]

One Bug:
Before checking out, there is 100points in the cart, after paying via Paypal, the order is made successful, but there is nothing in the pending point. that means pay via paypal won't get the points.

anyone have such problem?

[hem]

uploaded the files and can't get into admin now....this is the error...

<DIV class=systemError>1146 Table 'villscom_zencart.reward_status_track' doesn't exist
in:
[SELECT ph.*, o.orders_status FROM reward_status_track ph, orders o WHERE ph.orders_id=o.orders_id AND ph.date

Read the instructions in the readme.txt regarding the renaming of the reward_points_history table.

[hem]

oh!! that brings up a question, before I attempt to install.

How does this interact with table prefixes? For example, if all of my store tables use the prefix "zen_" before the tables, will the new tables have that prefix? Will the code be looking for the tables to have that prefix?

Yes, RP uses the same prefixes for it's tables as the rest of ZenCart.

[hem]

One Bug:
Before checking out, there is 100points in the cart, after paying via Paypal, the order is made successful, but there is nothing in the pending point. that means pay via paypal won't get the points.

anyone have such problem?

Does the customer receive an email informing them of the order?

[hem]

got a request

on the user CP, can it be made so they see the amoutn of points they have PLUS the value of it, liek they get on the checkou page

at this moment just shows the total amount of points, not it's value

Added to wishlist

[hem]

hehe... got another request for the future features...

New Member award -- i.e. a new member joins and he gets xx points. (kinda like the new member coupon or GC). ;D

Added to wishlist