diff options
author | CiaranG <ciaran@ciarang.com> | 2009-03-05 16:18:59 +0000 |
---|---|---|
committer | CiaranG <ciaran@ciarang.com> | 2009-03-05 16:18:59 +0000 |
commit | 3c53e821cc545d14807c9197d07e8686028a846d (patch) | |
tree | e51f35dc8783ea2ba3c9443d28a55a707330909a /lib/popularnoticesection.php | |
parent | e5345d8d7a5b519cfb24c9e2a971b485b3c1c872 (diff) | |
parent | ea0c5f565c9ca4b34c1071a51333f0f842a954b9 (diff) |
Merge branch '0.7.x' of git@gitorious.org:laconica/dev into 0.7.x
Diffstat (limited to 'lib/popularnoticesection.php')
-rw-r--r-- | lib/popularnoticesection.php | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/lib/popularnoticesection.php b/lib/popularnoticesection.php index f7fb93554..0505f0fa9 100644 --- a/lib/popularnoticesection.php +++ b/lib/popularnoticesection.php @@ -54,10 +54,12 @@ class PopularNoticeSection extends NoticeSection $weightexpr='sum(exp(-(now() - fave.modified) / %s))'; } - $qry = 'SELECT notice.id, '. + $qry = 'SELECT notice.*, '. $weightexpr . ' as weight ' . 'FROM notice JOIN fave ON notice.id = fave.notice_id ' . - 'GROUP BY notice.id ' . + 'GROUP BY notice.id,notice.profile_id,notice.content,notice.uri,' . + 'notice.rendered,notice.url,notice.created,notice.modified,' . + 'notice.reply_to,notice.is_local,notice.source ' . 'ORDER BY weight DESC'; $offset = 0; |