Reward Points Module for ZC v13x

[beadfaery]

Just updated to your latest version and had a very quick play and it seems good It even rewards points for my cheapy items, where it wasn't before.
Thanks AGAIN for the work you've put into this, Andrew! It was already a great mod IMO and now it's even better

actually....I've just noticed that if I redeem a Gift Cert, it doesn't take anything off the reward points?? It works if reward points are redeemed.


Question?? Was I supposed to uninstall the last version or sql first?

[andy]

Hi Andy
does this version fix the payPal issue?

thanks

Andy

[beadfaery]

actually....I've just noticed that if I redeem a Gift Cert, it doesn't take anything off the reward points?? It works if reward points are redeemed.


Question?? Was I supposed to uninstall the last version or sql first?

Ignore my last post figured it out.....sorry - it's late here and I'm half asleep

[hem]

Hi Andy
does this version fix the payPal issue?

thanks

Andy

It might- Check it out and let me know how you get on.

[Asgoroth]

I have an issue.. I upgraded from 1.13a to 1.20a

Admin->Custom->Reward Points list the users. I am able to sort the list and edit any listed user without trouble.

If I enter a 'Search' string the results are returned. Selecting any of the results listed from the search results in a screen refresh with a default user listing and the following error listed at the bottom of the page.

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
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I am able to select any of the listed users from this screen and edit them and I can also select a new sort order without additional errors. So, this error only seems to happen when a sort is used.

[hem]

I have an issue.. I upgraded from 1.13a to 1.20a

Admin->Custom->Reward Points list the users. I am able to sort the list and edit any listed user without trouble.

If I enter a 'Search' string the results are returned. Selecting any of the results listed from the search results in a screen refresh with a default user listing and the following error listed at the bottom of the page.



I am able to select any of the listed users from this screen and edit them and I can also select a new sort order without additional errors. So, this error only seems to happen when a sort is used.

I cannot reproduce this. When you get the error what's the exact information in your browser address bar?

[urbdistrib]

Has anyone gotten the Reward Points to work with Google Checkout?

I have tried everything and cannot get the reward points to register when customers checkout with Google. I finally had to just remove the reward points module. I really would like to add it if anyone can give me an idea of how to get it to work with Google. I added the zip file that should of fixed it however it didn't.

Any help would be so appreciated.

http://www.urbdistributing.net

[Asgoroth]

OK, additional info..

1) The address bar shows the following after clicking on a name that has been displayed from a search.

http://www.site.org/cart/admin/customers_reward_points.php?id=1&action=edit

2) I have removed the mod and reinstalled
a) Manual removal of all files
b) SQL patch uninstall.sql
c) install

3) Also, when a listing is displayed, there are only 40 names being listed.

4) I have reverted to a 1.13a install and it is working.

[kenwahl]

Has anyone gotten the Reward Points to work with Google Checkout?

I have tried everything and cannot get the reward points to register when customers checkout with Google. I finally had to just remove the reward points module. I really would like to add it if anyone can give me an idea of how to get it to work with Google. I added the zip file that should of fixed it however it didn't.

Any help would be so appreciated.

http://www.urbdistributing.net

I am using Google Checkout and the Reward Points are working with it. Did you copy googlecheckout.php (in the root folder of the verson 1.20 zip file) to /includes/modules/payment/googlecheckout.php . This should be the only file that effects Google Checkout.

Ken

Paws4Deals.com

[GG01]

I am getting an error:

1146 Table 'mycustom_zc1.zen_reward_master' doesn't exist
in: [SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute FROM zen_reward_master prp, zen_products p, zen_products_to_categories p2c WHERE p.products_id='20' AND p2c.products_id='20' 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;]

Also Admin, Configuration, Reward Points does not exist in Zen Cart Admin screen.

Where did I go wrong?? Can anyone please help me??