Changeset 12597 for branches/2.3/include/functions_comment.inc.php

Timestamp:

Nov 11, 2011, 11:21:58 AM (12 years ago)

Author:

mistic100

Message:

merge r12596 from trunk: feature 2500: make 'validate_user_comment' and 'delete_user_comment' working with array

File:

• branches/2.3/include/functions_comment.inc.php (modified) (3 diffs)

branches/2.3/include/functions_comment.inc.php

@@ -203 +203 @@
  * so to avoid a new sql request we add author in where clause
  *
- * @param comment_id
+ * @param int or array of int comment_id
  */
-function delete_user_comment($comment_id) {
+function delete_user_comment($comment_id)
+{
   $user_where_clause = '';
   if (!is_admin())
@@ -211 +212 @@
     $user_where_clause = '   AND author_id = \''.$GLOBALS['user']['id'].'\'';
   }
+  
+  if (is_array($comment_id))
+    $where_clause = 'id IN('.implode(',', $comment_id).')';
+  else
+    $where_clause = 'id = '.$comment_id;
+    
   $query = '
 DELETE FROM '.COMMENTS_TABLE.'
-  WHERE id = '.$comment_id.
+  WHERE '.$where_clause.
 $user_where_clause.'
 ;';
   $result = pwg_query($query);
-  if ($result) {
+  
+  if ($result) 
+  {
     email_admin('delete', 
                 array('author' => $GLOBALS['user']['username'],
@@ -378 +387 @@
 }
 
+/**
+ * Tries to validate a user comment in the database
+ * @param int or array of int comment_id
+ */
 function validate_user_comment($comment_id)
 {
+  if (is_array($comment_id))
+    $where_clause = 'id IN('.implode(',', $comment_id).')';
+  else
+    $where_clause = 'id = '.$comment_id;
+    
   $query = '
 UPDATE '.COMMENTS_TABLE.'
   SET validated = \'true\'
     , validation_date = NOW()
-  WHERE id = '.$comment_id.'
+  WHERE '.$where_clause.'
 ;';
   pwg_query($query);