diff options
author | plegall <plg@piwigo.org> | 2010-12-31 16:43:59 +0000 |
---|---|---|
committer | plegall <plg@piwigo.org> | 2010-12-31 16:43:59 +0000 |
commit | 4effe045ee0b924cdcf17c7499d12ab4467433a3 (patch) | |
tree | d618bc4851d25d1f0e203e07f0afb6cf5017cc1a /admin/batch_manager.php | |
parent | c716ed88b8b8a101bf35589a465ce3b45c6942aa (diff) |
feature 2091: Batch Manager, find all orphan photos
git-svn-id: http://piwigo.org/svn/trunk@8419 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r-- | admin/batch_manager.php | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/admin/batch_manager.php b/admin/batch_manager.php index 89a1b8bc1..e11c8213e 100644 --- a/admin/batch_manager.php +++ b/admin/batch_manager.php @@ -177,6 +177,21 @@ SELECT id ); } + if ('with no album' == $_SESSION['bulk_manager_filter']['prefilter']) + { + $query = ' +SELECT + id + FROM '.IMAGES_TABLE.' + LEFT JOIN '.IMAGE_CATEGORY_TABLE.' ON id = image_id + WHERE category_id is null +;'; + array_push( + $filter_sets, + array_from_query($query, 'id') + ); + } + if ('duplicates' == $_SESSION['bulk_manager_filter']['prefilter']) { // we could use the group_concat MySQL function to retrieve the list of |