Results 1 to 10 of 323

Threaded View

  1. #11
    Join Date
    Sep 2007
    Location
    Dublin, Ireland
    Posts
    1,288
    Plugin Contributions
    8

    Default Re: Reward Point Mod beta now available

    Interim fix #2. This will handle the calculation of reward points for discounted/specials and free items.

    Unzip the attached file into includes\functions\extra_functions

    Then copy and paste the following into Admin->Tools->Install SQL Patches:

    Code:
    SET @group_id = '';
    SELECT (@group_id := `configuration_group_id`) FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Reward Points';
    
    REPLACE INTO `configuration` 
    (`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
    VALUES (NULL , 'Adjust Reward Points for Sales/Specials', 'REWARD_POINTS_SPECIAL_ADJUST', '0', 'How to calculate Reward Points<br />0= Always use the base price.<br />1= Use price less Discounts and Specials.', @group_id, '7', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');
    
    REPLACE INTO `configuration` 
    (`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
    VALUES (NULL , 'Allow Reward Points on Free Products', 'REWARD_POINTS_ALLOW_ON_FREE', '0', 'Set how points are rewarded for free products.<br />0= Free products give 0 Reward Points.<br />1= Allow Reward Points on free products.', @group_id, '8', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');
    This will add two more config items to Admin->Configuration->Reward Points
    Last edited by hem; 18 Apr 2008 at 01:51 PM.
    Andrew

    Andrew Moore
    Omnicia Agile Development
    www.omnicia.com

 

 

Similar Threads

  1. v150 Adding a reward point module/add-on
    By dawneprochilo in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 10 Nov 2013, 05:16 PM
  2. Zen Cart v1.5.0 BETA release now available
    By DrByte in forum Zen Cart Release Announcements
    Replies: 11
    Last Post: 7 Oct 2011, 08:51 PM
  3. bug reported in reward point module
    By smart_pro in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 26 Mar 2009, 10:57 AM
  4. Error after installing reward point module
    By trisha33 in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 15 Feb 2009, 11:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg