feature 1028 : Allow admin to validate comment from picture page

git-svn-id: http://piwigo.org/svn/trunk@3409 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 21 insertions, 3 deletions

diff --git a/include/picture_comment.inc.php b/include/picture_comment.inc.php
index 2682d9dab..9a120e355 100644
--- a/include/picture_comment.inc.php
+++ b/include/picture_comment.inc.php
@@ -118,11 +118,20 @@ SELECT COUNT(*) AS nb_comments
 
   if ($row['nb_comments'] > 0)
   {
+    if ( !is_admin() )
+    {
+      $validated_clause = '  AND validated = \'true\'';
+    } 
+    else 
+    {
+      $validated_clause = '';
+    }
+
     $query = '
-SELECT id,author,date,image_id,content
+SELECT id,author,date,image_id,content,validated
   FROM '.COMMENTS_TABLE.'
-  WHERE image_id = '.$page['image_id'].'
-    AND validated = \'true\'
+  WHERE image_id = '.$page['image_id'].
+$validated_clause.'
   ORDER BY date ASC
   LIMIT '.$page['start'].', '.$conf['nb_comment_page'].'
 ;';
@@ -152,6 +161,15 @@ SELECT id,author,date,image_id,content
                     'comment_to_delete'=>$row['id']
                   )
               );
+	if ($row['validated'] != 'true')
+	{
+	  $tpl_comment['U_VALIDATE'] = 
+	    add_url_params($url_self,
+			   array('action' => 'validate_comment',
+				 'comment_to_validate' => $row['id']
+				 )
+			   );
+	}
       }
       $template->append('comments', $tpl_comment);
     }