Community Add-Ons

Maintainers: Jan Zonjee
Add file to this package
Top » Other

tep_get_category_tree optimization
for osCommerce Online Merchant v2.2

The function tep_get_category_tree is the one that creates the contents of the drop-down menu (the one that starts with Top) in the top right corner of the categories.php page in the admin section.
In the 2.2MS2 version of osCommerce it is very inefficient as relating to mySQL queries. It queries the database for every category, subcategory, or subsubcategory. If you have a lot of categories it will make that page load slow.

Legend:  Download   Report
Expand All / Collapse All
tep_get_category_tree opimization v2 Jan Zonjee 11 Mar 2006  

DO NOT USE Version 1.0. It had a serious flaw: if you deleted a category it would delete all your categories and all your products. It also would not go any deeper than three levels. This is fixed in version 2.

tep_get_category_tree optimization Jan Zonjee 8 Mar 2006