Reward Points Module for ZC v13x

[hem]

Oh I didn't know this mod already existed? I had mangled this mod to get it to work like that one

Just out of interest, what would you call that function?

[retched]

Just out of interest, what would you call that function?

The function which I changed?

[hem]

The function which I changed?

Well, what snappy name would you give it? Perpetual Rewards? Longtime Customer Benefit? Loyalty Accruement?

[retched]

Well, what snappy name would you give it? Perpetual Rewards? Longtime Customer Benefit? Loyalty Accruement?

Lifetime Customer Rewards would be something I'd name it.

[lina0962]

Hello,

First, thank you for your wonderful contribution!

I want to encourage customers to write reviews or testimonials in my site. Is it possible to reward customers, say 10 reward points, for them to do so?

Lina

[retched]

Hello,

First, thank you for your wonderful contribution!

I want to encourage customers to write reviews or testimonials in my site. Is it possible to reward customers, say 10 reward points, for them to do so?

Lina

You can manually add in points on your own after you moderate them.

If you want to automatically add them on a posted review... I think this can be done by adding a few lines to the review poster.

[hem]

Version 1.40a now available for testing.

The major change for this version is a new stub written especially to handle missing PayPal IPN orders. It is available for download from my website (http://www.omnicia.com).

Make sure you backup your database first (just to be safe).

IMPORTANT. If you use PayPal IPN and you have been manually adding Reward Points to customers, you must run the following SQL patch BEFORE installing this version. Failure to do so will result in doubled up points.

INSERT IGNORE INTO reward_status_track
    (customers_id,orders_id,date,reward_points,status)
    SELECT o.customers_id,o.orders_id,NOW(),ot.text,IF(o.orders_status=1,0,1)
        FROM orders o,orders_total ot
        WHERE ot.orders_id=o.orders_id AND  
              ot.class='ot_reward_points_display'; 

This patch is also available in the root folder of the zip and is called prep_IPN_RP_orders.sql.

[hem]

Further to this, if you are upgrading from the latest version (1.33a) then all you need to do is copy /admin/includes/functions/extra_functions/reward_points_functions.php to the corresponding folder in your admin folder. No need to install updates.sql either as there have been no changes to the MySQL tables.

[gj91]

That's correct. You've already installed it once, it does not need installing again.

Well, this is still not showing up right. Not sure what the problem is.

I may take a snapshot of the current site and start over.

[urbansamurai]

Further to this, if you are upgrading from the latest version (1.33a) then all you need to do is copy /admin/includes/functions/extra_functions/reward_points_functions.php to the corresponding folder in your admin folder. No need to install updates.sql either as there have been no changes to the MySQL tables.

I am eager to give the new version a try and will do so shortly. One question, I am using the rewards points and an order editor (sorry don't recall which one off hand) but when I edit orders, it does very strange things to the rewards points. It will change the total to 0 on the order page. Now it does not seem to make a difference to the ACTUAL points as they are still added to the account when the order is completed but it has been tough with my paypal orders as you know, it has not been adding the reward points for paypal orders so each time I had to manually enter reward points for an order I had edited, I had to also calculate the reward points myself as well. Also if you add an item to an order, the reward points don't seem to change for the edited order.

I understand that both of these modules are from different people. Does there need to be a collaboration on the module creator's part to see if there is a fix to these issues? I am amazingly happy with my rewards points module and very happy with my order editor as well.

If you would like more information or would like to view the site I am talking about you can go to www.urbansamuraihobbies.com.

Thanks.

Spencer.