diff options
author | Evan Prodromou <evan@controlyourself.ca> | 2009-03-04 11:05:58 -0800 |
---|---|---|
committer | Evan Prodromou <evan@controlyourself.ca> | 2009-03-04 11:05:58 -0800 |
commit | 8cc19b90eeb7920b2cfe79959038c5e25f40930a (patch) | |
tree | 8608ad304d57f7395ae4bf7b58ed4be7eaa0b6a1 /lib/grouptagcloudsection.php | |
parent | cf4e1872ab8109ea6a3230e43cc70899a17dd075 (diff) | |
parent | a7efd4ff556bbf6bafcfc81db758ab192b8802ad (diff) |
Merge branch '0.7.x' of git@gitorious.org:laconica/dev into 0.7.x
Diffstat (limited to 'lib/grouptagcloudsection.php')
-rw-r--r-- | lib/grouptagcloudsection.php | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/lib/grouptagcloudsection.php b/lib/grouptagcloudsection.php index f05be85cb..5d68af28b 100644 --- a/lib/grouptagcloudsection.php +++ b/lib/grouptagcloudsection.php @@ -58,8 +58,14 @@ class GroupTagCloudSection extends TagCloudSection function getTags() { + if (common_config('db', 'type') == 'pgsql') { + $weightexpr='sum(exp(-extract(epoch from (now() - notice_tag.created)) / %s))'; + } else { + $weightexpr='sum(exp(-(now() - notice_tag.created) / %s))'; + } + $qry = 'SELECT notice_tag.tag, '. - 'sum(exp(-(now() - notice_tag.created)/%s)) as weight ' . + $weightexpr . ' as weight ' . 'FROM notice_tag JOIN notice ' . 'ON notice_tag.notice_id = notice.id ' . 'JOIN group_inbox on group_inbox.notice_id = notice.id ' . |