bug:2944 Performance issues when creating an album

git-svn-id: http://piwigo.org/svn/trunk@23944 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 1 insertions, 16 deletions

diff --git a/admin/include/photos_add_direct_prepare.inc.php b/admin/include/photos_add_direct_prepare.inc.php
index 9c4ede9f3..4f5f61187 100644
--- a/admin/include/photos_add_direct_prepare.inc.php
+++ b/admin/include/photos_add_direct_prepare.inc.php
@@ -160,12 +160,9 @@ $template->assign(
 
 // 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
+SELECT category_id
   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
@@ -178,11 +175,6 @@ 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 album
@@ -197,13 +189,6 @@ display_select_cat_wrapper(
   'category_options'
   );
 
-// new category
-display_select_cat_wrapper(
-  $query,
-  $selected_parent,
-  'category_parent_options'
-  );
-
 
 // image level options
 $selected_level = isset($_POST['level']) ? $_POST['level'] : 0;