Changeset 721

Timestamp:

Jan 23, 2005, 4:27:20 PM (19 years ago)

Author:

plg

Message:

• bug fixed : same comments displayed as many times as element categories

File:

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

trunk/comments.php

@@ -112 +112 @@
 
 $query = '
-SELECT DISTINCT(ic.image_id) AS image_id,(ic.category_id) AS category_id
+SELECT DISTINCT(ic.image_id) AS image_id,ic.category_id, uppercats
   FROM '.COMMENTS_TABLE.' AS c, '.IMAGE_CATEGORY_TABLE.' AS ic
+    , '.CATEGORIES_TABLE.' AS cat
   WHERE c.image_id = ic.image_id
+    AND ic.category_id = cat.id
     AND date >= \''.$maxdate.'\'';
 if ($user['status'] != 'admin')
@@ -128 +130 @@
 }
 $query.= '
+  GROUP BY ic.image_id
   ORDER BY ic.image_id DESC
 ;';
@@ -149 +152 @@
   $subrow = mysql_fetch_array($subresult);
 
-  if (!isset($array_cat_names[$subrow['cat_id']]))
-  {
-    $cat_result = get_cat_info($subrow['cat_id']);
-    $array_cat_names[$subrow['cat_id']] =
-      get_cat_display_name($cat_result['name'], '');
-  }
-  
   // name of the picture
-  $name = $array_cat_names[$category_id].' > ';
+  $name = get_cat_display_name_cache($row['uppercats'], '', false);
+  $name.= $conf['level_separator'];
   if (!empty($subrow['name']))
   {
@@ -166 +163 @@
     $name.= str_replace('_',' ',get_filename_wo_extension($subrow['file']));
   }
-  $name.= ' [ '.$subrow['file'].' ]';
+
   // source of the thumbnail picture
   $thumbnail_src = get_thumbnail_src($subrow['path'], @$subrow['tn_ext']);