Changeset 28559

Timestamp:

May 29, 2014, 7:20:21 AM (10 years ago)

Author:

rvelices

Message:

simplify batch manager overly complicated and expensive sql call

File:

• trunk/admin/batch_manager_global.php (modified) (2 diffs)

trunk/admin/batch_manager_global.php

@@ -503 +503 @@
   // we need to know the category in which the last photo was added
   $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
+SELECT category_id
+  FROM '.IMAGE_CATEGORY_TABLE.'
+  ORDER BY image_id DESC
   LIMIT 1
 ;';
@@ -516 +512 @@
   {
     $row = pwg_db_fetch_assoc($result);
-    $selected_category = array($row['category_id']);
+    $selected_category[] = $row['category_id'];
   }
 }