THIS THREAD IS *EXCLUSIVELY* DEDICATED TO PROVIDING *HELP* WITH SQLITE STATEMENTS FOR USERS WHO WANT TO *CREATE* THEIR OWN *(CUSTOM) DYNAMIC PLAYLISTS*. OF COURSE, YOU CAN ALSO POST YOUR -WORKING- CUSTOM DYNAMIC PLAYLISTS HERE FOR OTHERS TO USE OR AS A SOURCE OF INSPIRATION. SO NOBODY HAS TO REINVENT TO WHEEL.
::Before posting I recommend you take a look at the '*dynamic playlists*' (https://github.com/AF-1/lms-dynamicplaylists/tree/main/DynamicPlaylists3/Playlists) (incl. context menu playlists) that come with the plugin. They are a good starting point and may help you understand how SQLite works. And please read the '*wiki on the DPL playlist format*' (https://github.com/AF-1/lms-dynamicplaylists/wiki/DPL-playlist-format) and the '*FAQ*' (https://github.com/AF-1/lms-dynamicplaylists#faq).:: Once you have a working SQLite statement, all you need to do is - open a -plain text- editor of your choice (e.g. -Notepad- on Windows or -BBEdit- on macOS) - paste the dynamic playlist definition (incl. your SQLite statement) - save the file with a *sql.xml* file extension (instead of txt). Example: mycustomplaylistname*.sql.xml* - move this file to the folder for custom playlists called "*DPL-custom-lists*" in the LMS playlists folder (unless you changed its location). Now your dynamic playlist should be listed in the playlist group you chose/created or in the -Not classified- group if it doesn't belong to any group. Very easy. So the challenging part is figuring out the SQLite statement. And that's what this thread is for. I can't promise that I'll have time to answer your requests. Fortunately, there are other users who I know will help you as well. *Plugin repositories:* 'Ratings Light' (https://github.com/AF-1/lms-ratingslight) 'Visual Statistics' (https://github.com/AF-1/lms-visualstatistics) 'Use Comment Tag Info' (https://github.com/AF-1/lms-usecommenttaginfo) 'Dynamic Playlists 3 FAQ' (https://github.com/AF-1/lms-dynamicplaylists#faq) 'Custom Skip 3 FAQ' (https://github.com/AF-1/lms-customskip#faq) ------------------------------------------------------------------------ afriend's Profile: http://forums.slimdevices.com/member.php?userid=39306 View this thread: http://forums.slimdevices.com/showthread.php?t=115501
_______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
