mhsparks wrote: > I suppose these are stored somewhere different to the tracks table in > the database (if they are even stored there) so the existing SQL doesn't > retrieve them. Obviously would be a nice enhancement but grateful the > plugins still work on my local collection. >
It someone is interested to try to fix it check with Michael(mherger) how they are represented in the database. My plugins does some filtering on tracks.audio=1 so if this isnt the case for online tracks that would explain it. There need to be a filter because playlists are also stored in tracks table but it might have to be adopted to work with integrated online music. Could be that there is also some filtering in the Perl code in my plugins that removes everything that isnt a file:// url or have tracks.remote=1 but in that case its probably unintentionally. It might also be that they arent in the database at all and that only the album is represented in the database while the tracks are retrieved from the streaming service when the user selects to play the album. If this is the case they are probably neither included if you play random songs with Random Mix plugin. In this case its harder to solve since many of my plugins are track based and assumes the track is represented in the database. In theory is should be possible to retrieve them into the database during scanning but Michael might have selected to not do that since the tracks might have changed in the streaming service since last rescan or because he dont want to overload the streaming service with requests during scanning. To me personally it feels like online music should be included when playing random songs with the standard Randim Mix plugin so if this isnt the case it can maybe be considered to be a bug/design flaw. If someone wants to look into this the first thing is probably to check if the tracks are in the database, disappears in the SQL query or if they are removed from the result in the Perl code in the plugin. There is and old brief description of the database structure here: https://wiki.slimdevices.com/index.php/SlimServerDatabaseStructure.html#tracks The above page was written a long time ago so you also need to look at schema changes done after it was written: https://github.com/Logitech/slimserver/tree/public/8.1/SQL/SQLite I think schema changes from schema_9_up and later might be of interest, I think schema_21_up is related to the online music integration. Erland Isaksson ('My homepage' (http://erland.isaksson.info)) Developer of 'many plugins/applets' (https://wiki.slimdevices.com/index.php/User_Erland.html) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
