Advanced Search Plus

[twitchtoo]

In theory, you need to change the search 'LIKE' to 'EQUALS'

Or use the SQL boundaries search to match the whole word.

That way it's not looking for everything, it's only looking for exact matches to the keyword you have typed in.

[Axeman]

Do you think that it could be integrated into the advanced search function or would that upset the working of it? From the way my toner/ink cartridge finder would need to search i would need to have a more refined search than the standard and also your addon search. Instead of a generic search, pulling out everything that has part of the search term in it, it would need to filter out anything that isn't an exact match.

Have you any ideas for coding this as an option so that the filtering is reflected in the domain name which could be copied and pasted into the links for my cartridge finder? I can get round it to a degree but I may lose custom because only certain products would be shown instead of the complete range of options for a customer's printer. The other thing is that if the general search were to be too specific people would not be able to see all of the available options for their product, whereas if it was an option it could be usefull for both my customer and me.

[puhycz]

Hi, I have problem with this plugin. It works all great, but no showing catregory name in results. The $listing->fields['categories_id'] in tpl_modules_advanced_search_categories.php is clean... Where will be problem?

Many thanks.

[twitchtoo]

Hi, I have problem with this plugin. It works all great, but no showing catregory name in results. The $listing->fields['categories_id'] in tpl_modules_advanced_search_categories.php is clean... Where will be problem?

Many thanks.

I need to see your site files to check, I emailed you.

[puhycz]

So, I send two emails, do you receive it? Thanks.

[twitchtoo]

So, I send two emails, do you receive it? Thanks.

Sorry no, please try again mate.

[Gamethrall]

Hi, I have problem with this plugin. It works all great, but no showing catregory name in results. The $listing->fields['categories_id'] in tpl_modules_advanced_search_categories.php is clean... Where will be problem?

Many thanks.

I'm having this issue too. I'm running 2.03 of the module on Zen Cart 1.5.5e.

In tpl_modules_advanced_search_categories.php, if I change

 
        $lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_name'] . '</a></h3><div class="listingDescription">'. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listing->fields['categories_id'], $_SESSION['languages_id'])))) . '</div>' ;

to

        $lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_id'] . '</a></h3><div class="listingDescription">'. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listing->fields['categories_id'], $_SESSION['languages_id'])))) . '</div>' ;

I do see a hyperlink to the category ID number.

I love this module and it fixes what I consider to be a big oversight in Zen Cart, so I'm hoping this can be resolved.

[twitchtoo]

I'm having this issue too. I'm running 2.03 of the module on Zen Cart 1.5.5e.

In tpl_modules_advanced_search_categories.php, if I change

 
        $lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_name'] . '</a></h3><div class="listingDescription">'. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listing->fields['categories_id'], $_SESSION['languages_id'])))) . '</div>' ;

to

        $lc_text = '<h3 class="itemTitle"><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new). '">' . $listing->fields['categories_id'] . '</a></h3><div class="listingDescription">'. zen_trunc_string(zen_clean_html(stripslashes(zen_get_category_description($listing->fields['categories_id'], $_SESSION['languages_id'])))) . '</div>' ;

I do see a hyperlink to the category ID number.

I love this module and it fixes what I consider to be a big oversight in Zen Cart, so I'm hoping this can be resolved.

The Fix:
includes/modules/YOUR_TEMPLATE/advanced_search_categories.php

replace line 45
$select_str_cat = "SELECT DISTINCT " . $select_column_list_cat . "cd.categories_description, cd.categories_id, c.parent_id ";

with this:
$select_str_cat = "SELECT DISTINCT " . $select_column_list_cat . "cd.categories_description, cd.categories_id, c.parent_id, cd.categories_name ";

This will display the correctly named category name below the image as a clickable link.

[twitchtoo]

Do you think that it could be integrated into the advanced search function or would that upset the working of it? From the way my toner/ink cartridge finder would need to search i would need to have a more refined search than the standard and also your addon search. Instead of a generic search, pulling out everything that has part of the search term in it, it would need to filter out anything that isn't an exact match.

Have you any ideas for coding this as an option so that the filtering is reflected in the domain name which could be copied and pasted into the links for my cartridge finder? I can get round it to a degree but I may lose custom because only certain products would be shown instead of the complete range of options for a customer's printer. The other thing is that if the general search were to be too specific people would not be able to see all of the available options for their product, whereas if it was an option it could be usefull for both my customer and me.

Although we could change the search engine, it may be beneficial to run a VB script on your database. In the past I've created searchable indexes with automation scripts that actually put a static 'label' or 'model' or 'sku' in a new searchable field. This is always 100% compatible with every new version of zen and super fast and easy to change if ever you need to.

Instead of searching everything for something, search one column for everything. Reduces processing time to boot.

[twitchtoo]

I've started updates to this module, watch for the 1.55f release shortly :)