X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fqueue_fn.php;h=8840668112300dbb4d96d62ebd63e7047e15a815;hb=0cd9db9cb7f4c96f597e37590a536eaae123238d;hp=2aca338f50d4e250707dbedf6e046d159c711281;hpb=6342b3e0bdd5774857a8fca809994f05e0208d25;p=friendica.git diff --git a/include/queue_fn.php b/include/queue_fn.php index 2aca338f50..8840668112 100644 --- a/include/queue_fn.php +++ b/include/queue_fn.php @@ -2,7 +2,7 @@ function update_queue_time($id) { logger('queue: requeue item ' . $id); - q("UPDATE `queue` SET `last` = '%s' WHERE `id` = %d LIMIT 1", + q("UPDATE `queue` SET `last` = '%s' WHERE `id` = %d", dbesc(datetime_convert()), intval($id) ); @@ -10,43 +10,63 @@ function update_queue_time($id) { function remove_queue_item($id) { logger('queue: remove queue item ' . $id); - q("DELETE FROM `queue` WHERE `id` = %d LIMIT 1", + q("DELETE FROM `queue` WHERE `id` = %d", intval($id) ); } +/** + * @brief Checks if the communication with a given contact had problems recently + * + * @param int $cid Contact id + * + * @return bool The communication with this contact has currently problems + */ function was_recently_delayed($cid) { + $was_delayed = false; - $r = q("SELECT `id` FROM `queue` WHERE `cid` = %d - and last > UTC_TIMESTAMP() - interval 15 minute limit 1", + // Are there queue entries that were recently added? + $r = q("SELECT `id` FROM `queue` WHERE `cid` = %d + AND `last` > UTC_TIMESTAMP() - INTERVAL 15 MINUTE LIMIT 1", intval($cid) ); - if(count($r)) - return true; - return false; + + $was_delayed = dbm::is_result($r); + + // We set "term-date" to a current date if the communication has problems. + // If the communication works again we reset this value. + if ($was_delayed) { + $r = q("SELECT `term-date` FROM `contact` WHERE `id` = %d AND `term-date` <= '1000-01-01' LIMIT 1", + intval($cid) + ); + $was_delayed = !dbm::is_result($r); + } + + return $was_delayed; } function add_to_queue($cid,$network,$msg,$batch = false) { $max_queue = get_config('system','max_contact_queue'); - if($max_queue < 1) + if ($max_queue < 1) { $max_queue = 500; + } $batch_queue = get_config('system','max_batch_queue'); - if($batch_queue < 1) + if ($batch_queue < 1) { $batch_queue = 1000; + } - $r = q("SELECT COUNT(*) AS `total` FROM `queue` left join `contact` ON `queue`.`cid` = `contact`.`id` + $r = q("SELECT COUNT(*) AS `total` FROM `queue` INNER JOIN `contact` ON `queue`.`cid` = `contact`.`id` WHERE `queue`.`cid` = %d AND `contact`.`self` = 0 ", intval($cid) ); - if($r && count($r)) { - if($batch && ($r[0]['total'] > $batch_queue)) { + if (dbm::is_result($r)) { + if ($batch && ($r[0]['total'] > $batch_queue)) { logger('add_to_queue: too many queued items for batch server ' . $cid . ' - discarding message'); return; - } - elseif((! $batch) && ($r[0]['total'] > $max_queue)) { + } elseif ((! $batch) && ($r[0]['total'] > $max_queue)) { logger('add_to_queue: too many queued items for contact ' . $cid . ' - discarding message'); return; }