Reward Points Module for ZC v13x

mipavluk:

yes, I delete it... in admin/includes/javascript
I don't have files related with the mod

Did you run RPD? That will show you any files still left.

RPD? I don't know what is that... :huh:

From the readme file in the mod zip:

Reward Point Mod Diagnostic Tool.

This is available here: http://www.omnicia.com/rpd.zip

If you have renamed your admin folder, you will need to open up rpd.xml in a plain text editor and change admin to your actual admin folder name

<?xml version="1.0" encoding="windows-1252"?>
<rpa>
    <folders>
        <folder>admin
```If memory is correct LOL you upload the files to your store directory then browse to your_site/your_store/rpd.php and it will give you a list of all files and if they are still there or missing :)

I take a look in your store, you have the mod installed... is working? or you assign points manually?
how you do with sales? because in my store, with sale prices points was applicated to real price.... I check yours and when you have sale price, points change to sale price...

Reward Point Module Diagnostic

Site Settings

Zencart version: Zen Cart v1.3.8a
PHP version: 5.2.9
MySQL version: 4.1.22-standard

Zencart Settings

Zencart Custom Folder: includes/templates/orange/
Zencart Custom Template: orange
Zencart MySQL Prefix: zen_

Folder/File Check

admin/- folder found.
admin/customers_reward_points.php- file missing!!!
admin/group_reward_points.php- file missing!!!
admin/reward_points.php- file missing!!!
admin/includes/- folder found.
admin/includes/reward_points.css- file missing!!!
admin/includes/boxes/- folder found.
admin/includes/boxes/extra_boxes/- folder found.
admin/includes/boxes/extra_boxes/group_reward_points_customers_dhtml.php- file missing!!!
admin/includes/boxes/extra_boxes/reward_points_catalog_dhtml.php- file missing!!!
admin/includes/boxes/extra_boxes/reward_points_customers_dhtml.php- file missing!!!
admin/includes/boxes/extra_boxes/reward_points_dhtml.php- file missing!!!
admin/includes/extra_datafiles/- folder found.
admin/includes/extra_datafiles/reward_points_filenames.php- file missing!!!
admin/includes/functions/- folder found.
admin/includes/functions/extra_functions/- folder found.
admin/includes/functions/extra_functions/reward_points_functions.php- file missing!!!
admin/includes/javascript/- folder found.
admin/includes/javascript/reward_points.js- file missing!!!
admin/includes/languages/- folder found.
admin/includes/languages/english/- folder found.
admin/includes/languages/english/customers_reward_points.php- file missing!!!
admin/includes/languages/english/group_reward_points.php- file missing!!!
admin/includes/languages/english/reward_points.php- file missing!!!
admin/includes/languages/english/extra_definitions/- folder found.
admin/includes/languages/english/extra_definitions/reward_points_definitions.php- file missing!!!
includes/- folder found.
includes/auto_loaders/- folder found.
includes/auto_loaders/config.reward_points.core.php- file missing!!!
includes/classes/- folder found.
includes/classes/observers/- folder found.
includes/classes/observers/class.reward_points.php- file missing!!!
includes/extra_datafiles/- folder found.
includes/extra_datafiles/reward_points_filenames.php- file missing!!!
includes/functions/- folder found.
includes/functions/extra_functions/- folder found.
includes/functions/extra_functions/reward_points_functions.php- file missing!!!
includes/languages/- folder found.
includes/languages/english/- folder found.
includes/languages/english/extra_definitions/- folder found.
includes/languages/english/extra_definitions/orange/- folder missing!!!
includes/languages/english/extra_definitions/orange/reward_points.php- file missing!!!
includes/languages/english/modules/- folder found.
includes/languages/english/modules/order_total/- folder found.
includes/languages/english/modules/order_total/ot_reward_points.php- file missing!!!
includes/languages/english/modules/order_total/ot_reward_points_display.php- file missing!!!
includes/modules/- folder found.
includes/modules/order_total/- folder found.
includes/modules/order_total/ot_reward_points.php- file missing!!!
includes/modules/order_total/ot_reward_points_display.php- file missing!!!
includes/modules/sideboxes/- folder found.
includes/modules/sideboxes/orange/- folder missing!!!
includes/modules/sideboxes/orange/reward_points.php- file missing!!!
includes/modules/sideboxes/orange/shopping_cart_with_rewards.php- file missing!!!
includes/templates/- folder found.
includes/templates/orange/- folder found.
includes/templates/orange/css/- folder found.
includes/templates/orange/css/stylesheet_reward.css- file missing!!!
includes/templates/orange/sideboxes/- folder found.
includes/templates/orange/sideboxes/tpl_reward_points.php- file missing!!!
includes/templates/orange/sideboxes/tpl_shopping_cart_with_rewards.php- file missing!!!
includes/templates/orange/templates/- folder found.
includes/templates/orange/templates/tpl_account_edit_default.php- file found.
includes/templates/orange/templates/tpl_product_info_display.php- file found.
includes/templates/orange/templates/tpl_product_reward_points.php- file missing!!!
includes/templates/orange/templates/tpl_create_account_success_default.php- file found.
MySQL Database Check

zen_reward_master- table missing!!!
rewards_products_id- field missing in zen_reward_master!!!
scope- field missing in zen_reward_master!!!
scope_id- field missing in zen_reward_master!!!
point_ratio- field missing in zen_reward_master!!!
bonus_points- field missing in zen_reward_master!!!
redeem_ratio- field missing in zen_reward_master!!!
redeem_points- field missing in zen_reward_master!!!
zen_reward_customer_points- table missing!!!
customers_id- field missing in zen_reward_customer_points!!!
reward_points- field missing in zen_reward_customer_points!!!
pending_points- field missing in zen_reward_customer_points!!!
zen_reward_status_track- table missing!!!
rewards_id- field missing in zen_reward_status_track!!!
customers_id- field missing in zen_reward_status_track!!!
orders_id- field missing in zen_reward_status_track!!!
date- field missing in zen_reward_status_track!!!
reward_points- field missing in zen_reward_status_track!!!
status- field missing in zen_reward_status_track!!!
zen_configuration_group- table found.
Reward Points- record found in zen_configuration_group.
zen_configuration- table found.
Reward Point Sidebox Display- record found in zen_configuration.
Reward Point Status Track- record found in zen_configuration.
Reward Point Sunrise Period- record found in zen_configuration.
Reward Point Redeem Minimum- record found in zen_configuration.
Reward Point Redeem Maximum- record found in zen_configuration.
Reward Point Rounding- record found in zen_configuration.
Max Transactions to Display in Customer Admin- record found in zen_configuration.
Delete Old Reward Transactions Period- record found in zen_configuration.
Adjust Reward Points for Sales/Specials- record found in zen_configuration.
Allow Reward Points on Free Products- record found in zen_configuration.
Allow Redeem of Reward Points on Order Total or Subtotal- record found in zen_configuration.
Set Minimum Order Value to Redeem Points Against- record found in zen_configuration.
Limit maximum Customers on Listings- record found in zen_configuration.
Display Products Reward Points When Zero- record found in zen_configuration.
Set New Account Reward Points- record found in zen_configuration.

hi hem,
when i run the sql, i got the following errors:

23 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 16 statements ignored. See "upgrade_exceptions" table for additional details.

now,
i can see "reward points" from admin-configuration", but when i click it, the page is empty.

i can see "reward points" from admin-customers, but when i click it, i got this:

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_CUSTOMER_LIMIT' 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 'B%' ORDER BY c.customers_lastname LIMIT REWARD_POINTS_CUSTOMER_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.

how do i fix the problem? :cry:

i use zencart 1.38a, reward points 1.22a, mysql 5.0

I installed the rewards points cart but the sidebox for it isn't showing up on the front end. Can anybody tell me what I'm doing wrong? Thanks

~Eris

myworld20091:

hi hem,
when i run the sql, i got the following errors:

now,
i can see "reward points" from admin-configuration", but when i click it, the page is empty.

i can see "reward points" from admin-customers, but when i click it, i got this:

how do i fix the problem? :cry:

i use zencart 1.38a, reward points 1.22a, mysql 5.0

Try running the uninstall.sql and then the new.sql

Eris:

I installed the rewards points cart but the sidebox for it isn't showing up on the front end. Can anybody tell me what I'm doing wrong? Thanks

~Eris

Have you switch it on under the Layout Boxes?

having a similar difficult time; tried to uninstall and reinstall and ended up with multiple Reward Point menu choice under admin configuration menu. I have removed all of the instlled files, but when i run the uninstall sql i get :

1146 Table 'civilwardocs.configuration' doesn't exist
in:
[DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_id;]
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 field

the menu items are still there....

when i run the rpd.php i get:

Reward Point Module Diagnostic
Site Settings
Zencart version: Zen Cart v1.3.8
PHP version: 4.4.7
MySQL version: 5.0.51a-log
Zencart Settings
Zencart Custom Folder: includes/templates/darkness/
Zencart Custom Template: darkness
Zencart MySQL Prefix: zen

all other admin menu items are gone, and the shopping process seems to work fine; how can i remove the admin - configure menu choices

Thanks in advance

i can see that the uninstall did not remove the configuration group from the database, but i would rather have the uninstall sql do it than remove them manually - i do not know if there are other items that should be removed as well

hi hem,
all products price display in price inc on my site.

if the product price exc $100, tax 10%, price inc $110, 1$=1point

so, i need it to be:

on product description page : Price $110, 100 reward points
in shopping cart : 100 reward points
on total order page when check out : 100 reward points

but now, i have the tax problem, it shows:

on product description page : Price $110, 100 reward points
in shopping cart : 110 reward points
on total order page when check out : 110 reward points

any ideas?

i have a question, i'm not sure if it could be done with the current version RP mod.
if the product price is $10 with an attribute $3, then the customer get 13 points for this order. but i dont want it add the attribute price to the point, is it possible?

nyrad:

i can see that the uninstall did not remove the configuration group from the database, but i would rather have the uninstall sql do it than remove them manually - i do not know if there are other items that should be removed as well

I'm having a similar problem. Though I managed to get missing areas back by using update.sql instead of new.sql after uninstall.sql, I had to reset up my reward points set-up, which I expected anyways after all that, but I too have multiple "Reward Points" sections with only one functional one in my configuration section. I remember reading something about it somewhere, but I'm too tired to try and find it again as I've literally read through the whole thread and did all the adjustments as needed along the way lol I remember having to go through my phpadmin once to change IDs for products, so I'm guessing I would have to do the same for this? I just can't seem to find the IDs for those "extra" pages in the phpadmin. But i'll try looking a little bit more before heading to bed. Otherwise any help or suggestion for this is appreciated. Btw, love this mod, once i got the hang of it, it wasn't as difficult. Thanks ^^

i set global reward point ratio to 1, its ok.
then i set one catagory reward point ratio to 50.

i go to the product page of this catagory, it showing correctly on the product description page. but in shopping cart, it still keep the ratio 1. and when check out, the ratio is also 1.

i dont know what's wrong with my rp mod?

Ayperi:

I'm having a similar problem. Though I managed to get missing areas back by using update.sql instead of new.sql after uninstall.sql, I had to reset up my reward points set-up, which I expected anyways after all that, but I too have multiple "Reward Points" sections with only one functional one in my configuration section. I remember reading something about it somewhere, but I'm too tired to try and find it again as I've literally read through the whole thread and did all the adjustments as needed along the way lol I remember having to go through my phpadmin once to change IDs for products, so I'm guessing I would have to do the same for this? I just can't seem to find the IDs for those "extra" pages in the phpadmin. But i'll try looking a little bit more before heading to bed. Otherwise any help or suggestion for this is appreciated. Btw, love this mod, once i got the hang of it, it wasn't as difficult. Thanks ^^

OK, got the issue fixed. Took me a tad to remember how to get to the area I needed lol Although it's simple enough if ya got phpMyAdmin and are at least half way familiar in navigating it, if ya don't on either count, then this probably won't help much but here's how I did it.
Went into my phpMyAdmin in database and selected the zen_configuration_group and selected browse tab. I deleted the ID numbers of pages that were invalid till I got the functional page left. For example I had 33-36 ID with 36 being the functional page. When you're on that browse page on the phpmyadmin you'll see the list of all the links under the configuration of zen cart, including your dublicates. I found that trying to change the 36 ID to a 33 caused it to go blank and doing an "update" sql install again just repeated the earlier prob, so I deleted the newer ID since it wasn't functioning anyways and reset the ID number to 36 and voila, it works.
So all you really needed to do in this case was delete the "blank" pages, leaving the correct one alone. By finding the invalid's ID just mouse over the Reward Points link and look at the last bit that says gID="" with "" being the actual number. And of course you'll want to know which one is valid, so take note of which numbered link works properly. Then when ya go into deleteing stuff you won't delete the wrong one. Hope this helps some of ya'll ^^

well, got other issues work, but i dont know yet how to subtract the reward points of attribute.

1 point = $1,
for the products, price $10, attribute $50
i want only give 10 points to customer
but now, rp mod gives 60 points

where do i modify the set?

myworld20091:

well, got other issues work, but i dont know yet how to subtract the reward points of attribute.

1 point = $1,
for the products, price $10, attribute $50
i want only give 10 points to customer
but now, rp mod gives 60 points

where do i modify the set?

Not possible at the moment. I will put it on the wishlist.

did the php my admin thing and removed them manually; will do fresh install; thanks for your guidance

nyrad:

i can see that the uninstall did not remove the configuration group from the database, but i would rather have the uninstall sql do it than remove them manually - i do not know if there are other items that should be removed as well

This script will delete all empty multiples on the config menu just copy and paste it to SQL patch. However if you use a table prefix you will need to set configuration_group_id to YOUR_PREFIX_configuration_group_id

#NEXT_X_ROWS_AS_ONE_COMMAND:2
DELETE FROM `configuration_group` WHERE NOT IN (
SELECT `configuration_group_id` FROM `configuration` WHERE 1);