Printable View
actually....I've just noticed that if I redeem a Gift Cert, it doesn't take anything off the reward points?? It works if reward points are redeemed.Quote:
Originally Posted by beadfaery
Question?? Was I supposed to uninstall the last version or sql first?
Hi Andy
does this version fix the payPal issue?
thanks
Andy
Ignore my last post :blush: figured it out.....sorry - it's late here and I'm half asleep :dontgetitQuote:
Originally Posted by beadfaery
It might- Check it out and let me know how you get on.Quote:
Originally Posted by andy
I have an issue.. I upgraded from 1.13a to 1.20a
Admin->Custom->Reward Points list the users. I am able to sort the list and edit any listed user without trouble.
If I enter a 'Search' string the results are returned. Selecting any of the results listed from the search results in a screen refresh with a default user listing and the following error listed at the bottom of the page.
I am able to select any of the listed users from this screen and edit them and I can also select a new sort order without additional errors. So, this error only seems to happen when a sort is used.Quote:
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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
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.
I cannot reproduce this. When you get the error what's the exact information in your browser address bar?Quote:
Originally Posted by Asgoroth
Has anyone gotten the Reward Points to work with Google Checkout?
I have tried everything and cannot get the reward points to register when customers checkout with Google. I finally had to just remove the reward points module. I really would like to add it if anyone can give me an idea of how to get it to work with Google. I added the zip file that should of fixed it however it didn't.
Any help would be so appreciated.
http://www.urbdistributing.net
OK, additional info..
1) The address bar shows the following after clicking on a name that has been displayed from a search.
2) I have removed the mod and reinstalledCode:http://www.site.org/cart/admin/customers_reward_points.php?id=1&action=edit
a) Manual removal of all files
b) SQL patch uninstall.sql
c) install
3) Also, when a listing is displayed, there are only 40 names being listed.
4) I have reverted to a 1.13a install and it is working.
I am using Google Checkout and the Reward Points are working with it. Did you copy googlecheckout.php (in the root folder of the verson 1.20 zip file) to /includes/modules/payment/googlecheckout.php . This should be the only file that effects Google Checkout.Quote:
Originally Posted by urbdistrib
Ken
Paws4Deals.com
I am getting an error:
1146 Table 'mycustom_zc1.zen_reward_master' doesn't exist
in: [SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute FROM zen_reward_master prp, zen_products p, zen_products_to_categories p2c WHERE p.products_id='20' AND p2c.products_id='20' AND ((prp.scope_id=p.products_id AND prp.scope='2') OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1') OR (prp.scope='0')) ORDER BY prp.scope DESC LIMIT 1;]
Also Admin, Configuration, Reward Points does not exist in Zen Cart Admin screen.
Where did I go wrong?? Can anyone please help me?? :cry:
What version did you upgrade from??? Plus did you follow the instructions in the readme.txt regarding the rename???Quote:
Originally Posted by GG01
Strange- Nothing has changed in that file between the two versions. Also the code you posted shows the customer_id being passed.Quote:
Originally Posted by Asgoroth
Hi
Ive installed the latest version, using a credit card, no points are added to the customer accounts or set as pending.
When it go into customers>reward points> search on my test user, and try to edit to allow points to be added manually i get this sql error
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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
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.
any idea's why this is happening, the first version worked fine
thanks
Andy
sorry to post agin, but cant edit the above post.
When i ran the db update.sql, i got errors, so i then ran the uninstall.sql and removed all the tables and then installed the new.sql with no errors, not sure if this has anything to do with the problem.
thanks
Andy
Hello Andy,
I have upgraded to the latest version, and I get this on the shopping cart page, in the Reward Points shopping cart and also on the product page where it used to show reward points value:-
I noticed nobody else reported it, so is it a clash with another module? I have turned it off for now.Quote:
Warning: Missing argument 2 for zen_round() in /home/gemtree/public_html/includes/functions/functions_general.php on line 176
What version of Zencart are you running?Quote:
Originally Posted by HeathenMagic
Hi Andy
zencart version is 3.17
ive unistalled the lastest version, installed version 1-13a again and its working fine
I installed it to see if paypal was working, but never got that far
thanks
Andy
I just reinstalled the old version and the problem goes. It is definitely a file from the includes/ folder that does (new version) it. I have tried debugging tools, but nothing comes through.
I am using zencart 1.38a (sorry should have put that)
I love the module, and would also like to know if you accept donations at all?
Regards,
James :smile:
Hello Andy,
It is this file that does it:-
includes/functions/extra_functions/reward_points_functions.php
It yields those error messages. I have quite a few mods, would it be a clash? But the 1.13a is fine, so not sure.
James
Thanks for the heads up James- I'm going to do a compare between the two versions and try and get a handle on what's wrong.Quote:
Originally Posted by HeathenMagic
Okay, I found a couple of issues- First was with the update.sql (it didn't) and an install.sql crept back into the release. Second the version of zen_round I use may not be backward compatible so I've sorted that out too. Interim release here:
http://www.omnicia.com/zencart_reward_points_module.zip
Hello Andy,
I got it working in a fashion. The only thing for me, is I get this above the shopping cart:-
I looked at the relevant section in that file:-Quote:
Warning: Invalid argument supplied for foreach() in /home/gemtree/public_html/includes/functions/extra_functions/reward_points_functions.php on line 16
For the time being, I changed the 0 to a 1, and it works upon testing:-Quote:
function GetRewardPoints($products)
{
$reward_points=0;
if(REWARD_POINT_MODE=='0')
{
foreach($products as $product)
if(isset($product['qty']))
$reward_points+=GetProductRewardPoints($product['id'],$product['attributes'])*$product['qty'];
else
if(isset($product['quantity']))
$reward_points+=GetProductRewardPoints($product['id'],$product['attributes'])*$product['quantity'];
else
if(isset($product['quantityField']))
$reward_points+=GetProductRewardPoints($product['id'],$product['attributes'])*$product['quantityField'];
else
$reward_points="RP Error";
But it must be a setting in the config that I have set to 0, and it causes the error at the top.Quote:
if(REWARD_POINT_MODE=='0')
Regards,
James
James- did you install the upgrade.sql file? The setting in question is the Reward Point Mode configuration item which is new for this version.Quote:
Originally Posted by HeathenMagic
I think I know where the shopping cart issue is coming from- I'll check it and post a new version shortly.
Hello Andrew,
Yes I installed the upgrade.sql. What I think has happened is that I have three Reward Points config under configuration. But I am able to get rid of the duplicates. I beg your pardon, I have just spotted the Reward Points Mode, and setting it to 1 makes the error go (I reuploaded the original file to extra functions)
So thankyou very much for your help. If you have a donation email or url, please let us know. I think everyone who uses this successfully should be giving something back to you.
I know I mentioned it before, but I don't know if the reward points for each customer can be extracted to a newsletter. I don't know if it will work for me now, as I am on PHPlist and I guess that is a tricky way to extract. Say on a persons newsletter, it will say 'You have 250 reward points or something'.
Thanks again,
James :clap:
That explains why when I was just checking your website the problem disappeared :blink:Quote:
Originally Posted by HeathenMagic
I think I know where the issue is- Can you tell me what mod you use for "Checkout Without Account Creation"- I'll install it locally and see if I can't track it down.
I will also see if I can get you a points-to-newsletter solution. If I produce something I want to make sure that it's easy to do and works across all newsletters.
Finally- thanks for the offer of a donation- not only thank you but thanks to everyone who have made similar offers. Really, I'm happy to do this- I think ZenCart is a great package and this is only my minor contribution to a much larger scheme. If you want to throw any money to someone, donate to the ZenCart community/design team- those are the guys that really need (and deserve) the support.
As for the Reward Point mod- I'm going to continue developing and debugging while people are still actively using the mod. Short term goal is to get the mod working for everyone. Long term goal is to incorporate everyone's wishes for a complete solution.
Hello Andrew,
I installed the Easy Sign Up mod, which is here:-
http://www.zen-cart.com/index.php?ma...roducts_id=844
Well I thought it was only fair to enquire about donations - I'm due to make another donation to the Zen Cart team anyway, so I will bump that up.
Thanks again,
James
Firstly, awesome module and it seems to work on the whole for the short period of time I've been testing.
What I am noticing though is that the points that a customer is earning are not going in the pending section after they place their order.
I can place points directly into a customer account and they can redeem them just fine but when they place orders, they just don't seem to be getting the points.
I'm using a stock 1.3.7 install with no other modules installed.
Thanks in advance,
Arthur
Arthur, any chance that they are using PayPal IPN to pay for their purchases?Quote:
Originally Posted by arthurhanlon
Hi Andy ;)
I' ve clean 1.3.8.a instalation with demo products without db prefixes on conf. >
Database: MySQL 4.0.27-log
PHP Version: 4.4.9 (Zend: 1.3.0)
i try to install your reward 1.20a mod, but always with same error :( >
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 'SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET `pending_points`=`pending_points`-IFNULL((SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE ph.`customers_id`=rc.`customers_id` AND ph.`status`=0 AND ph.`orders_id` NOT IN (SELECT `orders_id` FROM orders)),0);]
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.
if i try to unistall.sql from phpMyAdmin get this error >
Error
SQL query:
DELETE IGNORE FROM `configuration` WHERE `configuration_group_id` = @group_id ;
MySQL said: Documentation
#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 'IGNORE FROM `configuration` WHERE `configuration_group_id`=@gro
Thanks for reply;)
You need MySQL v4.2 minimum to run this mod.Quote:
Originally Posted by evan70
Nope, just standard "Cheque/Money Order" to process.Quote:
Originally Posted by hem
Does it not work with PayPal payments. I know that our live site has both ProtX Direct and the ProtX from in place for credit card payments. Will it work alongside this?
Thanks,
Arthur
Works with Cheque/Money Order (it's what I use to test). All other forms of payment work too except for PayPal IPN due to the way it handles payments.Quote:
Originally Posted by arthurhanlon
Hmmm...still can't seem to get it to work. I mean in regards to placing the points into pending then into earned after order has been processed. Any ideas?
I may try to install it again on another clean system and see if I can spot if anything was missed but I think I managed it fine.
Thanks,
Arthur
I have the mod set up and thanks it looks like a great one. I have one problem.
In my admin catalog I cannot access my Reward Points.
Under Customers I cannot access Group Reward Points and Reward Points.
I am getting this error for all 3.
Sorry, your security clearance does not allow you to access this resource.
Please contact your site administrator if you believe this to be incorrect.
Sorry for any inconvenience.
Thank You for the help!
Thanks for the great Mod I have been using Version 1.10a for a number of months without a hitch apart from "the PayPal IPN not assigning points problem".
I just installed your latest version 1.20a on my test site and have noticed that when I redeem reward point from a previous order. The amount that is redeemed is subtracted from the amount of reward points I would get on this order.
Version 1.10a would not deduct any points from the order after redeeming reward points from previous orders.
Has anybody else noticed this..
Hey travel124,
Do you possibly have Admin Profiles installed. U may need to add the permissions...Quote:
Sorry, your security clearance does not allow you to access this resource.
Please contact your site administrator if you believe this to be incorrect.
Thanks again for the great mod..
Yes I do have Admin Profiles installed. I could not tell what permissions I need to set.
Thank You!
Tim, thanks for the feedback. The "remove points when redeem points" was asked for by a number of people so I coded it in- If you want to still allow rewarded points even when redeeming I'll add it in as a configuration in the next release.Quote:
Originally Posted by Tim Ware
Nice catch on the Admin Profiles.
And to anyone still listening- I am determined to nail the Paypal IPN issue.
Hi,
After search customer last name in Admin->Customer->Reward Points Module
I click into customer which i found to edit point but i saw this trouble :
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 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM handicrareward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
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.
Do you know how to fix this?
Thanks you!
I'm guessing that you MySQL version is lower than 4.2Quote:
Originally Posted by kimsonvu
Please I would to know to what files to add permissions.
Thank You.
I am still unable to finish this install because of info below.
I have the mod set up and thanks it looks like a great one. I have one problem.
In my admin catalog I cannot access my Reward Points.
Under Customers I cannot access Group Reward Points and Reward Points.
I am getting this error for all 3.
Sorry, your security clearance does not allow you to access this resource.
Please contact your site administrator if you believe this to be incorrect.
Sorry for any inconvenience.
Thank You for the help!
You will have to take the question to the Admin Permissions mod thread- I'm afraid I don't use that modification.Quote:
Originally Posted by travel124
Hi,Quote:
Originally Posted by hem
I use bluehost and their Php version is 5.
What can i do now to fix this trouble?
Thanks in advance !
It works with v5. Just check with your ISP that your hosting is set for this version. I know with my host I had to add a line to my .htaccess file in order to use the newer version as they defaulted to v4 for backward compatibility.Quote:
Originally Posted by kimsonvu
Error
SQL query:
SELECT (
@group_id := `configuration_group_id`
)
FROM `configuration_group`
WHERE `configuration_group_title` LIKE 'Reward Points';
MySQL said:
#1146 - Table 'thescra1_zc2.configuration_group' doesn't exist
help how do i fix this
Hi,Quote:
Originally Posted by hem
I checked ! This is 5.26 php version !
PHP Version: 5.2.6 (Zend: 2.2.0) PHP Memory Limit: 128M
Hi Andrew. I've just discovered I'm having this problem, too :( I've had a customer pay with Paypal, so need to manually award her points, but I can't due to this error.Quote:
Originally Posted by kimsonvu
I have checked and yes....I am running MySQL version 4.1.22-standard .
Any idea how I update this? Do I need to ask my host to do it?:wacko:
Yes- just give your ISP a call and see if they can't update you to v5 (point out to them that v6 will be available shortly)Quote:
Originally Posted by beadfaery
Hello,
today I install the version 1.2 and now it didn't work correctly. I am in Germany and we have to show all prices with tax in it. Version 1.13 always calculate the reward points from the price without tax (It is o.k.).
The new version calculate from the prices without tax on the product_info_display.php and show for example 40 reward points but if you add the item to the cart the sitebox show 48 reward points, because it calculates from the price with tax.
I think it is equal from which price it is calculated but it should be the same in every case.
I use it on a life-shop and have to go back to 1.13 because this issue isn't acceptable.
This mod has not worked all week for me. I added the permissions but no longer getting downloads to come through on orders. I tried ran the uninstall and now I have this error.
1146 Table 'digit124_zenstore.zen_reward_master' doesn't exist
in:
[SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute FROM zen_reward_master prp, zen_products p, zen_products_to_categories p2c WHERE p.products_id='2749' AND p2c.products_id='2749' AND ((prp.scope_id=p.products_id AND prp.scope='2') OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1') OR (prp.scope='0')) ORDER BY prp.scope DESC LIMIT 1;]
If they can't do this for you, is there a way of changing the ID (Or even adding in the order number) to show decending ie the largest number first? This would then let you add manually for the most recent orders you have taken.Quote:
Originally Posted by hem
The code would be within the customer_reward_points.php file would it not?
First, great mod. Thank you Andrew. I just completed the install, but have few questions. A few things are missing: (using your "readme" instructions and attachments for reference), step 6, 8, and 9. How can I fix this, and where should I look. Also, is there a way to exclude reward points for "gift certificates?" Thanks in advance.
You are correct with this- However there are a number of elements within this mod which also require v4.2 or greater. To make the whole mod pre v4.2 compliant would also mean a greater number of MySQL calls and the resource impact that would entail.Quote:
Originally Posted by CandleMan
Check you make sure you have copied all the files over correctly (the thumbnails would indicate that the admin files are missing).Quote:
Originally Posted by winwallc
You are right, admin pages were missing. Are you familiar with these 2 issues below? thanks in advanceQuote:
Originally Posted by hem
BTW -- I admit I am one of those dumbass that didn't read your instructions. It was too late when i notice your DB requirements. I am currently using 4.1.x.x.x. Is there a fix or sol?
Admi-> catalog -> Reward Points
Fatal error: Call to undefined function: getrewardpointrecord() in /home/content/c/h/o/chopsticks/html/zen/admin/reward_points.php on line 125
Admi-> customers -> Reward Points
Fatal error: Call to undefined function: cleanuprewardpointhistory() in /home/content/c/h/o/chopsticks/html/zen/admin/customers_reward_points.php on line 25
Ok, after combing thru all previous threads, my problems was solved. Although should I still be concern about the mysql v4.1?
:clap: awsome mod, thanks again Andrew. You D-man. :yes:
Ok I've combed this thread and perhaps I have missed it.
When I turn on the sidebox, all my other side boxes disappear that go below it. Everything else is working flawlessly. Am I missing something?
Have you changed anything in the sidebox code??? The reason that the other sideboxes are not loading is because there is a php error which is stopping any further code being run.Quote:
Originally Posted by hintimates
Well, if it works, it works...Quote:
Originally Posted by winwallc
I'd still pester your ISP to update their MySQL version. v6 is now available. v4.1 is over five years old now. Even MySQL themselves no longer support it; from their website: "Active development and support for MySQL database server versions 3.23, 4.0, and 4.1 has ended."
No I haven't changed anything. Loaded straight in without any changes. I actually unzipped the files again and reloaded just in case. Sideboxes won't show up and eliminates all the ones underneath it.Quote:
Originally Posted by hem
Just an additional thought in my testing of it -
Is it possible to add a Reward Points section into the user account files so they can log in and look to see what they have on hand in there when they go into My Account?
And the site for this particular issue is www.justmixandbake.com
Quote:
Quote:
Originally Posted by CandleMan View Post
If they can't do this for you, is there a way of changing the ID (Or even adding in the order number) to show decending ie the largest number first? This would then let you add manually for the most recent orders you have taken.
The code would be within the customer_reward_points.php file would it not?
I understand this but for those who need to enter manually, surely it's a small change in the code of the php file to list the ID in descending order rather than ascending. (I'd have a go myself but do not understand PHP code at all....honest):blink:Quote:
You are correct with this- However there are a number of elements within this mod which also require v4.2 or greater. To make the whole mod pre v4.2 compliant would also mean a greater number of MySQL calls and the resource impact that would entail.
Strange- I'm able to see all the sideboxes on that site.Quote:
Originally Posted by hintimates
And the Reward Points are shown in the Account details.
You can see them right now because I have the Rewards Points box turned off. Let me put it on and you can see what I mean. Everything below the newsletter box will disappear.Quote:
Originally Posted by hem
And Rewards Points are NOT showing in user account details. If logged in, click on My Account and there is no area listing anything about Reward Points.
Further looking at things, sideboxes are disappearing if logged in to the account OR if not logged in, adding items to the shopping cart. That is what causes the disappearance of the side boxes below the newsletter box.
That would indicate that you haven't copied over all the files for the mod. One of the account files is missing that would display the reward points. I'd expect that's the same problem with the sidebox not working either.Quote:
Originally Posted by hintimates
FOUND THE SIDEBOX ISSUE! Sometimes it just takes going back over it for the 10th or 20th time. User error! Sorry!
And I resolved the My Account issue as well. Thank you! Sometimes talking about it seems to make finding things easier.
Hi all,
Not sure if I have missed something but I have placed an test order on my site and I have 300 points but it does not give me the option to use any points for payment?
How do I set this up?
Thanks.
If you go into Admin->Customers->Reward Points are the points shown as 'Pending' or 'Earned'??? It could be that the status of the order has not changed from 'Processing' so the points have not been earned yet.Quote:
Originally Posted by Adds
Reward Point Diagnostic here:
http://omnicia.com/rpd.zip
To use, copy both files to the root folder of your store and then go to www.your-website-address.com/rpd.php
This will highlight in red any missing files, tables and records.
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.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;
}
?>
Make sure that tpl_product_reward_points.php is in your custom template directory in the 'templates' folder.Quote:
Originally Posted by christon26
Yep, it's in there LOL this seems to be a mystery :blush:
Okay- got it sorted.Quote:
Originally Posted by christon26
Yay I can see it there now LOL thank you!
How come it wasn't showing before.....was it user error? lol :P
Your server wasn't handling $_REQUESTs so I added $_GET to the mix.Quote:
Originally Posted by christon26
Ahh ok, thanx!
lol I just moved servers a couple of days ago to get them to upgrade the MySQL so I could use this mod LOL
let me start with the fact that I really like this mod.Quote:
Originally Posted by Boogy
I installed it on my test server and the only fault I can find is this one. has there been a fix to this as I can't seem to find on in this thread.
but very nice work on everything else :bigups:
I'll check this out in the morning- Thanks for the heads up.Quote:
Originally Posted by StarBuck
I just installed this mod but I seem to have done something wrong. No sideboxes are showing that can be enabled in the layout boxes controller. And I have one error message in the listings
Warning: Missing argument 2 for zen_round() in /home/content/a/v/e/avenuebeads/html/includes/functions/functions_general.php on line 174
2 reward points
Any ideas?
"Search This Thread", a handy little tool at the top of the page LOL yields a similar problem to yours....click here and read from post 515 forward, and you might find a solution, least I hope you do lol good luck :DQuote:
Originally Posted by AvenueBeads
Eeeek now I noticed an error in the modules section
Fatal error: Call to a member function on a non-object in /home/content/a/v/e/avenuebeads/html/includes/modules/order_total/ot_gv.php on line 29
I've decided to remove the contribution and try it on a different site that isn't live
How do I get rid of these errors. I combed through my files several times and cant get rid of these errors.
http://www.avenuebeads.com/index.php...roducts_id=191
~Joe~
OK, never mind found the files. Had some hiding on me :)
Still have the fatal error in the order total modules though.
~Joe~
Andrew, thanks for the great module.
I upgraded from v1.13a to v1.20a and the Paypal order still doesn't generate reward points (user didn't return to the shop after the payment)... other payment works fine.
where is the code that trigger the reward point when Paypal order created?
Try going into your PP account profile settings, Website Payment Preferences, and activating the PDT Token, grab the code and add it to your PP module in admin, hopefully you should see the points start being generated then :)
Try the version off of my website: http://www.omnicia.com/Zencart%20Rew...s%20Module.zipQuote:
Originally Posted by AvenueBeads
There are a couple of bug fixes in this version which are not yet in the Download Contribution section. I'm hoping to have a new version posted here sometime this week.
Thats the Gift Voucher module- The Reward Point module does not modify or replace this so your problem has come from somewhere else.Quote:
Originally Posted by AvenueBeads
thanks Christon. I had PDT token setup in Admin but Paypal order didn't add reward points... also tried the new version Andrew just posted but with no luck. :(Quote:
Originally Posted by christon26
Question- Do you have Points rewarded by Product or Points rewarded by Total/Subtotal set?Quote:
Originally Posted by christon26
Andrew,
Thanks for this great mod. When you time permits can you please post the preferred configuration settings? i.e. order total versus sub-total and why a shop owner might want one versus other. I know this is really a business decision but somehow I have a feel that some settings create less headaches just reading from all the posts.
I am going to download the updated version from your site and try that one as we would like to offer this for Christmas shopping.