Changeset 12601 for extensions/Comments_on_Albums

Timestamp:

Nov 11, 2011, 2:57:12 PM (12 years ago)

Author:

mistic100

Message:

some more modifications for Subscribe_to_comments

Location:

extensions/Comments_on_Albums/include

Files:

• coa_admin_comments.php (modified) (2 diffs)
• coa_albums.php (modified) (3 diffs)
• functions_comment.inc.php (modified) (2 diffs)

extensions/Comments_on_Albums/include/coa_admin_comments.php

@@ -46 +46 @@
     else
     {
+      include_once(COA_PATH.'include/functions_comment.inc.php');
       check_input_parameter('comments', $_POST, true, PATTERN_ID);
 
       if (isset($_POST['validate_albums'])) 
       {
-        $query = '
-UPDATE '.COA_TABLE.' 
-  SET validated = \'true\',
-      validation_date = NOW()
-  WHERE id IN ('.implode(',', $_POST['comments']).')
-;';
-        pwg_query($query);
+        validate_user_comment_albums($_POST['comments']);
 
         array_push(
@@ -69 +64 @@
       if (isset($_POST['reject_albums'])) 
       {
-        $query = '
-DELETE 
-  FROM '.COA_TABLE.'
-  WHERE id IN ('.implode(',', $_POST['comments']).')
-;';
-        pwg_query($query);
+        delete_user_comment_albums($_POST['comments']);
 
         array_push(

extensions/Comments_on_Albums/include/coa_albums.php

@@ -361 +361 @@
   {
     $replacement = '
-{if isset($errors)}
+{if !empty($errors)}
 <div class="errors">
   <ul>
@@ -370 +370 @@
 </div>
 {/if}
-{if isset($infos)}
+{if !empty($infos)}
 <div class="infos">
   <ul>
@@ -380 +380 @@
 {/if}';
 
-    return $replacement.$content;
+    return str_replace('{$MENUBAR}', $replacement.'{$MENUBAR}', $content);
   }
 }

extensions/Comments_on_Albums/include/functions_comment.inc.php

@@ -195 +195 @@
     $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 '.COA_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'],
@@ -366 +374 @@
 }
 
+/**
+ * Tries to validate a user comment in the database
+ * @param int or array of int comment_id
+ */
 function validate_user_comment_albums($comment_id)
 {
+  if (is_array($comment_id))
+    $where_clause = 'id IN('.implode(',', $comment_id).')';
+  else
+    $where_clause = 'id = '.$comment_id;
+    
   $query = '
 UPDATE '.COA_TABLE.'
   SET validated = \'true\'
     , validation_date = NOW()
-  WHERE id = '.$comment_id.'
+  WHERE '.$where_clause.'
 ;';
   pwg_query($query);