Reward Points Module for ZC v13x

[hem]

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.

[mipavluk]

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

[LissaE]

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 :)

[mipavluk]

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...

[mipavluk]

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.

[myworld20091]

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?

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

[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

[hem]

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?

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

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

[hem]

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?

[nyrad]

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