Code:
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Links Manager';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_LINKS_STATUS';
INSERT INTO configuration_group VALUES (NULL, 'Links Manager', 'Links Display Settings', '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= 'Links Manager';
INSERT INTO `configuration` VALUES (NULL, 'Links Box - Display View All Links', 'BOX_DISPLAY_VIEW_ALL_LINKS', 'true', 'Display View All Links on Links Sidebox', @t4, 2, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Links Box - Display Submit Link', 'BOX_DISPLAY_SUBMIT_LINK', 'true', 'Display Submit Link on Sidebox', @t4, 3, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Display Description As Link', 'DISPLAY_LINK_DESCRIPTION_AS_LINK', 'false', 'Display the links description as a link', @t4, 4, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Enable Click Count', 'ENABLE_LINKS_COUNT', 'false', 'Enable links click count.', @t4, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Submit Link - Require Reciprocal Page', 'SUBMIT_LINK_REQUIRE_RECIPROCAL', 'true', 'Require Reciprocal Page on Links Submit', @t4, 6, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO `configuration` VALUES (NULL, 'Display Link Banner Image', 'LINK_LIST_IMAGE', '1', 'Do you want to display the Link Banner Image?', @t4, 7, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Display Link Description', 'LINK_LIST_DESCRIPTION', '2', 'Do you want to display the Link Description?', @t4, 8, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Display Link Click Count', 'LINK_LIST_COUNT', '0', 'Do you want to display the Link Click Count?', @t4, 9, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Title Minimum Length', 'ENTRY_LINKS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @t4, 10, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Title Maximum Length', 'ENTRY_LINKS_TITLE_MAX_LENGTH', '50', 'Maximum length of link title.', @t4, 11, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link URL Minimum Length', 'ENTRY_LINKS_URL_MIN_LENGTH', '10', 'Minimum length of link URL.', @t4, 12, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Description Minimum Length', 'ENTRY_LINKS_DESCRIPTION_MIN_LENGTH', '10', 'Minimum length of link description.', @t4, 13, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Description Maximum Length', 'ENTRY_LINKS_DESCRIPTION_MAX_LENGTH', '250', 'Maximum length of link description.', @t4, 14, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Contact Name Minimum Length', 'ENTRY_LINKS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @t4, 15, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Number Of Links to display on Links Page', 'MAX_DISPLAY_LINKS', '5', 'Set the number of Links to display on the Links page.', @t4, 16, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Links Check Phrase', 'LINKS_CHECK_PHRASE', 'yoursitename', 'Phrase to look for, when you perform a link check.', @t4, 17, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Links List - Scroll Box Size/Style', 'MAX_LINKS_LIST', '3', 'Number of link category names to be displayed in the scroll box window. Setting this to 1 or 0 will display a dropdown list', @t4, 18, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Length of Link Categories Name', 'MAX_DISPLAY_LINK_NAME_LEN', '17', 'Used in links box; maximum length of link category name to display. Longer names will be truncated.', @t4, 19, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Select Links Sort Order', 'DEFINE_SORT_ORDER', '1', 'Define the sort order of the links<br />1= Sort by Title<br />2= Sort by Date (Newest to Oldest)<br />3= Sort by number of clicks (highest to lowest)', @t4, 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3''),');
INSERT INTO `configuration` VALUES (NULL, 'Number of Link Categories Per Row - Default is 3', 'MAX_LINK_CATEGORIES_ROW', '3', 'Used to display Link Categories per row.<br />Default is 3', @t4, 21, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Category Image Directory', 'LINK_CATEGORY_IMAGE_DIRECTORY', 'link_category/', 'Set the Directory for the Category Image', @t4, 22, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image - Link Category Height', 'LINK_CATEGORY_IMAGE_HEIGHT', '80', 'The pixel width of Link Category images', @t4, 23, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image - Link Category Width', 'LINK_CATEGORY_IMAGE_WIDTH', '80', 'The pixel width of Link Category images', @t4, 24, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Show Banner Image Field', 'SHOW_LINKS_BANNER_IMAGE', 'true', 'Show Banner Image Field', @t4, 25, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Link Banner Image Directory', 'LINK_IMAGE_DIRECTORY', 'links_image/', 'Set the Directory for the Link Image', @t4, 26, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image - Link Banner Image Width', 'LINK_IMAGE_WIDTH', '150', 'The pixel width of Link images', @t4, 27, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image - Link Banner Image Height', 'LINK_IMAGE_HEIGHT', '30', 'The pixel height of Link images', @t4, 28, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Default Link Banner Image', 'DEFAULT_LINK_IMAGE', 'links_default.jpg', 'Set the Default Link Image', @t4, 29, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL,'Only registered customers may submit a Link', 'REGISTERED_LINK', 'false', 'Only registered customers may submit a Link', @t4, 30, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Links - Show Store Name and Address', 'LINKS_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', @t4, 31, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Define Links Status', 'DEFINE_LINKS_STATUS', '1', 'Enable the Defined Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', @t4, 32, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
INSERT INTO `configuration` VALUES (NULL, 'Links Manager Version', 'LM_VERSION', '3.5.3', 'Links Manager version', @t4, 33, NULL, now(), NULL, NULL);
Bookmarks