Reward Points Module for ZC v13x

[pinetreecandles]

So did I. I even went ahead and created my own FAQ that is HEAVILY inspired by the one Nullmind did for his site.

http://shop.ironcrown.com/index.php?...ard_points_faq

Mine pales in comparison to his. Well done I guess I will have to revist mine and give it it's own page since atm it's buried with my other FAQ's.

[Berserker]

Mine pales in comparison to his. Well done I guess I will have to revist mine and give it it's own page since atm it's buried with my other FAQ's.

Same here. By the way, how do you send someone points?

[Mike_Dean]

Hmmm.

Trying to install on my local site and I get this error when trying to access admin

1146 Table 'nortsandones.reward_status_track' doesn't exist
in:
[SELECT ph.*, o.orders_status FROM reward_status_track ph, orders o WHERE ph.orders_id=o.orders_id AND ph.date 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 renamed the custom folder to the same as mine, and then uploaded both the admin and includes. But as soon as I try and do anyting in Admin, it throws up the above error. ?

What steps did I miss ?

[Rasyr]

Hmmm.

Trying to install on my local site and I get this error when trying to access admin

1146 Table 'nortsandones.reward_status_track' doesn't exist
in:
[SELECT ph.*, o.orders_status FROM reward_status_track ph, orders o WHERE ph.orders_id=o.orders_id AND ph.date 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 renamed the custom folder to the same as mine, and then uploaded both the admin and includes. But as soon as I try and do anyting in Admin, it throws up the above error. ?

What steps did I miss ?

Mike, read back through this thread

Basically, that is an issue with the sql file and IF you have a DB prefix in use.

[Mike_Dean]

Mike, read back through this thread

Basically, that is an issue with the sql file and IF you have a DB prefix in use.

Thanks,

I'm not using a prefix, my db is nortandones not xxx_nortsandones.

What am I supposed to be renaming the following file to ?

Rename reward_points_functions.php to reward_points_functions.xxx

[Rasyr]

Thanks,

I'm not using a prefix, my db is nortandones not xxx_nortsandones.

What am I supposed to be renaming the following file to ?

Rename reward_points_functions.php to reward_points_functions.xxx

The prefix isn't on the DB name, it is on the DB table names. (i.e. the configuration table might be names zen_configuration).

You can look inside your includes/configure.php file to see if the store thinks you are using a DB Prefix -- for a line that says something like:

define('DB_PREFIX', 'zen_');

It it isn't that you need to rename the sql file, it is that you may need to make changes to it and rerun it (if your DB is using a prefix).

Here is the post that I was referring to finding -- http://www.zen-cart.com/forum/showpo...7&postcount=19

I don't think that you need to be renaming that file you are listing at all.

[Mike_Dean]

The prefix isn't on the DB name, it is on the DB table names. (i.e. the configuration table might be names zen_configuration).

You can look inside your includes/configure.php file to see if the store thinks you are using a DB Prefix -- for a line that says something like:


It it isn't that you need to rename the sql file, it is that you may need to make changes to it and rerun it (if your DB is using a prefix).

Here is the post that I was referring to finding -- http://www.zen-cart.com/forum/showpo...7&postcount=19

I don't think that you need to be renaming that file you are listing at all.

Thanks Rasyr, appreciate your help on this,

Ok..

I checked the file as you suggested and it's as follows.

define('DB_PREFIX', '');

So we can assume that there is no prefix..

The problem is, that I can't even run the sql file to begin with.

I uploaded the files, and then when I try and enter the Admin CP, thats when I get the error, so I can't even run the sql to begin with, so modifying the sql is not going to help ?

Sorry....

[bellaphile]

Here is the post that I was referring to finding -- http://www.zen-cart.com/forum/showpo...7&postcount=19

Hi,
I've tried this procedure and I still get the same error when I try to uninstall this (even my backup files aren't overriding this). How can I get rid of it?

Thanks!

[hem]

Thanks,

I'm not using a prefix, my db is nortandones not xxx_nortsandones.

What am I supposed to be renaming the following file to ?

Rename reward_points_functions.php to reward_points_functions.xxx

Exactly as it shows- change the extension to 'xxx'- that will stop it causing the error until you can do the SQL table rename.

[Rasyr]

Same here. By the way, how do you send someone points?

If you, as admin, want to give a person some points (beyond what they earn), the go to Admin|Customers|Reward Points, and then find and edit the customer.

My boss gave everybody on our store 1000 points to begin with (and then I had another 83 that I need to give even more to) -- i.e. every got 1000 points, those who had purchased more than $500 since 2002 (I have the records from the old online store, pre-zen) got additional points - equal to 2x the dollar amount that they spent.

So for the "everybody gets 1000 points, I did a sql statement and ran it and then have been working on editing the others since then.