Bugfix: Playbackhistory had wrong sort order

fixes #540

2 files changed, 2 insertions, 3 deletions

diff --git a/core/src/main/java/de/danoeh/antennapod/core/storage/DBReader.java b/core/src/main/java/de/danoeh/antennapod/core/storage/DBReader.java
index 62edaae29..9cc87cb47 100644
--- a/core/src/main/java/de/danoeh/antennapod/core/storage/DBReader.java
+++ b/core/src/main/java/de/danoeh/antennapod/core/storage/DBReader.java
@@ -549,7 +549,6 @@ public final class DBReader {
     public static List<FeedItem> getPlaybackHistory(final Context context) {
         if (BuildConfig.DEBUG)
             Log.d(TAG, "Loading playback history");
-        final int PLAYBACK_HISTORY_SIZE = 50;
 
         PodDBAdapter adapter = new PodDBAdapter(context);
         adapter.open();
diff --git a/core/src/main/java/de/danoeh/antennapod/core/storage/PodDBAdapter.java b/core/src/main/java/de/danoeh/antennapod/core/storage/PodDBAdapter.java
index 6b6e09369..eab92eab2 100644
--- a/core/src/main/java/de/danoeh/antennapod/core/storage/PodDBAdapter.java
+++ b/core/src/main/java/de/danoeh/antennapod/core/storage/PodDBAdapter.java
@@ -1037,8 +1037,8 @@ public class PodDBAdapter {
         Validate.isTrue(limit >= 0, "Limit must be >= 0");
 
         Cursor c = db.query(TABLE_NAME_FEED_MEDIA, null,
-                KEY_PLAYBACK_COMPLETION_DATE + " > 0 LIMIT " + limit, null, null,
-                null, null);
+                KEY_PLAYBACK_COMPLETION_DATE + " > 0", null, null,
+                null, String.format("%s DESC LIMIT %d", KEY_PLAYBACK_COMPLETION_DATE, limit));
         return c;
     }