Changeset 21658 for extensions/SmartAlbums/include/functions.inc.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/include/functions.inc.php (modified) (2 diffs)

extensions/SmartAlbums/include/functions.inc.php

@@ -52 +52 @@
   
   $query = '
-UPDATE '.CATEGORIES_TABLE.'
-  SET smart_update = NOW()
-  WHERE id = '.$cat_id.'
+UPDATE '.CATEGORY_FILTERS_TABLE.'
+  SET updated = NOW()
+  WHERE category_id = '.$cat_id.'
 ;';
   pwg_query($query);
@@ -689 +689 @@
     INNER JOIN '.CATEGORY_FILTERS_TABLE.' AS cf
     ON c.id = cf.category_id
-  WHERE smart_update < DATE_SUB(NOW(), INTERVAL '.$conf['SmartAlbums']['update_timeout'].' DAY)
+  WHERE updated < DATE_SUB(NOW(), INTERVAL '.$conf['SmartAlbums']['update_timeout'].' DAY)
 ;';