FAQ Manager

[welchyboy]

Not really sure what to do with those issues but I am sure someone on here can help. Did you do anything special to allow you to get emails whenever a user clicks ask a question and feels our the form other than put in your email address in the FAQ manager? The submitter of the question does get an email whatever you said thanks for submitting and will be looked at or whatever. But for me the only way I would know if anything has been submitted is to go to the FAQ manager.

[ndudman]

Hi

I've been messing round with the FAQ manager...and have fixed a few things...

1) the duplicate displaying of FAQ's if you have mulit lingual entries... I added an AND to the select statements in the 3 files
tpl_faqs_all_default.php
tpl_faqs_new_default.php
tpl_faqs_default.php

Generally made the made the selecting of a categories from sidebox actually display the FAQ's for that category and not all of them. I know that it was redirected to the tpl_faqs_all_default.php page as a temp fix as the tpl_faqs_default.php wasn't working... So I've had a go at fixing it and it works for me. I'd like to change it more and get sub categories and their faqs displayed and have the faq titles indented to indicate the hierachy a bit,,, but not so much time right now.

There was a missing value defined in one of the langauge files also...

Anyway try it out.
includes.zip
Neil

[ndudman]

I couldn't set the value to 3 in page " FAQ Manager - All FAQs Page" for the sort order as it wasn't available (only 1,2,5,6,7) so I modified the configureation table with the follow sql... as the 3, 4 sort options seemed to be specified in faq_listing_desplay_order.php ok. Don't know why they had been removed in the admin config area ? Do they not work so well or something ?

UPDATE `zencart`.`configuration` SET `configuration_description` = '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 />3= Category<br />4= Admin<br />6= Date Added desc<br />7= Date Added',
`set_function` = 'zen_cfg_select_option(array(''1'', ''2'', ''3'', ''4'', ''6'', ''7''), ' WHERE `configuration`.`configuration_id` =588 LIMIT 1 ;

Neil

[ndudman]

The sort on the now working faq (the changes I just attached in previous post) lost the fcPath from url and the sort would return blank results... added a hiden field to the search filter form.

Search the file faq_listing_display_order.php for the follow line

echo zen_draw_hidden_field('main_page', $_GET['main_page']);

And add underneath it

echo zen_draw_hidden_field('fcPath', $fcPath);

Neil

[mikedeezy33]

Neil -
Thanks for the updates and fixes. I have reviewed the last few pages and there have been a number of fixes that people have posted. Has anyone integrated this into a version release, tested, and submitted to the downloads section?

[ndudman]

No, I don't believe so... buts its a good idea if you have the time... I will perhaps do it if I add/change some more things... but I'm not really a good one for testing etc...

I tried to apply the FCKEditor fix, but couldn't get it to work, didn't spend too much time to work out and understand the changes required.

I'm doing another thing right now, adding multi-language support the Testimonials module, just like ez-pages multi-linual one... just copying that.

Neil

[divaboutiques]

I was getting this also... and I found a fix... couldnt' see it mentioned anywhere else so here it is I changed both files tpl_faq_default.php and tpl_faq_all_default.php and replaced the $faqs_all_query_raw = ..... line of code with the one below....

$faqs_all_query_raw = "select f.*, fd.*, fcd.faq_categories_name from " . TABLE_FAQS . " f, " . TABLE_FAQS_DESCRIPTION . " fd, " . TABLE_FAQ_CATEGORIES_DESCRIPTION . " fcd, " . TABLE_FAQ_CATEGORIES . " fc " .
"where f.faqs_status = '1' and f.faqs_id = fd.faqs_id and fd.language_id = '" . (int)$_SESSION['languages_id'] . "' and f.master_faq_categories_id = fcd.faq_categories_id and f.master_faq_categories_id = fc.faq_categories_id and fc.faq_categories_status='1' and fcd.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
$order_by;

I added the fcd.language_id = to avoid the duplicate rows being selected..

Neil

ndudman I tried your duplicate posting of FAQ fix, but I still get the same problem! Do you have anything else to try to fix the duplicate posting of asked questions?

[divaboutiques]

I couldn't set the value to 3 in page " FAQ Manager - All FAQs Page" for the sort order as it wasn't available (only 1,2,5,6,7) so I modified the configureation table with the follow sql... as the 3, 4 sort options seemed to be specified in faq_listing_desplay_order.php ok. Don't know why they had been removed in the admin config area ? Do they not work so well or something ?

UPDATE `zencart`.`configuration` SET `configuration_description` = '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 />3= Category<br />4= Admin<br />6= Date Added desc<br />7= Date Added',
`set_function` = 'zen_cfg_select_option(array(''1'', ''2'', ''3'', ''4'', ''6'', ''7''), ' WHERE `configuration`.`configuration_id` =588 LIMIT 1 ;

Neil

Can you be more specific, do I add the following code below in red into I sql section???

UPDATE `zencart`.`configuration` SET `configuration_description` = '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 />3= Category<br />4= Admin<br />6= Date Added desc<br />7= Date Added',
`set_function` = 'zen_cfg_select_option(array(''1'', ''2'', ''3'', ''4'', ''6'', ''7''), ' WHERE `configuration`.`configuration_id` =588 LIMIT 1 ;


Also:

The sort on the now working faq (the changes I just attached in previous post) lost the fcPath from url and the sort would return blank results... added a hiden field to the search filter form.

Search the file faq_listing_display_order.php for the follow line

echo zen_draw_hidden_field('main_page', $_GET['main_page']);

And add underneath it

echo zen_draw_hidden_field('fcPath', $fcPath);

Neil

What file do I change and add the following information I searched but couldn't find this information in the 3 file specified

Search the file faq_listing_display_order.php for the follow line

echo zen_draw_hidden_field('main_page', $_GET['main_page']);

And add underneath it

echo zen_draw_hidden_field('fcPath', $fcPath);

[Dharmesh Thanki]

Hi ,

I just installed pdf order center and i also configured in zencart ... but i still have a confustion that when i have to print invoice.. so which file i will have to called on invoice button.. it still opens in internet explorer... plz help me..

thanx in advance...
Dharmesh Thanki

[ndudman]

The below sql should be executed in order to update the configuration table, not inserted into anz php file. When I submited that fix I didnt fully understand that some db values are different on each install. So you want to have a look through your own configuration table for the entry "select * from configuration where configuration_key = 'FAQ_ALL_LIST_SORT_DEFAULT'

Update the values for that field... it won't be at row 588 like my table.

>What file do I change and add the following >information I searched but couldn't find this i>nformation in the 3 file specified

>Search the file >faq_listing_display_order.php for the follow l>ine

>echo >zen_draw_hidden_field('main_page', >$_GET['main_page']);
>
>And add underneath it

>echo >zen_draw_hidden_field('fcPath', $fcPath);>[/QUOTE]

Do you have the file faq_listing_display_order.php ? For me that line mentioned above was at about line 30... can you take another look ?

Neil