FAQ Manager

[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?...s_all&fcPath=1
The ask a question button is not show either.

THanks!

[BeadsGirl]

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]

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

-----------------------------------------------------

Free Online Pattern Maker

[nikki72]

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!

[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

[jettrue]

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.

[jettrue]

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

[jettrue]

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?

[nikki72]

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

[nikki72]

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