aboutsummaryrefslogtreecommitdiffstats
path: root/comments.php
diff options
context:
space:
mode:
Diffstat (limited to 'comments.php')
-rw-r--r--comments.php11
1 files changed, 10 insertions, 1 deletions
diff --git a/comments.php b/comments.php
index 2aaeb1fbf..cda791ca6 100644
--- a/comments.php
+++ b/comments.php
@@ -367,7 +367,7 @@ SELECT com.id AS comment_id,
com.content,
com.validated
FROM '.IMAGE_CATEGORY_TABLE.' AS ic
- LEFT JOIN '.COMMENTS_TABLE.' AS com
+ INNER JOIN '.COMMENTS_TABLE.' AS com
ON ic.image_id = com.image_id
LEFT JOIN '.USERS_TABLE.' As u
ON u.'.$conf['user_fields']['id'].' = com.author_id
@@ -418,6 +418,15 @@ SELECT c.id, name, permalink, uppercats, com.id as comment_id
ON c.id=ic.category_id
LEFT JOIN '.COMMENTS_TABLE.' AS com
ON ic.image_id=com.image_id
+ '.get_sql_condition_FandF
+ (
+ array
+ (
+ 'forbidden_categories' => 'c.id',
+ 'visible_categories' => 'c.id'
+ ),
+ 'WHERE'
+ ).'
;';
$categories = hash_from_query($query, 'comment_id');