Opened 18 years ago

Closed 18 years ago

#4348 closed patch (fixed)

"Recently Played Songs" list in mythweb shows recently added songs as well

Reported by: Ash Bostock <abostock@…> 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);

Change History (1)

comment:1 by Rob Smith, 18 years ago

Resolution: → fixed
Status: new → closed

(In [15801]) Fixes #4348, this won't show added songs in the last played section of mythwebs mythmusic. Thanks Ash!

Note: See TracTickets for help on using tickets.