ops-Gazelle/app/Task/UpdateSeedTimes.php

<?php

namespace Gazelle\Task;

class UpdateSeedTimes extends \Gazelle\Task {
    public function run(): void {
        self::$db->prepared_query("
            DELETE FROM xbt_files_users
            WHERE mtime < unix_timestamp(now() - INTERVAL ? SECOND)
            ", UNSEEDED_DRAIN_INTERVAL
        );
        self::$db->prepared_query('
            INSERT INTO xbt_files_history (uid, fid, seedtime)
                SELECT DISTINCT uid, fid, 1
                FROM xbt_files_users
                WHERE active = 1 AND remaining = 0 AND mtime > unix_timestamp(NOW() - INTERVAL 1 HOUR)
            ON DUPLICATE KEY UPDATE seedtime = seedtime + 1
        ');
        $this->processed = self::$db->affected_rows();
    }
}