include/queue.php

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