diff options
| author | Dries Buytaert <dries@buytaert.net> | 2002-12-10 20:03:08 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2002-12-10 20:03:08 +0000 |
| commit | c3c366dcdc7fb4971eefa76b2df338cffac3a0d7 (patch) | |
| tree | cd267c4ee0e664ae14090461db5c87a1f6ac6a0d | |
| parent | 296a01f39919184846a2154609c9cf5601d979bc (diff) | |
| download | brdo-c3c366dcdc7fb4971eefa76b2df338cffac3a0d7.tar.gz brdo-c3c366dcdc7fb4971eefa76b2df338cffac3a0d7.tar.bz2 | |
- The statistics module's blocks showed unpublished nodes. Patch by Ax.
| -rw-r--r-- | modules/statistics.module | 3 | ||||
| -rw-r--r-- | modules/statistics/statistics.module | 3 |
2 files changed, 4 insertions, 2 deletions
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); } diff --git a/modules/statistics/statistics.module b/modules/statistics/statistics.module index 9db0c5f56..3b893ef86 100644 --- a/modules/statistics/statistics.module +++ b/modules/statistics/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); } |