[tt-rss.git] / opml.php

<?
	session_start();

	require_once "sanity_check.php";

	// FIXME there are some brackets issues here

	$op = $_REQUEST["op"];
	if ($op == "Export") {
		header("Content-type: application/xml");
		print "<?xml version=\"1.0\"?>";
	}

	require_once "config.php";
	require_once "db.php";
	require_once "db-prefs.php";

//	$_SESSION["uid"] = PLACEHOLDER_UID; // FIXME: placeholder

	$link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);	

	if (DB_TYPE == "pgsql") {
		pg_query($link, "set client_encoding = 'utf-8'");
	}

	if ($op == "Export") {
		print "<opml version=\"1.0\">";
		print "<head><dateCreated>" . date("r", time()) . "</dateCreated></head>"; 
		print "<body>";

		$cat_mode = false;

		if (get_pref($link, 'ENABLE_FEED_CATS')) {
			$cat_mode = true;
			$result = db_query($link, "SELECT 
					ttrss_feeds.feed_url AS feed_url,
					ttrss_feeds.title AS title,
					ttrss_feed_categories.title AS cat_title
				FROM ttrss_feeds,ttrss_feed_categories 
				WHERE
					cat_id = ttrss_feed_categories.id
				ORDER BY ttrss_feed_categories.title,ttrss_feeds.title");
		} else {
			$result = db_query($link, "SELECT * FROM ttrss_feeds 
				ORDER BY title");
		}

		$old_cat_title = "";

		while ($line = db_fetch_assoc($result)) {
			$title = htmlspecialchars($line["title"]);
			$url = htmlspecialchars($line["feed_url"]);

			if ($cat_mode) {
				$cat_title = htmlspecialchars($line["cat_title"]);

				if ($old_cat_title != $cat_title) {
					if ($old_cat_title) {
						print "</outline>";	
					}

					print "<outline text=\"$cat_title\">";

					$old_cat_title = $cat_title;
				}
			}

			print "<outline text=\"$title\" xmlUrl=\"$url\"/>";
		}

		if ($cat_mode && $old_cat_title) {
			print "</outline>";	
		}

		print "</body></opml>";
	}

	function startElement($parser, $name, $attrs) {

		if ($name == "OUTLINE") {
			if ($name == "OUTLINE") {

				$title = $attrs["TEXT"];
				$url = $attrs["XMLURL"];

				if (!$title) {
					$title = $attrs['TITLE'];
				}
			}

			/* this is suboptimal */

			$link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);	

			if (!$link) return;

			$title = db_escape_string_2($title, $link);
			$url = db_escape_string_2($url, $link);

			if (!$title || !$url) return;

			print "Feed <b>$title</b> ($url)... ";

			$result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
				(title = '$title' OR feed_url = '$url') AND owner_uid = ".$_SESSION["uid"]);

			if ($result && db_num_rows($result) > 0) {
				
				print " Already imported.<br>";

			} else {
					  
				$result = db_query($link, "INSERT INTO ttrss_feeds (title, feed_url,owner_uid) VALUES
					('$title', '$url', '".$_SESSION["uid"]."')");

				print "<b>Done.</b><br>";

			}

			if ($link) db_close($link);

		}
	}

	function endElement($parser, $name) {


	}

	if ($op == "Import") {

		print "<html>
			<head>
				<link rel=\"stylesheet\" href=\"opml.css\" type=\"text/css\">
			</head>
			<body><h1>Importing OPML...</h1>
			<div>";

		if (WEB_DEMO_MODE) {
			print "OPML import is disabled in demo-mode.";
			print "<p><a class=\"button\" href=\"prefs.php\">
			Return to preferences</a></div></body></html>";

			return;
		}

		if (is_file($_FILES['opml_file']['tmp_name'])) {
		 
			$xml_parser = xml_parser_create();

			xml_set_element_handler($xml_parser, "startElement", "endElement");

			$fp = fopen($_FILES['opml_file']['tmp_name'], "r");

			if ($fp) {

				while ($data = fread($fp, 4096)) {

					if (!xml_parse($xml_parser, $data, feof($fp))) {
						
						print sprintf("Unable to parse OPML file, XML error: %s at line %d",
							xml_error_string(xml_get_error_code($xml_parser)),
							xml_get_current_line_number($xml_parser));

						print "<p><a class=\"button\" href=\"prefs.php\">
							Return to preferences</a>";

						return;

					}
				}

				xml_parser_free($xml_parser);
				fclose($fp);

			} else {
				print("Error: Could not open OPML input.");
			}

		} else {	
			print "Error: please upload OPML file.";
		}

		print "<p><a class=\"button\" href=\"prefs.php\">
			Return to preferences</a>";

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

	}

//	if ($link) db_close($link);

?>
Commit	Line	Data
9a4506c8	1	<?
5d3f29da AD	2	session_start();
5d3f29da AD	3
66581886 AD	4	require_once "sanity_check.php";
66581886 AD	5
9a4506c8 AD	6	// FIXME there are some brackets issues here
9a4506c8 AD	7
9f311df6 AD	8	$op = $_REQUEST["op"];
9f311df6 AD	9	if ($op == "Export") {
9a4506c8	10	header("Content-type: application/xml");
eac7480c	11	print "<?xml version=\"1.0\"?>";
9a4506c8 AD	12	}
	13
	14	require_once "config.php";
8158c57a	15	require_once "db.php";
a0111294	16	require_once "db-prefs.php";
9a4506c8	17
1c7f75ed	18	// $_SESSION["uid"] = PLACEHOLDER_UID; // FIXME: placeholder
5d3f29da	19
8158c57a	20	$link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
9f311df6	21
8158c57a AD	22	if (DB_TYPE == "pgsql") {
	23	pg_query($link, "set client_encoding = 'utf-8'");
	24	}
9a4506c8	25
9f311df6	26	if ($op == "Export") {
9a4506c8 AD	27	print "<opml version=\"1.0\">";
	28	print "<head><dateCreated>" . date("r", time()) . "</dateCreated></head>";
	29	print "<body>";
	30
da49ccf5 AD	31	$cat_mode = false;
	32
	33	if (get_pref($link, 'ENABLE_FEED_CATS')) {
	34	$cat_mode = true;
	35	$result = db_query($link, "SELECT
	36	ttrss_feeds.feed_url AS feed_url,
	37	ttrss_feeds.title AS title,
	38	ttrss_feed_categories.title AS cat_title
	39	FROM ttrss_feeds,ttrss_feed_categories
	40	WHERE
	41	cat_id = ttrss_feed_categories.id
	42	ORDER BY ttrss_feed_categories.title,ttrss_feeds.title");
	43	} else {
	44	$result = db_query($link, "SELECT * FROM ttrss_feeds
	45	ORDER BY title");
	46	}
	47
	48	$old_cat_title = "";
9a4506c8	49
8158c57a	50	while ($line = db_fetch_assoc($result)) {
6e0584e9 AD	51	$title = htmlspecialchars($line["title"]);
6e0584e9 AD	52	$url = htmlspecialchars($line["feed_url"]);
9a4506c8	53
da49ccf5 AD	54	if ($cat_mode) {
	55	$cat_title = htmlspecialchars($line["cat_title"]);
	56
	57	if ($old_cat_title != $cat_title) {
	58	if ($old_cat_title) {
	59	print "</outline>";
	60	}
	61
	62	print "<outline text=\"$cat_title\">";
	63
	64	$old_cat_title = $cat_title;
	65	}
	66	}
	67
9a4506c8 AD	68	print "<outline text=\"$title\" xmlUrl=\"$url\"/>";
	69	}
	70
da49ccf5 AD	71	if ($cat_mode && $old_cat_title) {
	72	print "</outline>";
	73	}
	74
9a4506c8 AD	75	print "</body></opml>";
	76	}
	77
9f311df6	78	function startElement($parser, $name, $attrs) {
8158c57a	79
9f311df6	80	if ($name == "OUTLINE") {
d212ce0e AD	81	if ($name == "OUTLINE") {
	82
	83	$title = $attrs["TEXT"];
	84	$url = $attrs["XMLURL"];
	85
	86	if (!$title) {
	87	$title = $attrs['TITLE'];
	88	}
	89	}
9f311df6	90
8b7395bb AD	91	/* this is suboptimal */
	92
	93	$link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
	94
	95	if (!$link) return;
	96
	97	$title = db_escape_string_2($title, $link);
	98	$url = db_escape_string_2($url, $link);
	99
f179a35d AD	100	if (!$title \|\| !$url) return;
f179a35d AD	101
9f311df6 AD	102	print "Feed <b>$title</b> ($url)... ";
9f311df6 AD	103
b76cdb2f	104	$result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
5d3f29da	105	(title = '$title' OR feed_url = '$url') AND owner_uid = ".$_SESSION["uid"]);
9f311df6	106
b76cdb2f	107	if ($result && db_num_rows($result) > 0) {
9f311df6 AD	108
	109	print " Already imported.<br>";
	110
	111	} else {
b76cdb2f	112
5d3f29da AD	113	$result = db_query($link, "INSERT INTO ttrss_feeds (title, feed_url,owner_uid) VALUES
5d3f29da AD	114	('$title', '$url', '".$_SESSION["uid"]."')");
9f311df6 AD	115
	116	print "<b>Done.</b><br>";
	117
	118	}
	119
7118b7ac AD	120	if ($link) db_close($link);
7118b7ac AD	121
9f311df6 AD	122	}
	123	}
	124
	125	function endElement($parser, $name) {
	126
	127
	128	}
	129
	130	if ($op == "Import") {
eac7480c	131
9f311df6 AD	132	print "<html>
	133	<head>
	134	<link rel=\"stylesheet\" href=\"opml.css\" type=\"text/css\">
	135	</head>
	136	<body><h1>Importing OPML...</h1>
	137	<div>";
	138
4769ddaf	139	if (WEB_DEMO_MODE) {
eac7480c AD	140	print "OPML import is disabled in demo-mode.";
	141	print "<p><a class=\"button\" href=\"prefs.php\">
	142	Return to preferences</a></div></body></html>";
	143
	144	return;
	145	}
	146
	147	if (is_file($_FILES['opml_file']['tmp_name'])) {
9f311df6 AD	148
	149	$xml_parser = xml_parser_create();
	150
	151	xml_set_element_handler($xml_parser, "startElement", "endElement");
	152
	153	$fp = fopen($_FILES['opml_file']['tmp_name'], "r");
	154
	155	if ($fp) {
	156
	157	while ($data = fread($fp, 4096)) {
	158
	159	if (!xml_parse($xml_parser, $data, feof($fp))) {
	160
	161	print sprintf("Unable to parse OPML file, XML error: %s at line %d",
	162	xml_error_string(xml_get_error_code($xml_parser)),
	163	xml_get_current_line_number($xml_parser));
	164
	165	print "<p><a class=\"button\" href=\"prefs.php\">
	166	Return to preferences</a>";
	167
	168	return;
	169
	170	}
	171	}
	172
	173	xml_parser_free($xml_parser);
	174	fclose($fp);
	175
	176	} else {
	177	print("Error: Could not open OPML input.");
	178	}
	179
	180	} else {
	181	print "Error: please upload OPML file.";
	182	}
	183
	184	print "<p><a class=\"button\" href=\"prefs.php\">
	185	Return to preferences</a>";
	186
	187	print "</div></body></html>";
	188
	189	}
	190
3d477c2c	191	// if ($link) db_close($link);
9f311df6	192
9a4506c8	193	?>