Changeset 27266 for extensions/SmartAlbums/maintain.inc.php

Timestamp:

Feb 8, 2014, 12:11:14 PM (10 years ago)

Author:

mistic100

Message:

allow to choose the sort order when using limit filter

File:

• extensions/SmartAlbums/maintain.inc.php (modified) (2 diffs)

extensions/SmartAlbums/maintain.inc.php

@@ -62 +62 @@
   `category_id` smallint(5) unsigned NOT NULL,
   `type` varchar(16) NOT NULL,
-  `cond` varchar(16) NULL,
+  `cond` varchar(32) NULL,
   `value` text NULL,
   `updated` DATETIME NOT NULL DEFAULT "1970-01-01 00:00:00"
@@ -114 +114 @@
       }
     }
+    
+    // limit filter extended in 2.2.1
+    pwg_query('UPDATE `' . $this->table . '` SET cond = "" WHERE type = "limit" AND cond = "limit";');
+    pwg_query('ALTER TABLE `' . $this->table . '` CHANGE `cond` `cond` VARCHAR(32) NULL ;');
 
     $this->installed = true;