Opened 17 years ago
Closed 17 years ago
#4348 closed patch (fixed)
"Recently Played Songs" list in mythweb shows recently added songs as well
Reported by: | Owned by: | xris | |
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | mythweb | Version: | head |
Severity: | medium | Keywords: | |
Cc: | Ticket locked: | no |
Description
Due to bug #4345 the "Recently Played Songs" list in mythweb shows recently added songs as well. Here's a quick fix...
Index: mythplugins/mythweb/modules/music/mp3act_functions.php =================================================================== --- mythplugins/mythweb/modules/music/mp3act_functions.php (revision 15162) +++ mythplugins/mythweb/modules/music/mp3act_functions.php (working copy) @@ -781,6 +781,7 @@ $query = 'SELECT ms.name, ms.song_id, mt.artist_name, UNIX_TIMESTAMP(ms.lastplay) AS playdate '. 'FROM music_songs AS ms '. 'LEFT JOIN music_artists AS mt ON ms.artist_id=mt.artist_id '. + 'WHERE ms.numplays > 0 '. 'ORDER BY ms.lastplay DESC '. 'LIMIT 40'; $result = mysql_query($query);
Note: See
TracTickets for help on using
tickets.
(In [15801]) Fixes #4348, this won't show added songs in the last played section of mythwebs mythmusic. Thanks Ash!