[mferguson]

I have a need for adding the current total number of products and reviews for a particular category (which also has subcategories) to my statspal. The catch is that I want the number to reflect all the products/reviews associated with that categories and the products of its children to reflected in the number that is calculated.

I'm familiar with build mysql queries but not with the caching mechanism that ReviewPost uses for categories. Is there a means of extracting this information and processing the information to calculate the numbers I need to insert into the statspal? If I can figure out how to calculate them I'm familiar with how to modify the templates to display this information dynamically.

Thanks for any assistance you can provide!

Mark