FAQ Manager

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.

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.
Attachment #4519
Neil

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

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

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?

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

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?

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

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

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

You need to make the same change to the file tpl_faq_newl_default.php also... which listing where you running(clicking on from the side panel).. all or new ?

You could also try puttng an echo $whateverthesqlstringnameis after that piece you have chaned. Run the changed code and copy the echoed sql statement, pasting it into your phpmyadmin or whatever you use and see if you get duplicates. This is what I did and noticed the problem with language_id.

You don't have duplicates in the db do you ?

Neil

[
QUOTE=divaboutiques;612230]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?[/QUOTE]

I installed this module and all seemed to go fine until I turned on the side box. Then it went really crazy. It put the left column in the center of the page and nothing else on the screen. Anyone have any fixes for this? I think this is a great idea for an add on but.... :cry:

I have a simple question yet not simple enough for me to figure out lol. Is there a way to change the size of the font displayed on the faq page.

welchyboy:

I have a simple question yet not simple enough for me to figure out lol. Is there a way to change the size of the font displayed on the faq page.

Well i figured it out. I added this code in the stylesheet.css

	/* FAQ question on main faq page font size */
	
	.main{
	
	font-size: 1.2em;
	
	}
	
	
	/* Font size for FAQ */
	
.plainBox, .plainbox-description {

  

  font-size: 1.6em;

 
}

Hope this helps someone it sure helped me. :clap:

I'm trying to figure out how to remove the "Sort by: (drop down)" on the FAQ page... does anyone know where to go to remove that feature?

Thanks!

I have a simple question:
is the currect version compatible with Zen Cart Version 1.3.7.1 ? I also use Chinese language, would there be any problem?

Thank you in advance for any help!

JGiacchi:

I'm trying to figure out how to remove the "Sort by: (drop down)" on the FAQ page... does anyone know where to go to remove that feature?

Thanks!

Anyone?

e81ny:

I have a simple question:
is the currect version compatible with Zen Cart Version 1.3.7.1 ? I also use Chinese language, would there be any problem?

Thank you in advance for any help!

Can anybody help? Please?

Thanks in advance!

Installed MOD, not what i was looking for. Can someone please help me uninstall this? This doesn't have a sql uninstall, and I am not advanced enough to write my own script to uninstall it thank you

If I remember correctly, I just deleted all the files that I uploaded and didn't bother with removing the SQL. Seems to be working fine.