From 41b82aa4b98bc0e2004e7d28c2f5933fbe3ad7a3 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Mon, 24 Dec 2012 14:27:15 +0400
Subject: add HOOK_UPDATE_TASK

---
 plugins/instances/instances.php | 107 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 107 insertions(+)

(limited to 'plugins/instances')

diff --git a/plugins/instances/instances.php b/plugins/instances/instances.php
index c5d8067af..f95d511ff 100644
--- a/plugins/instances/instances.php
+++ b/plugins/instances/instances.php
@@ -16,6 +16,113 @@ class Instances extends Plugin implements IHandler {
 
 		$host->add_hook($host::HOOK_PREFS_TABS, $this);
 		$host->add_handler("pref-instances", "*", $this);
+		$host->add_command("get-feeds", "receive popular feeds from linked instances", $this);
+		$host->add_hook($host::HOOK_UPDATE_TASK, $this);
+	}
+
+	function hook_update_task($args) {
+		_debug("Get linked feeds...");
+		$this->get_linked_feeds($this->link);
+	}
+
+	// Status codes:
+	// -1  - never connected
+	// 0   - no data received
+	// 1   - data received successfully
+	// 2   - did not receive valid data
+	// >10 - server error, code + 10 (e.g. 16 means server error 6)
+
+	function get_linked_feeds($link, $instance_id = false) {
+		if ($instance_id)
+			$instance_qpart = "id = '$instance_id' AND ";
+		else
+			$instance_qpart = "";
+
+		if (DB_TYPE == "pgsql") {
+			$date_qpart = "last_connected < NOW() - INTERVAL '6 hours'";
+		} else {
+			$date_qpart = "last_connected < DATE_SUB(NOW(), INTERVAL 6 HOUR)";
+		}
+
+		$result = db_query($link, "SELECT id, access_key, access_url FROM ttrss_linked_instances
+			WHERE $instance_qpart $date_qpart ORDER BY last_connected");
+
+		while ($line = db_fetch_assoc($result)) {
+			$id = $line['id'];
+
+			_debug("Updating: " . $line['access_url'] . " ($id)");
+
+			$fetch_url = $line['access_url'] . '/public.php?op=fbexport';
+			$post_query = 'key=' . $line['access_key'];
+
+			$feeds = fetch_file_contents($fetch_url, false, false, false, $post_query);
+
+			// try doing it the old way
+			if (!$feeds) {
+				$fetch_url = $line['access_url'] . '/backend.php?op=fbexport';
+				$feeds = fetch_file_contents($fetch_url, false, false, false, $post_query);
+			}
+
+			if ($feeds) {
+				$feeds = json_decode($feeds, true);
+
+				if ($feeds) {
+					if ($feeds['error']) {
+						$status = $feeds['error']['code'] + 10;
+
+						// access denied
+						if ($status == 16) {
+							db_query($link, "DELETE FROM ttrss_linked_feeds
+								WHERE instance_id = '$id'");
+						}
+					} else {
+						$status = 1;
+
+						if (count($feeds['feeds']) > 0) {
+
+							db_query($link, "DELETE FROM ttrss_linked_feeds
+								WHERE instance_id = '$id'");
+
+							foreach ($feeds['feeds'] as $feed) {
+								$feed_url = db_escape_string($feed['feed_url']);
+								$title = db_escape_string($feed['title']);
+								$subscribers = db_escape_string($feed['subscribers']);
+								$site_url = db_escape_string($feed['site_url']);
+
+								db_query($link, "INSERT INTO ttrss_linked_feeds
+									(feed_url, site_url, title, subscribers, instance_id, created, updated)
+								VALUES
+									('$feed_url', '$site_url', '$title', '$subscribers', '$id', NOW(), NOW())");
+							}
+						} else {
+							// received 0 feeds, this might indicate that
+							// the instance on the other hand is rebuilding feedbrowser cache
+							// we will try again later
+
+							// TODO: maybe perform expiration based on updated here?
+						}
+
+						_debug("Processed " . count($feeds['feeds']) . " feeds.");
+					}
+				} else {
+					$status = 2;
+				}
+
+			} else {
+				$status = 0;
+			}
+
+			_debug("Status: $status");
+
+			db_query($link, "UPDATE ttrss_linked_instances SET
+				last_status_out = '$status', last_connected = NOW() WHERE id = '$id'");
+
+		}
+	}
+
+
+	function get_feeds() {
+		$this->get_linked_feeds($this->link, false);
 	}
 
 	function get_prefs_js() {
-- 
cgit v1.2.3