Reward Point Mod beta now available

[pinetreecandles]

How about a minor mod which presents you with the list of possible order statuses and allows you to tick which ones are "transfer reward points" status items. When the order status changes then the 'state' of the reward points gets changed depending on how the "state" of the order changes.

That would be great! At least this way the store owner has some control over the the points are delivered.

[pinetreecandles]

Okay, a fix for this is available now.

That fixed the problem. Works great!

[hem]

That fixed the problem. Works great!

Thanks for the verification.

[Berserker]

How do i uninstall this mod?

[hem]

How do i uninstall this mod?

Easy way- If you have no other mod with the word "reward" in its name you can just delete all the files with "reward" in its name. Likewise remove the 3 tables with "reward" in its name. Then restore includes\order.php from your backup.

Hard way- Go through the zip file and remove all the corresponding files. Then remove the tables. Then restore order.php.

[Berserker]

Tables? I remember all the zip files and order.php but I don't remember any tables?

[hem]

Tables? I remember all the zip files and order.php but I don't remember any tables?

It was in the install.sql- There are 3 tables:

reward_customer_points
reward_product_points
reward_points_history

[Berserker]

I see..how do I remove them?

And when I uninstall this, I can still install it again when I need it right?

[hem]

I see..how do I remove them?

And when I uninstall this, I can still install it again when I need it right?

Do you use use phpmyadmin??? It's easy to delete tables using this. Otherwise go to Admin -> Tools -> Install SQL Patches and copy/paste the following:

DROP TABLE `reward_customer_points`, `reward_product_points`, `reward_points_history`; 

and you shouldn't have any problems re-installing in the future.

[andy]

Just installed the module, but when i check out i get thid error message, any idea what ive done wrong?

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE pending_points=pending_points+2' at lin
in:
[INSERT INTO reward_customer_points SET customers_id='1', pending_points='2' ON DUPLICATE KEY UPDATE pending_points=pending_points+2;]