Reward Points Module for ZC v13x

[hem]

That is a good start. However, that appears to simply not display if they are not greater then 0. The problem looks to be much deeper, as a purchase made on an item with a negative reward displayed post negative points to the customer.

The new version will not return any reward points less than zero. The issue is with rounding down of values that have 0 reward points.

[Asgoroth]

The new version will not return any reward points less than zero. The issue is with rounding down of values that have 0 reward points.

Outstanding. I await the release. Thank you for your efforts.

[LissaE]

Hey Andrew....I just came across a problem because it is the first time I have tried to do this LOL

I am running a contest where each entry is to be awarded some reward points, and when I do a search of the customer (that bit's fine lol) and click the Edit button from the search results I get this:

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 tried installing the update.sql and nada, still get the error....any ideas?

[LissaE]

Just a not that I have made a temporary workaround by increasing the list limit to 150 to enable me to get to the customer I needed for now LOL

[hem]

Hey Andrew....I just came across a problem because it is the first time I have tried to do this LOL

I am running a contest where each entry is to be awarded some reward points, and when I do a search of the customer (that bit's fine lol) and click the Edit button from the search results I get this:

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 tried installing the update.sql and nada, still get the error....any ideas?

That's fixed in v1.21a

[LissaE]

Oops....guess I should upgrade then eh? LOL

[LissaE]

Ok, upgraded LOL and WOW, love the alphabetical listing options! Thanx for all your hard work on this awesome mod =D