Just out of interest, what would you call that function?
Printable View
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
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.
This patch is also available in the root folder of the zip and is called prep_IPN_RP_orders.sql.PHP Code:
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';
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.