Reward Points Module for ZC v13x

[hem]

I am facing an error.
The points go in pending state, but am not able to move them to earned.

Other things:
1. The Reward Point Diagnostic that "hem" gave, works perfectly. (no errors)
2. Admin > Configuration > Reward Points shows nothing...empty table
3. Admin > Customers > Reward Points, when I press "edit", it gives error 1064 as below:
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 'REWARD_POINTS_MAX_TRANSACTIONS' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM zen_reward_status_track WHERE customers_id=3 AND status=0 ORDER BY date DESC LIMIT REWARD_POINTS_MAX_TRANSACTIONS;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Can someone help ?

The empty Reward Points configuration is worrying- Re-install upgrade.sql and see if that solves the problem.

[redeemer641]

This is a new install and I ran "new.sql". Where does the upgrade.sql exist ?

[redeemer641]

The diagnostic tool runs OK, but when I went and checked the database tables, the configuration table does not have the reward points fields in it.
Any idea, why this could be happening and what could be the work around ?
As I earlier said, the Admin > Configuration > Redeem Points is empty. Any ideas ?

[hem]

This is a new install and I ran "new.sql". Where does the upgrade.sql exist ?

It is in the root folder (same folder as the new.sql)

[redeemer641]

I still don't understand the reason though, but the problem is solved.

They entries for reward points in the "configuration" table of the database were missing.
Running any number of scripts did'nt help. I finally added all the entries for "configuration" table manually.
Now it works perfectly and without any problems.

Thanks for the great module...very useful !

[LissaE]

Hi, I've installed this and the only problem *so far* that I am having is that it won't display the reward points on my product info pages.....and yes I did very carefully merge the code into my modified file LOL

Is there something I am missing like a setting I need to set in Admin to make it 'switch on' for those pages?

I have activated the modules and set the ratio in Admin - Catalog - Reward Points, and for extra measure I ran the diagnostic, which reports nothing missing, so I am kinda lost LOL

[LissaE]

I am still trying to get this to show the reward points on my product pages BUT wanted to report that I have just had my first payment made with Paypal IPN after installing....I use Paypal IPN and bank transfer only....and the points were assigned to pending in the customers account, and I had no trouble updating them to earned.

I know something was mentioned earlier in this thread about the type of payment, between unique and web_accept if I recall correctly LOL where would I find this information?

NM figures I would find it like 2 seconds after posting LOL

[txn_type] => web_accept

[hem]

I am still trying to get this to show the reward points on my product pages BUT wanted to report that I have just had my first payment made with Paypal IPN after installing....I use Paypal IPN and bank transfer only....and the points were assigned to pending in the customers account, and I had no trouble updating them to earned.

I know something was mentioned earlier in this thread about the type of payment, between unique and web_accept if I recall correctly LOL where would I find this information?

NM figures I would find it like 2 seconds after posting LOL

[txn_type] => web_accept

There was an issue with pre v1.20 that it did not reward orders made using Paypal IPN. v1.20 has different code for handling this.

[hem]

Hi, I've installed this and the only problem *so far* that I am having is that it won't display the reward points on my product info pages.....and yes I did very carefully merge the code into my modified file LOL

Is there something I am missing like a setting I need to set in Admin to make it 'switch on' for those pages?

I have activated the modules and set the ratio in Admin - Catalog - Reward Points, and for extra measure I ran the diagnostic, which reports nothing missing, so I am kinda lost LOL

I see the RewardPoints div on you page but it is not calling the Reward Points display:

You have:

<!--bof Product Reward Points block -->
<h2 id="productRewardPoints" class="productRewardPoints">
</h2>
<!--eof Product Reward Points block --> 

You should have:

<!--bof Product Reward Points block -->
<h2 id="productRewardPoints" class="productRewardPoints">
<?php
/**
 * display the product reward points
 */
   include($template->get_template_dir('/tpl_product_reward_points.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_product_reward_points.php'); 
?>
</h2>
<!--eof Product Reward Points block -->

[LissaE]

Hi Andrew, I do have the code in there, it just won't call the display, and I have no idea why LOL

This is the code for my product info page:

<?php
/**
 * Page Template
 *
 * Loaded automatically by index.php?main_page=product_info.<br />
 * Displays details of a typical product
 *
 * @package templateSystem
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: tpl_product_info_display.php 5369 2006-12-23 10:55:52Z drbyte $
 */
 //require(DIR_WS_MODULES . '/debug_blocks/product_info_prices.php');
?>
<div class="centerColumn" id="productGeneral">

<!--bof Form start-->
<?php echo zen_draw_form('cart_quantity', zen_href_link(zen_get_info_page($_GET['products_id']), zen_get_all_get_params(array('action')) . 'action=add_product'), 'post', 'enctype="multipart/form-data"') . "\n"; ?>
<!--eof Form start-->

<?php if ($messageStack->size('product_info') > 0) echo $messageStack->output('product_info'); ?>

<!--bof Category Icon -->
<?php if ($module_show_categories != 0) {?>
<?php
/**
 * display the category icons
 */
require($template->get_template_dir('/tpl_modules_category_icon_display.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_category_icon_display.php'); ?>
<?php } ?>
<!--eof Category Icon -->

<!--bof Prev/Next top position -->
<?php if (PRODUCT_INFO_PREVIOUS_NEXT == 1 or PRODUCT_INFO_PREVIOUS_NEXT == 3) { ?>
<?php
/**
 * display the product previous/next helper
 */
require($template->get_template_dir('/tpl_products_next_previous.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_products_next_previous.php'); ?>
<?php } ?>
<!--eof Prev/Next top position-->
<br class="clearBoth" />

<!--bof Product Name-->
<div class="ProductDescriptionHeading">
<h2 class="centerBoxHeading"><?php echo $products_name; ?></h2>
</div>
<!--eof Product Name-->

<br class="clearBoth" />

<!--bof Main Product Image -->
<?php
  if (zen_not_null($products_image)) {
  ?>
<?php
/**
 * display the main product image
 */
   require($template->get_template_dir('/tpl_modules_main_product_image.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_main_product_image.php'); ?>
<?php
  }
?>
<!--eof Main Product Image-->

<br class="clearBoth" />

<div style="text-align:center;">
<!--bof Product Price block -->
<h2 id="productPrices" class="productGeneral">
<?php
// base price
  if ($show_onetime_charges_description == 'true') {
    $one_time = '<span >' . TEXT_ONETIME_CHARGE_SYMBOL . TEXT_ONETIME_CHARGE_DESCRIPTION . '</span><br />';
  } else {
    $one_time = '';
  }
  echo $one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == 1) ? TEXT_BASE_PRICE : '') . zen_get_products_display_price((int)$_GET['products_id']);
?></h2>
<!--eof Product Price block -->

<!--bof Product Reward Points block -->
<h2 id="productRewardPoints" class="productRewardPoints">
<?php
/**
 * display the product reward points
 */
   include($template->get_template_dir('/tpl_product_reward_points.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_product_reward_points.php'); 
?>
</h2>
<!--eof Product Reward Points block -->

<!--bof Product details list  -->
<p><?php if ( (($flag_show_product_info_model == 1 and $products_model != '') or ($flag_show_product_info_weight == 1 and $products_weight !=0) or ($flag_show_product_info_quantity == 1) or ($flag_show_product_info_manufacturer == 1 and !empty($manufacturers_name))) ) { ?>
  <?php echo (($flag_show_product_info_manufacturer == 1 and !empty($manufacturers_name)) ? '' . TEXT_PRODUCT_MANUFACTURER . $manufacturers_name . '' : '') . "\n"; ?>
<?php
  }
?><br /><br />
<!--eof Product details list -->

<!--bof Product date added/available-->
<?php
  if ($products_date_available > date('Y-m-d H:i:s')) {
    if ($flag_show_product_info_date_available == 1) {
?>
<?php echo sprintf(TEXT_DATE_AVAILABLE, zen_date_long($products_date_available)); ?><br /><br />
<?php
    }
  } else {
    if ($flag_show_product_info_date_added == 1) {
?>
<?php echo sprintf(TEXT_DATE_ADDED, zen_date_long($products_date_added)); ?><br /><br />
<?php
    } // $flag_show_product_info_date_added
  }
?>
<?php echo ($flag_show_product_info_reviews_count == 1 ? TEXT_CURRENT_REVIEWS . ' ' . $reviews->fields['count'] : ''); ?></p>
<!--eof Product date added/available -->
</div>
 <!--bof Product description -->
<div class="ProductDescriptionHeading">
<h2 class="centerBoxHeading">Product Description</h2>
</div>
<div style="text-align:center;">
<?php if ($products_description != '') { ?>
<div id="productDescription" class="productGeneral biggerText"><?php echo stripslashes($products_description); ?></div>
<?php } ?>
</div>
<!--eof Product description -->
<br class="clearBoth" />


<!--bof Attributes Module -->
<?php
  if ($pr_attr->fields['total'] > 0) {
?>
<?php
/**
 * display the product atributes
 */
  require($template->get_template_dir('/tpl_modules_attributes.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_attributes.php'); ?>
<?php
  }
?>
<!--eof Attributes Module -->

<!--bof Add to Cart Box -->
<?php
if (CUSTOMERS_APPROVAL == 3 and TEXT_LOGIN_FOR_PRICE_BUTTON_REPLACE_SHOWROOM == '') {
  // do nothing
} else {
?>
            <?php
    $display_qty = (($flag_show_product_info_in_cart_qty == 1 and $_SESSION['cart']->in_cart($_GET['products_id'])) ? '<p>' . PRODUCTS_ORDER_QTY_TEXT_IN_CART . $_SESSION['cart']->get_quantity($_GET['products_id']) . '</p>' : '');
            if ($products_qty_box_status == 0 or $products_quantity_order_max== 1) {
              // hide the quantity box and default to 1
              $the_button = '<input type="hidden" name="cart_quantity" value="1" />' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
            } else {
              // show the quantity box
    $the_button = PRODUCTS_ORDER_QTY_TEXT . '<input type="text" name="cart_quantity" value="' . (zen_get_buy_now_qty($_GET['products_id'])) . '" maxlength="6" size="4" /><br />' . zen_get_products_quantity_min_units_display((int)$_GET['products_id']) . '<br />' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
            }
    $display_button = zen_get_buy_now_button($_GET['products_id'], $the_button);
  ?>
  <?php if ($display_qty != '' or $display_button != '') { ?>
    <div id="cartAdd">
    <?php
      echo $display_qty;
      echo $display_button;
            ?>
          </div>
  <?php } // display qty and button ?>
<?php } // CUSTOMERS_APPROVAL == 3 ?>
<!--eof Add to Cart Box-->

<br class="clearBoth" />
<!--bof Additional Product Images -->
<?php
/**
 * display the products additional images
 */
  require($template->get_template_dir('/tpl_modules_additional_images.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_additional_images.php'); ?>
<!--eof Additional Product Images -->

<!--Webmaster Edit Section Removal -->

<!--bof Prev/Next bottom position -->
<?php if (PRODUCT_INFO_PREVIOUS_NEXT == 2 or PRODUCT_INFO_PREVIOUS_NEXT == 3) { ?>
<?php
/**
 * display the product previous/next helper
 */
 require($template->get_template_dir('/tpl_products_next_previous.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_products_next_previous.php'); ?>
<?php } ?>
<!--eof Prev/Next bottom position -->
<br class="clearBoth" />
<!--bof Ask a Question button -->
<div id="productAskQuestionLink" class="buttonRow forward">
   <?php echo '<a href="' . zen_href_link(FILENAME_ASK_A_QUESTION, 'products_id='
   . $_GET['products_id']) . '">' .
   zen_image_button(BUTTON_IMAGE_ASK_A_QUESTION, BUTTON_ASK_A_QUESTION_ALT) .
   '</a>'; ?>
</div>
<!--eof Ask a Question button -->

<!--bof Tell a Friend button -->
<?php
  if ($flag_show_product_info_tell_a_friend == 1) { ?>
<div id="productTellFriendLink" class="buttonRow forward"><?php echo ($flag_show_product_info_tell_a_friend == 1 ? '<a href="' . zen_href_link(FILENAME_TELL_A_FRIEND, 'products_id=' . $_GET['products_id']) . '">' . zen_image_button(BUTTON_IMAGE_TELLAFRIEND, BUTTON_TELLAFRIEND_ALT) . '</a>' : ''); ?>
</div>

<?php
  }
?>
<!--eof Tell a Friend button -->

<!--bof Reviews button and count-->
<?php
  if ($flag_show_product_info_reviews == 1) {
    // if more than 0 reviews, then show reviews button; otherwise, show the "write review" button
    if ($reviews->fields['count'] > 0 ) { ?>
<div id="productReviewLink" class="buttonRow back"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS, zen_get_all_get_params()) . '">' . zen_image_button(BUTTON_IMAGE_REVIEWS, BUTTON_REVIEWS_ALT) . '</a>'; ?></div>
<br class="clearBoth" />
<?php } else { ?>
<div id="productReviewLink" class="buttonRow back"><?php echo '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, zen_get_all_get_params(array())) . '">' . zen_image_button(BUTTON_IMAGE_WRITE_REVIEW, BUTTON_WRITE_REVIEW_ALT) . '</a>'; ?></div>
<br class="clearBoth" />
<?php
  }
}
?>
<!--eof Reviews button and count -->

<!--bof free ship icon  -->
<?php if(zen_get_product_is_always_free_shipping($products_id_current) && $flag_show_product_info_free_shipping) { ?>
<div id="freeShippingIcon"><?php echo TEXT_PRODUCT_FREE_SHIPPING_ICON; ?></div>
<?php } ?>
<!--eof free ship icon  -->

<!--bof Product URL -->
<?php
  if (zen_not_null($products_url)) {
    if ($flag_show_product_info_url == 1) {
?>
    <p id="productInfoLink" class="productGeneral centeredContent"><?php echo sprintf(TEXT_MORE_INFORMATION, zen_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($products_url), 'NONSSL', true, false)); ?></p>
<?php
    } // $flag_show_product_info_url
  }
?>
<!--eof Product URL -->

<!--bof also purchased products module-->
<?php require($template->get_template_dir('tpl_modules_also_purchased_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_also_purchased_products.php');?>
<!--eof also purchased products module-->

<!--bof Form close-->
</form>
<!--bof Form close-->
</div>

And this is the code for the tpl_product_reward_points.php that was included in the download:

<?php
/**
 * Module Template
 *
 * @package templateSystem
 * @copyright Copyright 2008 Andrew Moore
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 */
    if(isset($_REQUEST['products_id']))
    {
        $products_id=$_REQUEST['products_id'];
        //if(REWARD_POINTS_SPECIAL_ADJUST=='0')
         //echo (int)((zen_get_products_base_price($products_id)*GetRewardPointRatio($products_id))+REWARD_POINTS_ROUNDING);
        //else
         echo (int)GetProductRewardPoints($products_id);

        echo '&nbsp;'.PRODUCT_REWARD_POINT_TAG;
    }
?>

I have also just decided to change over how it gives out the points to calculate from the order total (i.e. after discounts etc, and not from the product price itself, and I think this means it won't display there now anyway? Or am I wrong on that LOL