aboutsummaryrefslogtreecommitdiffstats
path: root/admin/batch_manager.php
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2010-12-31 16:43:59 +0000
committerplegall <plg@piwigo.org>2010-12-31 16:43:59 +0000
commit4effe045ee0b924cdcf17c7499d12ab4467433a3 (patch)
treed618bc4851d25d1f0e203e07f0afb6cf5017cc1a /admin/batch_manager.php
parentc716ed88b8b8a101bf35589a465ce3b45c6942aa (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 'admin/batch_manager.php')
-rw-r--r--admin/batch_manager.php15
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