From 501fb86f7e62af30a99134388535dfa0db4a8c50 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 9 Oct 2002 20:20:49 +0000 Subject: - Made sure the tracker module does not list discarded comments. Patch by Moshe. --- modules/tracker.module | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'modules/tracker.module') diff --git a/modules/tracker.module b/modules/tracker.module index 576e5f6e5..32a8a0885 100644 --- a/modules/tracker.module +++ b/modules/tracker.module @@ -30,10 +30,10 @@ function tracker_comments($id = 0) { $period = time() - variable_get("tracker_period", 259200); // all comments of the past 3 days if not configured to a different value if ($id) { - $sresult = db_query("SELECT n.nid, n.title, COUNT(n.nid) AS comments, MAX(c.timestamp) AS last_comment FROM comments c LEFT JOIN node n ON c.nid = n.nid WHERE c.timestamp > $period AND c.uid = '%s' GROUP BY n.nid, n.title ORDER BY last_comment DESC LIMIT 10", $id); + $sresult = db_query("SELECT n.nid, n.title, COUNT(n.nid) AS comments, MAX(c.timestamp) AS last_comment FROM comments c LEFT JOIN node n ON c.nid = n.nid WHERE c.status = 0 AND c.timestamp > $period AND c.uid = '%s' GROUP BY n.nid, n.title ORDER BY last_comment DESC LIMIT 10", $id); } else { - $sresult = db_query("SELECT n.nid, n.title, COUNT(n.nid) AS comments, MAX(c.timestamp) AS last_comment FROM comments c LEFT JOIN node n ON c.nid = n.nid WHERE c.timestamp > $period GROUP BY n.nid, n.title ORDER BY last_comment DESC LIMIT 10"); + $sresult = db_query("SELECT n.nid, n.title, COUNT(n.nid) AS comments, MAX(c.timestamp) AS last_comment FROM comments c LEFT JOIN node n ON c.nid = n.nid WHERE c.status = 0 AND c.timestamp > $period GROUP BY n.nid, n.title ORDER BY last_comment DESC LIMIT 10"); } while ($node = db_fetch_object($sresult)) { -- cgit v1.2.3