Reward Points Module for ZC v13x

[opengrave]

You have an empty first line somewhere in one of your ZenCart files. Check this article for info on how to fix this: https://www.zen-cart.com/tutorials/index.php?article=87

I looked at this file and there are no extra lines.



If anyone that has set this up prior, I would be willing to pay to have my set up completed. The errors I'm receiving are all listed above. Please, PM me if you're willing.

[hem]

Hi Andrew,

I am new and quite rookie regarding SQL. I have a new -- and working -- installation of zen cart. What is the exact script that I need to type into the "Install SQL Patches" window in order to run the 'new.sql' file?

Thank you much
Jay

Where it says "Upload file" click on the browse button and select the file from there.

[mipavluk]

Hi Andrew

In Customers/Reward Points

I only can see my first 40 customers to edit it and give them manually their points.

If I make a search, for example, looking the customer 41, I can edit it, I obtain this 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 zen_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.

can you please help me?

thanks

[hem]

Hi Andrew

In Customers/Reward Points

I only can see my first 40 customers to edit it and give them manually their points.

If I make a search, for example, looking the customer 41, I can edit it, I obtain this 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 zen_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.

can you please help me?

thanks

That issue was sorted out in v1.22- http://www.omnicia.com/Zencart%20Rew...s%20Module.zip

[mipavluk]

I need execute the update.sql
and update all the files?

[hem]

I need execute the update.sql
and update all the files?

Look for the previous post here that just shows the update and execute that.

[zhengda]

Hi Hem.
I am new to zencart and i really like this module of yours. However i seems to be unable to install this module into my zencart. So i was wondering is there any specific steps to install this module successfully? Help would be greatly appreciated. Thank you

[djjase]

Hi,

I have checked every where - the php files have the correct wording, I have copied all the files over again and I still get this.

Reward Points You may click to redeem any collected Reward Points. Your redeemed points will be applied to the total and reflected in your cart after to click continue.

Current Reward Points:
90 CUSTOMER_EARNED_POINT_TAG
Minimum required to redeem:
1000 MINIMUM_POINT_LEVEL_TAG

Value of Redeemed Reward Points:
AU$0.90

Redeem Reward Points:
Not enough points to redeem.

This is from the reward_points.php file:

<?php
define('BOX_REWARD_POINTS', 'Reward Points');

define('PRODUCT_REWARD_POINT_TAG', 'reward points');
define('REWARD_POINTS_IN_CART_TAG', 'reward points in cart');
define('CUSTOMER_EARNED_POINT_TAG', 'points earned');
define('CUSTOMER_PENDING_POINT_TAG', 'points pending');
define('MINIMUM_POINT_LEVEL_TAG', 'points minimum');
define('MAXIMUM_POINT_LEVEL_TAG', 'points maximum');
define('CUSTOMER_TOTAL_POINT_TAG', 'points total');
define('NO_REWARD_POINTS_IN_CART_TAG','No points earned yet on current order.');
define('CUSTOMER_NOT_LOGGED_IN_TAG','Log in to see how many reward points you have already earned');
define('REWARD_POINT_TITLE','Reward Points');
define('REWARD_POINT_PROMPT','Total Reward Points: ');
?>

[hem]

Hi,

I have checked every where - the php files have the correct wording, I have copied all the files over again and I still get this.

Reward Points You may click to redeem any collected Reward Points. Your redeemed points will be applied to the total and reflected in your cart after to click continue.

Current Reward Points:
90 CUSTOMER_EARNED_POINT_TAG
Minimum required to redeem:
1000 MINIMUM_POINT_LEVEL_TAG

Value of Redeemed Reward Points:
AU$0.90

Redeem Reward Points:
Not enough points to redeem.

This is from the reward_points.php file:

<?php
define('BOX_REWARD_POINTS', 'Reward Points');

define('PRODUCT_REWARD_POINT_TAG', 'reward points');
define('REWARD_POINTS_IN_CART_TAG', 'reward points in cart');
define('CUSTOMER_EARNED_POINT_TAG', 'points earned');
define('CUSTOMER_PENDING_POINT_TAG', 'points pending');
define('MINIMUM_POINT_LEVEL_TAG', 'points minimum');
define('MAXIMUM_POINT_LEVEL_TAG', 'points maximum');
define('CUSTOMER_TOTAL_POINT_TAG', 'points total');
define('NO_REWARD_POINTS_IN_CART_TAG','No points earned yet on current order.');
define('CUSTOMER_NOT_LOGGED_IN_TAG','Log in to see how many reward points you have already earned');
define('REWARD_POINT_TITLE','Reward Points');
define('REWARD_POINT_PROMPT','Total Reward Points: ');
?>

Did you try the Reward Point Diagnostic? It would appear that the file is in the wrong location.

[hem]

Hi Hem.
I am new to zencart and i really like this module of yours. However i seems to be unable to install this module into my zencart. So i was wondering is there any specific steps to install this module successfully? Help would be greatly appreciated. Thank you

Just follow the steps in the readme.txt file- It's in the root of the zip file.