Reward Points Module for ZC v13x

[hem]

Is it complex??? I hadn't noticed

[MeltDown]

Is it complex??? I hadn't noticed

Or is it simple in an elaborately intricate and labyrinthine way?

[kenwahl]

I'm having a problem with this module that I haven't seen anyone post here. My site accepts both Authorize.net and Google Checkout. If they try to checkout via Google Checkout they are being billed for the rewards points they earn on that purchase. If they earn 10 rewards points for the purchase they are billed $10 that shows up in google checkout as a product. The module works fine via Authorize.net.

I've included a picture of it in google checkout.



Thanks
Ken

[pinetreecandles]

Andy-

Here is some good news, at least for those of us who use 2checkout. I just ran a live test using 2checkout and everything worked as it should. Confirmation emails were sent and received and points went to pending. When I updated the order status, the points went to earned as they should.

I then made a purchase using points as well as credit card through 2checkout and again, every went as it should. Emails received and earned points removed as well as new points earned. Worked like a charm

The next test I'm going to do is pay with a paypal account via 2checkout and see what happens. A new feature they have is paying with your paypal account through 2checkout. I will report back with my results after.

Sorry about the delay in reporting the results. Paypal seems to work with the mod when used through 2checkout. All points are transfered properly and notices are received for admin as well as customer. It's also working when using points to purchase an item.

Guess I will remove paypal option and just make a note that paypal accounts can be used for payment via 2checkout also.

[kenwahl]

Here is some added information on the errors with google checkout as described in prior post.

If I don't enable Google Checkout all works fine out of the box. If I enable google checkout I get the following error on the login page and the google checkout button doesn't show up or new sign up fields. Only the login for existing customers shows up:

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 ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricin' at line 5
in:
[SELECT redeem_ratio FROM zen_reward_master prp, zen_customers as c LEFT JOIN(zen_group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) WHERE c.customers_id= AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;]



If I edit the file reward_points_functions.php as follows the google checkout button shows up and all is well except when you click on google checkout you get the page in the picture shown in the prior post with it charging $10 for the 10 points earned. Normal checkout via authorize.net works fine either way.

original reward_points_functions.php:

function GetRedeemRatio($customers_id)
{
global $db;

$sql = "SELECT redeem_ratio
FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_CUSTOMERS." as c
LEFT JOIN(".TABLE_GROUP_PRICING." as gp) ON (gp.group_id=c.customers_group_pricing)
WHERE c.customers_id=".$customers_id."
AND ((prp.scope_id=".$customers_id." AND prp.scope=".SCOPE_CUSTOMER.")
OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=".SCOPE_GROUP.")
OR (prp.scope=".SCOPE_GLOBAL."))
ORDER BY prp.scope DESC LIMIT 1;";

$result=$db->Execute($sql);

changed reward_points_functions.php:

function GetRedeemRatio($customers_id)
{
global $db;

$sql = "SELECT redeem_ratio
FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_CUSTOMERS." as c
LEFT JOIN(".TABLE_GROUP_PRICING." as gp) ON (gp.group_id=c.customers_group_pricing)
WHERE c.customers_id='" . $customers_id . "'
AND ((prp.scope_id='" . $customers_id . "' AND prp.scope=".SCOPE_CUSTOMER.")
OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=".SCOPE_GROUP.")
OR (prp.scope=".SCOPE_GLOBAL."))
ORDER BY prp.scope DESC LIMIT 1;";

$result=$db->Execute($sql);

[MeltDown]

Does this mod work with attributes?

Thanks

[pinetreecandles]

Does this mod work with attributes?

Thanks

I don't think so, but I think I read on one of his posts that it's on his list of things to do.

[MeltDown]

I don't think so, but I think I read on one of his posts that it's on his list of things to do.

Good, because it wasn't working with one of my few attribute-based products and I was hoping it wasn't a glitch.

[hem]

Good, because it wasn't working with one of my few attribute-based products and I was hoping it wasn't a glitch.

I have coded in the Attributes function but was not going to go live with it until I resolved the PayPal problem...

One question to those who have been testing the mod with PayPal- Am I right in thinking that the problem only occurs with PayPal IPN? The other two PayPal methods should work okay.

[hem]

Here is some added information on the errors with google checkout as described in prior post.

If I don't enable Google Checkout all works fine out of the box. If I enable google checkout I get the following error on the login page and the google checkout button doesn't show up or new sign up fields. Only the login for existing customers shows up:

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 ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricin' at line 5
in:
[SELECT redeem_ratio FROM zen_reward_master prp, zen_customers as c LEFT JOIN(zen_group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) WHERE c.customers_id= AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;]



If I edit the file reward_points_functions.php as follows the google checkout button shows up and all is well except when you click on google checkout you get the page in the picture shown in the prior post with it charging $10 for the 10 points earned. Normal checkout via authorize.net works fine either way.

original reward_points_functions.php:

function GetRedeemRatio($customers_id)
{
global $db;

$sql = "SELECT redeem_ratio
FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_CUSTOMERS." as c
LEFT JOIN(".TABLE_GROUP_PRICING." as gp) ON (gp.group_id=c.customers_group_pricing)
WHERE c.customers_id=".$customers_id."
AND ((prp.scope_id=".$customers_id." AND prp.scope=".SCOPE_CUSTOMER.")
OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=".SCOPE_GROUP.")
OR (prp.scope=".SCOPE_GLOBAL."))
ORDER BY prp.scope DESC LIMIT 1;";

$result=$db->Execute($sql);

changed reward_points_functions.php:

function GetRedeemRatio($customers_id)
{
global $db;

$sql = "SELECT redeem_ratio
FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_CUSTOMERS." as c
LEFT JOIN(".TABLE_GROUP_PRICING." as gp) ON (gp.group_id=c.customers_group_pricing)
WHERE c.customers_id='" . $customers_id . "'
AND ((prp.scope_id='" . $customers_id . "' AND prp.scope=".SCOPE_CUSTOMER.")
OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=".SCOPE_GROUP.")
OR (prp.scope=".SCOPE_GLOBAL."))
ORDER BY prp.scope DESC LIMIT 1;";

$result=$db->Execute($sql);

That will get past the problem but it those not explain how the function got called without a Customer ID. Even when getting the Global Redeem value (Scope=0) 0 should still get passed as the Scope ID.