Reward Points Module for ZC v13x

[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.