diff options
| author | plegall <plg@piwigo.org> | 2005-11-19 16:07:18 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2005-11-19 16:07:18 +0000 |
| commit | 5a1d2d14ca53d6c0241a162b22aaa9ac488e8c39 (patch) | |
| tree | 3450b7bb210b0d3e6904d926c80c03e44c965f1c | |
| parent | a8836718e5a5c39fb7fc057f24eaf86229ec39c2 (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
| -rw-r--r-- | comments.php | 6 |
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']; |