From f7c533d5d92e7fcec2bf910463406299740be26b Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 27 Mar 2013 14:04:49 +0400 Subject: offline: fix catchup_above to only process unread articles bump version --- src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src') diff --git a/src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java b/src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java index b73efb92..96de96fe 100644 --- a/src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java +++ b/src/org/fox/ttrss/offline/OfflineHeadlinesFragment.java @@ -186,12 +186,12 @@ public class OfflineHeadlinesFragment extends Fragment implements OnItemClickLis stmt = m_activity.getWritableDb().compileStatement( "UPDATE articles SET modified = 1, unread = 0 WHERE " + "updated "+updatedOperator+" (SELECT updated FROM articles WHERE " + BaseColumns._ID + " = ?) " + - "AND feed_id IN (SELECT "+BaseColumns._ID+" FROM feeds WHERE cat_id = ?)"); + "AND unread = 1 AND feed_id IN (SELECT "+BaseColumns._ID+" FROM feeds WHERE cat_id = ?)"); } else { stmt = m_activity.getWritableDb().compileStatement( "UPDATE articles SET modified = 1, unread = 0 WHERE " + "updated "+updatedOperator+" (SELECT updated FROM articles WHERE " + BaseColumns._ID + " = ?) " + - "AND feed_id = ?"); + "AND unread = 1 AND feed_id = ?"); } stmt.bindLong(1, articleId); -- cgit v1.2.3-54-g00ecf