X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=lib%2Fgrouptagcloudsection.php;h=f1106cc7bf9caeb3151595e5e2d5b022ea8427c5;hb=c6f09306b1c72296db8b55500a5d6a2ea8cd5dd2;hp=091cf48457ce0bdb9330d62d78b9ff7363ef1944;hpb=bbb830e14c718c687f0636710a1827c90b11f4cc;p=quix0rs-gnu-social.git

diff --git a/lib/grouptagcloudsection.php b/lib/grouptagcloudsection.php
index 091cf48457..f1106cc7bf 100644
--- a/lib/grouptagcloudsection.php
+++ b/lib/grouptagcloudsection.php
@@ -58,11 +58,8 @@ 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))';
-        }
+        $weightexpr = common_sql_weight('notice_tag.created', common_config('tag', 'dropoff'));
+        // @fixme should we use the cutoff too? Doesn't help with indexing per-group.
 
         $names = $this->group->getAliases();
 
@@ -99,7 +96,6 @@ class GroupTagCloudSection extends TagCloudSection
 
         $tag = Memcached_DataObject::cachedQuery('Notice_tag',
                                                  sprintf($qry,
-                                                         common_config('tag', 'dropoff'),
                                                          $this->group->id,
                                                          $namestring),
                                                  3600);