[php-blog-cvs] serendipity/plugins/serendipity_event_statistics serendipity_event_statistics.php,1.11,1.11.2.1

[Garvin H. <gar...@us...>]

Update of /cvsroot/php-blog/serendipity/plugins/serendipity_event_statistics
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22231/plugins/serendipity_event_statistics

Modified Files:
      Tag: branch-smarty
	serendipity_event_statistics.php 
Log Message:
MFH


Index: serendipity_event_statistics.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/plugins/serendipity_event_statistics/serendipity_event_statistics.php,v
retrieving revision 1.11
retrieving revision 1.11.2.1
diff -u -d -r1.11 -r1.11.2.1
--- serendipity_event_statistics.php	29 Jun 2004 07:58:59 -0000	1.11
+++ serendipity_event_statistics.php	13 Oct 2004 09:40:17 -0000	1.11.2.1
@@ -179,7 +179,7 @@
                                                          {$serendipity['dbPrefix']}category c,
                                                          {$serendipity['dbPrefix']}entries e
                                                     WHERE ec.categoryid = c.categoryid AND ec.entryid = e.id
-                                                    GROUP BY ec.categoryid
+                                                    GROUP BY ec.categoryid, c.category_name
                                                     ORDER BY postings DESC";
                     $category_rows  = serendipity_db_query($cat_sql);
 
@@ -191,7 +191,7 @@
                                                     FROM {$serendipity['dbPrefix']}comments c,
                                                          {$serendipity['dbPrefix']}entries e
                                                     WHERE e.id = c.entry_id AND type = 'NORMAL' AND subscribed = 'true'
-                                                    GROUP BY e.id, c.email
+                                                    GROUP BY e.id, c.email, e.title
                                                     ORDER BY postings DESC
                                                     LIMIT $max_items");
 
@@ -200,14 +200,14 @@
                                                     FROM {$serendipity['dbPrefix']}comments c,
                                                          {$serendipity['dbPrefix']}entries e
                                                     WHERE e.id = c.entry_id AND type = 'NORMAL'
-                                                    GROUP BY e.id
+                                                    GROUP BY e.id, e.title
                                                     ORDER BY postings DESC
                                                     LIMIT $max_items");
 
                     $commentor_rows = serendipity_db_query("SELECT author, email, url, count(id) as postings
                                                     FROM {$serendipity['dbPrefix']}comments c
                                                     WHERE type = 'NORMAL'
-                                                    GROUP BY author
+                                                    GROUP BY author, email, url
                                                     ORDER BY postings DESC
                                                     LIMIT $max_items");
 
@@ -216,14 +216,14 @@
                                                     FROM {$serendipity['dbPrefix']}comments c,
                                                          {$serendipity['dbPrefix']}entries e
                                                     WHERE e.id = c.entry_id AND type = 'TRACKBACK'
-                                                    GROUP BY e.id
+                                                    GROUP BY e.id, e.title
                                                     ORDER BY postings DESC
                                                     LIMIT $max_items");
 
                     $tbr_rows = serendipity_db_query("SELECT author, email, url, count(id) as postings
                                                     FROM {$serendipity['dbPrefix']}comments c
                                                     WHERE type = 'TRACKBACK'
-                                                    GROUP BY author
+                                                    GROUP BY author, email, url
                                                     ORDER BY postings DESC
                                                     LIMIT $max_items");