From 7a1aee87c237402e64c7fa5324a288d059b83a34 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Thu, 20 Sep 2001 20:57:35 +0000 Subject: - added a new tracker.module (everybody kept nagging about the missing "your drupal" feature). Tracker.module will be improved and expanded during the process. - renamed a link in user.module --- modules/tracker.module | 67 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 67 insertions(+) create mode 100644 modules/tracker.module (limited to 'modules/tracker.module') diff --git a/modules/tracker.module b/modules/tracker.module new file mode 100644 index 000000000..46d2fee48 --- /dev/null +++ b/modules/tracker.module @@ -0,0 +1,67 @@ +". t("recent comments") .""; + } + + return $links ? $links : array(); +} + +function tracker_comments($id = 0) { + global $theme, $user; + + if ($id) { + $sresult = db_query("SELECT n.nid, n.title, COUNT(n.nid) AS count FROM comments c LEFT JOIN node n ON c.lid = n.nid WHERE c.author = '". check_input($id) ."' GROUP BY n.nid DESC ORDER BY n.nid DESC LIMIT 5"); + } + else { + $sresult = db_query("SELECT n.nid, n.title, COUNT(n.nid) AS count FROM comments c LEFT JOIN node n ON c.lid = n.nid GROUP BY n.nid DESC ORDER BY n.nid DESC LIMIT 5"); + } + + while ($node = db_fetch_object($sresult)) { + $output .= format_plural($node->count, "comment", "comments") ." ". t("attached to node") ." nid\">". check_output($node->title) .":\n"; + + if ($id) { + $cresult = db_query("SELECT * FROM comments WHERE author = '". check_input($id) ."' AND lid = '$node->nid' ORDER BY cid DESC"); + } + else { + $cresult = db_query("SELECT * FROM comments WHERE lid = '$node->nid' ORDER BY cid DESC"); + } + + $output .= "\n"; + } + + return $output; +} + +function tracker_menu() { + global $user; + + $links[] = "uid\">your recent comments"; + $links[] = "all recent comments"; + + return "
". implode(" · ", $links) ."
"; +} + + +function tracker_page() { + global $theme, $id; + + $theme->header(); + $theme->box(t("Tracker"), tracker_menu()); + + if ($id) { + $theme->box(t("Your recent comments"), tracker_comments($id)); + } + else { + $theme->box(t("All recent comments"), tracker_comments()); + } + + $theme->footer(); +} + +?> -- cgit v1.2.3