INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - Categories Box', 'FAQ Manager Categories Box Settings', '1' , '0');
UPDATE zen_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 zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - Categories Box';
INSERT INTO zen_configuration VALUES ('', 'Show FAQ Category Counts', 'SHOW_FAQ_COUNTS', 'true', 'Count recursively how many FAQs are in each FAQ category', @t4, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');
INSERT INTO zen_configuration VALUES ('', 'FAQ Categories Count Prefix', 'FAQ_CATEGORIES_COUNT_PREFIX', ' (', 'What do you want to Prefix the FAQ count with?<br />Default= (', @t4, 10, NULL, now(), NULL, 'zen_cfg_textarea_small(');
INSERT INTO zen_configuration VALUES ('', 'FAQ Categories Count Suffix', 'FAQ_CATEGORIES_COUNT_SUFFIX', ')', 'What do you want as a Suffix to the FAQ count?<br />Default= )', @t4, 11, NULL, now(), NULL, 'zen_cfg_textarea_small(');
INSERT INTO zen_configuration VALUES ('', 'FAQ Categories SubCategories Indent', 'FAQ_CATEGORIES_SUBFAQ_CATEGORIES_INDENT', ' ', 'What do you want to use as the FAQ subcategories indent?<br />Default= ', @t4, 12, NULL, now(), NULL, 'zen_cfg_textarea_small(');
INSERT INTO zen_configuration VALUES ('', 'FAQ Categories with 0 FAQs Status', 'FAQ_CATEGORIES_COUNT_ZERO', '0', 'Show FAQ Count for 0 FAQs?<br />0= off<br />1= on', @t4, 13, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO zen_configuration VALUES ('', 'Separator between links Status', 'SHOW_FAQ_CATEGORIES_SEPARATOR_LINK', '1', 'Show FAQ Category Separator between Category Names and Links?<br />0= off<br />1= on', @t4, 14, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO zen_configuration VALUES ('', 'Separator between the Category Name and Count', 'FAQ_CATEGORIES_SEPARATOR', '->', 'What separator do you want between the FAQ Category name and the count?<br />Default = -&gt;', @t4, 15, NULL, now(), NULL, 'zen_cfg_textarea_small(');
INSERT INTO zen_configuration VALUES ('', 'Separator between the Category Name and Sub Categories', 'FAQ_CATEGORIES_SEPARATOR_SUBS', '|_ ', 'What separator do you want between the FAQ Category name and FAQ Sub Category Name?<br />Default = |_&nbsp;', @t4, 16, NULL, now(), NULL, 'zen_cfg_textarea_small(');
INSERT INTO zen_configuration VALUES ('', 'Always Open to Show FAQ SubCategories', 'SHOW_FAQ_CATEGORIES_SUBFAQ_CATEGORIES_ALWAYS', '1', 'Always Show Categories and SubCategories<br />0= off, just show Top Categories<br />1= on, Always show Categories and SubCategories when selected', @t4, 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO zen_configuration VALUES ('', 'Show New FAQs Link', 'SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW', 'true', 'Show FAQs New Link in the FAQ Categories Box', @t4, 18, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO zen_configuration VALUES ('', 'Show All FAQs Link', 'SHOW_FAQ_CATEGORIES_BOX_FAQS_ALL', 'true', 'Show FAQs All Link in the FAQ Categories Box', @t4, 19, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - FAQ Info Page', 'FAQ Manager FAQ Info Page Settings', '1' , '0');
UPDATE zen_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 zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - FAQ Info Page';
INSERT INTO zen_configuration VALUES ('', 'Previous Next - Navigation Bar Position', 'FAQ_INFO_PREVIOUS_NEXT', '1', 'Location of Previous/Next Navigation Bar<br />0= off<br />1= Top of Page<br />2= Bottom of Page<br />3= Both Top and Bottom of Page', @t4, 30, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''Top of Page''), array(''id''=>''2'', ''text''=>''Bottom of Page''), array(''id''=>''3'', ''text''=>''Both Top & Bottom of Page'')),');
INSERT INTO zen_configuration VALUES ('', 'Previous Next - Sort Order', 'FAQ_INFO_PREVIOUS_NEXT_SORT', '1', 'FAQs Display Order by<br />0= FAQ ID<br />1= FAQ Name<br />6= FAQ Sort Order', @t4, 31, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''FAQ ID''), array(''id''=>''1'', ''text''=>''Name''), array(''id''=>''6'', ''text''=>''FAQ Sort Order'')),');
INSERT INTO zen_configuration VALUES ('', 'Previous Next - Button and Image Status', 'SHOW_FAQ_PREVIOUS_NEXT_STATUS', '0', 'Button and FAQ Image status settings are:<br />0= Off<br />1= On', @t4, 32, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''On'')),');
INSERT INTO zen_configuration VALUES ('', 'Previous Next - Button and Image Settings', 'SHOW_FAQ_PREVIOUS_NEXT_IMAGES', '0', 'Show Previous/Next Button and FAQ Image Settings<br />0= Button Only<br />1= Button and FAQ Image<br />2= FAQ Image Only', @t4, 33, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Button Only''), array(''id''=>''1'', ''text''=>''Button and FAQ Image''), array(''id''=>''2'', ''text''=>''FAQ Image Only'')),');
INSERT INTO zen_configuration VALUES ('', 'Previous Next - Navigation Includes FAQ Category', 'FAQ_INFO_FAQ_CATEGORIES', '1', 'FAQs Category Image and Name Alignment Above Previous/Next Navigation Bar<br />0= off<br />1= Align Left<br />2= Align Center<br />3= Align Right', @t4, 34, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'', ''text''=>''Off''), array(''id''=>''1'', ''text''=>''Align Left''), array(''id''=>''2'', ''text''=>''Align Center''), array(''id''=>''3'', ''text''=>''Align Right'')),');
INSERT INTO zen_configuration VALUES ('', 'Show FAQ Reviews Count', 'SHOW_FAQ_INFO_REVIEWS_COUNT', '1', 'Display FAQ Reviews Count on FAQ Info 0= off 1= on', @t4, 35, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
INSERT INTO zen_configuration VALUES ('', 'Show FAQ Reviews Button', 'SHOW_FAQ_INFO_REVIEWS', '1', 'Display FAQ Reviews Button on FAQ Info 0= off 1= on', @t4, 36, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
INSERT INTO zen_configuration VALUES ('', 'Show Date Added', 'SHOW_FAQ_INFO_DATE_ADDED', '1', 'Display Date Added on FAQ Info 0= off 1= on', @t4, 37, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
INSERT INTO zen_configuration VALUES ('', 'Show FAQ URL', 'SHOW_FAQ_INFO_URL', '1', 'Display URL on FAQ Info 0= off 1= on', @t4, 38, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
INSERT INTO zen_configuration VALUES ('', 'Show FAQ Tell a Friend button', 'SHOW_FAQ_INFO_TELL_A_FRIEND', '1', 'Display the Tell a Friend button on FAQ Info<br /><br />Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button<br />0= off 1= on', @t4, 39, NULL, now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');
INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - FAQ Listing', 'FAQ Manager FAQ Listing Settings', '1' , '0');
UPDATE zen_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 zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - FAQ Listing';
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Name', 'FAQ_LIST_NAME', '1', 'Do you want to display the FAQ Name?', @t4, 50, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Prev/Next Split Page Navigation (1-top, 2-bottom, 3-both)', 'PREV_NEXT_FAQ_BAR_LOCATION', '1', 'Sets the location of the FAQ Prev/Next Split Page Navigation', @t4, 51, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''3''), ');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Listing Default Sort Order', 'FAQ_LISTING_DEFAULT_SORT_ORDER', '', 'FAQ Listing Default sort order?<br />NOTE: Leave Blank for FAQ Sort Order. Sort the FAQ Listing in the order you wish for the default display to start in to get the sort order setting. Example: 2a', @t4, 52, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Number Per Page', 'MAX_DISPLAY_FAQS_LISTING', '10', 'Maximum Number of FAQs to list per page on main page', @t4, 53, NULL, now(), '', '');
INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - New FAQs Page', 'FAQ Manager New FAQs Page Settings', '1' , '0');
UPDATE zen_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 zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - New FAQs Page';
INSERT INTO zen_configuration VALUES ('', 'Number of FAQs Per Page', 'MAX_DISPLAY_FAQS_NEW', '10', 'Number of new FAQs listings per page', @t4, 70, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Image', 'FAQ_NEW_LIST_IMAGE', '1102', 'Do you want to display the FAQ Image?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 71, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Name', 'FAQ_NEW_LIST_NAME', '2101', 'Do you want to display the FAQ Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 72, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Date Added', 'FAQ_NEW_LIST_DATE_ADDED', '2601', 'Do you want to display the FAQ Date Added?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 73, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Description', 'FAQ_NEW_LIST_DESCRIPTION', '1', 'Do you want to display the FAQ Description - First 150 characters?<br />0= off<br />1= on', @t4, 74, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO zen_configuration VALUES ('', 'Default Sort Order', 'FAQ_NEW_LIST_SORT_DEFAULT', '6', 'What Sort Order Default should be used for New FAQs Display?<br />Default= 6 for Date New to Old<br /><br />1= FAQs Name<br />2= FAQs Name Desc<br />6= Date Added desc<br />7= Date Added', @t4, 75, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''6'', ''7''), ');
INSERT INTO zen_configuration VALUES ('', 'Image Width', 'IMAGE_FAQ_NEW_LISTING_WIDTH', '50', 'Default = 50', @t4, 76, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Image Height', 'IMAGE_FAQ_NEW_LISTING_HEIGHT', '40', 'Default = 40', @t4, 77, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Number of FAQs Per Page', 'MAX_DISPLAY_FAQS_ALL', '10', 'Number of faqs to list per screen', @t4, 80, NULL, now(), NULL, '');
INSERT INTO zen_configuration VALUES ('', 'New FAQs Page Configuration Group ID', 'FAQ_LISTS_GROUP_ID_NEW', @t4, 'Warning: Only change this if your FAQs All Group ID has changed from the default<br />What is the configuration_group_id for FAQ Listings?', @t4, 90, NULL, now(), '', '');
INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - All FAQs Page', 'FAQ Manager All FAQs Page Settings', '1' , '0');
UPDATE zen_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 zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - All FAQs Page';
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Image', 'FAQ_ALL_LIST_IMAGE', '1102', 'Do you want to display the FAQ Image?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 81, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Name', 'FAQ_ALL_LIST_NAME', '2101', 'Do you want to display the FAQ Name?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 82, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Date Added', 'FAQ_ALL_LIST_DATE_ADDED', '2601', 'Do you want to display the FAQ Date Added?<br /><br />0= off<br />1st digit Left or Right<br />2nd and 3rd digit Sort Order<br />4th digit number of breaks after<br />', @t4, 83, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Display FAQ Description', 'FAQ_ALL_LIST_DESCRIPTION', '1', 'Do you want to display the FAQ Description - First 150 characters?', @t4, 84, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ');
INSERT INTO zen_configuration VALUES ('', 'Default Sort Order', 'FAQ_ALL_LIST_SORT_DEFAULT', '1', 'What Sort Order Default should be used for All FAQs Display?<br />Default= 1 for FAQ Name<br /><br />1= FAQs Name<br />2= FAQs Name Desc<br />6= Date Added desc<br />7= Date Added', @t4, 85, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''6'', ''7''), ');
INSERT INTO zen_configuration VALUES ('', 'Image Width', 'IMAGE_FAQ_ALL_LISTING_WIDTH', '50', 'Default = 50', @t4, 86, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Image Height', 'IMAGE_FAQ_ALL_LISTING_HEIGHT', '40', 'Default = 40', @t4, 87, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'ALL FAQs Page Configuration Group ID', 'FAQ_LISTS_GROUP_ID_ALL', @t4, 'Warning: Only change this if your FAQs All Group ID has changed from the default<br />What is the configuration_group_id for FAQ Listings?', @t4, 90, NULL, now(), '', '');
INSERT INTO zen_configuration_group VALUES ('', 'FAQ Manager - General Config', 'FAQ Manager General Config Settings', '1' , '0');
UPDATE zen_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 zen_configuration_group
WHERE configuration_group_title= 'FAQ Manager - General Config';
INSERT INTO zen_configuration VALUES ('', 'FAQ Categories - FAQ Categories To List Per Row', 'MAX_DISPLAY_FAQ_CATEGORIES_PER_ROW', '1', 'How many FAQ categories to list per row', @t4, 91, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Allow faqs To Go Live As Submitted', 'FAQ_LIST_LIVE', 'false', 'Do you want faqs to go live as submitted<br>Set to false for admin approval.', @t4, 92, NULL, now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO zen_configuration VALUES ('', 'Define FAQs Submit', 'DEFINE_FAQS_SUBMIT_STATUS', '1', 'Enable the Defined faqs_submit text?<br />0= OFF<br />1= ON', @t4, 93, NULL, now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\'),');
INSERT INTO zen_configuration VALUES ('', 'Allow FAQS submission', 'ALLOW_FAQS_SUBMISSION', 'true', 'Allow users to submit FAQs.', @t4, 94, NULL, now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO zen_configuration VALUES ('', 'If Allow FAQS submission = true, allow unregistered users submit FAQs', 'UNREGISTERED_FAQS_SUBMIT', 'true', 'Allow unregistered users to submit FAQs.', @t4, 95, NULL, now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO zen_configuration VALUES ('', 'Allow Image Upload', 'SUBMIT_FAQ_ALLOW_IMAGE_UPLOAD', 'true', 'Allow Image Upload on FAQ Submit', @t4, 96, NULL, now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO zen_configuration VALUES ('', 'Send FAQ Submit Notification Emails To:', 'SEND_FAQ_SUBMIT_EMAILS_TO_EMAILS_TO', '[email protected]', 'Enter the email address that FAQ submit notifications should be sent to', @t4, 97, NULL, now(), '', '');
INSERT INTO zen_configuration VALUES ('', 'Define No FAQs Allowed', 'DEFINE_NO_FAQS_ALLOWED', '1', 'Enable the No FAQs Allowed text?<br>0= OFF<br>1= ON', @t4, 98, NULL, now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\'),');
Bookmarks