opml fixes

1 files changed, 127 insertions, 0 deletions

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>";
+		}
+
+
+	}
+?>