FAQ Manager

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

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