where is the SQL that controls what the categories side box outputs?

Hi,

I am trying to modify the sql that is used to general the links in the tpl_categories.php files but I can't seem to find it. I think that file uses $box_categories_array to generate the categories.

Where is the file that I would find the sql for the categories?

or any pointers?

thanks,

Expand on what you are attempting to accomplish

Hi,

http://garagefive.net/z2/

The zen cart has a bit of custom work done by another developer.

So basically, there is a vehicle search that will search out all products for that vehicle only and also, customize the categories so that when you click on "intakes", it will only show intakes related to the vehicle.

So what I am trying to do is to make it so that the categories show the items related to the vehicle selected and also show products that are tagged "universal". The developer made a module in the admin to assign keywords to the products.

So I was thinking of finding out where the sql is used to generate the categories so that I can modify the sql and have it display the universal products too.

I've managed to modify the sql for the vehicle selector so that once you choose a vehicle, it will show related items and universal items too but the categories are not affected.

Thanks,

kobra:

Expand on what you are attempting to accomplish

You might modify this or write another that takes over once your vehicle search has bee excecuted

/includes/classes/category_tree.php

ok, so $box_categories_array is created from the category_tree class?

actually, honestly, I am not sure how those categories are generated or how the variables in the sql are populated.

$categories_query = "select ptc.category_id as categories_id, cd.categories_name, c.parent_id, c.categories_image
                             from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCT_TYPES_TO_CATEGORY . " ptc
                             where c.parent_id = " . (int)$value . "
                             and ptc.category_id = cd.categories_id
                             and ptc.product_type_id = " . $master_type . "
                             and c.categories_id = ptc.category_id
                             and cd.language_id=" . (int)$_SESSION['languages_id'] ."
                             and c.categories_status= 1
                             order by sort_order, cd.categories_name";

For example, how is TABLE_CATEGORIES variable populated? does zencart know that is a variable and needs to be replaced by an actual value?

sorry for asking this. or is there a document that would explain this to me?

Check that file for "categories_array" starting about line 157

awesome, thanks.

I see 2 queries in that file, I suppose I should be modifying the 2nd query. Since the 1st one is only when "$product_type == 'all'", right?

If you change the query code then you will break the normal display

I think you need to keep it as is and provide another query that builds another array that is invoked when your customers perform your "vehicle search"

As I stated initially this might be best in a new file that is called after a search

Thanks Kobra, I will give it a shot, this will destroy my weekend....

Thanks Kobra, I will give it a shot, this will destroy my weekend....
What else did you have to do!!

Did ya think that an online business was set and forget?