Code:
# ePier Bulk File Generator
#ALTER TABLE products ADD products_epier int(4) NULL default NULL;
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'ePier Exporter Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'ePier Exporter Configuration', 'Set ePier Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'Output File Name', 'EPIER_OUTPUT_FILENAME', 'epier.txt', 'Set the name of your ePier output file', @configuration_group_id, 0, NOW(), NULL, NULL),
(NULL, 'Output Directory', 'EPIER_DIRECTORY', 'feed/', 'Set the name of your ePier output directory', @configuration_group_id, 0, NOW(), NULL, NULL),
(NULL, 'Use cPath in url', 'EPIER_USE_CPATH', 'false', 'Use cPath in product info url', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Compress Feed File', 'EPIER_COMPRESS', 'false', 'Compress ePier file?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Language', 'EPIER_LANGUAGE', 'English', 'The language of the products you wish to include (must match your database).', @configuration_group_id, 0, NOW(), NULL, NULL),
(NULL, 'Language Display', 'EPIER_LANGUAGE_DISPLAY', 'false', 'Do you want to include the language in your links? (required if your store is non-English default)', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Currency', 'EPIER_CURRENCY', 'USD', 'The currency of the products you wish to include (must be USD).', @configuration_group_id, 0, NOW(), NULL, NULL),
(NULL, 'Currency Display', 'EPIER_CURRENCY DISPLAY', 'false', 'Do you want to include the currency in your links? (required if your store is non-USD default)', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Included Categories', 'EPIER_POS_CATEGORIES', '', 'Enter category names separated by commas <br>(i.e. computers,software,televisions)<br>Leave blank to allow all categories', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'Excluded Categories', 'EPIER_NEG_CATEGORIES', '', 'Enter category names separated by commas <br>(i.e. computers,software,televisions)<br>Leave blank to deactivate', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'Starting Point', 'EPIER_START_PRODUCTS', '0', 'Default = 0 (not product_id)', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'Max products', 'EPIER_MAX_PRODUCTS', '0', 'Default = 0 for infinite # of products', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'Auction Site Attributes', 'EPIER_ASA', 'false', 'Activate Auction Site Attributes?', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Duration', 'EPIER_DURATION', '7', 'Duration in days up to 21 days maximum<br />default = 7', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'2\'),'),
(NULL, 'Define Shipping Cost?', 'EPIER_SHIPPING_SWITCH', 'false', 'Do you want to define your shipping costs?', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Shipping Cost', 'EPIER_SHIPPING_COST', '', 'Define your shipping costs', @configuration_group_id, 4, NOW(), NULL, NULL),
(NULL, 'Shipping Payment', 'EPIER_SHIPPING_PAYMENT', '4', '1 - Seller Pays Shipping<br />2 - Buyer Pays Actual Shipping<br />3 - Buyer Pays Fixed Amount<br />4 - Other (See Description)', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'2\',\'3\',\'4\'),'),
(NULL, 'Shipping Zone', 'EPIER_SHIPPING_ZONE', '', 'Where are you willing to ship?<br />1 - Own Country only<br />2 - Internationally', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'2\'),'),
(NULL, 'Reserve Price', 'EPIER_RESERVE', '0', 'What percentage of the store price do you want your reserve price to be?<br />Default = 0', @configuration_group_id, 5, NOW(), NULL, NULL),
(NULL, 'Starting Price', 'EPIER_STARTING', '100', 'What percentage of the store price do you want your starting price to be?<br />Default = 100', @configuration_group_id, 5, NOW(), NULL, NULL),
(NULL, 'Auto Relist', 'EPIER_AUTO_RELIST', 'n', 'Should this auction automatically restart if it closes with no bids?', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_select_option(array(\'y\', \'n\'),'),
(NULL, 'Featured Item', 'EPIER_FEATURED_ITEM', 'n', 'Should this item be featured on the main page? There is a $5 cost per item.', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_select_option(array(\'y\', \'n\'),'),
(NULL, 'Bold Title', 'EPIER_BOLD_TITLE', 'n', 'Should this item\'s title show in bold in Item Listings? There is a $0.50 cost per item.', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_select_option(array(\'y\', \'n\'),'),
(NULL, 'Photo Gallery', 'EPIER_PHOTO_GALLERY', 'n', 'Should this appear in the main page\'s Photo Gallery? There is a $0.50 cost per item.', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_select_option(array(\'y\', \'n\'),'),
(NULL, 'Category Featured Item', 'EPIER_CATEGORY_FEATURED_ITEM', 'n', 'Should this item be featured in its Top Level Category? $1 charge per item', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_select_option(array(\'y\', \'n\'),'),
(NULL, 'Payment Method', 'EPIER_PAYMENT_METHOD', '', 'What forms of payment do you accept? For more than one, seperate the list with commas(like 1,2,5)<br />1 - Money Order / Cashier\'s Check<br />2 - Personal Check<br />3 -Visa / Mastercard<br />4 -C.O.D. (Collect On Delivery)<br />5 - On-Line Escrow<br />6 - American Express<br />7 - Discover<br />8 - See Description<br />9 - Other<br />10 - Contact Seller', @configuration_group_id, 6, NOW(), NULL, NULL),
(NULL, 'Quantity', 'EPIER_QUANTITY', '', 'The number of items you are selling on this auction.<br />Leave blank to include all stock.', @configuration_group_id, 7, NOW(), NULL, NULL),
(NULL, 'Target', 'EPIER_TARGET', '0', 'This is where the item is going to be listed, or where it is from. If this is an item update, this MUST reflect where the item came from.<br />0 - ePier Auction<br />1 - Basic Storefront<br />2 - Advanced Storefront', @configuration_group_id, 8, NOW(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\',\'2\'),');
Bookmarks