From 3f286c4c2bb531156e16f3a1f809d36811ca1cd4 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 12 Feb 2006 11:15:24 +0100 Subject: skip counters output when number of unread articles at backend equals frontend, move tools to utils/ folder --- utils/xml-export.php | 164 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 164 insertions(+) create mode 100644 utils/xml-export.php (limited to 'utils/xml-export.php') diff --git a/utils/xml-export.php b/utils/xml-export.php new file mode 100644 index 000000000..620331fba --- /dev/null +++ b/utils/xml-export.php @@ -0,0 +1,164 @@ + + + + + + + XML Export + + + +

+ +
+

XML Export

+
+ Limit to: starred, + unread.
+

+
+
+ + + + + + + + +Source database schema is invalid + (got version $schema_version; expected ".SCHEMA_VERSION.")"; + print ""; + return; + } */ + + print "$schema_version"; + + if ($schema_version > 1) { + $owner_uid = $_SESSION["uid"]; + print "$owner_uid"; + } + + print "" . time() . ""; +?> + += 2 && $schema_version <= MAX_SCHEMA_VERSION) { + + $result = db_query($link, "SELECT + ttrss_entries.title AS title, + content, + marked, + unread, + updated, + guid, + link, + SUBSTRING(date_entered,1,16) AS date_entered, + SUBSTRING(last_read,1,16) AS last_read, + comments, + ttrss_feeds.feed_url AS feed_url, + ttrss_feeds.title AS feed_title + FROM + ttrss_entries,ttrss_feeds,ttrss_user_entries + WHERE + ttrss_user_entries.owner_uid = '$owner_uid' AND + ref_id = ttrss_entries.id AND + feed_id = ttrss_feeds.id $marked_qpart $unread_qpart + ORDER BY ttrss_entries.id"); + + } else { + + // BAD SCHEMA, NO COOKIE + + print "Source database schema is invalid + (got version $schema_version)"; + } + + print "" . db_num_rows($result) . ""; + +?> + + + +"; + + foreach (array_keys($line) as $key) { + $line[$key] = str_replace("", "", $line[$key]); + + print "<$key>"; + + } + + print ""; + } + +?> + + + + + -- cgit v1.2.3