Changeset 21658 for extensions/SmartAlbums/admin/cat_list.php

Timestamp:

Mar 17, 2013, 8:32:17 PM (11 years ago)

Author:

mistic100

Message:

move update time from categories_table to category_filters_table

File:

• extensions/SmartAlbums/admin/cat_list.php (modified) (2 diffs)

extensions/SmartAlbums/admin/cat_list.php

@@ -21 +21 @@
     permalink,
     dir,
-    smart_update
+    cf.updated
   FROM '.CATEGORIES_TABLE.' AS cat
   INNER JOIN '.CATEGORY_FILTERS_TABLE.' AS cf
     ON cf.category_id = cat.id
+  GROUP BY id
   ORDER BY global_rank ASC
 ;';
@@ -146 +147 @@
       'ID'          => $category['id'],
       'IMG_COUNT'   => !empty($categories_count_images[ $category['id'] ]) ? $categories_count_images[ $category['id'] ] : 0,
-      'LAST_UPDATE' => format_date($category['smart_update'], true),
+      'LAST_UPDATE' => format_date($category['updated'], true),
 
       'U_JUMPTO'    => make_index_url(array('category' => $category)),