From c3c366dcdc7fb4971eefa76b2df338cffac3a0d7 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 10 Dec 2002 20:03:08 +0000
Subject: - The statistics module's blocks showed unpublished nodes.  Patch by
 Ax.

---
 modules/statistics.module | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'modules/statistics.module')

diff --git a/modules/statistics.module b/modules/statistics.module
index 9db0c5f56..3b893ef86 100644
--- a/modules/statistics.module
+++ b/modules/statistics.module
@@ -1,4 +1,5 @@
 <?php
+// $Id$
 
 // Initialization hook, runs each time statistic module is loaded
 function statistics_init() {
@@ -791,7 +792,7 @@ function statistics_display_online_block() {
 /* Display linked title based on field name */
 function statistics_title_list($dbfield, $dbrows) {
   /* valid dbfields: totalcount, daycount, timestamp */
-  return db_query("SELECT statistics.nid, node.title, u.uid, u.name FROM statistics LEFT JOIN node ON statistics.nid = node.nid LEFT JOIN users u ON node.uid = u.uid WHERE %s <> '0' ORDER BY %s DESC LIMIT %s", "statistics.". $dbfield, "statistics.". $dbfield, $dbrows);
+  return db_query("SELECT statistics.nid, node.title, u.uid, u.name FROM statistics LEFT JOIN node ON statistics.nid = node.nid LEFT JOIN users u ON node.uid = u.uid WHERE %s <> '0' AND node.status = 1 ORDER BY %s DESC LIMIT %s", "statistics.". $dbfield, "statistics.". $dbfield, $dbrows);
 }
 
 
-- 
cgit v1.2.3