Reward Points Module for ZC v13x

[hem]

Hem

Before installing does this update resolve Google Checkout issues also?

Thanks
Ken

Paws4Deals

Not yet Ken, though I will have an updated Google Checkout/RP mod tomorrow if you want to give it a test drive. Google Checkout does not use notifiers which RP hangs on to do the point reward so it means an addition to the Google Checkout core code- I did try other methods (which worked badly) and I have posted a request on the Google Checkout mod site for the developers to add notifiers.

[kenwahl]

Not yet Ken, though I will have an updated Google Checkout/RP mod tomorrow if you want to give it a test drive. Google Checkout does not use notifiers which RP hangs on to do the point reward so it means an addition to the Google Checkout core code- I did try other methods (which worked badly) and I have posted a request on the Google Checkout mod site for the developers to add notifiers.

Thanks

I'll test it as soon as the update is posted.

Ken
Paws4Deals

[Einstin]

I've grabbed the rewards class and installed it as well. Should find out shortly if it will post the pending points to the customer account or not.

I also grabbed the updated version of the customer_reward_points.php to try as well. Would it take too much to add page navigation to this?

Also, congrats on a GREAT mod!
cheers!

[Einstin]

Andrew,
Tried the new class files posted at http://www.zen-cart.com/forum/showpo...&postcount=413 and had an order come in last night using PayPal IPN and was an instant payment transaction type unique. No points were added to the customers pending balance. No errors were shown or logged anywhere that I could find. Had to add the points manually for the customer this morning.

ZC Version 1.3.7
PHP Version 4.3.9
MySQL Version 4.1.20
Apache 2.0.52

[nsgowner]

I recently installed this module and when I view the following admin pages:

Customer Reward Points Admin

1146 Table 'nos0825310485094.zen_reward_customer_points' doesn't exist
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_group_pricing, r.pending_points, r.reward_points, gp.group_name, rm.redeem_ratio from zen_customers as c LEFT JOIN (zen_reward_customer_points as r) ON (r.customers_id=c.customers_id) LEFT JOIN(zen_group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) LEFT JOIN(zen_reward_master as rm) ON ((c.customers_group_pricing!=0 AND rm.scope=3 AND rm.scope_id=c.customers_group_pricing) OR (c.customers_group_pricing=0 AND rm.scope=0 AND rm.scope_id=0)) ORDER BY c.customers_lastname;]
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.

Reward Points - Top

1146 Table 'nos0825310485094.zen_reward_master' doesn't exist
in:
[SELECT * FROM zen_reward_master WHERE scope='0' AND scope_id='0';]
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 must have done something wrong when I installed the mod.

[hem]

Andrew,
Tried the new class files posted at http://www.zen-cart.com/forum/showpo...&postcount=413 and had an order come in last night using PayPal IPN and was an instant payment transaction type unique. No points were added to the customers pending balance. No errors were shown or logged anywhere that I could find. Had to add the points manually for the customer this morning.

ZC Version 1.3.7
PHP Version 4.3.9
MySQL Version 4.1.20
Apache 2.0.52

Looks like I'm going to smack the IPN module with a big stick

[CJPinder]

Looks like I'm going to smack the IPN module with a big stick

I don't think it uses any of the observer/notifiers so you might have to manually add something into the IPN handler file. You might be able to hook into the orders class but that is also a bit short on notifiers. May well have to be a core file change to really nail it down.

Regards,
Christian.

[hem]

I don't think it uses any of the observer/notifiers so you might have to manually add something into the IPN handler file. You might be able to hook into the orders class but that is also a bit short on notifiers. May well have to be a core file change to really nail it down.

Regards,
Christian.

The IPN mod does use notifiers though (Google Checkout doesn't). All I can think is that the mod does not call any user created classes. The problem is that debugging IPN is close to impossible.

I think you're right though, it's looking like there's no choice but to hack the core code.

[excalibur]

Andrew,
Tried the new class files posted at http://www.zen-cart.com/forum/showpo...&postcount=413 and had an order come in last night using PayPal IPN and was an instant payment transaction type unique. No points were added to the customers pending balance. No errors were shown or logged anywhere that I could find. Had to add the points manually for the customer this morning.

Same here although only happened on one sale as the otherts just sat in pending.