From e461e529ac5f6eb1ab3ca748493a019e01ebfc45 Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Mon, 31 Oct 2005 18:12:51 +0000
Subject: [PATCH] fix entry count, thanks to chris from the forums

---
 docs/NEWS                       | 3 +++
 include/plugin_internal.inc.php | 2 +-
 2 files changed, 4 insertions(+), 1 deletion(-)

diff --git a/docs/NEWS b/docs/NEWS
index 3cff25e..1c112f7 100644
--- a/docs/NEWS
+++ b/docs/NEWS
@@ -6,6 +6,9 @@ Version 1.0 ()
 Version 0.9.1 ()
 ------------------------------------------------------------------------
 
+    * Fix incorrect entry count in categories sidebar plugin (was also
+      counting drafts)
+
     * Set the correct reply-to name when sending comment mails, thanks
       to RobA from the forums (garvinhicking)
 
diff --git a/include/plugin_internal.inc.php b/include/plugin_internal.inc.php
index c81f719..34f10cb 100644
--- a/include/plugin_internal.inc.php
+++ b/include/plugin_internal.inc.php
@@ -1313,7 +1313,7 @@ class serendipity_categories_plugin extends serendipity_plugin {
                                             FROM {$serendipity['dbPrefix']}entrycat ec,
                                                  {$serendipity['dbPrefix']}category c,
                                                  {$serendipity['dbPrefix']}entries e
-                                            WHERE ec.categoryid = c.categoryid AND ec.entryid = e.id
+                                            WHERE ec.categoryid = c.categoryid AND ec.entryid = e.id AND e.isdraft = 'false'
                                             GROUP BY c.categoryid, c.category_name
                                             ORDER BY postings DESC";
             $category_rows  = serendipity_db_query($cat_sql);
-- 
2.39.5