From 5a1d2d14ca53d6c0241a162b22aaa9ac488e8c39 Mon Sep 17 00:00:00 2001 From: plegall Date: Sat, 19 Nov 2005 16:07:18 +0000 Subject: - 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 --- comments.php | 6 ++++-- 1 file 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']; -- cgit v1.2.3