Changeset 5199

Timestamp:

03/20/10 07:11:21 (3 years ago)

Author:

rvelices

Message:

fix bug (a comment could be displayed several times in the comments liat)

Files:

• trunk/comments.php (modified) (13 diffs)

trunk/comments.php

@@ -185 +185 @@
   if (isset($_GET[$loop_action]))
   {
-    $action = $loop_action;    
+    $action = $loop_action;
     check_input_parameter($action, $_GET, false, PATTERN_ID);
     $comment_id = $_GET[$action];
@@ -197 +197 @@
 
   $comment_author_id = get_comment_author_id($comment_id);
-    
+
   if (can_manage_comment($action, $comment_author_id))
   {
     $perform_redirect = false;
-  
+
     if ('delete' == $action)
     {
@@ -213 +213 @@
       $perform_redirect = true;
     }
-    
+
     if ('edit' == $action)
     {
@@ -226 +226 @@
           $_POST['key']
           );
-        
+
         $edit_comment = null;
       }
@@ -234 +234 @@
       }
     }
-    
+
     if ($perform_redirect)
     {
@@ -241 +241 @@
         .'comments.php'
         .get_query_string_diff(array('delete','validate','pwg_token'));
-      
+
       redirect($redirect_url);
     }
@@ -330 +330 @@
 SELECT COUNT(DISTINCT(com.id))
   FROM '.IMAGE_CATEGORY_TABLE.' AS ic
-    INNER JOIN '.COMMENTS_TABLE.' AS com    
+    INNER JOIN '.COMMENTS_TABLE.' AS com
     ON ic.image_id = com.image_id
     LEFT JOIN '.USERS_TABLE.' As u
@@ -375 +375 @@
   WHERE '.implode('
     AND ', $page['where_clauses']).'
-  GROUP BY comment_id, com.image_id, ic.category_id, com.author, 
-           com.author_id, com.date, com.content, com.validated
+  GROUP BY comment_id
   ORDER BY '.$page['sort_by'].' '.$page['sort_order'];
 if ('all' != $page['items_number'])
@@ -438 +437 @@
         )
       );
-    
+
     $tpl_comment = array(
       'U_PICTURE' => $url,
@@ -454 +453 @@
         .'comments.php'
         .get_query_string_diff(array('delete','validate','edit', 'pwg_token'));
-      
+
       $tpl_comment['U_DELETE'] = add_url_params(
         $url,
@@ -463 +462 @@
         );
     }
-    
+
     if (can_manage_comment('edit', $comment['author_id']))
     {
@@ -470 +469 @@
         .'comments.php'
         .get_query_string_diff(array('edit', 'delete','validate', 'pwg_token'));
-      
+
       $tpl_comment['U_EDIT'] = add_url_params(
         $url,
@@ -478 +477 @@
           )
         );
-      
+
       if (isset($edit_comment) and ($comment['comment_id'] == $edit_comment))
       {