- if (DB_TYPE == "pgsql") {
- $date_qpart = "updated >= NOW() - INTERVAL '1 week' AND";
- } else {
- $date_qpart = "updated >= DATE_SUB(NOW(), INTERVAL 1 WEEK) AND";
- }
-
- $result = db_query($link,
- "SELECT DISTINCT ttrss_entries.id,ttrss_entries.title,
- guid,link,comments,
- feed_id,content,updated,unread,marked FROM
- ttrss_user_entries,ttrss_entries,ttrss_feeds
- WHERE $unread_qpart $cid_qpart $date_qpart
- ttrss_feeds.id = feed_id AND
- ref_id = ttrss_entries.id AND
- ttrss_user_entries.owner_uid = ".$_SESSION["uid"]."
- ORDER BY updated DESC LIMIT $limit OFFSET $skip");
-
- if (function_exists('json_encode')) {
-
- while ($line = db_fetch_assoc($result)) {
- print "<article><![CDATA[";
-
- $line["marked"] = (int)sql_bool_to_bool($line["marked"]);
- $line["unread"] = (int)sql_bool_to_bool($line["unread"]);
-
- $line["labels"] = get_article_labels($link, $line["id"]);
-
-// too slow :(
-// $line["tags"] = format_tags_string(
-// get_article_tags($link, $line["id"]), $line["id"]);
-
- print json_encode($line);
- print "]]></article>";
- }
- }