root/modules/opml_domdoc.php

<?php
    function opml_import_domdoc($link, $owner_uid) {

        if (is_file($_FILES['opml_file']['tmp_name'])) {
            $doc = DOMDocument::load($_FILES['opml_file']['tmp_name']);

            $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) == 1) {
                $default_cat_id = db_fetch_result($result, 0, "id");
            } else {
                $default_cat_id = 0;
            }

            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) {

                            printf(__("Adding category <b>%s</b>...<br>"), $cat_title);

                            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;
                        if (!$element_category) $element_category = $parent_node->attributes->getNamedItem('text')->nodeValue;

                    } else {
                        $element_category = '';
                    }

                    if ($element_category) {

                        $element_category = db_escape_string($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
                            feed_url = '$feed_url'
                            AND owner_uid = '$owner_uid'");

                    print "<tr><td><a target='_blank' href='$site_url'><b>$feed_title</b></a></b> 
                        (<a target='_blank' 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, cat_id, site_url) VALUES
                                ('$feed_title', '$feed_url', '$owner_uid', '$default_cat_id', 
                                    '$site_url')";

                        }

                        //print $add_query;
                        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>";
        }


    }
?>