[mythtv-users] [PATCH] Mythweb -- Mythmusic playlist functionality AND Request for SQL help

[Christopher Flynn]

Well I took a quick look at things and I downloaded your patch and I
think there needs to be some work done in mythmusic itself to allow
multiple playlists. (Unless I'm missing something here)

Perhaps I should take this over to the devlist but it almost seems
silly to only allow for one playlist. I also think the database should
be changed a little. we need a lookup table that consists of the
playlistid and the songid (intid) we could then drop the songlist
field and have individual entries that would have the playlist that
the song belongs to and then the song itself.

You could then order things however you want. You could even add a
order number field to the lookup table and allow the user to order
their playlists to play things in a certain order. Maybe I'll take a
look at it later but I don't really have all that much free time right
now.


On Wed, 27 Oct 2004 14:23:16 -0400, Ryan Steffes <rbsteffes at gmail.com> wrote:
> >> Right now, while it works, it doesn't appear to because the tracks
> >> show up in database order, not playlist order.  If there isn't a good
> >> way, there are work around fixes but they'd require more active
> >> sorting and could get ugly fast.
> 
> >I think you may want to try and unload a little more of your code onto
> >the database instead of trying to code it yourself... the database is
> >great at storing and manipulating data, no need to reinvent the wheel.
> >Unless I missed what you are trying to do in the first place in that
> >case just ignore me.
> 
> No, this is actually exactly what I'm trying to do.  What I've got is
> a string like:
> 
> 2,5,6,1,7,3,10
> 
> and it does a
> where intid is in ("2,5,6,1,7,3,10")
> 
> What I'd LIKE is to be able to say order by intid (2,5,6,1,7,3,10) or
> something like that.  Instead, it'll sort by the actual intid and give
> me back 1 2 3 5 6 7 10
> 
> Failing that, I just uploaded a version that does the sorting
> manually, even though I'm not thrilled doing it that way.  The
> playlist reordering is a little gimpy, it's a combined version of some
> javascript listbox reordering I found in tutorials modified to do what
> we need.  I don't particularly LIKE it though, but can't think of
> another great way to do it that isn't cumbersome.
> 
> I'm sending out a few emails to people who are a heck of a lot better
> with css than me, and maybe they can point me in the right direction.
> I'd really like to be able to drag and drop list items in an unordered
> list, I think that'd be ideal.
> 
> Newer version is in the same place, patched against current CVS.
> 
> 
> http://www.afferentsys.com/~rbsteffes/patch-mythmusic.bz2
> 


-- 
You must be the change you wish to see in the world. - Gandhi