Bug 596 - Display total duration of a playlist
: Display total duration of a playlist
Status: RESOLVED FIXED
Product: Logitech Media Server
Classification: Unclassified
Component: Web Interface
: unspecified
: All All
: -- enhancement with 6 votes (vote)
: 7.9.x
Assigned To: Michael Herger
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2004-09-30 01:04 UTC by Jim Willsher
Modified: 2014-06-04 15:46 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jim Willsher 2004-09-30 01:04:33 UTC
I've been directed here by Tech Support.

There seems to be no way to display the total duration of a playlist. I'm 
currently putting together a playlist to cover a 14-hour music session, and 
without this information I'm working in the dark.

The player itself shows "1 of 105", but it would be cool if the player (or web 
interface, or both) could show the playlist length.

Keep up the good work. This product rocks!!!!
Comment 1 Max Spicer 2005-09-28 10:53:45 UTC
The Summary for this bug should be "Display total duration of a playlist" to
make searching easier.  I'm not "sufficiently empowered" to change it myself.  :-(
Comment 2 Jim Willsher 2006-02-11 07:19:17 UTC
Can anyone advise me how I would go about enhancing the UI to show this information?

The SQL for this is very simple:

SELECT (SUM(secs)) AS TotalSecs
FROM tracks
WHERE id IN (SELECT track FROM playlist_track WHERE playlist=4057)

(for playlist 4057). Then the TotalSecs field just needs to be converted into HH:MM:SS.

But I have no idea how to change the gui to show this, so I have to do it via a separate PHP script :-(
Comment 3 Chris Owens 2010-05-06 15:54:41 UTC
Dean doesn't work here any more :)
Comment 4 Alan Young 2011-11-06 23:23:47 UTC
Unassigned bugs cannot have a priority.
Comment 5 Michael Herger 2014-06-04 12:26:55 UTC
Should be feasible in the web UI. Let's see what I can come up with.
Comment 6 Michael Herger 2014-06-04 15:46:46 UTC
Commit a886b428f2ab6459a8b090c5b5bb80185b9e72ea - added the playtime to the Default skin.

It's been a while since I've fixed three digit bugs :-)