aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-08-21 13:10:25 +0000
committerz0rglub <z0rglub@piwigo.org>2004-08-21 13:10:25 +0000
commit46938a8f256ae5d441e6b736604e37e8ca265ce1 (patch)
tree8916f20f08b7b7f574d2a8a5c3acd887cb1510f4
parentdf07f5c59aeebc25c24de07177c101b5e8ed13ea (diff)
add in comment another possibility for counting user total number of
viewable elements (counting only once pictures linked to several categories) git-svn-id: http://piwigo.org/svn/trunk@490 68402e56-0260-453c-a942-63ccdbb3a9ee
-rw-r--r--include/functions_category.inc.php13
1 files changed, 12 insertions, 1 deletions
diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php
index 47db0e75f..8ff06ede7 100644
--- a/include/functions_category.inc.php
+++ b/include/functions_category.inc.php
@@ -256,7 +256,18 @@ function count_user_total_images()
if ( count( $user['restrictions'] ) > 0 )
$query.= ' WHERE id NOT IN ('.$user['forbidden_categories'].')';
$query.= ';';
-
+
+// $query = '
+// SELECT COUNT(DISTINCT(image_id)) as total
+// FROM '.PREFIX_TABLE.'image_category';
+// if (count($user['restrictions']) > 0)
+// {
+// $query.= '
+// WHERE category_id NOT IN ('.$user['forbidden_categories'].')';
+// }
+// $query = '
+// ;';
+
$row = mysql_fetch_array( mysql_query( $query ) );
if ( !isset( $row['total'] ) ) $row['total'] = 0;