diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-06-08 19:49:20 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-06-08 19:49:20 +0000 |
| commit | a37211cf82cd1c1b45b7f8420b018edefc56f3e8 (patch) | |
| tree | bdd7efef41271d5828160f2eef00fed920cb7f24 /account.php | |
| parent | a616715ae2fa2ca949fd2e8d277243285af193c0 (diff) | |
| download | brdo-a37211cf82cd1c1b45b7f8420b018edefc56f3e8.tar.gz brdo-a37211cf82cd1c1b45b7f8420b018edefc56f3e8.tar.bz2 | |
- Revised the 'track sitename' feature: it should be more accurate now.
Diffstat (limited to 'account.php')
| -rw-r--r-- | account.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/account.php b/account.php index 6f6ff89e5..f341c1d1c 100644 --- a/account.php +++ b/account.php @@ -388,7 +388,7 @@ function account_track_site() { $theme->header(); - $nresult = db_query("SELECT n.nid, n.title, COUNT(c.cid) AS count FROM comments c LEFT JOIN node n ON n.nid = c.lid WHERE c.timestamp > ". (time() - $period) ." GROUP BY c.lid ORDER BY count DESC"); + $nresult = db_query("SELECT n.nid, n.title, COUNT(c.cid) AS count FROM comments c LEFT JOIN node n ON n.nid = c.lid WHERE n.status = '". node_status("posted") ."' AND c.timestamp > ". (time() - $period) ." GROUP BY c.lid ORDER BY count DESC"); while ($node = db_fetch_object($nresult)) { $output .= "<LI>". format_plural($node->count, "comment", "comments") ." ". t("attached to") ." '<A HREF=\"node.php?id=$node->nid\">". check_output($node->title) ."</A>':</LI>"; |