Experimental Reward Points Module

Experimental Reward Points Module

Hi,
This is not a complete module but try it and if you got anything to say or you would like to have in it just mention it.
YOU'll have to put the ot_reward_points.php file in the includes->modules->order_total folder
and install it through modules folder.
and create two tables

CREATE TABLE `cs_customers_points` (
  `customers_points_id` int(11) NOT NULL auto_increment,
  `orders_products_id` int(11) NOT NULL,
  `points` int(11) NOT NULL,
  `rate` double NOT NULL,
  PRIMARY KEY  (`customers_points_id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `cs_products_points`
-- 

CREATE TABLE `cs_products_points` (
  `cs_products_points_id` int(11) NOT NULL auto_increment,
  `products_id` int(11) NOT NULL,
  `products_points` int(11) NOT NULL,
  PRIMARY KEY  (`cs_products_points_id`),
  UNIQUE KEY `products_id` (`products_id`)
) TYPE=MyISAM ;

and copy the two other files into the admin folder
or you can just copy them as they are
i haven't created the files for the menus(boxes) yet

can't i edit my post that i posted just now.
I will be free for some days so if you think this is worth a try ,try it and tell me of any modification.

I forgot to put the language file. heres the file with the language file

Sounds like it will be a great mod. So far I am getting the following, and a similar one on the last checkout page:-

1146 Table 'thegemtr_zc2.TABLE_CS_CUSTOMERS_POINTS' doesn't exist
in:
[select count(*) as total from TABLE_CS_CUSTOMERS_POINTS ccp inner join zen_orders_products op on ccp.orders_products_id=op.orders_products_id inner join zen_orders o on o.orders_id = op.orders_id left join zen_customers c on o.customers_id = c.customers_id 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.

Thought I would let you know. As for ideas, I don't if it is going to be a case of each item has reward points needed to get the item for free etc but that sounds good.

Cheers,

Heathenmagic

OH!
sorry for that ,i should have forseen it.Inexperience i guess.I hope this one is better and at least it runs.I would again like to warn that this is still in its infancy stage.
Thankyou for trying this and for posting

Hello

I am new to zen cart and I installed your module. I need info on how to configure it and use it in my site, since there is no info that came with the code. I really appreciated in advance.

thanks for trying this out.
i'll put it here as soon as i get enough time.

Hello precursor999

I installed the module and when i go to the admin order total under admin I see the one of your files printed in text in the admin page. So I do not get a chance to configure it. Is there any thing else I need to add to the configuration in general to access the module administration page.

Also, I would like to get any information or documentation regarding the installation and configuration when ever you are ready.

Thank you in advance