Reward Point Mod beta now available

Andy, what version of MySQL are you using??? You will need at least version 4.1 to run this mod.

4.0.24

I guess that answers it, is there a work around for this?

thanks

Andy

There is- it will mean rewriting the INSERT... ON DUPLICATE UPDATE to first do a SELECT and then do a REPLACE. However, I will need to check other areas of the MySQL code in the mod to see if they will fail on a pre-v4.1 instance of MySQL.

I was insterested in having the Rewards Points box show only if they were logged in and had reward points earned or pending so I did the following:

in includes/modules/sideboxes/reward_points.php
add:

if ((isset($_SESSION['customer_id']) && getCustomersRewardPoints($_SESSION['customer_id']) > 0)) {
    $show_reward_point_box = true;
      } else {
        $show_reward_point_box = false;
      }

    if ($show_reward_point_box == true) {

above this line:

require($template->get_template_dir('tpl_reward_points.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_reward_points.php');

add this:

}

above this:

?>

I don't know if that is the correct way to do it, but it works for me. I just put this here for anyone who wants to do the same thing.

Andy, please chime in if it's incorrect or there is a better way to do it.

Thanks

Nice work- can I add it to the official release???

hem:

Nice work- can I add it to the official release???

Sure thing. I'm no coder, but it seems to work for me.

I've loaded the module, but have a few questions

first, when editing the Rewards earned in admin, what goes here? there are two boxes and I am not sure what I need to put there to show correctly.

second- is there away to give customers that give referr to other customers to my site points also?

thanks

myhomeplay.com

JC67:

I've loaded the module, but have a few questions

first, when editing the Rewards earned in admin, what goes here? there are two boxes and I am not sure what I need to put there to show correctly.

I'm guessing you are talking about the sideboxes. There are two. The first (shopping cart with rewards) shows the standard shopping cart sidebox with the reward points added on the bottom. The second just displays a box with the current reward points, your earned reward points and reward points pending. If you check the zip file there is two screenshot images that might explain this a little better.

JC67:

second- is there away to give customers that give referr to other customers to my site points also?

thanks

myhomeplay.com

I have added this to my list of further mods.

Andy;
Mabey I missed it somewhere but it appears as if this mod only works with 1.3.8. Do you know if it will work with 1.3.7? I plan on migrating to 1.3.8 but for me that will be a major haul as I have a very heavily modded version of 1.3.7.

Actually the main coding was done under 1.3.7 and runs fine on it. PTC found that it would not run under 1.3.8 (see previous posts in this thread) and I've updated the code- but it's still set to run under 1.3.7. The only warning I can give (with your heavy modded site) is that I have to make 2 changes to an admin core file (order.php). If this has been changed a lot use a program like WinMerge to insert the differences (it's only two lines)

Thanks for the quick response Andy!

hem:

I'm guessing you are talking about the sideboxes. There are two. The first (shopping cart with rewards) shows the standard shopping cart sidebox with the reward points added on the bottom. The second just displays a box with the current reward points, your earned reward points and reward points pending. If you check the zip file there is two screenshot images that might explain this a little better.

I have added this to my list of further mods.

My bad, actually I was talking about the Reward points earned under Admin-Total order module. I get two buttons to delete or edit, then when I click edit I get to blank boxes. What should I put here?

Another question, can reward points be added to customers account by admin?

Bye the way, this is some great work you have done on this mod. Thanks

JC- you should get a box with various parameters to edit- See the attached screenshot.

As for the Customers Reward Points mod- it's next on my list.

JCS:

My bad, actually I was talking about the Reward points earned under Admin-Total order module. I get two buttons to delete or edit, then when I click edit I get to blank boxes. What should I put here?

same problem I had when I first installed it. The ot_reward_points_display you only need to set the sort order on (where you want it to display among every thing else that is listed). Try uninstalling that mod and the ot_reward_points. Then reinstall them both, but do the Reward Points earned first then the Reward Points. that worked for me.

Andy, for some reason if you install rewards points first and then the Reward Points earned mod second the later will not install correctly and you get that problem JCS and myself got. It works if you install the other way, at least it did for me.

pinetreecandles:

Andy, for some reason if you install rewards points first and then the Reward Points earned mod second the later will not install correctly and you get that problem JCS and myself got. It works if you install the other way, at least it did for me.

I'll have a look at this. The Rewards Redeem is derived from the Rewards Points Earned module. Possibly there is a conflict somewhere.

hem:

I'll have a look at this. The Rewards Redeem is derived from the Rewards Points Earned module. Possibly there is a conflict somewhere.

And the conflict is in the check function of ot_rewards_points.php it's refering to the Reward Points Redeem mod. The new version will be in the next upload but if you can't wait, I've attached it here. Just copy the file to includes/modules/order_total.

Hi Andy
did you manage to get time to see if your module can work with mysql v4.0.24 as my host is not willing up upgrade the server database version

thanks

Andy

Hi Andy
cant edit post above, but our hosts has phoned and update to v5 next week for us, so should be good to go next week, look forward to getting it all going

thanks

Andy

andy:

Hi Andy
cant edit post above, but our hosts has phoned and update to v5 next week for us, so should be good to go next week, look forward to getting it all going

thanks

Andy

Thanks for the update... I had a look at the code and it was looking to be a bit of a pain to handle legacy MySQL.