Display matching categories in search results

[michael_s]

Display matching categories in search results

For OsCommerce 2.2 rc1

This will display matching categories results where the name matches the search, if you have the category description mod

(http://www.oscommerce.com/community/contributions,2343), there is code to include that too.
Also included is code if you have my hide categories contribution (http://addons.oscommerce.com/info/5907).

Included here is an sql query to add a setting in admin to control category search.

If a category is selected in the search, then only that (and subcategories if option set) are searched.
The from / to date filters are also applied.
I`ve also added an option to search categories only.

During the writing of this I found what appears to me to be a vulnerability in the search form in OSC2.2 rc1 where it could be used by a malicious attacker to inject sql or code.
I have added a trap in advanced_search_result.php for this.

Forum started for this at http://forums.oscommerce.com/index.php?showtopic=301065

More...