Where did these sql queries move to?

[strelitzia]

[Note: remember to include site URL, ZC version, list of plugins, PHP version, etc ... read the Posting Tips shown above for information to include in your post here.
And, remove this comment before actually posting!]

In the process of upgrading from 1.5.6c to 1.5.7a and I need to merge in some customisation that was done on an sql query in includes/modules/pages/product_info/main_template_vars.php. Opened up the file to find the query no longer resides in there.
On ZC 1.5.6c there was a query at lines 18 to 24 and lines 39 to 53.

I noticed that the queries have been removed from includes/modules/pages/document_general_info/main_template_vars.php and includes/modules/pages/document_product_info/main_template_vars.php too.

Are there common queries for them all now, and where are they located?

Thanks for any help on this one.

[DrByte]

I'm guessing you're referring to the queries that are now run via zen_get_product_details() in the /includes/functions/functions_products.php file?

Beware that if you start changing queries in a function that's used by other parts of the code then you might cause unexpected effects elsewhere.

In the case of product_info (and other product-type pages), there's a main_template_vars_product_type.php file in each of those includes/modules/pages folders whose purpose is specifically for adding additional data and running custom queries if needed.

You can use whichever approach fits your custom needs best, without causing unexpected side effects.