FAQ Manager

**Hizen** · 8 Feb 2007, 11:12 AM

Don't forget to backup your database before you do any changes. When I import FAQ sql, myadmin doesn't seem to add prefix 'zen_' automatically. So, I added this myself in the sql file (just use search and replace tool). I also deleted the previous imported FAQ tables before I imported them again so that duplicate error would not appear. You can paste the following sql to your myadmin once you are ready. (broken line is not included). Good luck!

**Hizen** · 8 Feb 2007, 11:14 AM

--------------------------------------------------------->
DROP TABLE IF EXISTS faq_categories;
DROP TABLE IF EXISTS zen_faq_categories;
CREATE TABLE zen_faq_categories (
faq_categories_id int(11) NOT NULL auto_increment,
faq_categories_image varchar(64) default NULL,
parent_id int(11) NOT NULL default '0',
sort_order int(3) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
faq_categories_status tinyint(1) NOT NULL default '1',
PRIMARY KEY (faq_categories_id),
KEY idx_faq_categories_parent_id (parent_id),
KEY idx_sort_order (sort_order)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_categories_description;
DROP TABLE IF EXISTS zen_faq_categories_description;
CREATE TABLE zen_faq_categories_description (
faq_categories_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
faq_categories_name varchar(32) NOT NULL default '',
faq_categories_description text NOT NULL,
PRIMARY KEY (faq_categories_id,language_id),
KEY idx_faq_categories_name (faq_categories_name)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_reviews;
DROP TABLE IF EXISTS zen_faq_reviews;
CREATE TABLE zen_faq_reviews (
reviews_id int(11) NOT NULL auto_increment,
faqs_id int(11) NOT NULL default '0',
customers_id int(11) default NULL,
customers_name varchar(64) NOT NULL default '',
reviews_rating int(1) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
reviews_read int(5) NOT NULL default '0',
status int(1) NOT NULL default '1',
PRIMARY KEY (reviews_id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS faq_reviews_description;
DROP TABLE IF EXISTS zen_faq_reviews_description;
CREATE TABLE zen_faq_reviews_description (
reviews_id int(11) NOT NULL default '0',
languages_id int(11) NOT NULL default '0',
reviews_text text NOT NULL,
PRIMARY KEY (reviews_id,languages_id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_type_layout;
DROP TABLE IF EXISTS zen_faq_type_layout;
CREATE TABLE zen_faq_type_layout (
configuration_id int(11) NOT NULL auto_increment,
configuration_title text NOT NULL,
configuration_key varchar(255) NOT NULL default '',
configuration_value text NOT NULL,
configuration_description text NOT NULL,
faq_type_id int(11) NOT NULL default '0',
sort_order int(5) default NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL default '0001-01-01 00:00:00',
use_function text,
set_function text,
PRIMARY KEY (configuration_id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_types;
DROP TABLE IF EXISTS zen_faq_types;
CREATE TABLE zen_faq_types (
type_id int(11) NOT NULL auto_increment,
type_name varchar(255) NOT NULL default '',
type_handler varchar(255) NOT NULL default '',
type_master_type int(11) NOT NULL default '1',
allow_add_to_cart char(1) NOT NULL default 'Y',
default_image varchar(255) NOT NULL default '',
date_added datetime NOT NULL default '0001-01-01 00:00:00',
last_modified datetime NOT NULL default '0001-01-01 00:00:00',
PRIMARY KEY (type_id)
) TYPE=MyISAM;
INSERT INTO zen_faq_types VALUES (1, 'FAQ - General', 'faq', 1, 'N', '', now(), '');
DROP TABLE IF EXISTS faq_types_to_faq_category;
DROP TABLE IF EXISTS zen_faq_types_to_faq_category;
CREATE TABLE zen_faq_types_to_faq_category (
faq_type_id int(11) NOT NULL default '0',
faq_category_id int(11) NOT NULL default '0'
) TYPE=MyISAM;

DROP TABLE IF EXISTS faqs;
DROP TABLE IF EXISTS zen_faqs;
CREATE TABLE zen_faqs (
faqs_id int(11) NOT NULL auto_increment,
faqs_type int(11) NOT NULL default '1',
faqs_image varchar(64) default NULL,
faqs_date_added datetime NOT NULL default '0001-01-01 00:00:00',
faqs_last_modified datetime default NULL,
faqs_status tinyint(1) NOT NULL default '0',
faqs_sort_order int(11) NOT NULL default '0',
master_faq_categories_id int(11) NOT NULL default '0',
PRIMARY KEY (faqs_id),
KEY idx_faqs_date_added (faqs_date_added)
) TYPE=MyISAM;

DROP TABLE IF EXISTS faqs_description;
DROP TABLE IF EXISTS zen_faqs_description;
CREATE TABLE zen_faqs_description (
`faqs_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL default '1',
`faqs_name` varchar(64) NOT NULL default '',
`faqs_description` text,
`faqs_answer` text,
`faqs_url` varchar(255) default NULL,
`faqs_contact_name` varchar(255) default NULL,
`faqs_contact_mail` varchar(255) default NULL,
`faqs_owner` varchar(11) default '0',
`faqs_viewed` int(5) default '0',
PRIMARY KEY (`faqs_id`,`language_id`),
KEY `faqs_name` (`faqs_name`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS faqs_to_faq_categories;
DROP TABLE IF EXISTS zen_faqs_to_faq_categories;
CREATE TABLE zen_faqs_to_faq_categories (
faqs_id int(11) NOT NULL default '0',
faq_categories_id int(11) NOT NULL default '0',
PRIMARY KEY (faqs_id,faq_categories_id)
) TYPE=MyISAM;

**Hizen** · 8 Feb 2007, 11:14 AM

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? 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? 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? 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? 0= off 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? 0= off 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? 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? 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 0= off, just show Top Categories 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 0= off 1= Top of Page 2= Bottom of Page 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 0= FAQ ID 1= FAQ Name 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: 0= Off 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 0= Button Only 1= Button and FAQ Image 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 0= off 1= Align Left 2= Align Center 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 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 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? 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? 0= off 1st digit Left or Right 2nd and 3rd digit Sort Order 4th digit number of breaks after ', @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? 0= off 1st digit Left or Right 2nd and 3rd digit Sort Order 4th digit number of breaks after ', @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? 0= off 1st digit Left or Right 2nd and 3rd digit Sort Order 4th digit number of breaks after ', @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? 0= off 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? Default= 6 for Date New to Old 1= FAQs Name 2= FAQs Name Desc 6= Date Added desc 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 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? 0= off 1st digit Left or Right 2nd and 3rd digit Sort Order 4th digit number of breaks after ', @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? 0= off 1st digit Left or Right 2nd and 3rd digit Sort Order 4th digit number of breaks after ', @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? 0= off 1st digit Left or Right 2nd and 3rd digit Sort Order 4th digit number of breaks after ', @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? Default= 1 for FAQ Name 1= FAQs Name 2= FAQs Name Desc 6= Date Added desc 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 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 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? 0= OFF 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? 0= OFF 1= ON', @t4, 98, NULL, now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\'),');

**Pablosan** · 8 Feb 2007, 12:42 PM

Thanks man!!

I got an error though

Code:

Error

     SQL query:     
               INSERT  INTO zen_configuration_group
VALUES ( '',  'FAQ Manager - Categories Box',  'FAQ Manager Categories Box Settings',  '1',  '0'
);

     
      MySQL said: 
  #1146 - Table 'haskellg_estore.zen_configuration_group' doesn't exist

I exported the DB ( selected all ) to a zip.
The store is still working fine though.
I've never backed up a DB before.

**Hizen** · 8 Feb 2007, 01:47 PM

Originally Posted by Pablosan

Thanks man!!

I got an error though

Code:

Error
 
     SQL query:     
               INSERT  INTO zen_configuration_group
VALUES ( '',  'FAQ Manager - Categories Box',  'FAQ Manager Categories Box Settings',  '1',  '0'
);
 
 
      MySQL said:  
  #1146 - Table 'haskellg_estore.zen_configuration_group' doesn't exist

I exported the DB ( selected all ) to a zip.
The store is still working fine though.
I've never backed up a DB before.

I think it is because your original shop database hasn't got 'zen_' prefix. In this case, you need to delete 'zen_' prefix in the sql file, then import it to your DB again. Besides 10 new faq tables are added (i believe they are in your DB already), two old zc shop tables are affected (new entries are inserted), one is zen_configuration_group, the other is zen_configuration (note: you may not have 'zen_' prefix). When you import the sql, if there is a duplicate error, go to the table, find these new entries and delete them, then try the sql again. (make sure the entries you delete are FAQ related, not others)

Because this faq sql only add new tables or entries, it will not affect your existing shop operation.

**Pablosan** · 8 Feb 2007, 11:51 PM

No error for duplicates. I removed zen_ from the file enitrely.
But now I got this one.
Sorry I'm SQL noob.

: Missing parameter: import_type
: Missing parameter: format

Heres the file.

Also when clicking faq manager in admin, but I assmune thats because the SQL never finished.

1146 Table 'haskellg_estore.faqs' doesn't exist
in:
[select count(*) as count from faqs where faqs_status = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

**Hizen** · 9 Feb 2007, 01:01 PM

I don't know why it doen't work for you.

Try to add attached FAQ tables first. It should absolutely work fine.

**james739** · 6 Dec 2007, 02:27 PM

Originally Posted by Hizen

--------------------------------------------------------->
DROP TABLE IF EXISTS faq_categories;
DROP TABLE IF EXISTS zen_faq_categories;
CREATE TABLE zen_faq_categories (
faq_categories_id int(11) NOT NULL auto_increment,
faq_categories_image varchar(64) default NULL,
parent_id int(11) NOT NULL default '0',
sort_order int(3) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
faq_categories_status tinyint(1) NOT NULL default '1',
PRIMARY KEY (faq_categories_id),
KEY idx_faq_categories_parent_id (parent_id),
KEY idx_sort_order (sort_order)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_categories_description;
DROP TABLE IF EXISTS zen_faq_categories_description;
CREATE TABLE zen_faq_categories_description (
faq_categories_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
faq_categories_name varchar(32) NOT NULL default '',
faq_categories_description text NOT NULL,
PRIMARY KEY (faq_categories_id,language_id),
KEY idx_faq_categories_name (faq_categories_name)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_reviews;
DROP TABLE IF EXISTS zen_faq_reviews;
CREATE TABLE zen_faq_reviews (
reviews_id int(11) NOT NULL auto_increment,
faqs_id int(11) NOT NULL default '0',
customers_id int(11) default NULL,
customers_name varchar(64) NOT NULL default '',
reviews_rating int(1) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
reviews_read int(5) NOT NULL default '0',
status int(1) NOT NULL default '1',
PRIMARY KEY (reviews_id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS faq_reviews_description;
DROP TABLE IF EXISTS zen_faq_reviews_description;
CREATE TABLE zen_faq_reviews_description (
reviews_id int(11) NOT NULL default '0',
languages_id int(11) NOT NULL default '0',
reviews_text text NOT NULL,
PRIMARY KEY (reviews_id,languages_id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_type_layout;
DROP TABLE IF EXISTS zen_faq_type_layout;
CREATE TABLE zen_faq_type_layout (
configuration_id int(11) NOT NULL auto_increment,
configuration_title text NOT NULL,
configuration_key varchar(255) NOT NULL default '',
configuration_value text NOT NULL,
configuration_description text NOT NULL,
faq_type_id int(11) NOT NULL default '0',
sort_order int(5) default NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL default '0001-01-01 00:00:00',
use_function text,
set_function text,
PRIMARY KEY (configuration_id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS faq_types;
DROP TABLE IF EXISTS zen_faq_types;
CREATE TABLE zen_faq_types (
type_id int(11) NOT NULL auto_increment,
type_name varchar(255) NOT NULL default '',
type_handler varchar(255) NOT NULL default '',
type_master_type int(11) NOT NULL default '1',
allow_add_to_cart char(1) NOT NULL default 'Y',
default_image varchar(255) NOT NULL default '',
date_added datetime NOT NULL default '0001-01-01 00:00:00',
last_modified datetime NOT NULL default '0001-01-01 00:00:00',
PRIMARY KEY (type_id)
) TYPE=MyISAM;
INSERT INTO zen_faq_types VALUES (1, 'FAQ - General', 'faq', 1, 'N', '', now(), '');
DROP TABLE IF EXISTS faq_types_to_faq_category;
DROP TABLE IF EXISTS zen_faq_types_to_faq_category;
CREATE TABLE zen_faq_types_to_faq_category (
faq_type_id int(11) NOT NULL default '0',
faq_category_id int(11) NOT NULL default '0'
) TYPE=MyISAM;

DROP TABLE IF EXISTS faqs;
DROP TABLE IF EXISTS zen_faqs;
CREATE TABLE zen_faqs (
faqs_id int(11) NOT NULL auto_increment,
faqs_type int(11) NOT NULL default '1',
faqs_image varchar(64) default NULL,
faqs_date_added datetime NOT NULL default '0001-01-01 00:00:00',
faqs_last_modified datetime default NULL,
faqs_status tinyint(1) NOT NULL default '0',
faqs_sort_order int(11) NOT NULL default '0',
master_faq_categories_id int(11) NOT NULL default '0',
PRIMARY KEY (faqs_id),
KEY idx_faqs_date_added (faqs_date_added)
) TYPE=MyISAM;

DROP TABLE IF EXISTS faqs_description;
DROP TABLE IF EXISTS zen_faqs_description;
CREATE TABLE zen_faqs_description (
`faqs_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL default '1',
`faqs_name` varchar(64) NOT NULL default '',
`faqs_description` text,
`faqs_answer` text,
`faqs_url` varchar(255) default NULL,
`faqs_contact_name` varchar(255) default NULL,
`faqs_contact_mail` varchar(255) default NULL,
`faqs_owner` varchar(11) default '0',
`faqs_viewed` int(5) default '0',
PRIMARY KEY (`faqs_id`,`language_id`),
KEY `faqs_name` (`faqs_name`)
) TYPE=MyISAM;

DROP TABLE IF EXISTS faqs_to_faq_categories;
DROP TABLE IF EXISTS zen_faqs_to_faq_categories;
CREATE TABLE zen_faqs_to_faq_categories (
faqs_id int(11) NOT NULL default '0',
faq_categories_id int(11) NOT NULL default '0',
PRIMARY KEY (faqs_id,faq_categories_id)
) TYPE=MyISAM;

------------------------------
Nice site!
How did you get your footer like that. WIth the different columns?

Thanks

Thread: FAQ Manager

Thread Tools

Search Thread

Display

Hybrid View

Re: FAQ Manager

Re: FAQ Manager

Re: FAQ Manager

Re: FAQ Manager

Re: FAQ Manager

Re: FAQ Manager

Re: FAQ Manager

Re: FAQ Manager

Similar Threads

FAQ manager

FAQ Manager error

FAQ Manager ?

Faq Manager Character Limit

Posting Permissions