From 774b8df8739d2cab5656fa9907c6e6dd6f32158e Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 4 Feb 2009 10:19:36 +0300 Subject: move more stuff to offline.js --- offline.js | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) (limited to 'offline.js') diff --git a/offline.js b/offline.js index 371aeecf0..58c2377c2 100644 --- a/offline.js +++ b/offline.js @@ -490,3 +490,28 @@ function update_local_feedlist_counters() { exception_error("update_local_feedlist_counters", e); } } + +function get_local_feed_unread(id) { + try { + var rs; + + if (id == -4) { + rs = db.execute("SELECT SUM(unread) FROM articles"); + } else if (id == -1) { + rs = db.execute("SELECT SUM(unread) FROM articles WHERE marked = 1"); + } else { + rs = db.execute("SELECT SUM(unread) FROM articles WHERE feed_id = ?", [id]); + } + + if (rs.isValidRow()) { + return rs.field(0); + } else { + return 0; + } + + } catch (e) { + exception_error("get_local_feed_unread", e); + } +} + + -- cgit v1.2.3