New table "post-counts" to precalculate the counts

[friendica.git] / src / Worker / UpdateScores.php

diff --git a/src/Worker/UpdateScores.php b/src/Worker/UpdateScores.php
index 66f776ad7d336b603c6d02aecdfea843849bc15e..f17027a09d26b3bf063b738b580c4a3ccd058564 100644 (file)
--- a/src/Worker/UpdateScores.php
+++ b/src/Worker/UpdateScores.php
@@ -24,6 +24,7 @@ namespace Friendica\Worker;
 use Friendica\Core\Logger;
 use Friendica\Database\DBA;
 use Friendica\Model\Contact\Relation;
+use Friendica\Model\Post;
 
 /**
  * Update the interaction scores 
@@ -34,13 +35,16 @@ class UpdateScores
        {
                Logger::notice('Start score update');
 
-               $users = DBA::select('user', ['uid'], ["NOT `account_expired` AND NOT `account_removed` AND `uid` > ?", 0]);
+               $users = DBA::select('user', ['uid'], ["`verified` AND NOT `blocked` AND NOT `account_removed` AND NOT `account_expired` AND `uid` > ?", 0]);
                while ($user = DBA::fetch($users)) {
                        Relation::calculateInteractionScore($user['uid']);
                }
                DBA::close($users);
 
                Logger::notice('Score update done');
+
+               Post\Engagement::expire();
+
                return;
        }
 }