diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-03-16 07:38:39 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-03-16 07:38:39 +0000 |
| commit | 603f6041131710ece8bcad78c17fe7720860c469 (patch) | |
| tree | c47836fe4aeb5f2d946d426169a0357a5f133ba8 | |
| parent | 170b674a0953ce95e06f7a8442eb0f1097e7ee72 (diff) | |
| download | brdo-603f6041131710ece8bcad78c17fe7720860c469.tar.gz brdo-603f6041131710ece8bcad78c17fe7720860c469.tar.bz2 | |
- Added a pager to the tracker page.
| -rw-r--r-- | modules/tracker.module | 8 | ||||
| -rw-r--r-- | modules/tracker/tracker.module | 8 |
2 files changed, 12 insertions, 4 deletions
diff --git a/modules/tracker.module b/modules/tracker.module index 641814077..a5d0f090f 100644 --- a/modules/tracker.module +++ b/modules/tracker.module @@ -23,10 +23,10 @@ function tracker_link($type) { function tracker_posts($id = 0) { if ($id) { - $sresult = db_query_range("SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name, MAX(GREATEST(n.changed, c.timestamp)) AS last_activity FROM node n LEFT JOIN comments c ON n.nid = c.nid LEFT JOIN users u ON n.uid = u.uid WHERE n.uid = '". check_query($id) ."' AND n.status = 1 GROUP BY n.nid, n.title, n.type, n.changed, n.uid, u.name ORDER BY last_activity DESC", 0, 15); + $sresult = pager_query("SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name, MAX(GREATEST(n.changed, c.timestamp)) AS last_activity FROM node n LEFT JOIN comments c ON n.nid = c.nid LEFT JOIN users u ON n.uid = u.uid WHERE n.uid = '". check_query($id) ."' AND n.status = 1 GROUP BY n.nid, n.title, n.type, n.changed, n.uid, u.name ORDER BY last_activity DESC", 10, 0, "SELECT COUNT(nid) FROM node"); } else { - $sresult = db_query_range("SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name, MAX(GREATEST(n.changed, c.timestamp)) AS last_activity FROM node n LEFT JOIN comments c ON n.nid = c.nid LEFT JOIN users u ON n.uid = u.uid WHERE n.status = 1 GROUP BY n.nid, n.title, n.type, n.changed, n.uid, u.name ORDER BY last_activity DESC", 0, 15); + $sresult = pager_query("SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name, MAX(GREATEST(n.changed, c.timestamp)) AS last_activity FROM node n LEFT JOIN comments c ON n.nid = c.nid LEFT JOIN users u ON n.uid = u.uid WHERE n.status = 1 GROUP BY n.nid, n.title, n.type, n.changed, n.uid, u.name ORDER BY last_activity DESC", 10, 0, "SELECT COUNT(nid) FROM node"); } $header = array(t("Type"), t("Title"), t("Author")); @@ -58,6 +58,10 @@ function tracker_posts($id = 0) { $rows[] = array(array("data" => $type, "class" => "type"), array("data" => $title . $comments, "class" => "content"), array("data" => $author, "class" => "author")); } + if ($pager = pager_display(NULL, 10)) { + $rows[] = array(array("data" => $pager, "colspan" => 3)); + } + $output = "<div id=\"tracker\">"; $output .= table($header, $rows); $output .= "</div>"; diff --git a/modules/tracker/tracker.module b/modules/tracker/tracker.module index 641814077..a5d0f090f 100644 --- a/modules/tracker/tracker.module +++ b/modules/tracker/tracker.module @@ -23,10 +23,10 @@ function tracker_link($type) { function tracker_posts($id = 0) { if ($id) { - $sresult = db_query_range("SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name, MAX(GREATEST(n.changed, c.timestamp)) AS last_activity FROM node n LEFT JOIN comments c ON n.nid = c.nid LEFT JOIN users u ON n.uid = u.uid WHERE n.uid = '". check_query($id) ."' AND n.status = 1 GROUP BY n.nid, n.title, n.type, n.changed, n.uid, u.name ORDER BY last_activity DESC", 0, 15); + $sresult = pager_query("SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name, MAX(GREATEST(n.changed, c.timestamp)) AS last_activity FROM node n LEFT JOIN comments c ON n.nid = c.nid LEFT JOIN users u ON n.uid = u.uid WHERE n.uid = '". check_query($id) ."' AND n.status = 1 GROUP BY n.nid, n.title, n.type, n.changed, n.uid, u.name ORDER BY last_activity DESC", 10, 0, "SELECT COUNT(nid) FROM node"); } else { - $sresult = db_query_range("SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name, MAX(GREATEST(n.changed, c.timestamp)) AS last_activity FROM node n LEFT JOIN comments c ON n.nid = c.nid LEFT JOIN users u ON n.uid = u.uid WHERE n.status = 1 GROUP BY n.nid, n.title, n.type, n.changed, n.uid, u.name ORDER BY last_activity DESC", 0, 15); + $sresult = pager_query("SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name, MAX(GREATEST(n.changed, c.timestamp)) AS last_activity FROM node n LEFT JOIN comments c ON n.nid = c.nid LEFT JOIN users u ON n.uid = u.uid WHERE n.status = 1 GROUP BY n.nid, n.title, n.type, n.changed, n.uid, u.name ORDER BY last_activity DESC", 10, 0, "SELECT COUNT(nid) FROM node"); } $header = array(t("Type"), t("Title"), t("Author")); @@ -58,6 +58,10 @@ function tracker_posts($id = 0) { $rows[] = array(array("data" => $type, "class" => "type"), array("data" => $title . $comments, "class" => "content"), array("data" => $author, "class" => "author")); } + if ($pager = pager_display(NULL, 10)) { + $rows[] = array(array("data" => $pager, "colspan" => 3)); + } + $output = "<div id=\"tracker\">"; $output .= table($header, $rows); $output .= "</div>"; |