The Specials_Random Contribution

[sargenle]

In the Specials_Random contribution the author states this about the database.

 

 

This just a simple way to add random products as special across your website.

 

Upon running the file it selects x random products on show and applys the dates and discounts you setup in the admin.

If that product is already in the special it skips over it and does nothing. Once the script has run it will output 2 values.

The values tell you how many items it entered and how many it skipped over.

 

Just enter the following values into your database an you will see a configuration section called Specials.

Setup your settings there and then run the script once, you should now see these items in the specials section.

 

The group has the id of 53, just a random number I picked. If this already exists just change all occurances of 53 with a free configuration group number.

 

Does anyone know what the author is talking about.

 

I know I need to add something to the categories table but what to add I am unsure.

 

Lee

[sargenle]

In the Specials_Random contribution the author states this about the database.

Does anyone know what the author is talking about. 

 

I know I need to add something to the categories table but what to add I am unsure.

 

Lee

<{POST_SNAPBACK}>

 

I guess this might give more help to those reading what I am asking about.

 

I thought this was PHP code but I guess it describes what should go into the database.

 

 

INSERT INTO `configuration_group` ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` )

VALUES (

'53', 'Specials', 'Defining the values for auto create specials', '53' , '1'

);

INSERT INTO configuration VALUES ('', 'Minimum special price', 'SPECIAL_PRODUCT_MIN_PRICE', '10', 'Enter the minimum price for a product to be selected for a special. Any products below this price will not be selected.', 53, NULL, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('', 'Special Percentage', 'SPECIAL_PERCENTAGE', '5', 'This holds the percentage you want to take off of the products which are placed on special.', 53, NULL, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('', 'Number of Specials', 'NUMBER_SPECIALS', '5', 'How many products should be added as specials. This is a maximum value', 53, NULL, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('', 'Special Days', 'NUMBER_SPECIAL_DAYS', '14', 'How many days should the product be on special for?', 53, NULL, NULL, now(), NULL, NULL);