aboutsummaryrefslogtreecommitdiffstats
path: root/admin/photos_add_direct.php
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2010-04-09 19:47:29 +0000
committerplegall <plg@piwigo.org>2010-04-09 19:47:29 +0000
commite39b4c4a0c4fe6f5a146a55f5119d01abe09bcb7 (patch)
tree11779c177a99b77c500de75153ca4294fa6b193f /admin/photos_add_direct.php
parentfce10ca2d46e0cdc86f2c4b76209ce5af692f32c (diff)
feature 1591: smarter default categories in upload form. We use the most
recently added photo as reference. git-svn-id: http://piwigo.org/svn/trunk@5743 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--admin/photos_add_direct.php40
1 files changed, 39 insertions, 1 deletions
diff --git a/admin/photos_add_direct.php b/admin/photos_add_direct.php
index 0c24fc6ef..ec7235ad7 100644
--- a/admin/photos_add_direct.php
+++ b/admin/photos_add_direct.php
@@ -379,6 +379,36 @@ if (isset($page['thumbnails']))
}
}
+// categories
+//
+// we need to know the category in which the last photo was added
+$selected_category = array();
+$selected_parent = array();
+
+$query = '
+SELECT
+ category_id,
+ id_uppercat
+ FROM '.IMAGES_TABLE.' AS i
+ JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON image_id = i.id
+ JOIN '.CATEGORIES_TABLE.' AS c ON category_id = c.id
+ ORDER BY i.id DESC
+ LIMIT 1
+;';
+$result = pwg_query($query);
+if (pwg_db_num_rows($result) > 0)
+{
+ $row = pwg_db_fetch_assoc($result);
+
+ $selected_category = array($row['category_id']);
+
+ if (!empty($row['id_uppercat']))
+ {
+ $selected_parent = array($row['id_uppercat']);
+ }
+}
+
+// existing category
$query = '
SELECT id,name,uppercats,global_rank
FROM '.CATEGORIES_TABLE.'
@@ -386,10 +416,18 @@ SELECT id,name,uppercats,global_rank
display_select_cat_wrapper(
$query,
- array(),
+ $selected_category,
'category_options'
);
+// new category
+display_select_cat_wrapper(
+ $query,
+ $selected_parent,
+ 'category_parent_options'
+ );
+
+
// image level options
$tpl_options = array();
foreach (array_reverse($conf['available_permission_levels']) as $level)