SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Froogle Configuration';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'Froogle Configuration', 'Set Froogle Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Froogle Configuration';
INSERT INTO configuration VALUES ('', 'Froogle Username', 'FROOGLE_USERNAME', 'froogle_username', 'Enter your Froogle username', @t4, 1, now(), now(), NULL, NULL),
                                 ('', 'Froogle Password', 'FROOGLE_PASSWORD', 'froogle_password', 'Enter your froogle password', @t4, 2, now(), now(), NULL, NULL),
                                 ('', 'Froogle Server', 'FROOGLE_SERVER', 'hedwig.google.com', 'Enter froogle server<br />default: hedwig.google.com', @t4, 3, now(), now(), NULL, NULL),
                                 ('', 'Default Currency', 'FROOGLE_CURRENCY', 'USD', 'Enter currency<br />default = USD', @t4, 4, now(), now(), NULL, NULL),
                                 ('', 'Show Offer ID', 'FROOGLE_OFFER_ID', 'true', 'Display Offer ID', @t4, 5, now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
                                 ('', 'In Stock/Out Of Stock Status', 'FROOGLE_IN_STOCK', 'false', 'Display In Stock/Out Of Stock Status<br />Only use for advanced feeds', @t4, 6, now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
                                 ('', 'Low Cost Shipping Status', 'FROOGLE_SHIPPING', 'false', 'Display Minimum Shipping Amount<br />Only use for advanced feeds', @t4, 7, now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
                                 ('', 'Lowest Shipping Costs', 'FROOGLE_SHIPPING_LOW', '4.95', 'If Low Cost Shipping Status is True, what is your lowest shipping amount?<br />Only use for advanced feeds', @t4, 8, now(), now(), NULL, NULL),
                                 ('', 'Show Manufacturer', 'FROOGLE_MANUFACTURER', 'false', 'Display Manufacturer Name<br />Only use for advanced feeds', @t4, 9, now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
                                 ('', 'Show Product Type', 'FROOGLE_PRODUCT_TYPE_SHOW', 'false', 'Display Product Type<br />Only use for advanced feeds', @t4, 10, now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
                                 ('', 'Product Type', 'FROOGLE_PRODUCT_TYPE', 'other', 'If Display Product Type is True, choose your product type<br />Only use for advanced feeds', @t4, 11, now(), now(), NULL, 'zen_cfg_select_option(array(''book'', ''music'', ''video'', ''other''),'),
                                 ('', 'Show Feed Lanugage', 'FROOGLE_FEED_LANGUAGE_DISPLAY', 'false', 'Display Feed Language<br />Only use for advanced feeds', @t4, 12, now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
                                 ('', 'Feed Language', 'FROOGLE_FEED_LANGUAGE', 'en', 'If Show Feed Language is True, what is your feed language?<br />default = en<br />Only use for advanced feeds', @t4, 13, now(), now(), NULL, NULL),
                                 ('', 'Show Ship To Locations', 'FROOGLE_SHIP_TO_DISPLAY', 'false', 'Display Ship To Locations<br />Only use for advanced feeds', @t4, 14, now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
                                 ('', 'Ship To Locations', 'FROOGLE_SHIP_TO', 'ALL', 'If Show Ship To Locations is True, where do you ship to?<br />default = ALL<br />Only use for advanced feeds', @t4, 15, now(), now(), NULL, NULL),
                                 ('', 'Show Ship From Location', 'FROOGLE_SHIP_FROM_DISPLAY', 'false', 'Display Ship From Location<br />Only use for advanced feeds', @t4, 16, now(), now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
                                 ('', 'Ship From Location', 'FROOGLE_SHIP_FROM', 'USD', 'If Show Ship From Location is True, where do you ship from?<br />default = USD<br />Only use for advanced feeds', @t4, 17, now(), now(), NULL, NULL),
                                 ('', 'Output File Name', 'FROOGLE_OUTPUT_FILENAME', 'froogle.txt', 'Set the name of your froogle output file', @t4, 19, now(), now(), NULL, NULL);