[tt-rss.git] / classes / opml.php

<?php
class Opml extends Handler_Protected {

	function csrf_ignore($method) {
		$csrf_ignored = array("export", "import");

		return array_search($method, $csrf_ignored) !== false;
	}

	function export() {
		$output_name = $_REQUEST["filename"];
		if (!$output_name) $output_name = "TinyTinyRSS.opml";

		$show_settings = $_REQUEST["settings"];

		$owner_uid = $_SESSION["uid"];
		return $this->opml_export($output_name, $owner_uid, false, ($show_settings == 1));
	}

	function import() {
		$owner_uid = $_SESSION["uid"];

		header('Content-Type: text/html; charset=utf-8');

		print "<html>
			<head>
				<link rel=\"stylesheet\" href=\"css/utility.css\" type=\"text/css\">
				<title>".__("OPML Utility")."</title>
				<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
			</head>
			<body>
			<div class=\"floatingLogo\"><img src=\"images/logo_small.png\"></div>
			<h1>".__('OPML Utility')."</h1><div class='content'>";

		add_feed_category("Imported feeds");

		$this->opml_notice(__("Importing OPML..."));
		$this->opml_import($owner_uid);

		print "<br><form method=\"GET\" action=\"prefs.php\">
			<input type=\"submit\" value=\"".__("Return to preferences")."\">
			</form>";

		print "</div></body></html>";


	}

	// Export

	private function opml_export_category($owner_uid, $cat_id, $hide_private_feeds=false) {

		if ($cat_id) {
			$cat_qpart = "parent_cat = '$cat_id'";
			$feed_cat_qpart = "cat_id = '$cat_id'";
		} else {
			$cat_qpart = "parent_cat IS NULL";
			$feed_cat_qpart = "cat_id IS NULL";
		}

		if ($hide_private_feeds)
			$hide_qpart = "(private IS false AND auth_login = '' AND auth_pass = '')";
		else
			$hide_qpart = "true";

		$out = "";

		if ($cat_id) {
			$result = $this->dbh->query("SELECT title FROM ttrss_feed_categories WHERE id = '$cat_id'
				AND owner_uid = '$owner_uid'");
			$cat_title = htmlspecialchars($this->dbh->fetch_result($result, 0, "title"));
		}

		if ($cat_title) $out .= "<outline text=\"$cat_title\">\n";

		$result = $this->dbh->query("SELECT id,title
			FROM ttrss_feed_categories WHERE
			$cat_qpart AND owner_uid = '$owner_uid' ORDER BY order_id, title");

		while ($line = $this->dbh->fetch_assoc($result)) {
			$title = htmlspecialchars($line["title"]);
			$out .= $this->opml_export_category($owner_uid, $line["id"], $hide_private_feeds);
		}

		$feeds_result = $this->dbh->query("select title, feed_url, site_url
				from ttrss_feeds where $feed_cat_qpart AND owner_uid = '$owner_uid' AND $hide_qpart
				order by order_id, title");

		while ($fline = $this->dbh->fetch_assoc($feeds_result)) {
			$title = htmlspecialchars($fline["title"]);
			$url = htmlspecialchars($fline["feed_url"]);
			$site_url = htmlspecialchars($fline["site_url"]);

			if ($site_url) {
				$html_url_qpart = "htmlUrl=\"$site_url\"";
			} else {
				$html_url_qpart = "";
			}

			$out .= "<outline type=\"rss\" text=\"$title\" xmlUrl=\"$url\" $html_url_qpart/>\n";
		}

		if ($cat_title) $out .= "</outline>\n";

		return $out;
	}

	function opml_export($name, $owner_uid, $hide_private_feeds=false, $include_settings=true) {
		if (!$owner_uid) return;

		if (!isset($_REQUEST["debug"])) {
			header("Content-type: application/xml+opml");
			header("Content-Disposition: attachment; filename=" . $name );
		} else {
			header("Content-type: text/xml");
		}

		$out = "<?xml version=\"1.0\" encoding=\"utf-8\"?".">";

		$out .= "<opml version=\"1.0\">";
		$out .= "<head>
			<dateCreated>" . date("r", time()) . "</dateCreated>
			<title>Tiny Tiny RSS Feed Export</title>
		</head>";
		$out .= "<body>";

		$out .= $this->opml_export_category($owner_uid, false, $hide_private_feeds);

		# export tt-rss settings

		if ($include_settings) {
			$out .= "<outline text=\"tt-rss-prefs\" schema-version=\"".SCHEMA_VERSION."\">";

			$result = $this->dbh->query("SELECT pref_name, value FROM ttrss_user_prefs WHERE
			   profile IS NULL AND owner_uid = " . $_SESSION["uid"] . " ORDER BY pref_name");

			while ($line = $this->dbh->fetch_assoc($result)) {
				$name = $line["pref_name"];
				$value = htmlspecialchars($line["value"]);

				$out .= "<outline pref-name=\"$name\" value=\"$value\"/>";
			}

			$out .= "</outline>";

			$out .= "<outline text=\"tt-rss-labels\" schema-version=\"".SCHEMA_VERSION."\">";

			$result = $this->dbh->query("SELECT * FROM ttrss_labels2 WHERE
				owner_uid = " . $_SESSION['uid']);

			while ($line = $this->dbh->fetch_assoc($result)) {
				$name = htmlspecialchars($line['caption']);
				$fg_color = htmlspecialchars($line['fg_color']);
				$bg_color = htmlspecialchars($line['bg_color']);

				$out .= "<outline label-name=\"$name\" label-fg-color=\"$fg_color\" label-bg-color=\"$bg_color\"/>";

			}

			$out .= "</outline>";

			$out .= "<outline text=\"tt-rss-filters\" schema-version=\"".SCHEMA_VERSION."\">";

			$result = $this->dbh->query("SELECT * FROM ttrss_filters2
				WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY id");

			while ($line = $this->dbh->fetch_assoc($result)) {
				foreach (array('enabled', 'match_any_rule', 'inverse') as $b) {
					$line[$b] = sql_bool_to_bool($line[$b]);
				}

				$line["rules"] = array();
				$line["actions"] = array();

				$tmp_result = $this->dbh->query("SELECT * FROM ttrss_filters2_rules
					WHERE filter_id = ".$line["id"]);

				while ($tmp_line = $this->dbh->fetch_assoc($tmp_result)) {
					unset($tmp_line["id"]);
					unset($tmp_line["filter_id"]);

					$cat_filter = sql_bool_to_bool($tmp_line["cat_filter"]);

					if ($cat_filter && $tmp_line["cat_id"] || $tmp_line["feed_id"]) {
						$tmp_line["feed"] = getFeedTitle(
							$cat_filter ? $tmp_line["cat_id"] : $tmp_line["feed_id"],
							$cat_filter);
					} else {
						$tmp_line["feed"] = "";
					}

					$tmp_line["cat_filter"] = sql_bool_to_bool($tmp_line["cat_filter"]);
					$tmp_line["inverse"] = sql_bool_to_bool($tmp_line["inverse"]);

					unset($tmp_line["feed_id"]);
					unset($tmp_line["cat_id"]);

					array_push($line["rules"], $tmp_line);
				}

				$tmp_result = $this->dbh->query("SELECT * FROM ttrss_filters2_actions
					WHERE filter_id = ".$line["id"]);

				while ($tmp_line = $this->dbh->fetch_assoc($tmp_result)) {
					unset($tmp_line["id"]);
					unset($tmp_line["filter_id"]);

					array_push($line["actions"], $tmp_line);
				}

				unset($line["id"]);
				unset($line["owner_uid"]);
				$filter = json_encode($line);

				$out .= "<outline filter-type=\"2\"><![CDATA[$filter]]></outline>";

			}


			$out .= "</outline>";
		}

		$out .= "</body></opml>";

		// Format output.
		$doc = new DOMDocument();
		$doc->formatOutput = true;
		$doc->preserveWhiteSpace = false;
		$doc->loadXML($out);

		$xpath = new DOMXpath($doc);
		$outlines = $xpath->query("//outline[@title]");

		// cleanup empty categories
		foreach ($outlines as $node) {
			if ($node->getElementsByTagName('outline')->length == 0)
				$node->parentNode->removeChild($node);
		}

		$res = $doc->saveXML();

/*		// saveXML uses a two-space indent.  Change to tabs.
		$res = preg_replace_callback('/^(?:  )+/mu',
			create_function(
				'$matches',
				'return str_repeat("\t", intval(strlen($matches[0])/2));'),
			$res); */

		print $res;
	}

	// Import

	private function opml_import_feed($doc, $node, $cat_id, $owner_uid) {
		$attrs = $node->attributes;

		$feed_title = $this->dbh->escape_string(mb_substr($attrs->getNamedItem('text')->nodeValue, 0, 250));
		if (!$feed_title) $feed_title = $this->dbh->escape_string(mb_substr($attrs->getNamedItem('title')->nodeValue, 0, 250));

		$feed_url = $this->dbh->escape_string($attrs->getNamedItem('xmlUrl')->nodeValue);
		if (!$feed_url) $feed_url = $this->dbh->escape_string($attrs->getNamedItem('xmlURL')->nodeValue);

		$site_url = $this->dbh->escape_string(mb_substr($attrs->getNamedItem('htmlUrl')->nodeValue, 0, 250));

		if ($feed_url && $feed_title) {
			$result = $this->dbh->query("SELECT id FROM ttrss_feeds WHERE
				feed_url = '$feed_url' AND owner_uid = '$owner_uid'");

			if ($this->dbh->num_rows($result) == 0) {
				#$this->opml_notice("[FEED] [$feed_title/$feed_url] dst_CAT=$cat_id");
				$this->opml_notice(T_sprintf("Adding feed: %s", $feed_title));

				if (!$cat_id) $cat_id = 'NULL';

				$query = "INSERT INTO ttrss_feeds
					(title, feed_url, owner_uid, cat_id, site_url, order_id) VALUES
					('$feed_title', '$feed_url', '$owner_uid',
					$cat_id, '$site_url', 0)";
				$this->dbh->query($query);

			} else {
				$this->opml_notice(T_sprintf("Duplicate feed: %s", $feed_title));
			}
		}
	}

	private function opml_import_label($doc, $node, $owner_uid) {
		$attrs = $node->attributes;
		$label_name = $this->dbh->escape_string($attrs->getNamedItem('label-name')->nodeValue);

		if ($label_name) {
			$fg_color = $this->dbh->escape_string($attrs->getNamedItem('label-fg-color')->nodeValue);
			$bg_color = $this->dbh->escape_string($attrs->getNamedItem('label-bg-color')->nodeValue);

			if (!label_find_id($label_name, $_SESSION['uid'])) {
				$this->opml_notice(T_sprintf("Adding label %s", htmlspecialchars($label_name)));
				label_create($label_name, $fg_color, $bg_color, $owner_uid);
			} else {
				$this->opml_notice(T_sprintf("Duplicate label: %s", htmlspecialchars($label_name)));
			}
		}
	}

	private function opml_import_preference($doc, $node, $owner_uid) {
		$attrs = $node->attributes;
		$pref_name = $this->dbh->escape_string($attrs->getNamedItem('pref-name')->nodeValue);

		if ($pref_name) {
			$pref_value = $this->dbh->escape_string($attrs->getNamedItem('value')->nodeValue);

			$this->opml_notice(T_sprintf("Setting preference key %s to %s",
				$pref_name, $pref_value));

			set_pref($pref_name, $pref_value);
		}
	}

	private function opml_import_filter($doc, $node, $owner_uid) {
		$attrs = $node->attributes;

		$filter_type = $this->dbh->escape_string($attrs->getNamedItem('filter-type')->nodeValue);

		if ($filter_type == '2') {
			$filter = json_decode($node->nodeValue, true);

			if ($filter) {
				$match_any_rule = bool_to_sql_bool($filter["match_any_rule"]);
				$enabled = bool_to_sql_bool($filter["enabled"]);
				$inverse = bool_to_sql_bool($filter["inverse"]);
				$title = db_escape_string($filter["title"]);

				$this->dbh->query("BEGIN");

				$this->dbh->query("INSERT INTO ttrss_filters2 (match_any_rule,enabled,inverse,title,owner_uid)
					VALUES ($match_any_rule, $enabled, $inverse, '$title',
					".$_SESSION["uid"].")");

				$result = $this->dbh->query("SELECT MAX(id) AS id FROM ttrss_filters2 WHERE
					owner_uid = ".$_SESSION["uid"]);
				$filter_id = $this->dbh->fetch_result($result, 0, "id");

				if ($filter_id) {
					$this->opml_notice(T_sprintf("Adding filter..."));

					foreach ($filter["rules"] as $rule) {
						$feed_id = "NULL";
						$cat_id = "NULL";

						if (!$rule["cat_filter"]) {
							$tmp_result = $this->dbh->query("SELECT id FROM ttrss_feeds
								WHERE title = '".$this->dbh->escape_string($rule["feed"])."' AND owner_uid = ".$_SESSION["uid"]);
							if ($this->dbh->num_rows($tmp_result) > 0) {
								$feed_id = $this->dbh->fetch_result($tmp_result, 0, "id");
							}
						} else {
							$tmp_result = $this->dbh->query("SELECT id FROM ttrss_feed_categories
								WHERE title = '".$this->dbh->escape_string($rule["feed"])."' AND owner_uid = ".$_SESSION["uid"]);

							if ($this->dbh->num_rows($tmp_result) > 0) {
								$cat_id = $this->dbh->fetch_result($tmp_result, 0, "id");
							}
						}

						$cat_filter = bool_to_sql_bool($rule["cat_filter"]);
						$reg_exp = $this->dbh->escape_string($rule["reg_exp"]);
						$filter_type = (int)$rule["filter_type"];
						$inverse = bool_to_sql_bool($rule["inverse"]);

						$this->dbh->query("INSERT INTO ttrss_filters2_rules (feed_id,cat_id,filter_id,filter_type,reg_exp,cat_filter,inverse)
							VALUES ($feed_id, $cat_id, $filter_id, $filter_type, '$reg_exp', $cat_filter,$inverse)");
					}

					foreach ($filter["actions"] as $action) {

						$action_id = (int)$action["action_id"];
						$action_param = $this->dbh->escape_string($action["action_param"]);

						$this->dbh->query("INSERT INTO ttrss_filters2_actions (filter_id,action_id,action_param)
							VALUES ($filter_id, $action_id, '$action_param')");
					}
				}

				$this->dbh->query("COMMIT");
			}
		}
	}

	private function opml_import_category($doc, $root_node, $owner_uid, $parent_id) {
		$body = $doc->getElementsByTagName('body');

		$default_cat_id = (int) get_feed_category('Imported feeds', false);

		if ($root_node) {
			$cat_title = $this->dbh->escape_string(mb_substr($root_node->attributes->getNamedItem('text')->nodeValue, 0, 250));

			if (!$cat_title)
				$cat_title = $this->dbh->escape_string(mb_substr($root_node->attributes->getNamedItem('title')->nodeValue, 0, 250));

			if (!in_array($cat_title, array("tt-rss-filters", "tt-rss-labels", "tt-rss-prefs"))) {
				$cat_id = get_feed_category($cat_title, $parent_id);
				$this->dbh->query("BEGIN");
				if ($cat_id === false) {
					add_feed_category($cat_title, $parent_id);
					$cat_id = get_feed_category($cat_title, $parent_id);
				}
				$this->dbh->query("COMMIT");
			} else {
				$cat_id = 0;
			}

			$outlines = $root_node->childNodes;

		} else {
			$xpath = new DOMXpath($doc);
			$outlines = $xpath->query("//opml/body/outline");

			$cat_id = 0;
		}

		#$this->opml_notice("[CAT] $cat_title id: $cat_id P_id: $parent_id");
		$this->opml_notice(T_sprintf("Processing category: %s", $cat_title ? $cat_title : __("Uncategorized")));

		foreach ($outlines as $node) {
			if ($node->hasAttributes() && strtolower($node->tagName) == "outline") {
				$attrs = $node->attributes;
				$node_cat_title = $this->dbh->escape_string($attrs->getNamedItem('text')->nodeValue);

				if (!$node_cat_title)
					$node_cat_title = $this->dbh->escape_string($attrs->getNamedItem('title')->nodeValue);

				$node_feed_url = $this->dbh->escape_string($attrs->getNamedItem('xmlUrl')->nodeValue);

				if ($node_cat_title && !$node_feed_url) {
					$this->opml_import_category($doc, $node, $owner_uid, $cat_id);
				} else {

					if (!$cat_id) {
						$dst_cat_id = $default_cat_id;
					} else {
						$dst_cat_id = $cat_id;
					}

					switch ($cat_title) {
					case "tt-rss-prefs":
						$this->opml_import_preference($doc, $node, $owner_uid);
						break;
					case "tt-rss-labels":
						$this->opml_import_label($doc, $node, $owner_uid);
						break;
					case "tt-rss-filters":
						$this->opml_import_filter($doc, $node, $owner_uid);
						break;
					default:
						$this->opml_import_feed($doc, $node, $dst_cat_id, $owner_uid);
					}
				}
			}
		}
	}

	function opml_import($owner_uid) {
		if (!$owner_uid) return;

		$debug = isset($_REQUEST["debug"]);
		$doc = false;

#		if ($debug) $doc = DOMDocument::load("/tmp/test.opml");

		if ($_FILES['opml_file']['error'] != 0) {
			print_error(T_sprintf("Upload failed with error code %d",
				$_FILES['opml_file']['error']));
			return;
		}

		$tmp_file = false;

		if (is_uploaded_file($_FILES['opml_file']['tmp_name'])) {
			$tmp_file = tempnam(CACHE_DIR . '/upload', 'opml');

			$result = move_uploaded_file($_FILES['opml_file']['tmp_name'],
				$tmp_file);

			if (!$result) {
				print_error(__("Unable to move uploaded file."));
				return;
			}
		} else {
			print_error(__('Error: please upload OPML file.'));
			return;
		}

		if (is_file($tmp_file)) {
			$doc = new DOMDocument();
			libxml_disable_entity_loader(false);
			$doc->load($tmp_file);
			libxml_disable_entity_loader(true);
			unlink($tmp_file);
		} else if (!$doc) {
			print_error(__('Error: unable to find moved OPML file.'));
			return;
		}

		if ($doc) {
			$this->opml_import_category($doc, false, $owner_uid, false);
		} else {
			print_error(__('Error while parsing document.'));
		}
	}

	private function opml_notice($msg) {
		print "$msg<br/>";
	}

	static function opml_publish_url(){

		$url_path = get_self_url_prefix();
		$url_path .= "/opml.php?op=publish&key=" .
			get_feed_access_key('OPML:Publish', false, $_SESSION["uid"]);

		return $url_path;
	}


}
?>
Commit	Line	Data
3f9de6cc	1	<?php
369dbc19	2	class Opml extends Handler_Protected {
3f9de6cc AD	3
	4	function csrf_ignore($method) {
	5	$csrf_ignored = array("export", "import");
	6
	7	return array_search($method, $csrf_ignored) !== false;
	8	}
	9
	10	function export() {
	11	$output_name = $_REQUEST["filename"];
	12	if (!$output_name) $output_name = "TinyTinyRSS.opml";
	13
	14	$show_settings = $_REQUEST["settings"];
	15
	16	$owner_uid = $_SESSION["uid"];
	17	return $this->opml_export($output_name, $owner_uid, false, ($show_settings == 1));
	18	}
	19
	20	function import() {
	21	$owner_uid = $_SESSION["uid"];
	22
	23	header('Content-Type: text/html; charset=utf-8');
	24
	25	print "<html>
	26	<head>
5bbc4bb4	27	<link rel=\"stylesheet\" href=\"css/utility.css\" type=\"text/css\">
3f9de6cc AD	28	<title>".__("OPML Utility")."</title>
	29	<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"/>
	30	</head>
	31	<body>
884d1650 AD	32	<div class=\"floatingLogo\"><img src=\"images/logo_small.png\"></div>
884d1650 AD	33	<h1>".__('OPML Utility')."</h1><div class='content'>";
3f9de6cc	34
a42c55f0	35	add_feed_category("Imported feeds");
3f9de6cc AD	36
	37	$this->opml_notice(__("Importing OPML..."));
	38	$this->opml_import($owner_uid);
	39
	40	print "<br><form method=\"GET\" action=\"prefs.php\">
	41	<input type=\"submit\" value=\"".__("Return to preferences")."\">
	42	</form>";
	43
884d1650	44	print "</div></body></html>";
3f9de6cc AD	45
	46
	47	}
	48
	49	// Export
	50
	51	private function opml_export_category($owner_uid, $cat_id, $hide_private_feeds=false) {
	52
	53	if ($cat_id) {
	54	$cat_qpart = "parent_cat = '$cat_id'";
	55	$feed_cat_qpart = "cat_id = '$cat_id'";
	56	} else {
	57	$cat_qpart = "parent_cat IS NULL";
	58	$feed_cat_qpart = "cat_id IS NULL";
	59	}
	60
	61	if ($hide_private_feeds)
	62	$hide_qpart = "(private IS false AND auth_login = '' AND auth_pass = '')";
	63	else
	64	$hide_qpart = "true";
	65
	66	$out = "";
	67
	68	if ($cat_id) {
d9c85e0f	69	$result = $this->dbh->query("SELECT title FROM ttrss_feed_categories WHERE id = '$cat_id'
3f9de6cc	70	AND owner_uid = '$owner_uid'");
d9c85e0f	71	$cat_title = htmlspecialchars($this->dbh->fetch_result($result, 0, "title"));
3f9de6cc AD	72	}
3f9de6cc AD	73
fd087799	74	if ($cat_title) $out .= "<outline text=\"$cat_title\">\n";
3f9de6cc	75
d9c85e0f	76	$result = $this->dbh->query("SELECT id,title
3f9de6cc AD	77	FROM ttrss_feed_categories WHERE
	78	$cat_qpart AND owner_uid = '$owner_uid' ORDER BY order_id, title");
	79
d9c85e0f	80	while ($line = $this->dbh->fetch_assoc($result)) {
3f9de6cc AD	81	$title = htmlspecialchars($line["title"]);
	82	$out .= $this->opml_export_category($owner_uid, $line["id"], $hide_private_feeds);
	83	}
	84
d9c85e0f	85	$feeds_result = $this->dbh->query("select title, feed_url, site_url
3f9de6cc AD	86	from ttrss_feeds where $feed_cat_qpart AND owner_uid = '$owner_uid' AND $hide_qpart
	87	order by order_id, title");
	88
d9c85e0f	89	while ($fline = $this->dbh->fetch_assoc($feeds_result)) {
3f9de6cc AD	90	$title = htmlspecialchars($fline["title"]);
	91	$url = htmlspecialchars($fline["feed_url"]);
	92	$site_url = htmlspecialchars($fline["site_url"]);
	93
	94	if ($site_url) {
	95	$html_url_qpart = "htmlUrl=\"$site_url\"";
	96	} else {
	97	$html_url_qpart = "";
	98	}
	99
7bdc1df1	100	$out .= "<outline type=\"rss\" text=\"$title\" xmlUrl=\"$url\" $html_url_qpart/>\n";
3f9de6cc AD	101	}
	102
	103	if ($cat_title) $out .= "</outline>\n";
	104
	105	return $out;
	106	}
	107
	108	function opml_export($name, $owner_uid, $hide_private_feeds=false, $include_settings=true) {
	109	if (!$owner_uid) return;
	110
	111	if (!isset($_REQUEST["debug"])) {
	112	header("Content-type: application/xml+opml");
	113	header("Content-Disposition: attachment; filename=" . $name );
	114	} else {
	115	header("Content-type: text/xml");
	116	}
	117
	118	$out = "<?xml version=\"1.0\" encoding=\"utf-8\"?".">";
	119
	120	$out .= "<opml version=\"1.0\">";
	121	$out .= "<head>
	122	<dateCreated>" . date("r", time()) . "</dateCreated>
	123	<title>Tiny Tiny RSS Feed Export</title>
	124	</head>";
	125	$out .= "<body>";
	126
	127	$out .= $this->opml_export_category($owner_uid, false, $hide_private_feeds);
	128
	129	# export tt-rss settings
	130
	131	if ($include_settings) {
fd087799	132	$out .= "<outline text=\"tt-rss-prefs\" schema-version=\"".SCHEMA_VERSION."\">";
3f9de6cc	133
d9c85e0f	134	$result = $this->dbh->query("SELECT pref_name, value FROM ttrss_user_prefs WHERE
3f9de6cc AD	135	profile IS NULL AND owner_uid = " . $_SESSION["uid"] . " ORDER BY pref_name");
3f9de6cc AD	136
d9c85e0f	137	while ($line = $this->dbh->fetch_assoc($result)) {
3f9de6cc AD	138	$name = $line["pref_name"];
	139	$value = htmlspecialchars($line["value"]);
	140
	141	$out .= "<outline pref-name=\"$name\" value=\"$value\"/>";
	142	}
	143
	144	$out .= "</outline>";
	145
fd087799	146	$out .= "<outline text=\"tt-rss-labels\" schema-version=\"".SCHEMA_VERSION."\">";
3f9de6cc	147
d9c85e0f	148	$result = $this->dbh->query("SELECT * FROM ttrss_labels2 WHERE
3f9de6cc AD	149	owner_uid = " . $_SESSION['uid']);
3f9de6cc AD	150
d9c85e0f	151	while ($line = $this->dbh->fetch_assoc($result)) {
3f9de6cc AD	152	$name = htmlspecialchars($line['caption']);
	153	$fg_color = htmlspecialchars($line['fg_color']);
	154	$bg_color = htmlspecialchars($line['bg_color']);
	155
	156	$out .= "<outline label-name=\"$name\" label-fg-color=\"$fg_color\" label-bg-color=\"$bg_color\"/>";
	157
	158	}
	159
	160	$out .= "</outline>";
	161
fd087799	162	$out .= "<outline text=\"tt-rss-filters\" schema-version=\"".SCHEMA_VERSION."\">";
3f9de6cc	163
d9c85e0f	164	$result = $this->dbh->query("SELECT * FROM ttrss_filters2
fd994f1a	165	WHERE owner_uid = ".$_SESSION["uid"]." ORDER BY id");
3f9de6cc	166
d9c85e0f	167	while ($line = $this->dbh->fetch_assoc($result)) {
a1495542	168	foreach (array('enabled', 'match_any_rule', 'inverse') as $b) {
3f9de6cc AD	169	$line[$b] = sql_bool_to_bool($line[$b]);
	170	}
	171
fd994f1a AD	172	$line["rules"] = array();
	173	$line["actions"] = array();
	174
d9c85e0f	175	$tmp_result = $this->dbh->query("SELECT * FROM ttrss_filters2_rules
fd994f1a AD	176	WHERE filter_id = ".$line["id"]);
fd994f1a AD	177
d9c85e0f	178	while ($tmp_line = $this->dbh->fetch_assoc($tmp_result)) {
fd994f1a AD	179	unset($tmp_line["id"]);
	180	unset($tmp_line["filter_id"]);
	181
	182	$cat_filter = sql_bool_to_bool($tmp_line["cat_filter"]);
	183
	184	if ($cat_filter && $tmp_line["cat_id"] \|\| $tmp_line["feed_id"]) {
6322ac79	185	$tmp_line["feed"] = getFeedTitle(
fd994f1a AD	186	$cat_filter ? $tmp_line["cat_id"] : $tmp_line["feed_id"],
	187	$cat_filter);
	188	} else {
	189	$tmp_line["feed"] = "";
	190	}
	191
8592a8e3	192	$tmp_line["cat_filter"] = sql_bool_to_bool($tmp_line["cat_filter"]);
afa1a260	193	$tmp_line["inverse"] = sql_bool_to_bool($tmp_line["inverse"]);
8592a8e3	194
fd994f1a AD	195	unset($tmp_line["feed_id"]);
	196	unset($tmp_line["cat_id"]);
	197
	198	array_push($line["rules"], $tmp_line);
	199	}
	200
d9c85e0f	201	$tmp_result = $this->dbh->query("SELECT * FROM ttrss_filters2_actions
fd994f1a AD	202	WHERE filter_id = ".$line["id"]);
fd994f1a AD	203
d9c85e0f	204	while ($tmp_line = $this->dbh->fetch_assoc($tmp_result)) {
fd994f1a AD	205	unset($tmp_line["id"]);
	206	unset($tmp_line["filter_id"]);
	207
	208	array_push($line["actions"], $tmp_line);
	209	}
	210
	211	unset($line["id"]);
	212	unset($line["owner_uid"]);
3f9de6cc AD	213	$filter = json_encode($line);
3f9de6cc AD	214
dd0a17b0	215	$out .= "<outline filter-type=\"2\"><![CDATA[$filter]]></outline>";
3f9de6cc AD	216
	217	}
	218
	219
fd994f1a	220	$out .= "</outline>";
3f9de6cc AD	221	}
	222
	223	$out .= "</body></opml>";
	224
	225	// Format output.
	226	$doc = new DOMDocument();
	227	$doc->formatOutput = true;
	228	$doc->preserveWhiteSpace = false;
	229	$doc->loadXML($out);
	230
	231	$xpath = new DOMXpath($doc);
	232	$outlines = $xpath->query("//outline[@title]");
	233
	234	// cleanup empty categories
	235	foreach ($outlines as $node) {
	236	if ($node->getElementsByTagName('outline')->length == 0)
	237	$node->parentNode->removeChild($node);
	238	}
	239
	240	$res = $doc->saveXML();
	241
dd0a17b0	242	/* // saveXML uses a two-space indent. Change to tabs.
3f9de6cc AD	243	$res = preg_replace_callback('/^(?: )+/mu',
	244	create_function(
	245	'$matches',
	246	'return str_repeat("\t", intval(strlen($matches[0])/2));'),
dd0a17b0	247	$res); */
3f9de6cc AD	248
	249	print $res;
	250	}
	251
	252	// Import
	253
	254	private function opml_import_feed($doc, $node, $cat_id, $owner_uid) {
	255	$attrs = $node->attributes;
	256
d9c85e0f AD	257	$feed_title = $this->dbh->escape_string(mb_substr($attrs->getNamedItem('text')->nodeValue, 0, 250));
d9c85e0f AD	258	if (!$feed_title) $feed_title = $this->dbh->escape_string(mb_substr($attrs->getNamedItem('title')->nodeValue, 0, 250));
3f9de6cc	259
6bb05128 AD	260	$feed_url = $this->dbh->escape_string($attrs->getNamedItem('xmlUrl')->nodeValue);
6bb05128 AD	261	if (!$feed_url) $feed_url = $this->dbh->escape_string($attrs->getNamedItem('xmlURL')->nodeValue);
3f9de6cc	262
d9c85e0f	263	$site_url = $this->dbh->escape_string(mb_substr($attrs->getNamedItem('htmlUrl')->nodeValue, 0, 250));
3f9de6cc AD	264
3f9de6cc AD	265	if ($feed_url && $feed_title) {
d9c85e0f	266	$result = $this->dbh->query("SELECT id FROM ttrss_feeds WHERE
3f9de6cc AD	267	feed_url = '$feed_url' AND owner_uid = '$owner_uid'");
3f9de6cc AD	268
d9c85e0f	269	if ($this->dbh->num_rows($result) == 0) {
3f9de6cc AD	270	#$this->opml_notice("[FEED] [$feed_title/$feed_url] dst_CAT=$cat_id");
	271	$this->opml_notice(T_sprintf("Adding feed: %s", $feed_title));
	272
dd0a17b0 AD	273	if (!$cat_id) $cat_id = 'NULL';
dd0a17b0 AD	274
3f9de6cc AD	275	$query = "INSERT INTO ttrss_feeds
	276	(title, feed_url, owner_uid, cat_id, site_url, order_id) VALUES
	277	('$feed_title', '$feed_url', '$owner_uid',
dd0a17b0	278	$cat_id, '$site_url', 0)";
d9c85e0f	279	$this->dbh->query($query);
3f9de6cc AD	280
	281	} else {
	282	$this->opml_notice(T_sprintf("Duplicate feed: %s", $feed_title));
	283	}
	284	}
	285	}
	286
	287	private function opml_import_label($doc, $node, $owner_uid) {
	288	$attrs = $node->attributes;
d9c85e0f	289	$label_name = $this->dbh->escape_string($attrs->getNamedItem('label-name')->nodeValue);
3f9de6cc AD	290
3f9de6cc AD	291	if ($label_name) {
d9c85e0f AD	292	$fg_color = $this->dbh->escape_string($attrs->getNamedItem('label-fg-color')->nodeValue);
d9c85e0f AD	293	$bg_color = $this->dbh->escape_string($attrs->getNamedItem('label-bg-color')->nodeValue);
3f9de6cc	294
a42c55f0	295	if (!label_find_id($label_name, $_SESSION['uid'])) {
3f9de6cc	296	$this->opml_notice(T_sprintf("Adding label %s", htmlspecialchars($label_name)));
a42c55f0	297	label_create($label_name, $fg_color, $bg_color, $owner_uid);
3f9de6cc AD	298	} else {
	299	$this->opml_notice(T_sprintf("Duplicate label: %s", htmlspecialchars($label_name)));
	300	}
	301	}
	302	}
	303
	304	private function opml_import_preference($doc, $node, $owner_uid) {
	305	$attrs = $node->attributes;
d9c85e0f	306	$pref_name = $this->dbh->escape_string($attrs->getNamedItem('pref-name')->nodeValue);
3f9de6cc AD	307
3f9de6cc AD	308	if ($pref_name) {
d9c85e0f	309	$pref_value = $this->dbh->escape_string($attrs->getNamedItem('value')->nodeValue);
3f9de6cc AD	310
	311	$this->opml_notice(T_sprintf("Setting preference key %s to %s",
	312	$pref_name, $pref_value));
	313
a42c55f0	314	set_pref($pref_name, $pref_value);
3f9de6cc AD	315	}
	316	}
	317
3b003f63	318	private function opml_import_filter($doc, $node, $owner_uid) {
3f9de6cc AD	319	$attrs = $node->attributes;
3f9de6cc AD	320
d9c85e0f	321	$filter_type = $this->dbh->escape_string($attrs->getNamedItem('filter-type')->nodeValue);
3f9de6cc	322
3b003f63 AD	323	if ($filter_type == '2') {
3b003f63 AD	324	$filter = json_decode($node->nodeValue, true);
3f9de6cc AD	325
3f9de6cc AD	326	if ($filter) {
3b003f63 AD	327	$match_any_rule = bool_to_sql_bool($filter["match_any_rule"]);
3b003f63 AD	328	$enabled = bool_to_sql_bool($filter["enabled"]);
a1495542 AD	329	$inverse = bool_to_sql_bool($filter["inverse"]);
a1495542 AD	330	$title = db_escape_string($filter["title"]);
3f9de6cc	331
d9c85e0f	332	$this->dbh->query("BEGIN");
3f9de6cc	333
a1495542 AD	334	$this->dbh->query("INSERT INTO ttrss_filters2 (match_any_rule,enabled,inverse,title,owner_uid)
	335	VALUES ($match_any_rule, $enabled, $inverse, '$title',
	336	".$_SESSION["uid"].")");
3b003f63	337
d9c85e0f	338	$result = $this->dbh->query("SELECT MAX(id) AS id FROM ttrss_filters2 WHERE
3b003f63	339	owner_uid = ".$_SESSION["uid"]);
d9c85e0f	340	$filter_id = $this->dbh->fetch_result($result, 0, "id");
3b003f63 AD	341
	342	if ($filter_id) {
	343	$this->opml_notice(T_sprintf("Adding filter..."));
	344
	345	foreach ($filter["rules"] as $rule) {
	346	$feed_id = "NULL";
3f9de6cc	347	$cat_id = "NULL";
3f9de6cc	348
3b003f63	349	if (!$rule["cat_filter"]) {
d9c85e0f AD	350	$tmp_result = $this->dbh->query("SELECT id FROM ttrss_feeds
	351	WHERE title = '".$this->dbh->escape_string($rule["feed"])."' AND owner_uid = ".$_SESSION["uid"]);
	352	if ($this->dbh->num_rows($tmp_result) > 0) {
	353	$feed_id = $this->dbh->fetch_result($tmp_result, 0, "id");
3b003f63 AD	354	}
3b003f63 AD	355	} else {
d9c85e0f AD	356	$tmp_result = $this->dbh->query("SELECT id FROM ttrss_feed_categories
d9c85e0f AD	357	WHERE title = '".$this->dbh->escape_string($rule["feed"])."' AND owner_uid = ".$_SESSION["uid"]);
3b003f63	358
d9c85e0f AD	359	if ($this->dbh->num_rows($tmp_result) > 0) {
d9c85e0f AD	360	$cat_id = $this->dbh->fetch_result($tmp_result, 0, "id");
3b003f63 AD	361	}
	362	}
	363
	364	$cat_filter = bool_to_sql_bool($rule["cat_filter"]);
d9c85e0f	365	$reg_exp = $this->dbh->escape_string($rule["reg_exp"]);
3b003f63	366	$filter_type = (int)$rule["filter_type"];
afa1a260	367	$inverse = bool_to_sql_bool($rule["inverse"]);
3b003f63	368
afa1a260 AD	369	$this->dbh->query("INSERT INTO ttrss_filters2_rules (feed_id,cat_id,filter_id,filter_type,reg_exp,cat_filter,inverse)
afa1a260 AD	370	VALUES ($feed_id, $cat_id, $filter_id, $filter_type, '$reg_exp', $cat_filter,$inverse)");
3b003f63	371	}
3f9de6cc	372
3b003f63	373	foreach ($filter["actions"] as $action) {
3f9de6cc	374
3b003f63	375	$action_id = (int)$action["action_id"];
d9c85e0f	376	$action_param = $this->dbh->escape_string($action["action_param"]);
3f9de6cc	377
d9c85e0f	378	$this->dbh->query("INSERT INTO ttrss_filters2_actions (filter_id,action_id,action_param)
3b003f63 AD	379	VALUES ($filter_id, $action_id, '$action_param')");
3b003f63 AD	380	}
3f9de6cc	381	}
3b003f63	382
d9c85e0f	383	$this->dbh->query("COMMIT");
3f9de6cc AD	384	}
3f9de6cc AD	385	}
3b003f63	386	}
3f9de6cc AD	387
	388	private function opml_import_category($doc, $root_node, $owner_uid, $parent_id) {
	389	$body = $doc->getElementsByTagName('body');
	390
a42c55f0	391	$default_cat_id = (int) get_feed_category('Imported feeds', false);
3f9de6cc AD	392
3f9de6cc AD	393	if ($root_node) {
d9c85e0f	394	$cat_title = $this->dbh->escape_string(mb_substr($root_node->attributes->getNamedItem('text')->nodeValue, 0, 250));
3f9de6cc	395
cc616ea1	396	if (!$cat_title)
d9c85e0f	397	$cat_title = $this->dbh->escape_string(mb_substr($root_node->attributes->getNamedItem('title')->nodeValue, 0, 250));
cc616ea1	398
3f9de6cc	399	if (!in_array($cat_title, array("tt-rss-filters", "tt-rss-labels", "tt-rss-prefs"))) {
a42c55f0	400	$cat_id = get_feed_category($cat_title, $parent_id);
d9c85e0f	401	$this->dbh->query("BEGIN");
3f9de6cc	402	if ($cat_id === false) {
a42c55f0 AD	403	add_feed_category($cat_title, $parent_id);
a42c55f0 AD	404	$cat_id = get_feed_category($cat_title, $parent_id);
3f9de6cc	405	}
d9c85e0f	406	$this->dbh->query("COMMIT");
3f9de6cc AD	407	} else {
	408	$cat_id = 0;
	409	}
	410
	411	$outlines = $root_node->childNodes;
	412
	413	} else {
	414	$xpath = new DOMXpath($doc);
	415	$outlines = $xpath->query("//opml/body/outline");
	416
	417	$cat_id = 0;
	418	}
	419
	420	#$this->opml_notice("[CAT] $cat_title id: $cat_id P_id: $parent_id");
	421	$this->opml_notice(T_sprintf("Processing category: %s", $cat_title ? $cat_title : __("Uncategorized")));
	422
	423	foreach ($outlines as $node) {
	424	if ($node->hasAttributes() && strtolower($node->tagName) == "outline") {
	425	$attrs = $node->attributes;
d9c85e0f	426	$node_cat_title = $this->dbh->escape_string($attrs->getNamedItem('text')->nodeValue);
cc616ea1 AD	427
cc616ea1 AD	428	if (!$node_cat_title)
d9c85e0f	429	$node_cat_title = $this->dbh->escape_string($attrs->getNamedItem('title')->nodeValue);
cc616ea1	430
d9c85e0f	431	$node_feed_url = $this->dbh->escape_string($attrs->getNamedItem('xmlUrl')->nodeValue);
3f9de6cc AD	432
	433	if ($node_cat_title && !$node_feed_url) {
	434	$this->opml_import_category($doc, $node, $owner_uid, $cat_id);
	435	} else {
	436
	437	if (!$cat_id) {
	438	$dst_cat_id = $default_cat_id;
	439	} else {
	440	$dst_cat_id = $cat_id;
	441	}
	442
	443	switch ($cat_title) {
	444	case "tt-rss-prefs":
	445	$this->opml_import_preference($doc, $node, $owner_uid);
	446	break;
	447	case "tt-rss-labels":
	448	$this->opml_import_label($doc, $node, $owner_uid);
	449	break;
	450	case "tt-rss-filters":
3b003f63	451	$this->opml_import_filter($doc, $node, $owner_uid);
3f9de6cc AD	452	break;
	453	default:
	454	$this->opml_import_feed($doc, $node, $dst_cat_id, $owner_uid);
	455	}
	456	}
	457	}
	458	}
	459	}
	460
	461	function opml_import($owner_uid) {
	462	if (!$owner_uid) return;
	463
	464	$debug = isset($_REQUEST["debug"]);
	465	$doc = false;
	466
5a49ed95	467	# if ($debug) $doc = DOMDocument::load("/tmp/test.opml");
3f9de6cc	468
3306daec AD	469	if ($_FILES['opml_file']['error'] != 0) {
	470	print_error(T_sprintf("Upload failed with error code %d",
	471	$_FILES['opml_file']['error']));
	472	return;
	473	}
	474
	475	$tmp_file = false;
	476
	477	if (is_uploaded_file($_FILES['opml_file']['tmp_name'])) {
	478	$tmp_file = tempnam(CACHE_DIR . '/upload', 'opml');
	479
	480	$result = move_uploaded_file($_FILES['opml_file']['tmp_name'],
	481	$tmp_file);
	482
	483	if (!$result) {
	484	print_error(__("Unable to move uploaded file."));
	485	return;
	486	}
	487	} else {
	488	print_error(__('Error: please upload OPML file.'));
	489	return;
	490	}
	491
	492	if (is_file($tmp_file)) {
98c39afc	493	$doc = new DOMDocument();
3457ce7c	494	libxml_disable_entity_loader(false);
3306daec	495	$doc->load($tmp_file);
3457ce7c	496	libxml_disable_entity_loader(true);
3306daec	497	unlink($tmp_file);
3f9de6cc	498	} else if (!$doc) {
3306daec	499	print_error(__('Error: unable to find moved OPML file.'));
3f9de6cc AD	500	return;
	501	}
	502
	503	if ($doc) {
	504	$this->opml_import_category($doc, false, $owner_uid, false);
	505	} else {
	506	print_error(__('Error while parsing document.'));
	507	}
	508	}
	509
	510	private function opml_notice($msg) {
	511	print "$msg<br/>";
	512	}
	513
6322ac79	514	static function opml_publish_url(){
50832719 AD	515
	516	$url_path = get_self_url_prefix();
	517	$url_path .= "/opml.php?op=publish&key=" .
a42c55f0	518	get_feed_access_key('OPML:Publish', false, $_SESSION["uid"]);
50832719 AD	519
	520	return $url_path;
	521	}
	522
	523
3f9de6cc AD	524	}
3f9de6cc AD	525	?>