X-Git-Url: https://git.wh0rd.org/?p=tt-rss.git;a=blobdiff_plain;f=opml.php;h=bdee88e081694a516cc711290023b3a7d0e09854;hp=21af43f7b9ab1bf597f67272d31b6b2ce7308c41;hb=e52034b4bcce994312ce2af31be0a46a70172691;hpb=4e9f5c242047f215b23a4f2fd2d488d1dead70d3 diff --git a/opml.php b/opml.php index 21af43f7..bdee88e0 100644 --- a/opml.php +++ b/opml.php @@ -1,236 +1,37 @@ -"; - } + $sth = $pdo->prepare( "SELECT owner_uid + FROM ttrss_access_keys WHERE + access_key = ? AND feed_id = 'OPML:Publish'"); + $sth->execute([$key]); - if ($op == "Export") { - print ""; - print " - " . date("r", time()) . " - Tiny Tiny RSS Feed Export - "; - print ""; + if ($row = $sth->fetch()) { + $owner_uid = $row['owner_uid']; - $cat_mode = false; + $opml = new Opml($_REQUEST); + $opml->opml_export("", $owner_uid, true, false); - if (get_pref($link, 'ENABLE_FEED_CATS')) { - $cat_mode = true; - $result = db_query($link, "SELECT - title,feed_url,site_url, - (SELECT title FROM ttrss_feed_categories WHERE id = cat_id) as cat_title - FROM ttrss_feeds - WHERE - owner_uid = '$owner_uid' - ORDER BY cat_title,title"); } else { - $result = db_query($link, "SELECT * FROM ttrss_feeds - ORDER BY title WHERE owner_uid = '$owner_uid'"); - } - - $old_cat_title = ""; - - while ($line = db_fetch_assoc($result)) { - $title = htmlspecialchars($line["title"]); - $url = htmlspecialchars($line["feed_url"]); - $site_url = htmlspecialchars($line["site_url"]); - - if ($cat_mode) { - $cat_title = htmlspecialchars($line["cat_title"]); - - if ($old_cat_title != $cat_title) { - if ($old_cat_title) { - print "\n"; - } - - if ($cat_title) { - print "\n"; - } - - $old_cat_title = $cat_title; - } - } - - if ($site_url) { - $html_url_qpart = "htmlUrl=\"$site_url\""; - } else { - $html_url_qpart = ""; - } - - print "\n"; - } - - if ($cat_mode && $old_cat_title) { - print "\n"; + print "User not found"; } - - print ""; } - 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'])) { - $dom = domxml_open_file($_FILES['opml_file']['tmp_name']); - - if ($dom) { - $root = $dom->document_element(); - - $body = $root->get_elements_by_tagname('body'); - - if ($body[0]) { - $body = $body[0]; - - $outlines = $body->get_elements_by_tagname('outline'); - - print ""; - - foreach ($outlines as $outline) { - $feed_title = db_escape_string($outline->get_attribute('text')); - $cat_title = db_escape_string($outline->get_attribute('title')); - $feed_url = db_escape_string($outline->get_attribute('xmlUrl')); - $site_url = db_escape_string($outline->get_attribute('htmlUrl')); - - if ($cat_title && !$feed_url) { - - db_query($link, "BEGIN"); - - $result = db_query($link, "SELECT id FROM - ttrss_feed_categories WHERE title = '$cat_title' AND - owner_uid = '$owner_uid' LIMIT 1"); - - if (db_num_rows($result) == 0) { - - print "Adding category $cat_title...
"; - - db_query($link, "INSERT INTO ttrss_feed_categories - (title,owner_uid,site_url) - VALUES ('$cat_title', '$owner_uid', '$site_url')"); - } - - db_query($link, "COMMIT"); - } - -// print "$active_category : $feed_title : $xmlurl
"; - - if (!$feed_title || !$feed_url) continue; - - db_query($link, "BEGIN"); - - $cat_id = null; - - $parent_node = $outline->parent_node(); - - if ($parent_node && $parent_node->node_name() == "outline") { - $element_category = $parent_node->get_attribute('title'); - } else { - $element_category = ''; - } - - if ($element_category) { - - $result = db_query($link, "SELECT id FROM - ttrss_feed_categories WHERE title = '$element_category' AND - owner_uid = '$owner_uid' LIMIT 1"); - - if (db_num_rows($result) == 1) { - $cat_id = db_fetch_result($result, 0, "id"); - } - } - - $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE - (title = '$feed_title' OR feed_url = '$feed_url') - AND owner_uid = '$owner_uid'"); - - print ""; - - if (db_num_rows($result) > 0) { - print ""; - } else { - - if ($cat_id) { - $add_query = "INSERT INTO ttrss_feeds - (title, feed_url, owner_uid, cat_id) VALUES - ('$feed_title', '$feed_url', '$owner_uid', '$cat_id')"; - - } else { - $add_query = "INSERT INTO ttrss_feeds - (title, feed_url, owner_uid) VALUES - ('$feed_title', '$feed_url', '$owner_uid')"; - - } - - db_query($link, $add_query); - - print ""; - } - - print ""; - - db_query($link, "COMMIT"); - } - - print "
$feed_title - (rss)Already imported.Done.
"; - - } else { - print "
Error: can't find body element.
"; - } - } else { - print "
Error while parsing document.
"; - } - - } else { - print "
Error: please upload OPML file.
"; - } - - print "

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