Changeset 575

Timestamp:

12/07/2003 09:25:05 AM (21 years ago)

Author:

saxmatt

Message:

list_cats to use new category link function.

File:

• trunk/b2-include/b2template.functions.php (modified) (3 diffs)

trunk/b2-include/b2template.functions.php

@@ -1349 +1349 @@
 function list_cats($optionall = 1, $all = 'All', $sort_column = 'ID', $sort_order = 'asc',
                    $file = 'blah', $list = true, $optiondates = 0, $optioncount = 0, $hide_empty = 1) {
-    global $tablecategories, $tableposts, $wpdb;
+    global $tablecategories, $tableposts, $tablepost2cat, $wpdb;
     global $pagenow, $siteurl, $blogfilename;
     global $querystring_start, $querystring_equal, $querystring_separator;
@@ -1357 +1357 @@
     $sort_column = 'cat_'.$sort_column;
 
-    $query  = " SELECT cat_ID, cat_name,";
-    $query .= "  COUNT($tableposts.ID) AS cat_count,";
-    $query .= "  DAYOFMONTH(MAX(post_date)) AS lastday, MONTH(MAX(post_date)) AS lastmonth";
-    $query .= " FROM $tablecategories LEFT JOIN $tableposts ON cat_ID = post_category";
-    $query .= " WHERE cat_ID > 0 ";
-    $query .= " GROUP BY post_category ";
+    $query  = "
+        SELECT cat_ID, cat_name,
+        COUNT($tablepost2cat.post_id) AS cat_count,
+        DAYOFMONTH(MAX(post_date)) AS lastday, MONTH(MAX(post_date)) AS lastmonth
+        FROM $tablecategories LEFT JOIN $tablepost2cat ON (cat_ID = category_id)
+        LEFT JOIN $tableposts ON (ID = post_id)
+        WHERE cat_ID > 0 
+        GROUP BY category_id
+        ";
     if (intval($hide_empty) == 1) {
         $query .= " HAVING cat_count > 0";
@@ -1386 +1389 @@
     foreach ($categories as $category) {
         $cat_name = apply_filters('list_cats', $category->cat_name);
-        $link = '<a href="'.$file.$querystring_start.'cat'.$querystring_equal.$category->cat_ID.'">';
+        $link = '<a href="'.get_category_link(0, $category->cat_ID).'" title="View all posts filed under ' . $category->cat_name . '">';
         $link .= stripslashes($cat_name).'</a>';
         if (intval($optioncount) == 1) {