- $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>";
-
- $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 "<outline text=\"$title\" xmlUrl=\"$url\"/>";
- }
-
- 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'");
-
- if ($result && db_num_rows($result) > 0) {
-
- print " Already imported.<br>";
-
- } else {
-
- $result = db_query($link, "INSERT INTO ttrss_feeds (title, feed_url) VALUES
- ('$title', '$url')");