diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-02-09 14:38:20 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-02-09 14:38:20 +0000 |
| commit | 6953d95b2d121c86e76379ceeb9ad1af428c64e0 (patch) | |
| tree | b15fe4aaeb864f1b9ecc6d8671db721f9c71ebb0 | |
| parent | c97e7fe1805d2ac0f2f3aedc89611a237f0edfdc (diff) | |
| download | brdo-6953d95b2d121c86e76379ceeb9ad1af428c64e0.tar.gz brdo-6953d95b2d121c86e76379ceeb9ad1af428c64e0.tar.bz2 | |
- Fixed bug #1133: disabled comments are no longer shown. Thanks Gerhard.
| -rw-r--r-- | modules/tracker.module | 4 | ||||
| -rw-r--r-- | modules/tracker/tracker.module | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/modules/tracker.module b/modules/tracker.module index e93acb098..74222598a 100644 --- a/modules/tracker.module +++ b/modules/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>"; 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>"; |