From 0e80aac51b8232ea48405754107fb1c5399322c1 Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Sun, 24 Feb 2008 11:06:32 +0000
Subject: [PATCH] fix author counting without drafted articles

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

diff --git a/docs/NEWS b/docs/NEWS
index 22f2d8e..96ef33f 100644
--- a/docs/NEWS
+++ b/docs/NEWS
@@ -3,6 +3,9 @@
 Version 1.3 ()
 ------------------------------------------------------------------------
 
+    * Fix sidebar plugin for the author's list to not include counting
+      drafted articles (garvinhicking)
+
     * Add option "template" to smarty function call {serendipity_
       printSidebar} (garvinhicking)
 
diff --git a/include/functions.inc.php b/include/functions.inc.php
index 4571b40..1aac3b9 100644
--- a/include/functions.inc.php
+++ b/include/functions.inc.php
@@ -370,7 +370,7 @@ function serendipity_fetchUsers($user = '', $group = null, $is_count = false) {
     if ($is_count) {
         $query_select = ", count(e.authorid) as artcount";
         $query_join   = "LEFT OUTER JOIN {$serendipity['dbPrefix']}entries AS e
-                                      ON a.authorid = e.authorid";
+                                      ON (a.authorid = e.authorid AND e.isdraft = 'false')";
     }
 
     if ($is_count || $group != null) {
-- 
2.39.5