Reward Points Module for ZC v13x

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! :clap:
cheers!

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

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

Customer Reward Points Admin

Quote:

---

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

Quote:

---

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.:frusty:

Quote:

---

Originally Posted by Boogy

Thanks for this, everything is working great accept for 1 thing. I have "Adjust Reward Points for Sales/Specials" set up so that you will earn points based on whatever the sale price is, not the regular price. This is confirmed when you click on an item. For example, if a product is on sale for $17.00, marked down from $20.00 it shows in red text that you will earn 170 points. This part is working correctly. However, on Step 2 of the check-out page it shows that you will earn 200 points. I also have "Allow Redeem of Reward Points on Order Total or Subtotal" set to subtotal, so that you won't earn points on S$H fees.

Am I missing another setting that needs to be fixed?

---

Any updates?

Here's a Reward Point Diagnostic. Unzip the attached zip file to the root of your zencart folder and then fire up your browser and enter the following address: [your site URL]/rpd.php.

This will check that all the files, folders, tables and records are correct for RP to run. Look for any items highlighted in red. You can delete rpd.php and rpd.xml once everything is running correctly.

http://www.zen-cart.com/forum/attach...1&d=1221258768

Quote:

---

Originally Posted by HeathenMagic

I think this is a brilliant module. I will send a few pints to you soon, and I encourage other users to do the same.

I had a question. I wondered if there is a way to extract a customers reward point total, for it to show up in a newsletter for that respective person.

Regards,

Heathenmagic:smile:

---

IT should be possible. I will check to see how I can make it easier to call within the email

Quote:

---

Originally Posted by 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

---

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

Quote:

---

Originally Posted by hem

See attachment here- Unzip to includes/classes/observers (overwrite the one there). Let me know how you get on.

---

Okay, first, I tried to update to the latest version and royally screwed something up and broke my whole store.

Once I had it restored (made sure to backup before attempting to upgrade the RP module -- the sql is where it went wacky on me.. hehe), I tried just adding this class file.

No luck, still no IPN joy..... :dontgetit

Quote:

---

Originally Posted by hem

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.

Quote:

---

Originally Posted by CJPinder

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.