Reward Points Module for ZC v13x

Quote:

---

Originally Posted by countrycharm

Another thing I would do is upgrade your Zen Cart version 1.3.8a. to the current version of Zen Cart 1.5.1. You are running and out dated version with all kinds of Security vulnerabilities. I can not emphasize enough about the Security vulnerabilities people have by running Zen Cart v1.3.8a.

---

Hi Countrycharm,

thanks for reply.
I created many screenshots of my current settings. Please take a look, and see if there is anything wrong with configuration,especially in admin/configuration/reward point.
Please download the pdf from here .

I cannot upgrade the zencart version, as I'm just responsible to install this mod for my client. He has many customizations done on this zencart version, so upgrading will be big exercise to perform

Appreciate your kind advise. Many thanks.

Regards,
Sky

Quote:

---

Originally Posted by skywalker826

Hi Countrycharm,

thanks for reply.
I created many screenshots of my current settings. Please take a look, and see if there is anything wrong with configuration,especially in admin/configuration/reward point.
Please download the pdf from here .

I cannot upgrade the zencart version, as I'm just responsible to install this mod for my client. He has many customizations done on this zencart version, so upgrading will be big exercise to perform

Appreciate your kind advise. Many thanks.

Regards,
Sky

---

Hi Sky,
I'm not trying to be mean about anything and please don't take it the wrong way.
You need to tell your client that he is putting all his customers and there information at risk using a out dated and unsupported Zen Cart version 1.3.8a with known Security vulnerabilities. This will be my last response because this module has been upgraded to work on zen cart version 1.3.9h and 1.5.1. It is not supported or advise to be use on outdated version of zen carts. I hope you understand.

Try setting your admin/configurations/Reward Points like so.
The admin/customers/Group Reward Redeem has to be set to 1.0000 not 0.1000

Attachment 11701

Quote:

---

Originally Posted by countrycharm

Hi Sky,
I'm not trying to be mean about anything and please don't take it the wrong way.
You need to tell your client that he is putting all his customers and there information at risk using a out dated and unsupported Zen Cart version 1.3.8a with known Security vulnerabilities. This will be my last response because this module has been upgraded to work on zen cart version 1.3.9h and 1.5.1. It is not supported or advise to be use on outdated version of zen carts. I hope you understand.

Try setting your admin/configurations/Reward Points like so.
The admin/customers/Group Reward Redeem has to be set to 1.0000 not 0.1000

Attachment 11701

---

Thanks so much. This fixes the issue with admin/customers/Group Reward Redeem set to 1.0000

Quote:

---

Originally Posted by skywalker826

I cannot upgrade the zencart version, as I'm just responsible to install this mod for my client. He has many customizations done on this zencart version, so upgrading will be big exercise to perform

---

Quote:

---

Originally Posted by countrycharm

Hi Sky,
I'm not trying to be mean about anything and please don't take it the wrong way.
You need to tell your client that he is putting all his customers and there information at risk using a out dated and unsupported Zen Cart version 1.3.8a with known Security vulnerabilities.

---

I agree with CountryCharm.. and at the risk of also sounding harsh, your client's "many customizations" is NOT a good reason to NOT upgrade his store from a version with KNOWN vulnerabilities and code that will STOP working should his webhost upgrade to PHP 5.3.x. You should AT LEAST inform him of this issue. If you cannot do the upgrade, then he should be aware of the issue so that he give some thought to seeking a resource who can.

Now before you think we're being overly hysterical about this let me give you insight into one of the many possible vulnerabilities with the 1.3.8 codebase. One which affected two client's of mine who decided to WAIT to upgrade versus upgrading when I informed them of the risks of continuing on with 1.3.8. There is a hack in which the store's PayPal settings can be HIJACKED allowing the hacker to modify the PayPal payment module to direct funds from your client's sales into the hacker's PayPal account.. On the surface this particular hack gives no appearance that anything is wrong.. Sales will continue unil your client see sales in their store and no corresponding PayPal payment.. It could take days before they notice this.. and here's the kicker.. Your client will have NO RECOURSE with PayPal to get the funds returned to them.. They then will have the unenviable task of either honoring the sales and taking a loss or telling their clients that their store was hacked and to inform the clients that they have to fight with PayPal to get their money back (which of course will RUIN their reputation)..

Now in the case of my two clients, they were BOTH lucky.. One luckily caught the hack as soon as the PayPal change was made BEFORE any sales were processed. The other didn't catch it until three sales had gone through. She decided to eat the loss and fulfill the orders.. She worked with PayPals fraud unit, but has no prayer of ever seeing her money returned.

The moral of the story: Do your due diligence, and inform your client of the vulnerable state their store is in.. If they want to then risk not upgrading to avoid paying for an upgrade, then that is on them. If the issue is that you feel that the upgrade task may be over your head, then that is a different matter altogether, and one that that you need to be honest with your client about so they can make proper decisions for their business..

Hi,

I'm using Zen Cart 1.5.1. My Reward Points system seems to work OK so thank you to an author of this great free module.
I was checking my logs directory and came across this error:

Quote:

---

[11-Jan-2013 15:02:40 Europe/London] 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 '463''
AND ((prp.scope_id=p.products_id AND prp.scope='2')
OR (p.produ' 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='463''
AND p2c.products_id='463''
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 /home/beautyst/public_html/includes/classes/db/mysql/query_factory.php on line 120

---

Can anyone point in the right direction. I'm not sure where to start:no:

Kind Regards
Damian K.

Quote:

---

Originally Posted by damiankrzyz

Hi,

I'm using Zen Cart 1.5.1. My Reward Points system seems to work OK so thank you to an author of this great free module.
I was checking my logs directory and came across this error:



Can anyone point in the right direction. I'm not sure where to start:no:

Kind Regards
Damian K.

---

I can see son double quotes here

PHP Code:

---

WHERE p.products_id='463''
                AND p2c.products_id='463'' 


---

I don't think that is right

i just installed but i couldnt find how to edit the redeem ratio.

I only see this in my order total moduleAttachment 11806

hope someone can help me :)

Quote:

---

Originally Posted by juneloweelyn

i just installed but i couldnt find how to edit the redeem ratio.

I only see this in my order total moduleAttachment 11806

hope someone can help me :)

---

You have to go to admin/configurations/Reward Points and set up all setting to your liking.

Quote:

---

Originally Posted by juneloweelyn

i just installed but i couldnt find how to edit the redeem ratio.

I only see this in my order total moduleAttachment 11806

hope someone can help me :)

---

Quote:

---

Originally Posted by countrycharm

You have to go to admin/configurations/Reward Points and set up all setting to your liking.

---

Which is explained in the readme file for this module..

Quote:

---

Originally Posted by DivaVocals

Which is explained in the readme file for this module..

---

I already did :) but i couldnt find where to adjust the redeem ratio.
in the read me, it says i can adjust it in modules >order total > rewards point

But i cant seem to find it, hope u can help me