opml/db updater tweaks

[tt-rss.git] / modules / opml_domdoc.php

<?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 target='_new' href='$site_url'><b>$feed_title</b></a></b> 
						(<a target='_new' 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>";
		}


	}
?>