Have you looked at the code in the ui_branch ? You can check this out of CVS, and have a look if you want, however the code is in a bit of a state of limbo (and has been for some time I'm afraid).
I had a go at adding compilation support to this branch. I think if you look through the mailing list achive you will see my earlier messages about it. I'm not sure that I understand what you propose below. The database structure already has an 'Artist' field in the Album table and an 'Artist' field in the 'Track' table, so you effectively already have a TrackArtist and DiscArtist already. My approach was to scan the database for groups of Albums with the same name and different artists, and then to merge them into one 'metaartist' called 'Compilation' or something. There were quite a few changes required, and I think there are still a few problems. Maybe we could collaborate a bit. btw how does the cost of a CD jukebox with 300 cd's like you describe compare to a couple of large harddiscs? Rob > Artist table... > > A Compilation Album would then look something like this: > > Id Name Artist AlbumArtist > 101 "Mix 1" 3 (Artist1) 1 (Various > Artists) > 102 "Mix 1" 4 (Artist2) 1 (Various > Artists) > etc... > > A normal Album would look like this: > > Id Name Artist > AlbumArtist > 201 "101" 10 (Depeche Mode) > 10 (Depeche Mode) > > I realize that this will need some changes in the SQL scripts, and the > displaying of the albums... > > I cannot see a problem with the SQL side of things, if agreed on this > way to do it, I could go though the SQL scripting, and adjust it if you > like ? > > Also it shouldn't be a biggie to write a quick Perl script to fill up > the AlbumArtist attribute with either "Various Artist" or the Artist > name... > > Tell me what you think about this solution... > > Regards, > Heino Walther > > > -- 01010010 01101111 01100010 01100101 01110010 01110100 01001000 01100001 01110010 01110100 _______________________________________________ Obs-dev mailing list [EMAIL PROTECTED] http://www.freeamp.org/mailman/listinfo/obs-dev
