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

Timestamp:

Jun 27, 2012, 9:19:07 PM (12 years ago)

Author:

mistic100

Message:

updated for Piwigo 2.4
new filters : name, author, level, hits

File:

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

extensions/SmartAlbums/maintain.inc.php

@@ -2 +2 @@
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
 
+global $prefixeTable;
+define('smart_table', $prefixeTable . 'category_filters');
+
+define('smart_default_config', serialize(array(
+    'update_on_upload' => false,
+    'show_list_messages' => true,
+    )));
+
 function plugin_install() 
 {
-        global $prefixeTable;
-
   /* create table to store filters */
         pwg_query(
-'CREATE TABLE IF NOT EXISTS `' . $prefixeTable . 'category_filters` (
+'CREATE TABLE IF NOT EXISTS `' . smart_table . '` (
   `category_id` smallint(5) unsigned NOT NULL,
   `type` varchar(16) NOT NULL,
@@ -20 +26 @@
       
   /* config parameter */
-  pwg_query('
-INSERT INTO `' . CONFIG_TABLE . '`
-  VALUES (
-    \'SmartAlbums\', 
-    \''.serialize(array(
-        'update_on_upload' => false,
-        'show_list_messages' => true,
-        )
-      ).'\',
-    \'Configuration for SmartAlbums plugin\'
-  )
-;');
-
+  conf_update_param('SmartAlbums', smart_default_config);
 }
 
@@ -41 +35 @@
   if (!isset($conf['SmartAlbums']))
   {
-    pwg_query('
-INSERT INTO `' . CONFIG_TABLE . '`
-  VALUES (
-    \'SmartAlbums\', 
-    \''.serialize(array(
-        'update_on_upload' => false,
-        'show_list_messages' => true,
-        )
-      ).'\',
-    \'Configuration for SmartAlbums plugin\'
-  )
-;');
+    conf_update_param('SmartAlbums', smart_default_config);
+  }
+  
+  /* some filters renamed in 1.2 */
+  $name_changes = array(
+    'the' => 'the_post',
+    'before' => 'before_post',
+    'after' => 'after_post',
+    'the_crea' => 'the_taken',
+    'before_crea' => 'before_taken',
+    'after_crea' => 'after_taken',
+    );
+  foreach ($name_changes as $old => $new)
+  {
+    pwg_query('UPDATE TABLE ' . smart_table . ' SET cond = "'.$new.'" WHERE cond = "'.$old.'";');
   }
 }
 
 function plugin_uninstall() 
-{
-        global $prefixeTable;
-  
-  pwg_query('DROP TABLE `' . $prefixeTable . 'category_filters`;');
+{  
+  pwg_query('DROP TABLE `' . smart_table . '`;');
   pwg_query('ALTER TABLE `' . IMAGE_CATEGORY_TABLE . '` DROP `smart`;');
-  pwg_query('DELETE FROM `' . CONFIG_TABLE . '` WHERE param = \'SmartAlbums\';');
+  pwg_query('DELETE FROM `' . CONFIG_TABLE . '` WHERE param = \'SmartAlbums\' LIMIT 1;');
 }
+
 ?>