diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-02-23 14:15:17 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-02-23 14:15:17 +0000 |
| commit | 5b1451ce291da5c75a08e1b3aaf2689fc1487fb9 (patch) | |
| tree | ff941668e5cbd841546937e5b589b14668fb8da3 | |
| parent | d00469cd05aa7351255f9c16b13ca5dc1cc879b5 (diff) | |
| download | brdo-5b1451ce291da5c75a08e1b3aaf2689fc1487fb9.tar.gz brdo-5b1451ce291da5c75a08e1b3aaf2689fc1487fb9.tar.bz2 | |
- a small improvement to the "track drop.org" page
| -rw-r--r-- | account.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/account.php b/account.php index 5b8a1805e..369ce9828 100644 --- a/account.php +++ b/account.php @@ -448,7 +448,7 @@ function account_track_site() { $period = 259200; // 3 days - $sresult = db_query("SELECT s.subject, s.id, COUNT(c.lid) AS count FROM comments c LEFT JOIN stories s ON c.lid = s.id WHERE s.status = 2 AND c.link = 'story' AND ". time() ." - c.timestamp < $period GROUP BY c.lid ORDER BY count DESC LIMIT 10"); + $sresult = db_query("SELECT s.subject, s.id, COUNT(c.lid) AS count FROM comments c LEFT JOIN stories s ON c.lid = s.id WHERE s.status = 2 AND c.link = 'story' AND ". time() ." - c.timestamp < $period GROUP BY c.lid ORDER BY s.timestamp DESC LIMIT 10"); while ($story = db_fetch_object($sresult)) { $output .= "<LI>". format_plural($story->count, "comment", "comments") ." ". t("attached to story") ." '<A HREF=\"story.php?id=$story->id\">". check_output($story->subject) ."</A>':</LI>"; |