FAQ Manager

[danilovig]

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, '');


ExampleI 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, '');

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

[danilovig]

Another solution is:

includes/templates/yourtemplate/sideboxes/tpl_faq_categories.php

line:96

add after:

      case (SHOW_NEW_FAQS_LIMIT == '120'):

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

          break; 

Put

          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;
      } 

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

[gofer_p]

Another solution is:

includes/templates/yourtemplate/sideboxes/tpl_faq_categories.php

line:96

add after:

      case (SHOW_NEW_FAQS_LIMIT == '120'):

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

          break; 

Put

          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.

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

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

[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

[nikki72]

BTW is there away to get the FAQ manager to show in the site map

[gezuvor]

I installed this on a test server and have waded through the pages to correct some errors. Phew!

But, there are more and I have some questions that seem to repeat without answer:
- How can the sort box be removed? I want all pages to sort by category.
- Regardless of the category I click, all FAQ are displayed in some random order. No point in having categories if they are useless...

Thanks

[Rob905]

I have installed the FAQ manager I downloaded here on a modded 1.3.8a system.

The problems I have so far is that:
1. I don't have a button that shows for "Ask a Question", it just shows the alt text. Yet I can see the button in the directory where the other buttons are.
2. I also do not have the config option that is supposed to be in the admin section.

Can ayone help with this or has this module pretty much died?

Site is http://niagaraicewineshop.com

Thanks
Robert

[Rob905]

Is there a list of files that need to be pulled in the event that I decide to delete this MOD?

Is there a way to remove the SQL changes that were needed for this MOD?

Robert