Reward Points Module for ZC v13x

[Mariscrap]

Hi Paul, tysm for trying to help me.

I think is what I have in my status track (see the image above)

[geeker]

Thanks for answering my last question. I have another.

Is there a setting that will allow for fractional points, not rounded off? So points awarded can be 1.25 and points can be redeemed as well.

I am hoping there is a way other than going in and messing with the code.

Thanks in advance!

[countrycharm]

Thanks for answering my last question. I have another.

Is there a setting that will allow for fractional points, not rounded off? So points awarded can be 1.25 and points can be redeemed as well.

I am hoping there is a way other than going in and messing with the code.

Thanks in advance!

Short answer to your question is no. Why in the world would you want to give out fraction of points in the first place. That would be custom code. You will have to hire someone to rewrite the Reward Points module to do that.

[countrycharm]

Hi Paul, tysm for trying to help me.

I think is what I have in my status track (see the image above)

If they are not showing in the admin area then you have not installed Reward points right, or a file or files didn't upload all the way. Go back and check your installation of Reward Points.

[geeker]

Short answer to your question is no. Why in the world would you want to give out fraction of points in the first place. That would be custom code. You will have to hire someone to rewrite the Reward Points module to do that.

I figured it would be custom and I'm looking into it. We are using this as a "store credit" reward so customers are given 3% back on every purchase as store credit. It's what my boss wants to have so ... I will make it so. Thanks!

[countrycharm]

I figured it would be custom and I'm looking into it. We are using this as a "store credit" reward so customers are given 3% back on every purchase as store credit. It's what my boss wants to have so ... I will make it so. Thanks!

Why don't you try the Store Credits and Rewards Points Module. It might serve your purpose.
That module allows store owners to offer store credit to their customers. Credit can be manually set from the Zen Cart admin, or awarded to customers after each purchase by giving a percentage of their order total as store credits.

[geeker]

Thanks I will give that a shot as well. I have this mod installed and a few changes to the rounding functions and not casting a few values as int seem to be doing the trick.

[countrycharm]

Thanks I will give that a shot as well. I have this mod installed and a few changes to the rounding functions and not casting a few values as int seem to be doing the trick.

After you test it for a while maybe you can share what you did with the community just in case someone else needs to do the same thing.

[BlessIsaacola]

If anyone can help resolve this issue I'd greatly appreciate it. Just upgraded our rewards points today to 2.1b on Zen Cart 1.5.1 and I am getting the following error:

[06-Aug-2013 01:24:05 America/New_York] PHP Fatal 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 '11178''
				AND ((prp.scope_id=p.products_id AND prp.scope='2') 
				OR (p.pro' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute 
				FROM reward_master prp, products p, products_to_categories p2c 
				WHERE p.products_id='11178''
				AND p2c.products_id='11178''
				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; in /MASKED/includes/classes/db/mysql/query_factory.php on line 120

Thanks for your help!

[gilby]

If anyone can help resolve this issue I'd greatly appreciate it. Just upgraded our rewards points today to 2.1b on Zen Cart 1.5.1 and I am getting the following error:

[06-Aug-2013 01:24:05 America/New_York] PHP Fatal 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 '11178''
                AND ((prp.scope_id=p.products_id AND prp.scope='2') 
                OR (p.pro' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute 
                FROM reward_master prp, products p, products_to_categories p2c 
                WHERE p.products_id='11178'' <-problem here
                AND p2c.products_id='11178'' <- and here
                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; in /MASKED/includes/classes/db/mysql/query_factory.php on line 120

Thanks for your help!

You have extra single quotes (shown in red) which are causing problems in at least 2 places