Changeset 10213 for extensions/Comments_on_Albums/include/functions_comment.inc.php

Timestamp:

Apr 9, 2011, 6:40:27 PM (13 years ago)

Author:

mistic100

Message:

compatibility with 'rv_tscroller' & comments revalidation

File:

• extensions/Comments_on_Albums/include/functions_comment.inc.php (modified) (2 diffs)

extensions/Comments_on_Albums/include/functions_comment.inc.php

@@ -217 +217 @@
  * @param content
  */
-
 function update_user_comment_albums($comment, $post_key)
+{
+  global $conf;
+
+  $comment_action = 'validate';
+
+  if ( !verify_ephemeral_key($post_key, $comment['image_id']) )
+  {
+    $comment_action='reject';
+  }
+
+  // perform more spam check
+  $comment_action =
+    trigger_event('user_comment_check',
+                  $comment_action,
+                  array_merge($comment,
+                              array('author' => $GLOBALS['user']['username'])
+                              )
+                  );
+
+  if ( $comment_action!='reject' )
+  {
+    $user_where_clause = '';
+    if (!is_admin())
+    {
+      $user_where_clause = '   AND author_id = \''.
+        $GLOBALS['user']['id'].'\'';
+    }
+    
+    // should the updated comment must be validated
+    if (!$conf['comments_validation'] or is_admin())
+    {
+      $comment_action='validate'; //one of validate, moderate, reject
+    }
+    else
+    {
+      $comment_action='moderate'; //one of validate, moderate, reject
+    }
+
+    $query = '
+UPDATE '.COA_TABLE.'
+  SET content = \''.$comment['content'].'\',
+      validated = \''.($comment_action=='validate' ? 'true':'false').'\',
+      validation_date = '.($comment_action=='validate' ? 'NOW()':'NULL').'
+  WHERE id = '.$comment['comment_id'].
+$user_where_clause.'
+;';
+    $result = pwg_query($query);
+    
+    // mail admin and ask to validate the comment
+    if ($result and $conf['email_admin_on_comment_validation'] and 'moderate' == $comment_action) 
+    {
+      include_once(PHPWG_ROOT_PATH.'include/functions_mail.inc.php');
+
+      $comment_url = get_absolute_root_url().'comments.php?display_mode=albums&comment_id='.$comment['comment_id'];
+
+      $keyargs_content = array
+      (
+        get_l10n_args('Author: %s', stripslashes($GLOBALS['user']['username']) ),
+        get_l10n_args('Comment: %s', stripslashes($comment['content']) ),
+        get_l10n_args('', ''),
+        get_l10n_args('Manage this user comment: %s', $comment_url),
+        get_l10n_args('', ''),
+        get_l10n_args('(!) This comment requires validation', ''),
+      );
+
+      pwg_mail_notification_admins
+      (
+        get_l10n_args('Comment by %s', stripslashes($GLOBALS['user']['username']) ),
+        $keyargs_content
+      );
+    }
+    // just mail admin
+    else if ($result)
+    {
+      email_admin('edit', array('author' => $GLOBALS['user']['username'],
+                                'content' => stripslashes($comment['content'])) );
+    }
+  }
+  
+  return $comment_action;
+}
+
+/* function update_user_comment_albums($comment, $post_key)
 {
   global $conf;
@@ -259 +341 @@
     }
   }
-}
+}*/
 
 if (!function_exists('email_admin')) {