Changeset 9539

Timestamp:

Mar 4, 2011, 11:39:51 PM (13 years ago)

Author:

plg

Message:

convert data (pendings and permissions) from Piwigo core 2.1

convert permissions from Community 2.1

File:

• extensions/community/maintain.inc.php (modified) (1 diff)

extensions/community/maintain.inc.php

@@ -103 +103 @@
   pwg_query($query);
 }
+
+function plugin_activate()
+{
+  community_get_data_from_core21();
+  community_get_data_from_community21();
+}
+
+function community_get_data_from_core21()
+{
+  global $conf, $prefixeTable;
+  
+  $from_piwigo21_file = $conf['local_data_dir'].'/plugins/core_user_upload_to_community.php';
+  if (is_file($from_piwigo21_file))
+  {
+    include($from_piwigo21_file);
+    $user_upload_conf = unserialize($user_upload_conf);
+    
+    include_once(PHPWG_ROOT_PATH.'admin/include/functions_upload.inc.php');
+    prepare_upload_configuration();
+
+    $user_upload_conf['upload_user_access'] = 1;
+
+    if (isset($user_upload_conf['uploadable_categories']) and is_array($user_upload_conf['uploadable_categories']))
+    {
+      $type = 'any_registered_user';
+      if (isset($user_upload_conf['upload_user_access']) and 1 == $user_upload_conf['upload_user_access'])
+      {
+        $type = 'any_visitor';
+      }
+
+      $inserts = array();
+    
+      foreach ($user_upload_conf['uploadable_categories'] as $category_id)
+      {
+        array_push(
+          $inserts,
+          array(
+            'type' => $type,
+            'category_id' => $category_id,
+            'recursive' => 'false',
+            'create_subcategories' => 'false',
+            'moderated' => 'true',
+            )
+          );
+      }
+      
+      if (count($inserts) > 0)
+      {
+        mass_inserts(
+          $prefixeTable.'community_permissions',
+          array_keys($inserts[0]),
+          $inserts
+          );
+      }
+    }
+    
+    if (isset($user_upload_conf['waiting_rows']) and is_array($user_upload_conf['waiting_rows']))
+    {
+      $id_of_user = array();
+      
+      $query = '
+SELECT
+    '.$conf['user_fields']['id'].' AS id,
+    '.$conf['user_fields']['username'].' AS username
+  FROM '.USERS_TABLE.'
+;';
+      $result = pwg_query($query);
+      while ($row = pwg_db_fetch_assoc($result))
+      {
+        $id_of_user[ $row['username'] ] = $row['id'];
+      }
+      
+      $inserts = array();
+      
+      foreach ($user_upload_conf['waiting_rows'] as $pending)
+      {
+        $source_path = get_complete_dir($pending['storage_category_id']).$pending['file'];
+        
+        if (is_file($source_path))
+        {
+          $image_id = add_uploaded_file($source_path, $pending['file'], array($pending['storage_category_id']), 16);
+          
+          array_push(
+            $inserts,
+            array(
+              'image_id' => $image_id,
+              'added_on' => date ('Y-m-d H:i:s', $pending['date']),
+              'state' => 'moderation_pending',
+              )
+            );
+
+          $data = array();
+          
+          if (isset($pending['username']) and isset($id_of_user[ $pending['username'] ]))
+          {
+            $data['added_by'] = $id_of_user[ $pending['username'] ];
+          }
+          
+          foreach (array('date_creation', 'author', 'name', 'comment') as $field)
+          {
+            $value = getAttribute($pending['infos'], $field);
+            if (!empty($value))
+            {
+            $data[$field] = pwg_db_real_escape_string($value);
+            }
+          }
+          
+          if (count($data) > 0)
+          {
+            $data['id'] = $image_id;
+            
+            mass_updates(
+              IMAGES_TABLE,
+              array(
+                'primary' => array('id'),
+                'update'  => array_keys($data)
+                ),
+              array($data)
+              );
+          }
+          
+          // deletion
+          unlink($source_path);
+          if (!isset($pending['tn_ext']))
+          {
+            $pending['tn_ext'] = 'jpg';
+          }
+          @unlink(get_thumbnail_path(array('path'=>$source_path, 'tn_ext'=>$pending['tn_ext'])));
+        }
+      }
+      
+      if (count($inserts) > 0)
+      {
+        mass_inserts(
+          $prefixeTable.'community_pendings',
+          array_keys($inserts[0]),
+          $inserts
+          );
+      }
+    }
+    unlink($from_piwigo21_file);
+  }
+}
+
+function community_get_data_from_community21()
+{
+  global $prefixeTable;
+  
+  $old_community_table = $prefixeTable.'community';
+  $query = 'SHOW TABLES;';
+  $result = pwg_query($query);
+  while ($row = pwg_db_fetch_row($result))
+  {
+    if ($old_community_table == $row[0])
+    {
+      $inserts = array();
+      
+      $query = '
+SELECT
+    *
+  FROM '.$old_community_table.'
+;';
+      $result = pwg_query($query);
+      while ($row = pwg_db_fetch_assoc($result))
+      {
+        array_push(
+          $inserts,
+          array(
+            'type' => 'user',
+            'user_id' => $row['user_id'],
+            'category_id' => null,
+            'recursive' => 'true',
+            'create_subcategories' => $row['permission_level'] == 2 ? 'true' : 'false',
+            'moderated' => 'false',
+            )
+          );
+      }
+      
+      if (count($inserts) > 0)
+      {
+        mass_inserts(
+          $prefixeTable.'community_permissions',
+          array_keys($inserts[0]),
+          $inserts
+          );
+      }
+      
+      $query = 'DROP TABLE '.$old_community_table.';';
+      pwg_query($query);
+      
+      break;
+    }
+  }
+}
 ?>