FAQ Manager

e81ny:

Can anybody help? Please?

Thanks in advance!

There are some serious bugs with this FAQ mod right now, I would not recommend using it unless they have been resolved. It will mess up how your categories are displayed.

urbdistrib:

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:

Hi, I just installed the FAQ module and this also happened to me.

What I neglected to realize, and it is not mentioned in the readme is that if you are running a template then you need to copy the files from /includes/template/YOUR_TEMPLATE to your template directory. Once I did this it seems to work.

Hope this helps a bit.:smile:

I notice several people asked this question already but no one has answered it at least in the pages i have read ( it's a long thread )

How do you stop your main page showing up when you click one of your product categories after installing this.

My main page shows up in all categories which have subcategories.

If the category doesn't have subcategories the main page doesn't show up and thats how i want it.

Someone suggested deleting a file but thats no use if you want to actually use the module.

So what is the fix for this issue ?

pixelpadre:

I understand that using FAQ module causes the main page to be displayed above the body of any category page. Is this true? If it is, what is the work around it besides eliminating the main page?

Thats my problem too although it's only the very top of the page - The one you can edit in define pages editior.

Does anyone have this mod installed on their site? I would like to see how it works.

I installed it, but it is off - changes the colors on my template and gives this error:

1054 Unknown column 'p.products_date_added' in 'where clause'
in:
[select p.faqs_id from zen_faqs p where p.faqs_status = '1' and p.products_date_added >=20081211 and (p.products_date_available <=20081218 or p.products_date_available IS NULL) limit 1]
:huh:

Grace38:

I notice several people asked this question already but no one has answered it at least in the pages i have read ( it's a long thread )

How do you stop your main page showing up when you click one of your product categories after installing this.

My main page shows up in all categories which have subcategories.

If the category doesn't have subcategories the main page doesn't show up and thats how i want it.

Someone suggested deleting a file but thats no use if you want to actually use the module.

So what is the fix for this issue ?

Unless someone fixes the PHP code in the module, all you can do is uninstall it.:(

it works only there is had that injectar this sql....

but @t4 is the group configuration Where you want to install it

INSERT INTO configuration VALUES ('', 'Limit New Faq', 'SHOW_NEW_FAQS_LIMIT', '60', 'Limit fac', @t4, 100, NULL, now(), NULL, '');

Example:(I have put it in the last position )

NSERT INTO configuration_group VALUES ('', 'FAQ Manager - FAQ Listing', 'FAQ Manager FAQ Listing Settings', '1' , '0');

UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;

SELECT (@t4:=configuration_group_id) as t4

FROM configuration_group

WHERE configuration_group_title= 'FAQ Manager - FAQ Listing';

INSERT INTO configuration VALUES ('', 'Display FAQ Name', 'FAQ_LIST_NAME', '1', 'Do you want to display the FAQ Name?', @t4, 50, NULL, now(), '', '');

INSERT INTO configuration VALUES ('', 'Prev/Next Split Page Navigation (1-top, 2-bottom, 3-both)', 'PREV_NEXT_FAQ_BAR_LOCATION', '1', 'Sets the location of the FAQ Prev/Next Split Page Navigation', @t4, 51, NULL, now(), '', 'zen_cfg_select_option(array(''1'', ''2'', ''3''), ');

INSERT INTO configuration VALUES ('', 'Display FAQ Listing Default Sort Order', 'FAQ_LISTING_DEFAULT_SORT_ORDER', '', 'FAQ Listing Default sort order?<br />NOTE: Leave Blank for FAQ Sort Order. Sort the FAQ Listing in the order you wish for the default display to start in to get the sort order setting. Example: 2a', @t4, 52, NULL, now(), '', '');

INSERT INTO configuration VALUES ('', 'Number Per Page', 'MAX_DISPLAY_FAQS_LISTING', '10', 'Maximum Number of FAQs to list per page on main page', @t4, 53, NULL, now(), '', '');

INSERT INTO configuration VALUES ('', 'Limit New Faq', 'SHOW_NEW_FAQS_LIMIT', '60', 'Limit fac', @t4, 100, NULL, now(), NULL, '');

bgroup99:

Unless someone fixes the PHP code in the module, all you can do is uninstall it.:(

Another solution is:

includes/templates/yourtemplate/sideboxes/tpl_faq_categories.php

line:96

add after:

```php
  case (SHOW_NEW_FAQS_LIMIT == '120'):

      $display_limit = ' and TO_DAYS(NOW()) -  TO_DAYS(p.faqs_date_added) <= 120';

      break;

Put

     ```php
          default:
		  $display_limit= '';
		  break;
	  }
      

The final code:

   if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true') {

      switch (true) {

        case (SHOW_NEW_FAQS_LIMIT == '0'):

          $display_limit = '';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '1'):

          $display_limit = " and date_format(p.faqs_date_added, '%Y%m') >= date_format(now(), '%Y%m')";

          break;

        case (SHOW_NEW_FAQS_LIMIT == '30'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 30';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '60'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 60';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '90'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 90';

          break;

        case (SHOW_NEW_FAQS_LIMIT == '120'):

          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 120';

          break;

		default:
		  $display_limit= '';
		  break;
	  }

danilovig:

it works only there is had that inject this sql....

danilovig:

Another solution is:

includes/templates/yourtemplate/sideboxes/tpl_faq_categories.php

line:96

add after:

```php

  case (SHOW_NEW_FAQS_LIMIT == '120'):

      $display_limit = ' and TO_DAYS(NOW()) -  TO_DAYS(p.faqs_date_added) <= 120';

      break;

> 
> Put
> 
>      ```php
          default:
		  $display_limit= '';
		  break;
	  }
      

The final code:

if (SHOW_FAQ_CATEGORIES_BOX_FAQS_NEW == 'true') {

  switch (true) {

    case (SHOW_NEW_FAQS_LIMIT == '0'):

      $display_limit = '';

      break;

    case (SHOW_NEW_FAQS_LIMIT == '1'):

      $display_limit = " and date_format(p.faqs_date_added, '%Y%m') >= date_format(now(), '%Y%m')";

      break;

    case (SHOW_NEW_FAQS_LIMIT == '30'):

      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 30';

      break;

    case (SHOW_NEW_FAQS_LIMIT == '60'):

      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 60';

      break;

    case (SHOW_NEW_FAQS_LIMIT == '90'):

      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 90';

      break;

    case (SHOW_NEW_FAQS_LIMIT == '120'):

      $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 120';

      break;

	default:
	  $display_limit= '';
	  break;
  }

This solution worked for me.Thanks danilovig.

this thread has been great. It's helped me out a lot, however I can not figure out how to get it to not display double bread crumbs across the top of my faq pages.
example: http://2antioch.org/store/index.php?main_page=faqs_all&fcPath=1
The ask a question button is not show either.

THanks!

raspberryjamcloth:

I installed it, but it is off - changes the colors on my template and gives this error:

1054 Unknown column 'p.products_date_added' in 'where clause'
in:
[select p.faqs_id from zen_faqs p where p.faqs_status = '1' and p.products_date_added >=20081211 and (p.products_date_available <=20081218 or p.products_date_available IS NULL) limit 1]

:huh:

You need to edit
includes/templates/YOUR_TEMPLATE_FOLDER/sideboxes/tpl_faq_categories.php

Put

$display_limit = '';

on the first AND last line.

My final code:

<?php
  $display_limit = '';
  
  $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_limit = '';
          break;
        case (SHOW_NEW_FAQS_LIMIT == '1'):
          $display_limit = " and date_format(p.faqs_date_added, '%Y%m') >= date_format(now(), '%Y%m')";
          break;
        case (SHOW_NEW_FAQS_LIMIT == '30'):
          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 30';
          break;
        case (SHOW_NEW_FAQS_LIMIT == '60'):
          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 60';
          break;
        case (SHOW_NEW_FAQS_LIMIT == '90'):
          $display_limit = ' and TO_DAYS(NOW()) - TO_DAYS(p.faqs_date_added) <= 90';
          break;
        case (SHOW_NEW_FAQS_LIMIT == '120'):
          $display_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_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";

  $display_limit = '';
?>

and you will be happy :clap:

---

Free Online Pattern Maker

The only thing I can not figure out is how to keep the man page from displaying on the top categories page. I seen a reference to this earlier in this thread but I didn't see a fix. Thanks!

I am using the apple zen template, when the faq mod is viewed it moves my right boxes to bottom of page

example here

jettrue that made the apple zen template said this about my problem

"It's not apple zen, the people who designed those mods probably forgot to wrap the pages correctly with the centerColumn wrapper. I've seen it happen a lot."
Does anyone here know how to fix this issue?

thanks

nikki72:

I am using the apple zen template, when the faq mod is viewed it moves my right boxes to bottom of page

example here

jettrue that made the apple zen template said this about my problem

"It's not apple zen, the people who designed those mods probably forgot to wrap the pages correctly with the centerColumn wrapper. I've seen it happen a lot."
Does anyone here know how to fix this issue?

thanks

I checked the download, and all of the includes/templates/YOUR_TEMPLATE/templates/ files are missing the

<div class="centerColumn" id="nameofpagehereDefault">

at the beginning of the file

and the closing </div> at the end of the file.

That is the standard way includes/templates/YOUR_TEMPLATE/templates/ files are enclosed in zen cart. My template (and others might too) relies on that being there, and it also gives people a way to style the content of each page with css, since each page is given its own unique id.

I think perhaps not every single page in that folder needs that added, since some of those pages (like tpl_faqs_next_previous.php) aren't necessarily responsible for the whole pages content, just a portion of it. I'm pretty sure all of the files in that folder that end in _default.php need it added, though.

nikki72:

this thread has been great. It's helped me out a lot, however I can not figure out how to get it to not display double bread crumbs across the top of my faq pages.
example: http://2antioch.org/store/index.php?main_page=faqs_all&fcPath=1
The ask a question button is not show either.

THanks!

It's got double breadcrumbs, because this mod is poorly coded. It's not supposed to add breadcrumbs, as zen cart already does that in another file. You can open up all the files in includes/templates/YOUR_TEMPLATE/templates/ and if it has this code:

<?php if (DEFINE_BREADCRUMB_STATUS == '1' || DEFINE_BREADCRUMB_STATUS == '2' ) { ?>
  <tr>
    <td class="breadCrumb" colspan="2"><?php echo $breadcrumb->trail(BREAD_CRUMBS_SEPARATOR); ?></td>
  </tr>
<?php } ?>

remove it.

If the original designer of this mod isn't active, I'll happily clean up the coding, but I won't take over support of the mod, LOL.

Grace38:

I notice several people asked this question already but no one has answered it at least in the pages i have read ( it's a long thread )

How do you stop your main page showing up when you click one of your product categories after installing this.

My main page shows up in all categories which have subcategories.

If the category doesn't have subcategories the main page doesn't show up and thats how i want it.

Someone suggested deleting a file but thats no use if you want to actually use the module.

So what is the fix for this issue ?

If you open up includes/templates/YOUR_TEMPLATE/templates/tpl_index_faq_categories.php and remove this:

<table border="0" width="100%" cellspacing="2" cellpadding="2">
<?php
if ($show_welcome == 'true') {
?>
  <tr>
    <td class="pageHeading"><h1><?php echo HEADING_TITLE; ?></h1></td>
  </tr>
  <tr>
    <td class="greetUser"><?php echo zen_customer_greeting(); ?></td>
  </tr>
<?php if (TEXT_MAIN) { ?>
  <tr>
    <td class="main"><?php echo TEXT_MAIN; ?></td>
  </tr>
<?php } ?>
<?php if (TEXT_INFORMATION) { ?>
  <tr>
    <td class="plainBox"><?php echo TEXT_INFORMATION; ?></td>
  </tr>
<?php } ?>
<?php if (DEFINE_MAIN_PAGE_STATUS == '1') { ?>
  <tr>
    <td class="plainBox"><?php require($define_main_page); ?><br /></td>
  </tr>
<?php } ?>

<?php } else { ?>
  <tr>
    <td class="breadCrumb" colspan="2"><?php echo $breadcrumb->trail(BREAD_CRUMBS_SEPARATOR); ?></td>
  </tr>
  <tr>
    <td class="pageHeading"><h1><?php echo $breadcrumb->last(); ?></h1></td>
  </tr>
<?php } ?>
</table><br />

does the issue go away?

All is fair in love and war....... opps no... but all is about fair here!
I got every page to correctly wrap except the "tell a friend"
for the life of me I can not find a template for this! ugh.... I believe I got it fixed on the rest of the pages.

I tell you this is a good add on for zen cart..... if I had the know how I would try to work on it! Maybe later on lol..

anywhooo, anyone know which template determines the "tell a friend" in the FAQ mod?

thanks
Nicole

jettrue:

If you open up includes/templates/YOUR_TEMPLATE/templates/tpl_index_faq_categories.php and remove this:

<table border="0" width="100%" cellspacing="2" cellpadding="2"> <?php if ($show_welcome == 'true') { ?> <tr> <td class="pageHeading"><h1><?php echo HEADING_TITLE; ?></h1></td> </tr> <tr> <td class="greetUser"><?php echo zen_customer_greeting(); ?></td> </tr> <?php if (TEXT_MAIN) { ?> <tr> <td class="main"><?php echo TEXT_MAIN; ?></td> </tr> <?php } ?> <?php if (TEXT_INFORMATION) { ?> <tr> <td class="plainBox"><?php echo TEXT_INFORMATION; ?></td> </tr> <?php } ?> <?php if (DEFINE_MAIN_PAGE_STATUS == '1') { ?> <tr> <td class="plainBox"><?php require($define_main_page); ?><br /></td> </tr> <?php } ?> <?php } else { ?> <tr> <td class="breadCrumb" colspan="2"><?php echo $breadcrumb->trail(BREAD_CRUMBS_SEPARATOR); ?></td> </tr> <tr> <td class="pageHeading"><h1><?php echo $breadcrumb->last(); ?></h1></td> </tr> <?php } ?> </table><br /> ``` > does the issue go away?

Thanks jettrue, but this doesn't work :(
My welcome line only shows up now in main categories that have sub categories, not in the main category listing that has items directly listed in it!

This would not be a big issue, but I was going to try and use that area to install a slide show gallery...... dreaming

nikki72:

this thread has been great. It's helped me out a lot, however I can not figure out how to get it to not display double bread crumbs across the top of my faq pages.
example: http://2antioch.org/store/index.php?main_page=faqs_all&fcPath=1
The ask a question button is not show either.

THanks!
I fixed this by going through every page and deleting any reference to the breadcrumbs, fun lol