"; } require_once "config.php"; require_once "db.php"; require_once "db-prefs.php"; $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 ""; print "" . date("r", time()) . ""; print ""; $result = db_query($link, "SELECT * FROM ttrss_feeds ORDER BY title"); while ($line = db_fetch_assoc($result)) { $title = htmlspecialchars($line["title"]); $url = htmlspecialchars($line["feed_url"]); print ""; } print ""; } 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 $title ($url)... "; $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE title = '$title' OR feed_url = '$url'"); if ($result && db_num_rows($result) > 0) { print " Already imported.
"; } else { $result = db_query($link, "INSERT INTO ttrss_feeds (title, feed_url) VALUES ('$title', '$url')"); print "Done.
"; } if ($link) db_close($link); } } function endElement($parser, $name) { } if ($op == "Import") { print "

Importing OPML...

"; if (get_pref($link, 'WEB_DEMO_MODE')) { print "OPML import is disabled in demo-mode."; print "

Return to preferences

"; 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 "

Return to preferences"; return; } } xml_parser_free($xml_parser); fclose($fp); } else { print("Error: Could not open OPML input."); } } else { print "Error: please upload OPML file."; } print "

Return to preferences"; print ""; } // if ($link) db_close($link); ?>