FAQ Manager

[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.

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

[raunharman]

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]

[Ajeh]

The ORDER is using:

order by c.sort_order, cd.categories_name

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

Check your table structures to be sure which ones they should be ...

[raunharman]

I just installed the patch to the existing database.

[jasmel]

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!

[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?

[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

[khopek]

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.

[billipo]

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

[Earnest-Enterprises]

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