commit b6674f6324b5c1b43a4fe5030b82881a50d449b4
Author: Kris Maglione <maglion...@gmail.com>
Date: Thu Jan 7 19:33:30 2010 -0500
[sqlite] Set album art for albums as well as tracks.
src/itdb_sqlite.c | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
---
diff --git a/src/itdb_sqlite.c b/src/itdb_sqlite.c
index ca38902..de2d26c 100644
--- a/src/itdb_sqlite.c
+++ b/src/itdb_sqlite.c
@@ -1217,6 +1217,8 @@ static int mk_Library(Itdb_iTunesDB *itdb,
}
}
+ sqlite3_exec(db, "UPDATE album SET artwork_item_pid = (SELECT item.pid
FROM item WHERE item.artwork_cache_id != 0 AND item.album_pid = album.pid LIMIT
1);", NULL, NULL, NULL);
+
sqlite3_exec(db, "COMMIT;", NULL, NULL, NULL);
res = 0;
------------------------------------------------------------------------------
Throughout its 18-year history, RSA Conference consistently attracts the
world's best and brightest in the field, creating opportunities for Conference
attendees to learn about information security's most important issues through
interactions with peers, luminaries and emerging and established companies.
http://p.sf.net/sfu/rsaconf-dev2dev
_______________________________________________
gtkpod-cvs2 mailing list
gtkpod-cvs2@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gtkpod-cvs2
