X-Git-Url: https://git.wh0rd.org/?a=blobdiff_plain;f=opml.php;h=bdee88e081694a516cc711290023b3a7d0e09854;hb=e2b8c9273e09091c235959c25d8e4d8122aa6ca8;hp=eab0b7b7d453c0e38c747bc755728c7706d5a108;hpb=d3cface62d58aae453899aa5f93a36bd7f35b28d;p=tt-rss.git
diff --git a/opml.php b/opml.php
index eab0b7b7..bdee88e0 100644
--- a/opml.php
+++ b/opml.php
@@ -1,7 +1,8 @@
attributes;
-
- $feed_title = db_escape_string($attrs->getNamedItem('text')->nodeValue);
- if (!$feed_title) $feed_title = db_escape_string($attrs->getNamedItem('title')->nodeValue);
-
- $feed_url = db_escape_string($attrs->getNamedItem('xmlUrl')->nodeValue);
- if (!$feed_url) $feed_url = db_escape_string($attrs->getNamedItem('xmlURL')->nodeValue);
-
- $site_url = db_escape_string($attrs->getNamedItem('htmlUrl')->nodeValue);
-
- if ($feed_url && $feed_title) {
- $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
- feed_url = '$feed_url' AND owner_uid = '$owner_uid'");
-
- if (db_num_rows($result) == 0) {
- #opml_notice("[FEED] [$feed_title/$feed_url] dst_CAT=$cat_id");
- opml_notice(T_sprintf("Adding feed: %s", $feed_title));
-
- $query = "INSERT INTO ttrss_feeds
- (title, feed_url, owner_uid, cat_id, site_url, order_id) VALUES
- ('$feed_title', '$feed_url', '$owner_uid',
- '$cat_id', '$site_url', 0)";
- db_query($link, $query);
-
- } else {
- opml_notice(T_sprintf("Duplicate feed: %s", $feed_title));
- }
- }
- }
-
- function opml_import_label($link, $doc, $node, $owner_uid) {
- $attrs = $node->attributes;
- $label_name = db_escape_string($attrs->getNamedItem('label-name')->nodeValue);
-
- if ($label_name) {
- $fg_color = db_escape_string($attrs->getNamedItem('label-fg-color')->nodeValue);
- $bg_color = db_escape_string($attrs->getNamedItem('label-bg-color')->nodeValue);
-
- if (!label_find_id($link, $label_name, $_SESSION['uid'])) {
- opml_notice(T_sprintf("Adding label %s", htmlspecialchars($label_name)));
- label_create($link, $label_name, $fg_color, $bg_color);
- } else {
- opml_notice(T_sprintf("Duplicate label: %s", htmlspecialchars($label_name)));
- }
- }
- }
-
- function opml_import_preference($link, $doc, $node, $owner_uid) {
- $attrs = $node->attributes;
- $pref_name = db_escape_string($attrs->getNamedItem('pref-name')->nodeValue);
-
- if ($pref_name) {
- $pref_value = db_escape_string($attrs->getNamedItem('value')->nodeValue);
-
- opml_notice(T_sprintf("Setting preference key %s to %s",
- $pref_name, $pref_value));
-
- set_pref($link, $pref_name, $pref_value);
- }
- }
-
- function opml_import_filter($link, $doc, $node, $owner_uid) {
- $attrs = $node->attributes;
-
- $filter_name = db_escape_string($attrs->getNamedItem('filter-name')->nodeValue);
-
- if ($filter_name) {
-
- $filter = json_decode($node->nodeValue, true);
-
- if ($filter) {
- $reg_exp = db_escape_string($filter['reg_exp']);
- $filter_type = (int)$filter['filter_type'];
- $action_id = (int)$filter['action_id'];
-
- $result = db_query($link, "SELECT id FROM ttrss_filters WHERE
- reg_exp = '$reg_exp' AND
- filter_type = '$filter_type' AND
- action_id = '$action_id' AND
- owner_uid = " .$_SESSION['uid']);
-
- if (db_num_rows($result) == 0) {
- $enabled = bool_to_sql_bool($filter['enabled']);
- $action_param = db_escape_string($filter['action_param']);
- $inverse = bool_to_sql_bool($filter['inverse']);
- $filter_param = db_escape_string($filter['filter_param']);
- $cat_filter = bool_to_sql_bool($filter['cat_filter']);
-
- $feed_url = db_escape_string($filter['feed_url']);
- $cat_title = db_escape_string($filter['cat_title']);
-
- $result = db_query($link, "SELECT id FROM ttrss_feeds WHERE
- feed_url = '$feed_url' AND owner_uid = ".$_SESSION['uid']);
-
- if (db_num_rows($result) != 0) {
- $feed_id = db_fetch_result($result, 0, "id");
- } else {
- $feed_id = "NULL";
- }
-
- $result = db_query($link, "SELECT id FROM ttrss_feed_categories WHERE
- title = '$cat_title' AND owner_uid = ".$_SESSION['uid']);
-
- if (db_num_rows($result) != 0) {
- $cat_id = db_fetch_result($result, 0, "id");
- } else {
- $cat_id = "NULL";
- }
-
- opml_notice(T_sprintf("Adding filter %s", htmlspecialchars($reg_exp)));
-
- $query = "INSERT INTO ttrss_filters (filter_type, action_id,
- enabled, inverse, action_param, filter_param,
- cat_filter, feed_id,
- cat_id, reg_exp,
- owner_uid)
- VALUES ($filter_type, $action_id,
- $enabled, $inverse, '$action_param', '$filter_param',
- $cat_filter, $feed_id,
- $cat_id, '$reg_exp', ".
- $_SESSION['uid'].")";
-
- db_query($link, $query);
-
- } else {
- opml_notice(T_sprintf("Duplicate filter %s", htmlspecialchars($reg_exp)));
- }
- }
- }
- }
-
- function opml_import_category($link, $doc, $root_node, $owner_uid, $parent_id) {
- $body = $doc->getElementsByTagName('body');
-
- $default_cat_id = (int) get_feed_category($link, 'Imported feeds', false);
-
- if ($root_node) {
- $cat_title = db_escape_string($root_node->attributes->getNamedItem('title')->nodeValue);
-
- if (!in_array($cat_title, array("tt-rss-filters", "tt-rss-labels", "tt-rss-prefs"))) {
- $cat_id = get_feed_category($link, $cat_title, $parent_id);
- db_query($link, "BEGIN");
- if ($cat_id === false) {
- add_feed_category($link, $cat_title, $parent_id);
- $cat_id = get_feed_category($link, $cat_title, $parent_id);
- }
- db_query($link, "COMMIT");
- } else {
- $cat_id = 0;
- }
-
- $outlines = $root_node->childNodes;
-
- } else {
- $xpath = new DOMXpath($doc);
- $outlines = $xpath->query("//opml/body/outline");
-
- $cat_id = 0;
- }
-
- #opml_notice("[CAT] $cat_title id: $cat_id P_id: $parent_id");
- opml_notice(T_sprintf("Processing category: %s", $cat_title ? $cat_title : __("Uncategorized")));
-
- foreach ($outlines as $node) {
- if ($node->hasAttributes() && strtolower($node->tagName) == "outline") {
- $attrs = $node->attributes;
- $node_cat_title = db_escape_string($attrs->getNamedItem('title')->nodeValue);
-
- if ($node->hasChildNodes() && $node_cat_title) {
- opml_import_category($link, $doc, $node, $owner_uid, $cat_id);
- } else {
-
- if (!$cat_id) {
- $dst_cat_id = $default_cat_id;
- } else {
- $dst_cat_id = $cat_id;
- }
-
- switch ($cat_title) {
- case "tt-rss-prefs":
- opml_import_preference($link, $doc, $node, $owner_uid);
- break;
- case "tt-rss-labels":
- opml_import_label($link, $doc, $node, $owner_uid);
- break;
- case "tt-rss-filters":
- opml_import_filter($link, $doc, $node, $owner_uid);
- break;
- default:
- opml_import_feed($link, $doc, $node, $dst_cat_id, $owner_uid);
- }
- }
- }
- }
- }
-
- function opml_import_domdoc($link, $owner_uid) {
-
- $debug = isset($_REQUEST["debug"]);
- $doc = false;
-
- #if ($debug) $doc = DOMDocument::load("/tmp/test.opml");
-
- if (is_file($_FILES['opml_file']['tmp_name'])) {
- $doc = DOMDocument::load($_FILES['opml_file']['tmp_name']);
- } else if (!$doc) {
- print_error(__('Error: please upload OPML file.'));
- return;
- }
-
- if ($doc) {
- opml_import_category($link, $doc, false, $owner_uid);
- } else {
- print_error(__('Error while parsing document.'));
- }
- }
-
- function opml_export_category($link, $owner_uid, $cat_id, $hide_private_feeds=false) {
-
- if ($cat_id) {
- $cat_qpart = "parent_cat = '$cat_id'";
- $feed_cat_qpart = "cat_id = '$cat_id'";
- } else {
- $cat_qpart = "parent_cat IS NULL";
- $feed_cat_qpart = "cat_id IS NULL";
- }
-
- if ($hide_private_feeds)
- $hide_qpart = "(private IS false AND auth_login = '' AND auth_pass = '')";
- else
- $hide_qpart = "true";
-
- $out = "";
-
- if ($cat_id) {
- $result = db_query($link, "SELECT title FROM ttrss_feed_categories WHERE id = '$cat_id'
- AND owner_uid = '$owner_uid'");
- $cat_title = db_fetch_result($result, 0, "title");
- }
-
- if ($cat_title) $out .= "