X-Git-Url: https://git.wh0rd.org/?a=blobdiff_plain;f=opml.php;h=af3694051d16d64f3b4862c18202ba10e101c8cd;hb=62974d71d4a0bce118c94442ebc12753fa1f513a;hp=2e9f2368f8b2fca06419a6a09fff7931bcc9bfa5;hpb=a4234239568f14dbad890dd7eeb3208fe5922193;p=tt-rss.git diff --git a/opml.php b/opml.php index 2e9f2368..af369405 100644 --- a/opml.php +++ b/opml.php @@ -1,168 +1,35 @@ "; - - print ""; - print " - " . date("r", time()) . " - Tiny Tiny RSS Feed Export - "; - print ""; - - $cat_mode = false; - - $select = "SELECT * "; - $where = "WHERE owner_uid = '$owner_uid'"; - $orderby = "ORDER BY title"; - if ($hide_private_feeds){ - $where = "WHERE owner_uid = '$owner_uid' AND private IS false"; - } - - if (get_pref($link, 'ENABLE_FEED_CATS')) { - $cat_mode = true; - $select = "SELECT - title, feed_url, site_url, - (SELECT title FROM ttrss_feed_categories WHERE id = cat_id) as cat_title"; - $orderby = "ORDER BY cat_title, title"; - - } - - $result = db_query($link, $select." FROM ttrss_feeds ".$where." ".$orderby); + if (!init_plugins()) return; - $old_cat_title = ""; + $op = $_REQUEST['op']; - 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 == "publish"){ + $key = db_escape_string( $_REQUEST["key"]); - // FIXME there are some brackets issues here - - $op = $_REQUEST["op"]; - - if (!$op) $op = "Export"; - - if ($op == "Export") { - - login_sequence($link); - $owner_uid = $_SESSION["uid"]; - return opml_export($link, $owner_uid); - } - if ($op == "publish"){ - $key = db_escape_string($_REQUEST["key"]); - - $result = db_query($link, "SELECT login, owner_uid - FROM ttrss_user_prefs, ttrss_users WHERE - pref_name = '_PREFS_PUBLISH_KEY' AND - value = '$key' AND - ttrss_users.id = owner_uid"); + $result = db_query( "SELECT owner_uid + FROM ttrss_access_keys WHERE + access_key = '$key' AND feed_id = 'OPML:Publish'"); if (db_num_rows($result) == 1) { - $owner = db_fetch_result($result, 0, "owner_uid"); - return opml_export($link, $owner, True); - } else { - print "User not found"; - } - } - - if ($op == "Import") { - - login_sequence($link); - $owner_uid = $_SESSION["uid"]; - - print " - - - ".__("OPML Utility")." - - -
-

".__('OPML Utility')."

"; - - db_query($link, "BEGIN"); + $owner_uid = db_fetch_result($result, 0, "owner_uid"); - /* create Imported feeds category just in case */ + $opml = new Opml($_REQUEST); + $opml->opml_export("", $owner_uid, true, false); - $result = db_query($link, "SELECT id FROM - ttrss_feed_categories WHERE title = 'Imported feeds' AND - owner_uid = '$owner_uid' LIMIT 1"); - - if (db_num_rows($result) == 0) { - db_query($link, "INSERT INTO ttrss_feed_categories - (title,owner_uid) - VALUES ('Imported feeds', '$owner_uid')"); - } - - db_query($link, "COMMIT"); - - /* Handle OPML import by DOMXML/DOMDocument */ - - if (function_exists('domxml_open_file')) { - print "

".__("Importing OPML (using DOMXML extension)...")."

"; - require_once "modules/opml_domxml.php"; - opml_import_domxml($link, $owner_uid); - } else if (PHP_VERSION >= 5) { - print "

".__("Importing OPML (using DOMDocument extension)...")."

"; - require_once "modules/opml_domdoc.php"; - opml_import_domdoc($link, $owner_uid); } else { - print_error(__("DOMXML extension is not found. It is required for PHP versions below 5.")); + print "User not found"; } - - print "
- -
"; - - print ""; - } -// if ($link) db_close($link); - ?>