+ $subscribers = DBA::select('push_subscriber', ['id', 'push', 'callback_url', 'nickname'], ["`push` > 0 AND `next_try` < UTC_TIMESTAMP()"]);
+
+ while ($subscriber = DBA::fetch($subscribers)) {
+ // We always handle retries with low priority
+ if ($subscriber['push'] > 1) {
+ $priority = PRIORITY_LOW;
+ } else {
+ $priority = $default_priority;
+ }
+
+ logger('Publish feed to ' . $subscriber['callback_url'] . ' for ' . $subscriber['nickname'] . ' with priority ' . $priority, LOGGER_DEBUG);
+ Worker::add($priority, 'PubSubPublish', (int)$subscriber['id']);
+ }
+
+ DBA::close($subscribers);
+ }
+
+ /**
+ * @brief Renew the feed subscription
+ *
+ * @param integer $uid User ID
+ * @param string $nick Priority for push workers
+ * @param integer $subscribe Subscribe (Unsubscribe = false)
+ * @param string $hub_callback Callback address
+ * @param string $hub_topic Feed topic
+ * @param string $hub_secret Subscription secret
+ */
+ public static function renew($uid, $nick, $subscribe, $hub_callback, $hub_topic, $hub_secret)
+ {
+ // fetch the old subscription if it exists
+ $subscriber = DBA::selectFirst('push_subscriber', ['last_update', 'push'], ['callback_url' => $hub_callback]);
+
+ // delete old subscription if it exists
+ DBA::delete('push_subscriber', ['callback_url' => $hub_callback]);
+
+ if ($subscribe) {
+ // if we are just updating an old subscription, keep the
+ // old values for last_update but reset the push
+ if (DBA::isResult($subscriber)) {
+ $last_update = $subscriber['last_update'];
+ $push_flag = min($subscriber['push'], 1);
+ } else {
+ $last_update = DateTimeFormat::utcNow();
+ $push_flag = 0;
+ }
+
+ // subscribe means adding the row to the table
+ $fields = ['uid' => $uid, 'callback_url' => $hub_callback,
+ 'topic' => $hub_topic, 'nickname' => $nick, 'push' => $push_flag,
+ 'last_update' => $last_update, 'renewed' => DateTimeFormat::utcNow(),
+ 'secret' => $hub_secret];
+ DBA::insert('push_subscriber', $fields);