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

Ryan Steffes rbsteffes at gmail.com
Wed Oct 27 18:23:16 UTC 2004


>> 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


More information about the mythtv-users mailing list