Reward Point Mod beta now available

[hem]

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

[andy]

4.0.24

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

thanks

Andy

[hem]

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.

[pinetreecandles]

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

[hem]

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

[pinetreecandles]

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

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

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

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

thanks

myhomeplay.com

[hem]

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.

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.

[Einstin]

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.

[hem]

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)