Changeset 23037 for extensions/community/include/functions_community.inc.php

Timestamp:

Jun 4, 2013, 12:55:59 PM (11 years ago)

Author:

plg

Message:

manage quota (number of photos, disk usage)

File:

• extensions/community/include/functions_community.inc.php (modified) (5 diffs)

extensions/community/include/functions_community.inc.php

@@ -52 +52 @@
     'upload_categories' => array(),
     'permission_ids' => array(),
+    'nb_photos' => 0,
+    'storage' => 0,
     );
   
@@ -68 +70 @@
     category_id,
     recursive,
-    create_subcategories
+    create_subcategories,
+    nb_photos,
+    storage
   FROM '.COMMUNITY_PERMISSIONS_TABLE.'
   WHERE (type = \'any_visitor\')';
@@ -120 +124 @@
       }
     }
+
+    if ($return['nb_photos'] != -1)
+    {
+      if (empty($row['nb_photos']) or -1 == $row['nb_photos'])
+      {
+        // that means "no limit"
+        $return['nb_photos'] = -1;
+      }
+      elseif ($row['nb_photos'] > $return['nb_photos'])
+      {
+        $return['nb_photos'] = $row['nb_photos'];
+      }
+    }
+    
+    if ($return['storage'] != -1)
+    {
+      if (empty($row['storage']) or -1 == $row['storage'])
+      {
+        // that means "no limit"
+        $return['storage'] = -1;
+      }
+      elseif ($row['storage'] > $return['storage'])
+      {
+        $return['storage'] = $row['storage'];
+      }
+    }
   }
 
@@ -126 +156 @@
     $return ['upload_whole_gallery'] = true;
     $return ['create_whole_gallery'] = true;
+    $return['nb_photos'] = -1;
+    $return['storage'] = -1;
   }
 
@@ -270 +302 @@
   }
 }
+
+function community_get_user_limits($user_id)
+{
+  // how many photos and storage for this user?
+  $query = '
+SELECT
+    COUNT(id) AS nb_photos,
+    IFNULL(FLOOR(SUM(filesize)/1024), 0) AS storage
+  FROM '.IMAGES_TABLE.'
+  WHERE added_by = '.$user_id.'
+;';
+  return pwg_db_fetch_assoc(pwg_query($query));
+}
 ?>