aboutsummaryrefslogtreecommitdiffstats
path: root/comments.php
diff options
context:
space:
mode:
authorplegall <plg@piwigo.org>2005-11-19 16:07:18 +0000
committerplegall <plg@piwigo.org>2005-11-19 16:07:18 +0000
commit5a1d2d14ca53d6c0241a162b22aaa9ac488e8c39 (patch)
tree3450b7bb210b0d3e6904d926c80c03e44c965f1c /comments.php
parenta8836718e5a5c39fb7fc057f24eaf86229ec39c2 (diff)
- bug 215 fixed: unvalidated user comments are not displayed on user
comments common page anymore git-svn-id: http://piwigo.org/svn/branches/branch-1_5@946 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'comments.php')
-rw-r--r--comments.php6
1 files changed, 4 insertions, 2 deletions
diff --git a/comments.php b/comments.php
index 2a980416d..c78d5f2ad 100644
--- a/comments.php
+++ b/comments.php
@@ -287,7 +287,8 @@ SELECT COUNT(DISTINCT(id))
FROM '.IMAGE_CATEGORY_TABLE.' AS ic
INNER JOIN '.COMMENTS_TABLE.' AS com
ON ic.image_id = com.image_id
- WHERE '.$since_options[$page['since']]['clause'].'
+ WHERE validated = \'true\'
+ AND '.$since_options[$page['since']]['clause'].'
AND '.$page['cat_clause'].'
AND '.$page['author_clause'].'
AND '.$page['keyword_clause'];
@@ -329,7 +330,8 @@ SELECT com.id AS comment_id
FROM '.IMAGE_CATEGORY_TABLE.' AS ic
INNER JOIN '.COMMENTS_TABLE.' AS com
ON ic.image_id = com.image_id
- WHERE '.$since_options[$page['since']]['clause'].'
+ WHERE validated = \'true\'
+ AND '.$since_options[$page['since']]['clause'].'
AND '.$page['cat_clause'].'
AND '.$page['author_clause'].'
AND '.$page['keyword_clause'];