]>
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 if ($name == "OUTLINE") {
41 $title = $attrs["TEXT"];
42 $url = $attrs["XMLURL"];
45 $title = $attrs['TITLE'];
49 if (!$title ||
!$url) return;
51 print "Feed <b>$title</b> ($url)... ";
53 $link = db_connect(DB_HOST
, DB_USER
, DB_PASS
, DB_NAME
);
55 $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
56 title = '$title' OR feed_url = '$url'");
58 if ($result && db_num_rows($result) > 0) {
60 print " Already imported.<br>";
64 $result = db_query($link, "INSERT INTO ttrss_feeds (title, feed_url) VALUES
67 print "<b>Done.</b><br>";
71 if ($link) db_close($link);
76 function endElement($parser, $name) {
81 if ($op == "Import") {
85 <link rel=\"stylesheet\" href=\"opml.css\" type=\"text/css\">
87 <body><h1>Importing OPML...</h1>
91 print "OPML import is disabled in demo-mode.";
92 print "<p><a class=\"button\" href=\"prefs.php\">
93 Return to preferences</a></div></body></html>";
98 if (is_file($_FILES['opml_file']['tmp_name'])) {
100 $xml_parser = xml_parser_create();
102 xml_set_element_handler($xml_parser, "startElement", "endElement");
104 $fp = fopen($_FILES['opml_file']['tmp_name'], "r");
108 while ($data = fread($fp, 4096)) {
110 if (!xml_parse($xml_parser, $data, feof($fp))) {
112 print sprintf("Unable to parse OPML file, XML error: %s at line %d",
113 xml_error_string(xml_get_error_code($xml_parser)),
114 xml_get_current_line_number($xml_parser));
116 print "<p><a class=\"button\" href=\"prefs.php\">
117 Return to preferences</a>";
124 xml_parser_free($xml_parser);
128 print("Error: Could not open OPML input.");
132 print "Error: please upload OPML file.";
135 print "<p><a class=\"button\" href=\"prefs.php\">
136 Return to preferences</a>";
138 print "</div></body></html>";
142 // if ($link) db_close($link);