Changeset 1509 in ExiteCMS for branches/PLi-Fusion/blogs.php

Timestamp:

07/02/08 18:27:06 (4 years ago)

Author:

hverton

Message:

Merged trunk revisions 1408:1508 into the PLi-Fusion branch

File:

• branches/PLi-Fusion/blogs.php (modified) (2 diffs)

branches/PLi-Fusion/blogs.php

@@ -222 +222 @@
             $bloglimit = time() - $settings['blogs_indexage'] * 86400;
             // select all authors
-            $result = dbquery("SELECT DISTINCT b.blog_author, u.user_name, count(*) AS count FROM ".$db_prefix."blogs b, ".$db_prefix."users u WHERE b.blog_author = u.user_id AND (blog_datestamp > '".$bloglimit."' OR blog_edittime > '".$bloglimit."') GROUP BY blog_author ORDER BY count DESC, user_name ASC");
+            $result = dbquery("SELECT DISTINCT b.blog_author, u.user_name, count(*) AS count FROM ".$db_prefix."blogs b, ".$db_prefix."users u WHERE b.blog_author = u.user_id GROUP BY blog_author ORDER BY count DESC, user_name ASC");
         }
         $variables['list'] = array();
@@ -234 +234 @@
             $variables['list'][] = $data;
         }
-
         break;      
 }