3 * @file src/Model/Queue.php
5 namespace Friendica\Model;
7 use Friendica\Core\Config;
8 use Friendica\Database\DBA;
9 use Friendica\Util\DateTimeFormat;
11 require_once 'include/dba.php';
16 * @param string $id id
18 public static function updateTime($id)
20 logger('queue: requeue item ' . $id);
21 $queue = DBA::selectFirst('queue', ['retrial'], ['id' => $id]);
22 if (!DBA::isResult($queue)) {
26 $retrial = $queue['retrial'];
29 self::removeItem($id);
32 // Calculate the delay until the next trial
33 $delay = (($retrial + 3) ** 4) + (rand(1, 30) * ($retrial + 1));
34 $next = DateTimeFormat::utc('now + ' . $delay . ' seconds');
36 DBA::update('queue', ['last' => DateTimeFormat::utcNow(), 'retrial' => $retrial + 1, 'next' => $next], ['id' => $id]);
40 * @param string $id id
42 public static function removeItem($id)
44 logger('queue: remove queue item ' . $id);
45 DBA::delete('queue', ['id' => $id]);
49 * @brief Checks if the communication with a given contact had problems recently
51 * @param int $cid Contact id
53 * @return bool The communication with this contact has currently problems
55 public static function wasDelayed($cid)
57 // Are there queue entries that were recently added?
58 $r = q("SELECT `id` FROM `queue` WHERE `cid` = %d
59 AND `last` > UTC_TIMESTAMP() - INTERVAL 15 MINUTE LIMIT 1",
63 $was_delayed = DBA::isResult($r);
65 // We set "term-date" to a current date if the communication has problems.
66 // If the communication works again we reset this value.
68 $r = q("SELECT `term-date` FROM `contact` WHERE `id` = %d AND `term-date` <= '1000-01-01' LIMIT 1",
71 $was_delayed = !DBA::isResult($r);
78 * @param string $cid cid
79 * @param string $network network
80 * @param string $msg message
81 * @param boolean $batch batch, default false
83 public static function add($cid, $network, $msg, $batch = false, $guid = '')
86 $max_queue = Config::get('system', 'max_contact_queue');
91 $batch_queue = Config::get('system', 'max_batch_queue');
92 if ($batch_queue < 1) {
96 $r = q("SELECT COUNT(*) AS `total` FROM `queue` INNER JOIN `contact` ON `queue`.`cid` = `contact`.`id`
97 WHERE `queue`.`cid` = %d AND `contact`.`self` = 0 ",
101 if (DBA::isResult($r)) {
102 if ($batch && ($r[0]['total'] > $batch_queue)) {
103 logger('too many queued items for batch server ' . $cid . ' - discarding message');
105 } elseif ((! $batch) && ($r[0]['total'] > $max_queue)) {
106 logger('too many queued items for contact ' . $cid . ' - discarding message');
111 DBA::insert('queue', [
113 'network' => $network,
115 'created' => DateTimeFormat::utcNow(),
116 'last' => DateTimeFormat::utcNow(),
118 'batch' =>($batch) ? 1 : 0
120 logger('Added item ' . $guid . ' for ' . $cid);