The empty Reward Points configuration is worrying- Re-install upgrade.sql and see if that solves the problem.Quote:
Originally Posted by redeemer641
Printable View
The empty Reward Points configuration is worrying- Re-install upgrade.sql and see if that solves the problem.Quote:
Originally Posted by redeemer641
This is a new install and I ran "new.sql". Where does the upgrade.sql exist ?
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 ?
It is in the root folder (same folder as the new.sql)Quote:
Originally Posted by 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 !
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 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.Quote:
Originally Posted by christon26
I see the RewardPoints div on you page but it is not calling the Reward Points display:Quote:
Originally Posted by christon26
You have:
You should have:PHP Code:<!--bof Product Reward Points block -->
<h2 id="productRewardPoints" class="productRewardPoints">
</h2>
<!--eof Product Reward Points block -->
PHP Code:<!--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 -->
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:
And this is the code for the tpl_product_reward_points.php that was included in the download:PHP Code:<?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>
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 LOLPHP Code:<?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 ' '.PRODUCT_REWARD_POINT_TAG;
}
?>