Experimental Reward Points Module

[precursor999]

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

[precursor999]

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.

[precursor999]

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

[HeathenMagic]

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

[precursor999]

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

[wajabdul2000]

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.

[precursor999]

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

[wajabdul2000]

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