Changeset 24421 for extensions/UserCollections/include/install.inc.php

Timestamp:

Sep 11, 2013, 6:44:54 PM (11 years ago)

Author:

mistic100

Message:

new system for shares : password protection, link timeout, management popup + for mails
handle lightbox conflicts
menublock is visible by AMM

File:

• extensions/UserCollections/include/install.inc.php (modified) (3 diffs)

extensions/UserCollections/include/install.inc.php

@@ -26 +26 @@
   `comment` text NULL,
   `nb_images` mediumint(8) NOT NULL DEFAULT 0,
-  `public` tinyint(1) DEFAULT 0,
-  `public_id` varchar(10) NULL,
   PRIMARY KEY (`id`)
-) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
 ;';
   pwg_query($query);
@@ -37 +35 @@
   `col_id` mediumint(8) NOT NULL,
   `image_id` mediumint(8) NOT NULL,
-  `add_date` DATETIME NULL,
+  `add_date` datetime NULL,
   UNIQUE KEY `UNIQUE` (`col_id`,`image_id`)
-) DEFAULT CHARSET=utf8
+) ENGINE=MyISAM DEFAULT CHARSET=utf8
 ;';
   pwg_query($query);
   
+  // version 2.0.0
   $result = pwg_query('SHOW COLUMNS FROM `'.$prefixeTable.'collection_images` LIKE "add_date";');
   if (!pwg_db_num_rows($result))
   {
-    pwg_query('ALTER TABLE `'.$prefixeTable.'collection_images` ADD `add_date` DATETIME NULL;');
+    pwg_query('ALTER TABLE `'.$prefixeTable.'collection_images` ADD `add_date` datetime NULL;');
   }
   
@@ -52 +51 @@
   if (!pwg_db_num_rows($result))
   {
-    pwg_query('ALTER TABLE `'.$prefixeTable.'collections` ADD `comment` TEXT NULL;');
+    pwg_query('ALTER TABLE `'.$prefixeTable.'collections` ADD `comment` text NULL;');
     pwg_query('ALTER TABLE `'.$prefixeTable.'collections` DROP `active`;');
+  }
+  
+  // version 2.1.0
+  $query = '
+CREATE TABLE IF NOT EXISTS `'.$prefixeTable.'collection_shares` (
+  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
+  `col_id` mediumint(8) NOT NULL,
+  `share_key` varchar(64) NOT NULL,
+  `params` text NULL,
+  `add_date` datetime NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `share_key` (`share_key`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
+;';
+  pwg_query($query);
+  
+  $result = pwg_query('SHOW COLUMNS FROM `'.$prefixeTable.'collections` LIKE "public";');
+  if (pwg_db_num_rows($result))
+  {
+    $now = date('Y-m-d H:i:s');
+    
+    $query = '
+SELECT id, public_id
+  FROM `'.$prefixeTable.'collections`
+  WHERE public = 1
+;';
+    $result = pwg_query($query);
+    
+    $inserts = array();
+    while ($row = pwg_db_fetch_assoc($result))
+    {
+      $inserts[] = array(
+        'col_id' => $row['id'],
+        'share_key' => $row['public_id'],
+        'params' => serialize(array('password'=>'','deadline'=>'')),
+        'add_date' => $now,
+        );
+    }
+    
+    mass_inserts($prefixeTable.'collection_shares',
+      array('col_id','share_key','add_date'),
+      $inserts
+      );
+    
+    pwg_query('ALTER TABLE `'.$prefixeTable.'collections` DROP `public`, DROP `public_id`;');
   }
 }