-// $_SESSION["uid"] = PLACEHOLDER_UID; // FIXME: placeholder
-
- $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
-
- if (DB_TYPE == "pgsql") {
- pg_query($link, "set client_encoding = 'utf-8'");
- }
-
- if ($op == "Export") {
- print "<opml version=\"1.0\">";
- print "<head><dateCreated>" . date("r", time()) . "</dateCreated></head>";
- print "<body>";
-
- $cat_mode = false;
-
- if (get_pref($link, 'ENABLE_FEED_CATS')) {
- $cat_mode = true;
- $result = db_query($link, "SELECT
- ttrss_feeds.feed_url AS feed_url,
- ttrss_feeds.title AS title,
- ttrss_feed_categories.title AS cat_title
- FROM ttrss_feeds,ttrss_feed_categories
- WHERE
- cat_id = ttrss_feed_categories.id
- ORDER BY ttrss_feed_categories.title,ttrss_feeds.title");
- } else {
- $result = db_query($link, "SELECT * FROM ttrss_feeds
- ORDER BY title");
- }
-
- $old_cat_title = "";
-
- while ($line = db_fetch_assoc($result)) {
- $title = htmlspecialchars($line["title"]);
- $url = htmlspecialchars($line["feed_url"]);
-
- if ($cat_mode) {
- $cat_title = htmlspecialchars($line["cat_title"]);
-
- if ($old_cat_title != $cat_title) {
- if ($old_cat_title) {
- print "</outline>";
- }
-
- print "<outline title=\"$cat_title\">";
-
- $old_cat_title = $cat_title;
- }
- }
-
- print "<outline text=\"$title\" xmlUrl=\"$url\"/>";
- }
-
- if ($cat_mode && $old_cat_title) {
- print "</outline>";
- }
-
- print "</body></opml>";
- }
-
- function startElement($parser, $name, $attrs) {
-
- if ($name == "OUTLINE") {
- if ($name == "OUTLINE") {
-
- $title = $attrs["TEXT"];
- $url = $attrs["XMLURL"];
-
- if (!$title) {
- $title = $attrs['TITLE'];
- }
- }
-
- /* this is suboptimal */
-
- $link = db_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
-
- if (!$link) return;
-
- $title = db_escape_string_2($title, $link);
- $url = db_escape_string_2($url, $link);