Reward Points Module for ZC v13x

beadfaery:

Just updated to your latest version and had a very quick play and it seems good :clap: 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 :bigups: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?

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 :blush: figured it out.....sorry - it's late here and I'm half asleep :dontgetit

andy:

Hi Andy
does this version fix the payPal issue?

thanks

Andy

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

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.

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.

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?

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

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.

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

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

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?? :cry:

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?? :cry:

What version did you upgrade from??? Plus did you follow the instructions in the readme.txt regarding the rename???

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.

Strange- Nothing has changed in that file between the two versions. Also the code you posted shows the customer_id being passed.

Hi
Ive installed the latest version, using a credit card, no points are added to the customer accounts or set as pending.

When it go into customers>reward points> search on my test user, and try to edit to allow points to be added manually i get this sql 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
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.

any idea's why this is happening, the first version worked fine

thanks

Andy

sorry to post agin, but cant edit the above post.

When i ran the db update.sql, i got errors, so i then ran the uninstall.sql and removed all the tables and then installed the new.sql with no errors, not sure if this has anything to do with the problem.

thanks

Andy

Hello Andy,

I have upgraded to the latest version, and I get this on the shopping cart page, in the Reward Points shopping cart and also on the product page where it used to show reward points value:-

Warning: Missing argument 2 for zen_round() in /home/gemtree/public_html/includes/functions/functions_general.php on line 176

I noticed nobody else reported it, so is it a clash with another module? I have turned it off for now.

HeathenMagic:

Hello Andy,

I have upgraded to the latest version, and I get this on the shopping cart page, in the Reward Points shopping cart and also on the product page where it used to show reward points value:-

I noticed nobody else reported it, so is it a clash with another module? I have turned it off for now.

What version of Zencart are you running?

Hi Andy
zencart version is 3.17

ive unistalled the lastest version, installed version 1-13a again and its working fine

I installed it to see if paypal was working, but never got that far

thanks

Andy

I just reinstalled the old version and the problem goes. It is definitely a file from the includes/ folder that does (new version) it. I have tried debugging tools, but nothing comes through.

I am using zencart 1.38a (sorry should have put that)

I love the module, and would also like to know if you accept donations at all?

Regards,

James :smile:

Hello Andy,

It is this file that does it:-

includes/functions/extra_functions/reward_points_functions.php

It yields those error messages. I have quite a few mods, would it be a clash? But the 1.13a is fine, so not sure.

James

HeathenMagic:

Hello Andy,

It is this file that does it:-

includes/functions/extra_functions/reward_points_functions.php

It yields those error messages. I have quite a few mods, would it be a clash? But the 1.13a is fine, so not sure.

James

Thanks for the heads up James- I'm going to do a compare between the two versions and try and get a handle on what's wrong.