diff options
author | Andrew Dolgov <[email protected]> | 2007-03-02 14:58:51 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2007-03-02 14:58:51 +0100 |
commit | 30f782a278a9f1f44402ea5ecf8efef1894b813c (patch) | |
tree | e6e3fcc7a9e02f94122ac5364ba75a33a451a426 /modules | |
parent | d7c848d97bb30d668a987ebe2348ccd52d72c99f (diff) |
opml fixes
Diffstat (limited to 'modules')
-rw-r--r-- | modules/opml_domdoc.php | 127 | ||||
-rw-r--r-- | modules/opml_domxml.php | 132 |
2 files changed, 259 insertions, 0 deletions
diff --git a/modules/opml_domdoc.php b/modules/opml_domdoc.php new file mode 100644 index 000000000..459841022 --- /dev/null +++ b/modules/opml_domdoc.php @@ -0,0 +1,127 @@ +<?php + function opml_import_domdoc($link, $owner_uid) { + + if (is_file($_FILES['opml_file']['tmp_name'])) { + $doc = DOMDocument::load($_FILES['opml_file']['tmp_name']); + + if ($doc) { + $body = $doc->getElementsByTagName('body'); + + $xpath = new DOMXpath($doc); + $query = "/opml/body//outline"; + + $outlines = $xpath->query($query); + + print "<table>"; + + foreach ($outlines as $outline) { + + $feed_title = db_escape_string($outline->attributes->getNamedItem('text')->nodeValue); + + if (!$feed_title) { + $feed_title = db_escape_string($outline->attributes->getNamedItem('title')->nodeValue); + } + + $cat_title = db_escape_string($outline->attributes->getNamedItem('title')->nodeValue); + + if (!$cat_title) { + $cat_title = db_escape_string($outline->attributes->getNamedItem('text')->nodeValue); + } + + $feed_url = db_escape_string($outline->attributes->getNamedItem('xmlUrl')->nodeValue); + $site_url = db_escape_string($outline->attributes->getNamedItem('htmlUrl')->nodeValue); + + 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 <b>$cat_title</b>...<br>"; + + 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<br>"; + + if (!$feed_title || !$feed_url) continue; + + db_query($link, "BEGIN"); + + $cat_id = null; + + $parent_node = $outline->parentNode; + + if ($parent_node && $parent_node->nodeName == "outline") { + $element_category = $parent_node->attributes->getNamedItem('title')->nodeValue; + } 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 "<tr><td><a href='$site_url'><b>$feed_title</b></a></b> + (<a href=\"$feed_url\">rss</a>)</td>"; + + if (db_num_rows($result) > 0) { + print "<td>Already imported.</td>"; + } 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 "<td><b>Done.</b></td>"; + } + + print "</tr>"; + + db_query($link, "COMMIT"); + } + + print "</table>"; + + } else { + print "<div class=\"error\">Error while parsing document.</div>"; + } + + } else { + print "<div class=\"error\">Error: please upload OPML file.</div>"; + } + + + } +?> diff --git a/modules/opml_domxml.php b/modules/opml_domxml.php new file mode 100644 index 000000000..2a140f325 --- /dev/null +++ b/modules/opml_domxml.php @@ -0,0 +1,132 @@ +<?php + function opml_import_domxml($link, $owner_uid) { + + 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 "<table>"; + + 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 <b>%s</b>."), $cat_title); + print "<br>"; + + 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<br>"; + + 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 "<tr><td><a href='$site_url'><b>$feed_title</b></a></b> + (<a href=\"$feed_url\">rss</a>)</td>"; + + if (db_num_rows($result) > 0) { + print "<td>"._("Already imported.")."</td>"; + } 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 "<td><b>"._('Done.')."</b></td>"; + } + + print "</tr>"; + + db_query($link, "COMMIT"); + } + + print "</table>"; + + } else { + print "<div class=\"error\">"._("Error: can't find body element.")."</div>"; + } + } else { + print "<div class=\"error\">"._("Error while parsing document.")."</div>"; + } + + } else { + print "<div class=\"error\">"._("Error: please upload OPML file.")."</div>"; + } + + } +?> |