FAQ Manager

Printable View

Show 100 post(s) from this thread on one page

7 Sep 2009, 11:19 AM
Laiwis

Re: FAQ Manager

Quote:

Originally Posted by Laiwis

Hi, can you help me. I have problem with duplicate faq view. On image you can see 2 faqs.
Where can i repair it, some idea?
Thank you.
http://www.zen-cart.com/forum/attach...1&d=1251995972

I insert new question and than quesiton is insert in my language and in english language too. I need turn off view in english. How can i do that?
please
7 Sep 2009, 11:34 AM
raunharman

Re: FAQ Manager

I am getting the following error, when i try to view the FAQ on the category page:
1109 Unknown table 'c' in order clause
in:
[select f.*, fd.*, fcd.faq_categories_name from faqs f, faqs_description fd, faq_categories_description fcd, faq_categories fc where f.faqs_status = '1' and f.faqs_id = fd.faqs_id and fd.language_id = '1' 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' order by c.sort_order, cd.categories_name limit 0, 10]
8 Sep 2009, 04:39 AM
Ajeh

Re: FAQ Manager

The ORDER is using:

Code:

order by c.sort_order, cd.categories_name

I do not see "c" or "cd" referenced ... aren't those "f" and "fcd"? :unsure:

Check your table structures to be sure which ones they should be ...
9 Sep 2009, 06:56 AM
raunharman

Re: FAQ Manager

I just installed the patch to the existing database.
8 Oct 2009, 10:02 PM
jasmel

Re: FAQ Manager

Quote:

Originally Posted by davewest

Are you asking about coding a button? The 'ask a question' button and form is part of the mod.

I too didn't have the button for "ask a question". If you right click the alt text and look at properties you will find that the image path is to a file called: includes/templates/template_default/buttons/english/button_ask_a_question.gif

However the file there is misspelled: button_ask_a_quetion.gif (missing the "s")

Fix: Rename the file button_ask_a_question.gif

Hope that helps!
8 Oct 2009, 10:06 PM
jasmel

Re: FAQ Manager

Now, if I can just find out where the "SILVER_SEPARATOR" file is... my web stats page always shows a 404 Error for some image named SILVER_SEPARATOR and I think it has to do with this module.

Anybody else see this 404 error?
12 Oct 2009, 03:23 PM
jasmel

Re: FAQ Manager

Quote:

Originally Posted by jasmel

Now, if I can just find out where the "SILVER_SEPARATOR" file is... my web stats page always shows a 404 Error for some image named SILVER_SEPARATOR and I think it has to do with this module.

Anybody else see this 404 error?

found the answer: http://www.zen-cart.com/forum/showpo...28&postcount=8
27 Oct 2009, 07:02 AM
khopek

Re: FAQ Manager

I installed this mod, however after creating a test category and faq...I get the message 'question not found' when trying to view the faq on the site.
10 Nov 2009, 04:31 AM
billipo

Re: FAQ Manager

I wish I knew more about modifying pages because I think what I want is an easy fix.

For some reason, (and there might be a good one) in the Admin for the FAQ sidebox module you cannot choose "Category" as the default sort order for the FAQ page. It skips right over it!

Unfortunately, I think that is the one that looks the best, but I cannot figure out how to make it selectable by modifying the code.

Does anyone know how to change the php in the Admin side of the FAQ module so that I can make "Category" the default sort order for all pages?

Thanks,
bill
12 Nov 2009, 05:55 AM
Earnest-Enterprises

Re: FAQ Manager

Quote:

Originally Posted by mrowkaz

PHP Code:

<?php // // +----------------------------------------------------------------------+ // |zen-cart Open Source E-commerce | // +----------------------------------------------------------------------+ // | Copyright (c) 2003 The zen-cart developers | // | | // | [url]http://www.zen-cart.com/index.php[/url] | // | | // | Portions Copyright (c) 2003 osCommerce | // +----------------------------------------------------------------------+ // | This source file is subject to version 2.0 of the GPL license, | // | that is bundled with this package in the file LICENSE, and is | // | available through the world-wide-web at the following url: | // | [url]http://www.zen-cart.com/license/2_0.txt[/url]. | // | If you did not receive a copy of the zen-cart license and are unable | // | to obtain it through the world-wide-web, please send a note to | // | [email protected] so we can mail you a copy immediately. | // +----------------------------------------------------------------------+ // $Id: faq_manager.php 001 2005-05-05 [email protected] // $content = ""; $content .= '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" class="sideBoxContent">' . "\n"; for ($i=0;$i<sizeof($box_faq_categories_array);$i++) { switch(true) { // to make a specific faq_category stand out define a new class in the stylesheet example: A.faq_category-holiday // uncomment the select below and set the fcPath=3 to the fcPath= your_faq_categories_id // many variations of this can be done // case ($box_faq_categories_array[$i]['path'] == 'fcPath=3'): // $new_style = 'faq_category-holiday'; // break; case ($box_faq_categories_array[$i]['top'] == 'true'): $new_style = 'category-top'; break; case ($box_faq_categories_array[$i]['has_sub_cat']): $new_style = 'category-subs'; break; default: $new_style = 'category-products'; } if (zen_get_faq_types_to_faq_category($box_faq_categories_array[$i]['path']) == '3' or ($box_faq_categories_array[$i]['top'] != 'true' and SHOW_FAQ_CATEGORIES_SUBFAQ_CATEGORIES_ALWAYS != 1)) { // skip it this is for the document box } else { $content .= '<a class="' . $new_style . '" href="' . zen_href_link(FILENAME_FAQS, $box_faq_categories_array[$i]['path']) . '">'; if ($box_faq_categories_array[$i]['current']) { if ($box_faq_categories_array[$i]['has_sub_cat']) { $content .= '<span class="category-subs-parent">' . $box_faq_categories_array[$i]['name'] . '</span>'; } else { $content .= '<span class="category-subs-selected">' . $box_faq_categories_array[$i]['name'] . '</span>'; } } else { $content .= $box_faq_categories_array[$i]['name']; } if ($box_faq_categories_array[$i]['has_sub_cat']) { $content .= FAQ_CATEGORIES_SEPARATOR; } $content .= '</a>'; if (SHOW_FAQ_COUNTS == 'true') { if ((FAQ_CATEGORIES_COUNT_ZERO == '1' and $box_faq_categories_array[$i]['count'] == 0) or $box_faq_categories_array[$i]['count'] >= 1) { $content .= FAQ_CATEGORIES_COUNT_PREFIX . $box_faq_categories_array[$i]['count'] . FAQ_CATEGORIES_COUNT_SUFFIX; } } $content .= '<br />'; } } if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true' or SHOW_FAQ_CATEGORIES_BOX_FEATURED_FAQS == 'true' or SHOW_FAQ_CATEGORIES_BOX_FAQS_ALL == 'true') { // display a separator between faq_categories and links if (SHOW_FAQ_CATEGORIES_SEPARATOR_LINK == '1') { $content .= '<br />' . zen_draw_separator('pixel_silver.gif') . '<br />'; } if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true') { switch (true) { case (SHOW_NEW_FAQS_LIMIT == '0'): $display_faq_limit = ''; break; case (SHOW_NEW_FAQS_LIMIT == '1'): $display_faq_limit = " and date_format(p.faqs_date_added, '%Y%m') >= date_format(now(), '%Y%m')"; break; case (SHOW_NEW_FAQS_LIMIT == '30'): $$display_faq_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 30'; break; case (SHOW_NEW_FAQS_LIMIT == '60'): $display_faq_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 60'; break; case (SHOW_NEW_FAQS_LIMIT == '90'): $display_faq_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 90'; break; case (SHOW_NEW_FAQS_LIMIT == '120'): $display_faq_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 120'; break; } $show_this = $db->Execute("select p.faqs_id from " . TABLE_FAQS . " p where p.faqs_status = '1' " . $display_faq_limit . " limit 1"); if ($show_this->RecordCount() > 0) { $content .= '<a class="category-links" href="' . zen_href_link(FILENAME_FAQS_NEW) . '">' . FAQ_CATEGORIES_BOX_HEADING_WHATS_NEW . '</a>' . '<br />'; } } if (SHOW_FAQ_CATEGORIES_BOX_FAQS_ALL == 'true') { $content .= '<a class="category-links" href="' . zen_href_link(FILENAME_FAQS_ALL) . '">' . FAQ_CATEGORIES_BOX_HEADING_FAQS_ALL . '</a>'; } } $content .= '</div>' . "\n"; ?>[PHP]

[/PHP]

What/which filename in this mod is this, Mrowkaz? Are these fixes that you have made work OK (or not)?

Thanks....

Rod

Show 100 post(s) from this thread on one page