Changeset 3409

Timestamp:

Jun 10, 2009, 10:11:28 PM (15 years ago)

Author:

nikrou

Message:

feature 1028 : Allow admin to validate comment from picture page

Location:

trunk

Files:

• include/picture_comment.inc.php (modified) (2 diffs)
• picture.php (modified) (1 diff)

trunk/include/picture_comment.inc.php

@@ -119 +119 @@
   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'].'
@@ -153 +162 @@
                   )
               );
+        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);

trunk/picture.php

@@ -323 +323 @@
       redirect($url_self);
     }
+    case 'validate_comment' :
+    {
+      if (isset($_GET['comment_to_validate'])
+          and is_numeric($_GET['comment_to_validate'])
+          and is_admin() and !is_adviser() )
+      {
+        $query = '
+UPDATE '.COMMENTS_TABLE.'
+  SET validated = \'true\'
+  , validation_date = NOW()
+  WHERE id='.$_GET['comment_to_validate'].'
+;';
+        pwg_query( $query );
+      }
+      redirect($url_self);
+    }
+
   }
 }