4 function update_queue_time($id) {
5 logger('queue: requeue item ' . $id);
6 q("UPDATE `queue` SET `last` = '%s' WHERE `id` = %d LIMIT 1",
7 dbesc(datetime_convert()),
12 function remove_queue_item($id) {
13 logger('queue: remove queue item ' . $id);
14 q("DELETE FROM `queue` WHERE `id` = %d LIMIT 1",
19 require_once("boot.php");
23 @include(".htconfig.php");
24 require_once("dba.php");
25 $db = new dba($db_host, $db_user, $db_pass, $db_data);
26 unset($db_host, $db_user, $db_pass, $db_data);
29 require_once("session.php");
30 require_once("datetime.php");
31 require_once('include/items.php');
32 require_once('include/bbcode.php');
34 $a->set_baseurl(get_config('system','url'));
38 logger('queue: start');
40 $r = q("SELECT `queue`.*, `contact`.`name`, `contact`.`uid` FROM `queue`
41 LEFT JOIN `contact` ON `queue`.`cid` = `contact`.`id`
42 WHERE `queue`.`created` < UTC_TIMESTAMP() - INTERVAL 3 DAY");
45 logger('Removing expired queue item for ' . $rr['name'] . ', uid=' . $rr['uid']);
46 logger('Expired queue data :' . $rr['content'], LOGGER_DATA);
48 q("DELETE FROM `queue` WHERE `created` < UTC_TIMESTAMP() - INTERVAL 3 DAY");
51 $r = q("SELECT `id` FROM `queue` WHERE `last` < UTC_TIMESTAMP() - INTERVAL 15 MINUTE ");
58 require_once('include/salmon.php');
60 foreach($r as $q_item) {
61 $qi = q("SELECT * FROM `queue` WHERE `id` = %d LIMIT 1",
67 $c = q("SELECT * FROM `contact` WHERE `id` = %d LIMIT 1",
71 remove_queue_item($q_item['id']);
74 if(in_array($c[0]['notify'],$deadguys)) {
75 logger('queue: skipping known dead url: ' . $c[0]['notify']);
76 update_queue_time($q_item['id']);
80 $u = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
84 remove_queue_item($q_item['id']);
88 $data = $qi[0]['content'];
94 switch($contact['network']) {
96 logger('queue: dfrndelivery: item ' . $q_item['id'] . ' for ' . $contact['name']);
97 $deliver_status = dfrn_deliver($owner,$contact,$data);
99 if($deliver_status == (-1)) {
100 update_queue_time($q_item['id']);
101 $deadguys[] = $contact['notify'];
104 remove_queue_item($q_item['id']);
108 if($contact['notify']) {
109 logger('queue: slapdelivery: item ' . $q_item['id'] . ' for ' . $contact['name']);
110 $deliver_status = slapper($owner,$contact['notify'],$data);
112 if($deliver_status == (-1))
113 update_queue_time($q_item['id']);
115 remove_queue_item($q_item['id']);