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

[Ryan Steffes]

On Wed, 27 Oct 2004 11:23:43 -0500, Kevin Kuphal <kuphal at dls.net> wrote:
> Ryan Steffes wrote:
> 
> 
> 
> >http://www.afferentsys.com/~rbsteffes/patch-mythmusic.bz2
> >
> >This patch adds to the functionality I've been working on to add
> >playlist manipulation to mythweb.  Previously added was the ability to
> >create/rename/add to/remove from a playlist.  I've added reordering
> >playlists.
> >
> >That brings me to the second part of the request.  If anyone out there
> >is particularly good at SQL I'm looking for a way to sort a select
> >statement against a known string.  The reason for this is because the
> >way mythweb gets track names is efficient from a query standpoint, it
> >gets them in the order of the intid key for the tracks in the db not
> >the order they are listed in the playlist.  It's because it retrieves
> >as where intid is in ( " playlist ") essentially.  Is there a way I
> >can have it sort against the playlist before returning the rows?
> >That'd make playlist reordering look a lot better.
> >
> >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.
> >
> >
> Wouldn't it be easier to sort them using PHP where you probably have
> alot more options and let the query execute as fast as possible the way
> it does now?
> 
> Kevin
> 

That's one of the work around fixes.  The real answer to your question
is yes, with some alterations to the logic.  I tried to avoid making
particularly drastic changes when more simple ones will do like
avoiding javascript except where I couldn't find another way.

I'm mulling over some ideas that'll keep people from having to
completely redo their themes to work with this theme.  As it is there
are only a few minor changes needed to ignore what I've done and get
old themes to work again.