Master Products - Ms2

[martinstan]

Hi

This looks perfect fo my needs but also quite a complicated install.

 

a) does anyone have this running online anywhere so that I can see it in action?

 

b)could someone tell me how to install the following sql.

INSERT INTO configuration VALUES ('', 'Display Slave Product Name', 'MASTER_LIST_NAME', '5', 'Do you wish to display the products name?', 16, 1, '2003-11-17 20:22:53', '2003-11-04 23:28:38', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Display Slave Product Price', 'MASTER_LIST_PRICE', '13', 'Do you want to display the Product Price?', 16, 3, '2003-11-16 20:47:55', '2003-11-04 23:28:38', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Display Slave Product Manufacturer Name', 'MASTER_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', 16, 4, NULL, '2003-11-04 23:28:38', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Display Slave Product Image', 'MASTER_LIST_IMAGE', '0', 'Do you want to display the Product Image?', 16, 8, '2003-11-10 21:38:06', '2003-11-04 23:28:38', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Display Slave Product Model', 'MASTER_LIST_MODEL', '1', 'Do you want to display the Product Model?', 16, 2, '2003-11-16 22:10:58', '2003-11-04 23:28:38', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Display Slave Product Quantity', 'MASTER_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', 16, 6, '2003-11-09 22:49:47', '2003-11-04 23:28:38', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Display Slave Product Weight', 'MASTER_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', 16, 5, NULL, '2003-11-04 23:28:38', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Display Slave Product Options', 'MASTER_LIST_OPTIONS', '2', 'Set to 0 to disable, set to 8 to enable.', 16, 12, now(), '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'MASTER_PREV_NEXT_BAR_LOCATION', '2', ' Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 16, 12, '2003-11-10 01:02:58', '2003-11-04 23:28:38', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Display the Buy Now Column', 'MASTER_LIST_BUY_NOW', '10', 'Do you want to display the Buy Now column?', 16, 9, '2003-11-12 19:02:59', '2003-11-09 20:38:04', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Display Slave Product Description', 'MASTER_LIST_DESCRIPTION', '2', 'Set to 0 to disable, set to 99 to enable.', 16, 10, '2003-11-17 19:02:49', '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO configuration VALUES ('', 'Length of Truncated Product Description', 'MASTER_LIST_DESCRIPTION_LENGTH', '100', 'How many characters would you like to display?', 16, 11, '2003-11-10 23:36:52', '2003-11-10 18:51:26', NULL, NULL);
insert into configuration values ('', 'Entries in Accessories Infobox', 'MASTER_LIST_NUM_ACCESSORIES', '5', 'Maximum number of entries in the suggested accessories infobox', 3, 12, now(), now(), NULL, NULL);


INSERT INTO configuration_group VALUES (16, 'Slave Products', 'Slave Product Listing - configuration options', 16, 1);

ALTER TABLE products ADD products_master VARCHAR( 50 ) NOT NULL DEFAULT '0';
ALTER TABLE products ADD products_master_status tinyint(2) NOT NULL default '0';
ALTER TABLE products ADD products_listing_status tinyint(2) NOT NULL default '1';

 

Do I just run it in PHPmyadmin in the SQL tab?

 

Thanks in advance