Changeset 29430 for trunk/search.php

Timestamp:

Sep 8, 2014, 11:46:50 AM (10 years ago)

Author:

plg

Message:

bug 3136: in author search listbox, do no count photos twice if they are associated to 2 albums

File:

• trunk/search.php (modified) (2 diffs)

trunk/search.php

@@ -215 +215 @@
 SELECT
     author,
-    COUNT(*) AS counter
+    id
   FROM '.IMAGES_TABLE.' AS i
     JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON ic.image_id = i.id
@@ -227 +227 @@
     ).'
     AND author IS NOT NULL
-  GROUP BY author
+  GROUP BY author, id
   ORDER BY author
 ;';
-$authors = query2array($query);
+$author_counts = array();
+$result = pwg_query($query);
+while ($row = pwg_db_fetch_assoc($result))
+{
+  if (!isset($author_counts[ $row['author'] ]))
+  {
+    $author_counts[ $row['author'] ] = 0;
+  }
+  
+  $author_counts[ $row['author'] ]++;
+}
+
+foreach ($author_counts as $author => $counter)
+{
+  $authors[] = array(
+    'author' => $author,
+    'counter' => $counter,
+    );
+}
 
 $template->assign('AUTHORS', $authors);