include/queue.php

   1 <?php
   2
   3
   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()),
   8                 intval($id)
   9         );
  10 }
  11
  12 function remove_queue_item($id) {
  13         logger('queue: remove queue item ' . $id);
  14         q("DELETE FROM `queue` WHERE `id` = %d LIMIT 1",
  15                 intval($id)
  16         );
  17 }
  18
  19         require_once("boot.php");
  20
  21         $a = new App;
  22
  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);
  27
  28
  29         require_once("session.php");
  30         require_once("datetime.php");
  31         require_once('include/items.php');
  32         require_once('include/bbcode.php');
  33
  34         $a->set_baseurl(get_config('system','url'));
  35
  36         $deadguys = array();
  37
  38         logger('queue: start');
  39
  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");
  43         if(count($r)) {
  44                 foreach($r as $rr) {
  45                         logger('Removing expired queue item for ' . $rr['name'] . ', uid=' . $rr['uid']);
  46                         logger('Expired queue data :' . $rr['content'], LOGGER_DATA);
  47                 }
  48                 q("DELETE FROM `queue` WHERE `created` < UTC_TIMESTAMP() - INTERVAL 3 DAY");
  49         }
  50
  51         $r = q("SELECT `id` FROM `queue` WHERE `last` < UTC_TIMESTAMP() - INTERVAL 15 MINUTE ");
  52
  53         if(! count($r))
  54                 killme();
  55
  56         // delivery loop
  57
  58         require_once('include/salmon.php');
  59
  60         foreach($r as $q_item) {
  61                 $qi = q("SELECT * FROM `queue` WHERE `id` = %d LIMIT 1",
  62                         intval($q_item['id'])
  63                 );
  64                 if(! count($qi))
  65                         continue;
  66
  67                 $c = q("SELECT * FROM `contact` WHERE `id` = %d LIMIT 1",
  68                         intval($qi[0]['cid'])
  69                 );
  70                 if(! count($c)) {
  71                         remove_queue_item($q_item['id']);
  72                         continue;
  73                 }
  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']);
  77                                 continue;
  78                 }
  79
  80                 $u = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
  81                         intval($c[0]['uid'])
  82                 );
  83                 if(! count($u)) {
  84                         remove_queue_item($q_item['id']);
  85                         continue;
  86                 }
  87
  88                 $data      = $qi[0]['content'];
  89                 $contact   = $c[0];
  90                 $owner     = $u[0];
  91
  92                 $deliver_status = 0;
  93
  94                 switch($contact['network']) {
  95                         case 'dfrn':
  96                                 logger('queue: dfrndelivery: item ' . $q_item['id'] . ' for ' . $contact['name']);
  97                                 $deliver_status = dfrn_deliver($owner,$contact,$data);
  98
  99                                 if($deliver_status == (-1)) {
 100                                         update_queue_time($q_item['id']);
 101                                         $deadguys[] = $contact['notify'];
 102                                 }
 103                                 else {
 104                                         remove_queue_item($q_item['id']);
 105                                 }
 106                                 break;
 107                         default:
 108                                 if($contact['notify']) {
 109                                         logger('queue: slapdelivery: item ' . $q_item['id'] . ' for ' . $contact['name']);
 110                                         $deliver_status = slapper($owner,$contact['notify'],$data);
 111
 112                                         if($deliver_status == (-1))
 113                                                 update_queue_time($q_item['id']);
 114                                         else
 115                                                 remove_queue_item($q_item['id']);
 116                                 }
 117                                 break;
 118                 }
 119         }
 120
 121         killme();
 122
 123         // NOTREACHED
 124