diff options
| author | nikrou <nikrou@piwigo.org> | 2009-11-05 09:52:20 +0000 |
|---|---|---|
| committer | nikrou <nikrou@piwigo.org> | 2009-11-05 09:52:20 +0000 |
| commit | ad1c1c1f5d2470a1475c86b006c746ff1449be76 (patch) | |
| tree | 8fbe2e37dab0cd45f98c9673a70f887f86fd0932 | |
| parent | c68aa12c5a93cecacc97d28c7a0f8405eed1f461 (diff) | |
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
| -rw-r--r-- | comments.php | 4 |
1 files changed, 0 insertions, 4 deletions
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 |