Changeset 19446 for extensions/SmartAlbums/include/install.inc.php

Timestamp:

Dec 16, 2012, 3:21:10 PM (11 years ago)

Author:

mistic100

Message:

• add regex for phot name, author
• add dimensions filter
• rewrite javascript algorithms
• add auto update on timeout (default 3 days)
• display photos count on plugin albums list

File:

• extensions/SmartAlbums/include/install.inc.php (modified) (4 diffs)

extensions/SmartAlbums/include/install.inc.php

@@ -11 +11 @@
     $smart_default_config = serialize(array(
       'update_on_upload' => false,
+      'update_on_date' => true,
+      'update_timeout' => 3,
       'show_list_messages' => true,
       'smart_is_forbidden' => true,
+      'last_update' => 0,
       ));
     
@@ -25 +28 @@
     {
       $new_conf['smart_is_forbidden'] = true;
-      conf_update_param('SmartAlbums', serialize($new_conf));
-      $conf['SmartAlbums'] = serialize($new_conf);
     }
+    // new params in 2.1.0
+    if (!isset($new_conf['update_on_date']))
+    {
+      $new_conf['update_on_date'] = true;
+      $new_conf['update_timeout'] = 3;
+      $new_conf['last_update'] = 0;
+    }
+    conf_update_param('SmartAlbums', serialize($new_conf));
+    $conf['SmartAlbums'] = serialize($new_conf);
   }
   
@@ -45 +55 @@
   {      
     pwg_query('ALTER TABLE `' . IMAGE_CATEGORY_TABLE . '` ADD `smart` ENUM(\'true\', \'false\') NOT NULL DEFAULT \'false\';');
+  }
+  
+  // new column on category table
+  $result = pwg_query('SHOW COLUMNS FROM `' . CATEGORIES_TABLE . '` LIKE "smart_update";');
+  if (!pwg_db_num_rows($result))
+  {      
+    pwg_query('ALTER TABLE `' . CATEGORIES_TABLE . '` ADD `smart_update` DATETIME NOT NULL;');
   }
   
@@ -68 +85 @@
     foreach ($name_changes as $old => $new)
     {
-      pwg_query('UPDATE `' . $prefixeTable . 'category_filters` SET cond = "'.$new.'" WHERE cond = "'.$old.'";');
+      pwg_query('UPDATE `' . $prefixeTable . 'category_filters` SET cond = "'.$new.'" WHERE type = "date" AND cond = "'.$old.'";');
     }
   }