X-Git-Url: https://git.wh0rd.org/?p=tt-rss.git;a=blobdiff_plain;f=opml.php;h=bdee88e081694a516cc711290023b3a7d0e09854;hp=ff888d24661c8c44c8dc55034bb257c70a4834f5;hb=e52034b4bcce994312ce2af31be0a46a70172691;hpb=01a87dff9efecf9070b652f59a52e55bd2db1906 diff --git a/opml.php b/opml.php index ff888d24..bdee88e0 100644 --- a/opml.php +++ b/opml.php @@ -1,241 +1,37 @@ prepare( "SELECT owner_uid + FROM ttrss_access_keys WHERE + access_key = ? AND feed_id = 'OPML:Publish'"); + $sth->execute([$key]); - // FIXME there are some brackets issues here + if ($row = $sth->fetch()) { + $owner_uid = $row['owner_uid']; - $op = $_REQUEST["op"]; - - if (!$op) $op = "Export"; - - if ($op == "Export") { - header("Content-type: application/xml+opml"); - print ""; - } + $opml = new Opml($_REQUEST); + $opml->opml_export("", $owner_uid, true, false); - if ($op == "Export") { - print ""; - print " - " . date("r", time()) . " - Tiny Tiny RSS Feed Export - "; - print ""; - - $cat_mode = 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 - WHERE owner_uid = '$owner_uid' ORDER BY title"); + print "User not found"; } - - $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 ""; } - if ($op == "Import") { - - print " - - - - -

-
-

"._('Importing OPML...')."

"; - - 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')); - - if (!$feed_title) { - $feed_title = db_escape_string($outline->get_attribute('title')); - } - - $cat_title = db_escape_string($outline->get_attribute('title')); - - if (!$cat_title) { - $cat_title = db_escape_string($outline->get_attribute('text')); - } - - $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) { - - printf(_("Adding category %s..."), $cat_title); - print "
"; - - db_query($link, "INSERT INTO ttrss_feed_categories - (title,owner_uid) - VALUES ('$cat_title', '$owner_uid')"); - } - - db_query($link, "COMMIT"); - } - -// print "$active_category : $feed_title : $feed_url
"; - - 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, site_url) VALUES - ('$feed_title', '$feed_url', '$owner_uid', - '$cat_id', '$site_url')"; - - } else { - $add_query = "INSERT INTO ttrss_feeds - (title, feed_url, owner_uid, site_url) VALUES - ('$feed_title', '$feed_url', '$owner_uid', '$site_url')"; - - } - - 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); - ?>