Frontend for multiple shops

[ditman]

It first creates a session and a link to the DB that is controlled by this session - then search.php can query the now open DB.

The problem is that I haven't found where's the code that reads "SELECT * FROM `table` WHERE `productname` = '$form_input'"

Or anything like that. Where is the query that searchs in the database generated? I haven't found that yet

[kobra]

Depending on where in the process you are i.e navugating to a category page or using the search function ....most of these are defined as functions and could be in the /includes/functions/functions_lookups.php

[ditman]

Depending on where in the process you are i.e navugating to a category page or using the search function ....most of these are defined as functions and could be in the /includes/functions/functions_lookups.php

Hmm, haved a look there and there's nothing useful (almost every function needs the product_id to perform a lookup)...

The closest I've ever been today is function zen_parse_search_string() located in /includes/functions/functions_general.php but the search string comes prepared from the outside I think I'll be doing some "debugging" from this function to see where it gets called.

Thanks to the link to the functions directory tho!

[ditman]

Well, I think I found most of it, thanks to this link:

http://www.phpxref.com/xref/zencart/.../index.html.gz

the file where the variable $listing_sql is initialized is:

includes/modules/pages/advanced_search_result/header_php.php