From 30f782a278a9f1f44402ea5ecf8efef1894b813c Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Fri, 2 Mar 2007 14:58:51 +0100
Subject: opml fixes

---
 modules/opml_domdoc.php | 127 ++++++++++++++++++++++++++++++++++++++++++++++
 modules/opml_domxml.php | 132 ++++++++++++++++++++++++++++++++++++++++++++++++
 2 files changed, 259 insertions(+)
 create mode 100644 modules/opml_domdoc.php
 create mode 100644 modules/opml_domxml.php

(limited to 'modules')

diff --git a/modules/opml_domdoc.php b/modules/opml_domdoc.php
new file mode 100644
index 000000000..459841022
--- /dev/null
+++ b/modules/opml_domdoc.php
@@ -0,0 +1,127 @@
+<?php
+	function opml_import_domdoc($link, $owner_uid) {
+
+		if (is_file($_FILES['opml_file']['tmp_name'])) {
+			$doc = DOMDocument::load($_FILES['opml_file']['tmp_name']);
+
+			if ($doc) {
+				$body = $doc->getElementsByTagName('body');
+
+				$xpath = new DOMXpath($doc);
+				$query = "/opml/body//outline";
+
+				$outlines = $xpath->query($query);
+
+				print "<table>";
+
+				foreach ($outlines as $outline) {
+
+					$feed_title = db_escape_string($outline->attributes->getNamedItem('text')->nodeValue);
+
+					if (!$feed_title) {
+						$feed_title = db_escape_string($outline->attributes->getNamedItem('title')->nodeValue);
+					}
+
+					$cat_title = db_escape_string($outline->attributes->getNamedItem('title')->nodeValue);
+
+					if (!$cat_title) {
+						$cat_title = db_escape_string($outline->attributes->getNamedItem('text')->nodeValue);
+					}
+
+					$feed_url = db_escape_string($outline->attributes->getNamedItem('xmlUrl')->nodeValue);
+					$site_url = db_escape_string($outline->attributes->getNamedItem('htmlUrl')->nodeValue);
+
+					if ($cat_title && !$feed_url) {
+
+						db_query($link, "BEGIN");
+
+						$result = db_query($link, "SELECT id FROM
+								ttrss_feed_categories WHERE title = '$cat_title' AND
+								owner_uid = '$owner_uid' LIMIT 1");
+
+						if (db_num_rows($result) == 0) {
+
+							print "Adding category <b>$cat_title</b>...<br>";
+
+							db_query($link, "INSERT INTO ttrss_feed_categories
+									(title,owner_uid) 
+									VALUES ('$cat_title', '$owner_uid')");
+						}
+
+						db_query($link, "COMMIT");
+					}
+
+					//						print "$active_category : $feed_title : $feed_url<br>";
+
+					if (!$feed_title || !$feed_url) continue;
+
+					db_query($link, "BEGIN");
+
+					$cat_id = null;
+
+					$parent_node = $outline->parentNode;
+
+					if ($parent_node && $parent_node->nodeName == "outline") {
+						$element_category = $parent_node->attributes->getNamedItem('title')->nodeValue;
+					} else {
+						$element_category = '';
+					}
+
+					if ($element_category) {
+
+						$result = db_query($link, "SELECT id FROM
+								ttrss_feed_categories WHERE title = '$element_category' AND
+								owner_uid = '$owner_uid' LIMIT 1");								
+
+							if (db_num_rows($result) == 1) {	
+								$cat_id = db_fetch_result($result, 0, "id");
+							}
+					}								
+
+					$result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
+							(title = '$feed_title' OR feed_url = '$feed_url') 
+							AND owner_uid = '$owner_uid'");
+
+					print "<tr><td><a href='$site_url'><b>$feed_title</b></a></b> 
+						(<a href=\"$feed_url\">rss</a>)</td>";
+
+					if (db_num_rows($result) > 0) {
+						print "<td>Already imported.</td>";
+					} else {
+
+						if ($cat_id) {
+							$add_query = "INSERT INTO ttrss_feeds 
+								(title, feed_url, owner_uid, cat_id, site_url) VALUES
+								('$feed_title', '$feed_url', '$owner_uid', 
+								 '$cat_id', '$site_url')";
+
+						} else {
+							$add_query = "INSERT INTO ttrss_feeds 
+								(title, feed_url, owner_uid, site_url) VALUES
+								('$feed_title', '$feed_url', '$owner_uid', '$site_url')";
+
+						}
+
+						db_query($link, $add_query);
+
+						print "<td><b>Done.</b></td>";
+					}
+
+					print "</tr>";
+
+					db_query($link, "COMMIT");
+				}
+
+				print "</table>";
+
+			} else {
+				print "<div class=\"error\">Error while parsing document.</div>";
+			}
+
+		} else {
+			print "<div class=\"error\">Error: please upload OPML file.</div>";
+		}
+
+
+	}
+?>
diff --git a/modules/opml_domxml.php b/modules/opml_domxml.php
new file mode 100644
index 000000000..2a140f325
--- /dev/null
+++ b/modules/opml_domxml.php
@@ -0,0 +1,132 @@
+<?php
+	function opml_import_domxml($link, $owner_uid) {
+
+		if (is_file($_FILES['opml_file']['tmp_name'])) {
+			$dom = domxml_open_file($_FILES['opml_file']['tmp_name']);
+
+			if ($dom) {
+				$root = $dom->document_element();
+
+				$body = $root->get_elements_by_tagname('body');
+
+				if ($body[0]) {			
+					$body = $body[0];
+
+					$outlines = $body->get_elements_by_tagname('outline');
+
+					print "<table>";
+
+					foreach ($outlines as $outline) {
+
+						$feed_title = db_escape_string($outline->get_attribute('text'));
+
+						if (!$feed_title) {
+							$feed_title = db_escape_string($outline->get_attribute('title'));
+						}
+
+						$cat_title = db_escape_string($outline->get_attribute('title'));
+
+						if (!$cat_title) {
+							$cat_title = db_escape_string($outline->get_attribute('text'));
+						}
+	
+						$feed_url = db_escape_string($outline->get_attribute('xmlUrl'));
+						$site_url = db_escape_string($outline->get_attribute('htmlUrl'));
+
+						if ($cat_title && !$feed_url) {
+
+							db_query($link, "BEGIN");
+							
+							$result = db_query($link, "SELECT id FROM
+								ttrss_feed_categories WHERE title = '$cat_title' AND
+								owner_uid = '$owner_uid' LIMIT 1");
+
+							if (db_num_rows($result) == 0) {
+
+								printf(_("Adding category <b>%s</b>."), $cat_title);
+								print "<br>";
+
+								db_query($link, "INSERT INTO ttrss_feed_categories
+									(title,owner_uid) 
+								VALUES ('$cat_title', '$owner_uid')");
+							}
+
+							db_query($link, "COMMIT");
+						}
+
+//						print "$active_category : $feed_title : $feed_url<br>";
+
+						if (!$feed_title || !$feed_url) continue;
+
+						db_query($link, "BEGIN");
+
+						$cat_id = null;
+
+						$parent_node = $outline->parent_node();
+
+						if ($parent_node && $parent_node->node_name() == "outline") {
+							$element_category = $parent_node->get_attribute('title');
+						} else {
+							$element_category = '';
+						}
+
+						if ($element_category) {
+
+							$result = db_query($link, "SELECT id FROM
+									ttrss_feed_categories WHERE title = '$element_category' AND
+									owner_uid = '$owner_uid' LIMIT 1");								
+
+							if (db_num_rows($result) == 1) {	
+								$cat_id = db_fetch_result($result, 0, "id");
+							}
+						}								
+
+						$result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
+							(title = '$feed_title' OR feed_url = '$feed_url') 
+							AND owner_uid = '$owner_uid'");
+
+						print "<tr><td><a href='$site_url'><b>$feed_title</b></a></b> 
+							(<a href=\"$feed_url\">rss</a>)</td>";
+
+						if (db_num_rows($result) > 0) {
+							print "<td>"._("Already imported.")."</td>";
+						} else {
+
+							if ($cat_id) {
+								$add_query = "INSERT INTO ttrss_feeds 
+									(title, feed_url, owner_uid, cat_id, site_url) VALUES
+									('$feed_title', '$feed_url', '$owner_uid', 
+										'$cat_id', '$site_url')";
+
+							} else {
+								$add_query = "INSERT INTO ttrss_feeds 
+									(title, feed_url, owner_uid, site_url) VALUES
+									('$feed_title', '$feed_url', '$owner_uid', '$site_url')";
+
+							}
+
+							db_query($link, $add_query);
+							
+							print "<td><b>"._('Done.')."</b></td>";
+						}
+
+						print "</tr>";
+						
+						db_query($link, "COMMIT");
+					}
+
+					print "</table>";
+
+				} else {
+					print "<div class=\"error\">"._("Error: can't find body element.")."</div>";
+				}
+			} else {
+				print "<div class=\"error\">"._("Error while parsing document.")."</div>";
+			}
+
+		} else {
+			print "<div class=\"error\">"._("Error: please upload OPML file.")."</div>";
+		}
+
+	}
+?>
-- 
cgit v1.2.3-54-g00ecf