[Contribution] Match Categories in Search Results for osCommerce versions 2.3.x

[auzStar 148]

Support Thread for Match Categories in Search Results for osCommerce versions 2.3.x

 

Report problems here.

 

I will monitor this thread and try to answer as many questions as I can.

 

Feedback and comments appreciated.

 

 

Download link:

http://addons.oscommerce.com/info/9197
 

 

Dom

Edited December 29, 2014 by auzStar

[Hostecom 0]

Hi. Tested and Works in Oscommerce 2.2ms. Only little changes in tables for a correct composition. No code changes needed. Great contibution!

[auzStar 148]

@@Hostecom

 

Hi John,

 

Thanks for testing and feedback.

 

Could you please post the changes you made to the tables. May help others.

 

cheers

[Hostecom 0]

Hi, sure:

 

 

step 1

 

FIND AROUND LINE 133 to 135:

 

<h1><?php echo HEADING_TITLE_2; ?></h1>

 

<div class="contentContainer">

 

 

REPLACE WITH ALL THE CODE BELOW:

 

<div class="contentContainer">

 

<!-- begin Match Categories in Search Results -->

<?php

  if ((ENABLE_CATEGORY_LIST_IN_SEARCH == 'true' && ((ENABLE_CATEGORY_LIST_USER_CONTROL == 'false') || (isset($HTTP_GET_VARS['cat_search']) && $HTTP_GET_VARS['cat_search'] == '1') || (isset($HTTP_GET_VARS['cat_only']) && $HTTP_GET_VARS['cat_only'] == '1')) && (!isset($HTTP_GET_VARS['page']) || $HTTP_GET_VARS['page'] == '1')) || (ENABLE_CATEGORY_LIST_IN_SEARCH == 'true' && ENABLE_CATEGORY_SEARCH_ONLY == 'true')) {

    include('category_search_result.php');

  }

 

  if ((ENABLE_CATEGORY_LIST_IN_SEARCH == 'false' || ENABLE_CATEGORY_SEARCH_ONLY == 'false') && (!isset($HTTP_GET_VARS['cat_only']) || $HTTP_GET_VARS['cat_only'] != '1')) {

?>

<!-- end Match Categories in Search Results -->

 

<h1><?php echo HEADING_TITLE_2; ?></h1>

 

just changed to:

 

 

step 1

 

FIND AROUND LINE 133 to 135:

 

<h1><?php echo HEADING_TITLE_2; ?></h1>

 

<div class="contentContainer">

 

 

REPLACE WITH ALL THE CODE BELOW:

 

          <tr>

          <td>

<!-- begin Match Categories in Search Results -->

<?php

  if ((ENABLE_CATEGORY_LIST_IN_SEARCH == 'true' && ((ENABLE_CATEGORY_LIST_USER_CONTROL == 'false') || (isset($HTTP_GET_VARS['cat_search']) && $HTTP_GET_VARS['cat_search'] == '1') || (isset($HTTP_GET_VARS['cat_only']) && $HTTP_GET_VARS['cat_only'] == '1')) && (!isset($HTTP_GET_VARS['page']) || $HTTP_GET_VARS['page'] == '1')) || (ENABLE_CATEGORY_LIST_IN_SEARCH == 'true' && ENABLE_CATEGORY_SEARCH_ONLY == 'true')) {

    include('category_search_result.php');

  }

 

  if ((ENABLE_CATEGORY_LIST_IN_SEARCH == 'false' || ENABLE_CATEGORY_SEARCH_ONLY == 'false') && (!isset($HTTP_GET_VARS['cat_only']) || $HTTP_GET_VARS['cat_only'] != '1')) {

?>

</td></tr>

 

Some classes from stylesheet.css located in files are different from my version, but its very easy to customize the results. Without this stylesheet changes the result still show right, uses table default styles. 

 

Thanks to your module my search now has new life :)

[radhavallabh 41]

Hi

Firstly thanks for this amazing Mod you have created...

I am getting the below error on installing this mod on the advanced search result page-

 

1054 - Unknown column 'c.categories_status' in 'where clause'

select c.categories_id, cd.categories_name from categories c left join categories_description cd on c.categories_id = cd.categories_id where c.categories_status = 1 and cd.language_id = '1' and ((cd.categories_name like '%flute%') ) order by categories_name

 

Your help will be deeply appreciated...

[♥bruyndoncx 260]

just remove

 

c.categories_status = 1 and

 

from the sql where clause and you should be fine.

 

it is a field that comes from a enable/disable categories contribution

[radhavallabh 41]

@@bruyndoncx    Thank you so much..... :) It works like a charm now....

Edited July 21, 2015 by radhavallabh

[auzStar 148]

@@radhavallabh

@@bruyndoncx

 

Hi guys, sorry I've only just seen this now.

 

There's no need to alter the sql statement. In "admin->configuration->categories search" set Don't show hidden categories to false.

 

That option is there for the "Hidden Categories" add-on, if you have it installed, to allow you to include/exclude hidden categories from search results. i.e. if that add-on is installed, set the above option to true to control whether or not to hide categories which have been set for each category via the "Hidden Categories" add-on. If the "Hidden Categories" add-on is not installed then set it to false. (If set to false and the "Hidden Categories" add-on is installed then hidden categories will still be seen in search results regardless of whether they are hidden or not) 

 

If you don't have that add-on installed you set this option to false. It's mentioned in the install documentation.

 

cheers

 

[radhavallabh 41]

Thankyou..... But I am using the Categories Status addon... Still will set the Don't show hidden categories to false too..

But everything is now working perfectly.....

Thanks again.. :)

[auzStar 148]

@@radhavallabh

 

If you have the "Hidden Categories" add-on installed then you should have a "categories_status" field in the "categories" table, because the "Match Categories in Search Results" add-on relies on this when the setting Don't show hidden categories is set to true. If "categories_status" field is not used in the "categories" table, then there is some info in the install doco on how to modify the files.

 

cheers

 

[desmoulins22 1]

did install it few min ago on  (osCommerce Online Merchant v2.3.4),have to say ,easy to do it and took me just few min and it works flawless.

Thank you very much !!!