rendered paste bodyIndex: mythtv/programs/mythbackend/httpstatus.cpp
===================================================================
--- mythtv/programs/mythbackend/httpstatus.cpp (revision 12978)
+++ mythtv/programs/mythbackend/httpstatus.cpp (working copy)
@@ -1120,7 +1120,11 @@
if (query.isConnected())
{
- query.prepare("SELECT filename FROM music_songs WHERE song_id = :KEY" );
+ query.prepare("SELECT CONCAT_WS('/', music_directories.path, "
+ "music_songs.filename) AS filename FROM music_songs "
+ "LEFT JOIN music_directories ON "
+ "music_songs.directory_id=music_directories.directory_id "
+ "WHERE music_songs.song_id = :KEY");
query.bindValue(":KEY", nTrack );
query.exec();