When I choose playlists and I can see the list of playlists. How can I create a button next to the batch download button?
My button will run a query and print out or download a list of all the files in the playlist with their full paths. I can then take this list and rsync them to another machine. I prefer rsync because batch download takes too long on my server.
The query:
SELECT s.file INTO OUTFILE '/tmp/result.txt' LINES TERMINATED BY '\n' FROM song s LEFT JOIN playlist_data pd ON s.id = pd.object_id LEFT JOIN playlist p ON p.id = pd.playlist WHERE p.id = $playlist_id;
