]>
git.wh0rd.org - tt-rss.git/blob - opml.php
2 // FIXME there are some brackets issues here
6 header("Content-type: application/xml");
7 print "<?xml version=\"1.0\"?>";
10 require_once "config.php";
11 require_once "db.php";
13 $link = db_connect(DB_HOST
, DB_USER
, DB_PASS
, DB_NAME
);
15 if (DB_TYPE
== "pgsql") {
16 pg_query($link, "set client_encoding = 'utf-8'");
19 if ($op == "Export") {
20 print "<opml version=\"1.0\">";
21 print "<head><dateCreated>" . date("r", time()) . "</dateCreated></head>";
24 $result = db_query($link, "SELECT * FROM ttrss_feeds ORDER BY title");
26 while ($line = db_fetch_assoc($result)) {
27 $title = $line["title"];
28 $url = $line["feed_url"];
30 print "<outline text=\"$title\" xmlUrl=\"$url\"/>";
33 print "</body></opml>";
36 function startElement($parser, $name, $attrs) {
38 if ($name == "OUTLINE") {
39 $title = db_escape_string($attrs['TEXT']);
40 $url = db_escape_string($attrs['XMLURL']);
42 if (!$title ||
!$url) return;
44 print "Feed <b>$title</b> ($url)... ";
46 $link = db_connect(DB_HOST
, DB_USER
, DB_PASS
, DB_NAME
);
48 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
49 title = '$title' OR feed_url = '$url'");
51 if ($result && db_num_rows($result) > 0) {
53 print " Already imported.<br>";
57 $result = db_query($link, "INSERT INTO ttrss_feeds (title, feed_url) VALUES
60 print "<b>Done.</b><br>";
64 if ($link) db_close($link);
69 function endElement($parser, $name) {
74 if ($op == "Import") {
78 <link rel=\"stylesheet\" href=\"opml.css\" type=\"text/css\">
80 <body><h1>Importing OPML...</h1>
84 print "OPML import is disabled in demo-mode.";
85 print "<p><a class=\"button\" href=\"prefs.php\">
86 Return to preferences</a></div></body></html>";
91 if (is_file($_FILES['opml_file']['tmp_name'])) {
93 $xml_parser = xml_parser_create();
95 xml_set_element_handler($xml_parser, "startElement", "endElement");
97 $fp = fopen($_FILES['opml_file']['tmp_name'], "r");
101 while ($data = fread($fp, 4096)) {
103 if (!xml_parse($xml_parser, $data, feof($fp))) {
105 print sprintf("Unable to parse OPML file, XML error: %s at line %d",
106 xml_error_string(xml_get_error_code($xml_parser)),
107 xml_get_current_line_number($xml_parser));
109 print "<p><a class=\"button\" href=\"prefs.php\">
110 Return to preferences</a>";
117 xml_parser_free($xml_parser);
121 print("Error: Could not open OPML input.");
125 print "Error: please upload OPML file.";
128 print "<p><a class=\"button\" href=\"prefs.php\">
129 Return to preferences</a>";
131 print "</div></body></html>";