FAQ Manager

[Dehaw]

Do you have a url?

I am working on a new version of this and haven't come across it lately.

Derek

[Pablosan]

I installed this before I read this thread. I asumed it would work since it was in the downloads section.

Should I remove it and wait for the upgrade?

[Hizen]

I think it's better set the FAQ question description field as not required when submiting a question. Any idea how to do that?

[Dehaw]

You would need to edit the header.php file within includes/modules/pages/testimonials_submit/header.php.

You may also want to remove the little red star too which can be done within the actual template file.

Hope this helps

Derek

p.s., i'm going to be changing the way this mod woeks and removing the redundant code and files, so any suggestions would be good.

[Hizen]

Thank you for your help Derek. The mod is working perfectly!

[Pablosan]

You would need to edit the header.php file within includes/modules/pages/testimonials_submit/header.php.

You may also want to remove the little red star too which can be done within the actual template file.

Hope this helps

Derek

p.s., i'm going to be changing the way this mod woeks and removing the redundant code and files, so any suggestions would be good.

Will it be working for 1.3.7 in the near future? I can't get past the database error.

[Hizen]

I'm using 1.3.7. It is working fine with Derek's FAQ. However, I did change quite a lot to get it work on my site. As for database, I did not upload through zen cart sql patch, I used phpmyadmin sql to avoid 1064 error in SQL syntax.

[Pablosan]

Cool I'll use myadmin. Got any other tips for getting it to work? I'm impatient and I already added a link for it.

[Hizen]

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]

--------------------------------------------------------->
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;