X-Git-Url: https://git.wh0rd.org/?p=tt-rss.git;a=blobdiff_plain;f=opml.php;h=bdee88e081694a516cc711290023b3a7d0e09854;hp=023f29ffecec1075ff34b8bbdbf175055676f8ab;hb=07fd4f8d9d4f301f5ad88ff9e80f042fc3eb0c36;hpb=5d3f29da4ba7fb7fe898bbde28e8d133f0b15764 diff --git a/opml.php b/opml.php index 023f29ff..bdee88e0 100644 --- a/opml.php +++ b/opml.php @@ -1,156 +1,37 @@ -"; - } - +"; - 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') AND owner_uid = ".$_SESSION["uid"]); - - if ($result && db_num_rows($result) > 0) { - - print " Already imported.
"; + if (!init_plugins()) return; - } else { - - $result = db_query($link, "INSERT INTO ttrss_feeds (title, feed_url,owner_uid) VALUES - ('$title', '$url', '".$_SESSION["uid"]."')"); + $op = $_REQUEST['op']; - print "Done.
"; + if ($op == "publish"){ + $key = $_REQUEST["key"]; + $pdo = Db::pdo(); - } + $sth = $pdo->prepare( "SELECT owner_uid + FROM ttrss_access_keys WHERE + access_key = ? AND feed_id = 'OPML:Publish'"); + $sth->execute([$key]); - if ($link) db_close($link); + if ($row = $sth->fetch()) { + $owner_uid = $row['owner_uid']; - } - } - - function endElement($parser, $name) { - - - } - - if ($op == "Import") { - - print " - - - -

Importing OPML...

-
"; - - if (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"); + $opml = new Opml($_REQUEST); + $opml->opml_export("", $owner_uid, true, false); - $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."; + } else { + print "User not found"; } - - print "

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