summaryrefslogtreecommitdiff
path: root/modules/tracker/tracker.module
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2003-02-09 14:38:20 +0000
committerDries Buytaert <dries@buytaert.net>2003-02-09 14:38:20 +0000
commit6953d95b2d121c86e76379ceeb9ad1af428c64e0 (patch)
treeb15fe4aaeb864f1b9ecc6d8671db721f9c71ebb0 /modules/tracker/tracker.module
parentc97e7fe1805d2ac0f2f3aedc89611a237f0edfdc (diff)
downloadbrdo-6953d95b2d121c86e76379ceeb9ad1af428c64e0.tar.gz
brdo-6953d95b2d121c86e76379ceeb9ad1af428c64e0.tar.bz2
- Fixed bug #1133: disabled comments are no longer shown. Thanks Gerhard.
Diffstat (limited to 'modules/tracker/tracker.module')
-rw-r--r--modules/tracker/tracker.module4
1 files changed, 2 insertions, 2 deletions
diff --git a/modules/tracker/tracker.module b/modules/tracker/tracker.module
index e93acb098..74222598a 100644
--- a/modules/tracker/tracker.module
+++ b/modules/tracker/tracker.module
@@ -40,10 +40,10 @@ function tracker_comments($id = 0) {
$output .= format_plural($node->comments, "1 comment", "%count comments") ." ". t("attached to node") ." ". l($node->title, "node/view/$node->nid") .":\n";
if ($id) {
- $cresult = db_query("SELECT c.*, u.name FROM comments c LEFT JOIN users u ON c.uid = u.uid WHERE c.timestamp > $period AND c.uid = '%d' AND c.nid = '%d' ORDER BY cid DESC", $id, $node->nid);
+ $cresult = db_query("SELECT c.*, u.name FROM comments c LEFT JOIN users u ON c.uid = u.uid WHERE c.timestamp > %d AND c.uid = '%d' AND c.nid = '%d' AND c.status = 0 ORDER BY cid DESC", $period, $id, $node->nid);
}
else {
- $cresult = db_query("SELECT c.*, u.name FROM comments c LEFT JOIN users u ON c.uid = u.uid WHERE c.timestamp > $period AND c.nid = '%d' ORDER BY cid DESC", $node->nid);
+ $cresult = db_query("SELECT c.*, u.name FROM comments c LEFT JOIN users u ON c.uid = u.uid WHERE c.timestamp > %d AND c.nid = '%d'AND c.status = 0 ORDER BY cid DESC", $period, $node->nid);
}
$output .= "<ul>";