rlem wrote: > Hi all, > > For the record: I'm still very happy with DP3 ;-). > Mainly I'm making (ahem, "hacking together", 'with a little help' > (https://www.cameron.willmot.ca/posts/dynamicplaylist/)) my own custom > Dynamic Playlists that should work -without user interaction-, so just > click and play. > I've got things like "Toprated songs added in the past year, and in > genre X, Y, Z" working perfectly. > > The only thing that's not (really) working is *excluding songs that were > played recently* (say: in the last 3 days). > This SQL with Beatles top rated tracks is playing fine (no errors in the > log): > > ...but the > > > Code: -------------------- > > and ifnull(track_statistics.lastplayed,0)<(STRFTIME("%s",DATE('NOW','-3 DAY'))) -------------------- > > > > seems to be ignored, because Carry That Weight is queued, but it > shouldn't have been because it was last played yesterday: > > How do other people do this? > > Thanks, > Randy
What br@m said. TrackStat's *track_statistics* table and the default LMS *tracks_persistent* table basically contain the some information. So if you're just retrieving -ratings- or stats like -last played, date added- or -playcount- you can simply query *tracks_persistent*. I don't know -how- you use TrackStat but seeing that you seem to have another rating plugin installed (Ratings Light?) you don't necessarily need TrackStat to set ratings or retrieve ratings/stats. The website you linked to probably uses DPL v2. With DPLv3 you can use your custom dynamic playlist definition directly in DPL (without SQLPlayList), just by putting the file in the DPL custom playlist folder. SQLPlayList is still a good way to start creating your custom dynamic playlist but please remember that it can't know '*all DPL v3 playlist parameters*' (https://github.com/AF-1/lms-dynamicplaylists/wiki/DPL-playlist-format#playlist-parameters) because its last version dates from before DPL v3. '*github repos*' (https://github.com/AF-1/) ------------------------------------------------------------------------ afriend's Profile: http://forums.slimdevices.com/member.php?userid=39306 View this thread: http://forums.slimdevices.com/showthread.php?t=115073 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
