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         logger('queue: start');
  37
  38         $r = q("SELECT `queue`.*, `contact`.`name`, `contact`.`uid` FROM `queue`
  39                 LEFT JOIN `contact` ON `queue`.`cid` = `contact`.`id`
  40                 WHERE `queue`.`created` < UTC_TIMESTAMP() - INTERVAL 3 DAY");
  41         if(count($r)) {
  42                 foreach($r as $rr) {
  43                         logger('Removing expired queue item for ' . $rr['name'] . ', uid=' . $rr['uid']);
  44                         logger('Expired queue data :' . $rr['content'], LOGGER_DATA);
  45                 }
  46                 q("DELETE FROM `queue` WHERE `created` < UTC_TIMESTAMP() - INTERVAL 3 DAY");
  47         }
  48
  49         $r = q("SELECT `id` FROM `queue` WHERE `last` < UTC_TIMESTAMP() - INTERVAL 15 MINUTE ");
  50
  51         if(! count($r))
  52                 killme();
  53
  54         // delivery loop
  55
  56         require_once('include/salmon.php');
  57
  58         foreach($r as $q_item) {
  59                 $qi = q("SELECT * FROM `queue` WHERE `id` = %d LIMIT 1",
  60                         intval($q_item['id'])
  61                 );
  62                 if(! count($qi))
  63                         continue;
  64
  65                 $c = q("SELECT * FROM `contact` WHERE `id` = %d LIMIT 1",
  66                         intval($qi[0]['cid'])
  67                 );
  68                 if(! count($c)) {
  69                         remove_queue_item($q_item['id']);
  70                         continue;
  71                 }
  72                 $u = q("SELECT * FROM `user` WHERE `uid` = %d LIMIT 1",
  73                         intval($c[0]['uid'])
  74                 );
  75                 if(! count($u)) {
  76                         remove_queue_item($q_item['id']);
  77                         continue;
  78                 }
  79
  80                 $data      = $qi[0]['content'];
  81                 $contact   = $c[0];
  82                 $owner     = $u[0];
  83
  84                 $deliver_status = 0;
  85
  86                 switch($contact['network']) {
  87                         case 'dfrn':
  88                                 logger('queue: dfrndelivery: item ' . $q_item['id'] . ' for ' . $contact['name']);
  89                                 $deliver_status = dfrn_deliver($owner,$contact,$data);
  90
  91                                 if($deliver_status == (-1))
  92                                         update_queue_time($q_item['id']);
  93                                 else
  94                                         remove_queue_item($q_item['id']);
  95
  96                                 break;
  97                         default:
  98                                 if($contact['notify']) {
  99                                         logger('queue: slapdelivery: item ' . $q_item['id'] . ' for ' . $contact['name']);
 100                                         $deliver_status = slapper($owner,$contact['notify'],$data);
 101
 102                                         if($deliver_status == (-1))
 103                                                 update_queue_time($q_item['id']);
 104                                         else
 105                                                 remove_queue_item($q_item['id']);
 106                                 }
 107                                 break;
 108                 }
 109         }
 110
 111         killme();
 112
 113         // NOTREACHED
 114