Reward Points Module for ZC v13x

hem:

Have you made any changes to your zencart database recently?

No, not any major changes. I have moved my downloads folder outside the public_html folder in order to protect them. Then had to change the configure.php files to connect to the new folder, but other than that, no I have not changed anything.

Not sure what you mean by running the diagnostics. I am still somewhat new to all this and not exactly sure what that is. I am a fast learner for the most part though.

I was also wondering if it is possible to award points to certain customers and where I can do that. Maybe I can't right now due to the errors.

Thanks for your help.

hem:

Also- try running rpd (Reward Point Diagnostics)- You can download the latest from https://www.omnicia.com/rpd.zip- Just copy the two files to your root folder and call rpd.php from your browser.

OK, I downloaded it and tried to run it an it says the link it broken. Am I doing something wrong. I typed in www.mydomain/rpd.php. What else should I do?

I am also not seeing a lot of the options that I see in the screenshots. I to do not have, or maybe don't see where, you can get to the Reward Points - Top section in the categories. I also do not see where I can change the customers points in the customers section in Admin. Did I do something wrong. I have installed many modules before and this one seemed pretty straight forward.

Hi dropbop

Sorry for late responce iam not sure which files they were now but i just run the check tool which you can down load and it will say exactly whic files are missing, heres the link to the tool

http://www.omnicia.com/rpd.zip

Regards Dean

Hi guys

Just checked the link and its working ive just downloaded the checker again to make sure..

http://www.omnicia.com/rpd.zip

medeano:

Hi guys

Just checked the link and its working ive just downloaded the checker again to make sure..

http://www.omnicia.com/rpd.zip

Once I have ran the file, how do I read it and know how to fix the problems? New to this all.

lauriesscraps:

Once I have ran the file, how do I read it and know how to fix the problems? New to this all.

RPD will flag all the items that are missing in red. You need to take a note of these files (and their locations) and copy the missing files from the original zip you downloaded.

hem:

RPD will flag all the items that are missing in red. You need to take a note of these files (and their locations) and copy the missing files from the original zip you downloaded.

Maybe I am not running it right because I do not see any red. This is all I see:

<?xml version="1.0" encoding="windows-1252"?> <rpa> <folders> <folder>admin <file>customers_reward_points.php</file> <file>group_reward_points.php</file> <file>reward_points.php</file> <folder>includes <file>reward_points.css</file> <folder>boxes <folder>extra_boxes <file>group_reward_points_customers_dhtml.php</file> <file>reward_points_catalog_dhtml.php</file> <file>reward_points_customers_dhtml.php</file> <file>reward_points_dhtml.php</file></folder></folder> <folder>extra_datafiles <file>reward_points_filenames.php</file></folder> <folder>functions <folder>extra_functions <file>reward_points_functions.php</file></folder></folder> <folder>javascript <file>reward_points.js</file></folder> <folder>languages <folder>english <file>customers_reward_points.php</file> <file>group_reward_points.php</file> <file>reward_points.php</file> <folder>extra_definitions <file> reward_points_definitions.php</file></folder></folder></folder></folder></folder> <folder>includes <folder>auto_loaders <file>config.reward_points.core.php</file></folder> <folder>classes <folder>observers <file>class.reward_points.php</file></folder></folder> <folder>extra_datafiles <file>reward_points_filenames.php</file></folder> <folder>functions <folder>extra_functions <file>reward_points_functions.php</file></folder></folder> <folder>languages <folder>english <folder>extra_definitions <folder>CUSTOM <file>reward_points.php</file></folder></folder> <folder>modules <folder>order_total <file>ot_reward_points.php</file> <file>ot_reward_points_discount.php</file> <file>ot_reward_points_display.php</file></folder></folder></folder></folder> <folder>modules <folder>order_total <file>ot_reward_points.php</file> <file>ot_reward_points_discount.php</file> <file>ot_reward_points_display.php</file></folder> <folder>sideboxes <folder>CUSTOM <file>reward_points.php</file> <file>shopping_cart_with_rewards.php</file></folder></folder></folder> <folder>templates <folder>CUSTOM <folder>css <file>stylesheet_reward.css</file></folder> <folder>sideboxes <file>tpl_reward_points.php</file> <file>tpl_shopping_cart_with_rewards.php</file></folder> <folder>templates <file>tpl_account_edit_default.php</file> <file>tpl_product_info_display.php</file> <file>tpl_product_reward_points.php</file> <file> tpl_create_account_success_default.php</file></folder></folder></folder></folder> </folders> <tables> <table>reward_master <field>rewards_products_id</field> <field>scope</field> <field>scope_id</field> <field>point_ratio</field> <field>bonus_points</field> <field>redeem_ratio</field> <field>redeem_points</field></table> <table>reward_customer_points <field>customers_id</field> <field>reward_points</field> <field>pending_points</field></table> <table>reward_status_track <field>rewards_id</field> <field>customers_id</field> <field>orders_id</field> <field>date</field> <field>reward_points</field> <field>status</field></table> <table>configuration_group <record>Reward Points</record></table> <table>configuration <record>Reward Point Sidebox Display</record> <record>Reward Point Status Track</record> <record>Reward Point Sunrise Period</record> <record>Reward Point Redeem Minimum</record> <record>Reward Point Redeem Maximum</record> <record>Reward Point Rounding</record> <record>Max Transactions to Display in Customer Admin</record> <record>Delete Old Reward Transactions Period</record> <record>Adjust Reward Points for Sales/Specials</record> <record>Allow Reward Points on Free Products</record> <record>Allow Redeem of Reward Points on Order Total or Subtotal</record> <record>Set Minimum Order Value to Redeem Points Against</record> <record>Limit maximum Customers on Listings</record> <record>Display Products Reward Points When Zero</record> <record>Set New Account Reward Points</record></table> </tables> </rpa>

I was also very sure to load all the files I had in the download. I am not sure if this would fix the problem that I have of not seeing everything that is in the screen shots, or the original problem I had that was posted in post # 1256. I am having 2 separate problems with this mod, so any help is HUGELY appreciated! Thank you!

You are running the rpd.xml file- Run rpd.php

hem:

You are running the rpd.xml file- Run rpd.php

OK, I feel really stupid for asking this, but how do I do that?
I put the rdp.xml and php files in my root directory. When I put in the address https://www.lauriesscraps.com/rpd.php it say s the link is broken, and when I click on it in FTP it just pulls up the coding.

I know this should be simple, but I just don't know what you mean. Thank you for your patience with me.

OK, I think I got it fixed, as far as seeing the other things I was not in the screenshots. Now I am seeing an error message somewhere else, under Customer Reward Points Admin:

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 '' at line 1
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_group_pricing, r.pending_points, r.reward_points, gp.group_name, rm.redeem_ratio from customers as c LEFT JOIN (reward_customer_points as r) ON (r.customers_id=c.customers_id) LEFT JOIN(group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) LEFT JOIN(reward_master as rm) ON ((c.customers_group_pricing!=0 AND rm.scope=3 AND rm.scope_id=c.customers_group_pricing) OR (c.customers_group_pricing=0 AND rm.scope=0 AND rm.scope_id=0)) WHERE c.customers_lastname LIKE 'A%' ORDER BY c.customers_lastname LIMIT ;]
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 a=have been going through everything trying to figure this out on my own and just decided to uninstall the SQL patch then reinstall it, which worked ok, then I started changes some of the settings in admin and I got th error again, so I uninstalled then reinstalled again and it fixed it. Not sure if will give me the error again or not, but for now it is fixed.

The only other question I have is this..... I installed another module that gives a "free gift" of my choosing when the order is over a certain amount of money. Even though it shows up as free in the shopping cart when it is automatically added, and I have free products set to 0 points, it still gives points for the "free gift" item. Do you know if that can be changed or fixed?

Thanks again for all your help. I am slowly learning my way around all of these. Thank you for your patience.

hem:

I not sure- My guess would be to code into the function pre_confirmation_check() so that the order total is checked and if it is zero then don't prompt for paypal details.

Mine is doing the same thing and I did not see a fix to this problem. Is there a fix to this?

Mine will go straight to pay pal even if there is nothing owing, and I can also not choose how many points to put towards the purchase. Is this something that is in the beta version that was posted about back in October?

Thanks again!

hem:

Just set your ratio to 1.15.
But how to handle that, when I use two different taxes in shop?

I still haven't gotten any response on my questions.... does anyone have any suggestions on the pay pal problem and the points being given for free gifts problem? Thank you!

Crzipilot:

Ran that update. It did place the items on the menu, but now I have two reward points directories on the config menu. One is blank.....one has all the options on it. I will mess with it and make sure it's figuring it correctly.

thanks

This is what has happened to me.

Kind Regards

integrity_designs:

This is what has happened to me.

Kind Regards

there's an SQL patch included in the mod zipfile called remove_multiple_config_items.sql. Just run that under Config->Tools->SQL Patches.

lauriesscraps:

I still haven't gotten any response on my questions.... does anyone have any suggestions on the pay pal problem and the points being given for free gifts problem? Thank you!

Well the first issue is a Paypal problem so probably the best is to flag it with them. For the second I'd change the way your RP is being calculated in Config->Reward Points; From the readme.txt

From 1.20a admin can set a Mode configuration item to select whether points are rewarded by product or are
rewarded by order (sub)total.

hem:

there's an SQL patch included in the mod zipfile called remove_multiple_config_items.sql. Just run that under Config->Tools->SQL Patches.

This is what I got when I used the remove_multiple_config_items.sql:

1146 Table 'integri2_zc1.configuration' doesn't exist
in:
[DELETE FROM zen_configuration_group WHERE configuration_group_id NOT IN ( SELECT configuration_group_id FROM configuration WHERE 1);]
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 did try it earlier on tonight and for some reason I had all my products etc missing so I re-installed the sql patch and now I have 3 of the Reward Points in configuration under Admin.

Kind Regards

integrity_designs:

This is what I got when I used the remove_multiple_config_items.sql:

I did try it earlier on tonight and for some reason I had all my products etc missing so I re-installed the sql patch and now I have 3 of the Reward Points in configuration under Admin.

Kind Regards

There is an issue with an ZC corefile called sqlpatch.php which affects anyone who uses a prefix on their zencart tables. You can find an updated version in admin/sqlpatch.zip- Just extract this to admin/sqlpatch.php and the script will work.