From a3dc10babc0609f2a097bca76da1de8b2d92ace6 Mon Sep 17 00:00:00 2001 From: rvelices Date: Thu, 25 Sep 2008 00:39:12 +0000 Subject: - sql optim: do not include category_cats (which makes a query) if current category does not have children (info known when building menubar) - in index.php - fill the template completely before including menubar/category_cats/thumbnails (some themes might want to use in the menubar some vars ...) git-svn-id: http://piwigo.org/svn/trunk@2586 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/functions_category.inc.php | 2 ++ 1 file changed, 2 insertions(+) (limited to 'include/functions_category.inc.php') diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php index 53f98a5c2..26c9478ef 100644 --- a/include/functions_category.inc.php +++ b/include/functions_category.inc.php @@ -103,6 +103,8 @@ WHERE '.$where.' while ($row = mysql_fetch_assoc($result)) { array_push($cats, $row); + if ($row['id']==@$page['category']['id']) //save the number of subcats for later optim + $page['category']['count_categories'] = $row['count_categories']; } usort($cats, 'global_rank_compare'); -- cgit v1.2.3