From 856f707fe60d64b0e7a6a8748ed847f72284287c Mon Sep 17 00:00:00 2001 From: rub Date: Fri, 16 Feb 2007 23:13:01 +0000 Subject: Fix Issue 0000605: Not linked elements failure with no virtual categories galleries Add missing translations git-svn-id: http://piwigo.org/svn/trunk@1831 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/element_set.php | 19 +++++++++++++------ 1 file changed, 13 insertions(+), 6 deletions(-) (limited to 'admin/element_set.php') diff --git a/admin/element_set.php b/admin/element_set.php index 530bbd5f5..ee9884e31 100644 --- a/admin/element_set.php +++ b/admin/element_set.php @@ -147,20 +147,27 @@ SELECT id ;'; $virtual_categories = array_from_query($query, 'id'); - $query = ' + if (!empty($virtual_categories)) + { + $query = ' SELECT DISTINCT(image_id) FROM '.IMAGE_CATEGORY_TABLE.' ;'; - $all_elements = array_from_query($query, 'image_id'); - - $query = ' + $all_elements = array_from_query($query, 'image_id'); + + $query = ' SELECT DISTINCT(image_id) FROM '.IMAGE_CATEGORY_TABLE.' WHERE category_id IN ('.implode(',', $virtual_categories).') ;'; - $linked_to_virtual = array_from_query($query, 'image_id'); + $linked_to_virtual = array_from_query($query, 'image_id'); - $page['cat_elements_id'] = array_diff($all_elements, $linked_to_virtual); + $page['cat_elements_id'] = array_diff($all_elements, $linked_to_virtual); + } + else + { + $page['cat_elements_id'] = array(); + } } else if ('duplicates' == $_GET['cat']) { -- cgit v1.2.3