From ad1c1c1f5d2470a1475c86b006c746ff1449be76 Mon Sep 17 00:00:00 2001 From: nikrou Date: Thu, 5 Nov 2009 09:52:20 +0000 Subject: Bug 1220 : partial revert of r4140 commit. No author id in branch 2.0 git-svn-id: http://piwigo.org/svn/branches/2.0@4191 68402e56-0260-453c-a942-63ccdbb3a9ee --- comments.php | 4 ---- 1 file changed, 4 deletions(-) (limited to 'comments.php') diff --git a/comments.php b/comments.php index 48cb77a46..1f0221c08 100644 --- a/comments.php +++ b/comments.php @@ -261,8 +261,6 @@ SELECT COUNT(DISTINCT(com.id)) FROM '.IMAGE_CATEGORY_TABLE.' AS ic 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 WHERE '.implode(' AND ', $page['where_clauses']).' ;'; @@ -299,8 +297,6 @@ 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 - LEFT JOIN '.USERS_TABLE.' As u - ON u.'.$conf['user_fields']['id'].' = com.author_id WHERE '.implode(' AND ', $page['where_clauses']).' GROUP BY comment_id -- cgit v1.2.3