Changeset 23085 for extensions/community/maintain.inc.php

Timestamp:

Jun 7, 2013, 2:41:14 PM (11 years ago)

Author:

plg

Message:

New feature: user album. Only for registered users, no recursivity. Piwigo
will automatically create an upload album for each user with appropriate
community permissions, at first connection.

Bug fixed: on activation, do not create a new "Community" album if it already
exists.

Bug fixed: remove debug for quota

Bug fixed: round corners for number of pending pictures in admin menu.

File:

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

extensions/community/maintain.inc.php

@@ -24 +24 @@
   $query = 'DROP TABLE '.$prefixeTable.'community_pendings;';
   pwg_query($query);
+
+  $query = 'ALTER TABLE '.$prefixeTable.'categories drop column community_user;';
+  pwg_query($query);
+
+  // delete configuration
+  pwg_query('DELETE FROM `'. CONFIG_TABLE .'` WHERE param IN ("community", "community_cache_key");');
 }
 
@@ -241 +247 @@
 {
   global $prefixeTable;
-  
-  // create an album "Community"
-  $category_info = create_virtual_category('Community');
+
+  // is there a "Community" album?
+  $query = '
+SELECT
+    id
+  FROM '.CATEGORIES_TABLE.'
+  WHERE name = \'Community\'
+;';
+  $result = pwg_query($query);
+  while ($row = pwg_db_fetch_assoc($result))
+  {
+    $category_id = $row['id'];
+    break;
+  }
+
+  if (!isset($category_id))
+  {
+    // create an album "Community"
+    $category_info = create_virtual_category('Community');
+    $category_id = $category_info['id'];
+  }
 
   $insert = array(
     'type' => 'any_registered_user',
-    'category_id' => $category_info['id'],
+    'category_id' => $category_id,
     'recursive' => 'true',
     'create_subcategories' => 'true',