FAQ Manager

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