From 949d5232b8817ce9483b61c8a12f321e533d9b75 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Kjetil=20=C3=98rbekk?= Date: Thu, 11 Sep 2008 14:14:57 +0200 Subject: - Fixed track numbers in /Albums/* --- TODO | 2 -- src/mfs_subr.c | 10 +++++----- 2 files changed, 5 insertions(+), 7 deletions(-) diff --git a/TODO b/TODO index e35370c..950f2fd 100644 --- a/TODO +++ b/TODO @@ -2,8 +2,6 @@ v. 0.1 ~~~~~~ -* Fix track numbers in /Albums - * Fix /Genres * BUG: fsync errors with /.config diff --git a/src/mfs_subr.c b/src/mfs_subr.c index 8db6d7a..cbf8f8d 100644 --- a/src/mfs_subr.c +++ b/src/mfs_subr.c @@ -661,9 +661,9 @@ mfs_realpath(const char *path, char **realpath) { break; error = 0; lh = mfs_lookup_start(0, realpath, mfs_lookup_path, - "SELECT filepath FROM song " - "WHERE (title||'.'||extension) LIKE ? AND " - "album LIKE ?"); + "SELECT filepath FROM song WHERE " + "LTRIM(track||' ')||title||'.'||extension LIKE ? " + "AND album LIKE ?"); if (lh == NULL) { error = -EIO; break; @@ -805,8 +805,8 @@ mfs_lookup_album(const char *path, struct filler_data *fd) if (album == NULL) break; lh = mfs_lookup_start(0, fd, mfs_lookup_list, - "SELECT DISTINCT title||'.'||extension FROM song " - "WHERE album LIKE ?"); + "SELECT DISTINCT LTRIM(track||' ')||title||'.'||extension " + "FROM song WHERE album LIKE ?"); mfs_lookup_insert(lh, album, LIST_DATATYPE_STRING); break; } -- cgit v1.2.3