Files
ops-Gazelle/app/Task/UpdateSeedTimes.php
2023-11-20 20:52:22 +01:00

17 lines
530 B
PHP

<?php
namespace Gazelle\Task;
class UpdateSeedTimes extends \Gazelle\Task {
public function run(): void {
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();
}
}