atrocity wrote:
> I should make it clear that I've also restarted LMS. Twice, in fact.
Ok, quickly before I have to leave.
#1
While working on DPL 3 I switched very often between 2.10.247 (the last
DPL 2 version) and DPL 3. Erland changed the code in the end so that DPL
would never ask for or require the license manager. And it never did. So
don't know what's going on there. Did you dl the old plugin from the
link on my github page and followed the steps there?
#2
"Albums - never played" means just that. Albums with no tracks in them
that have been played before = the sum of the play counts of all tracks
in an album would be 0. Also in the latest release version 3.1.7 there's
still a minimum track requirement of 3 tracks for albums to be
considered. In the lastest (but not yet released) version on github you
can change this value.
>From what I understand you want -partially- played albums - which is
probably the state of most albums (at least most of mine).
Anyway here's a very quick draft of a playlist that should meet your
parameters. So if you're feeling adventurous (haven't tested it at
all):
Code:
--------------------
-- PlaylistName:Albums - partially played
-- PlaylistGroups:
create temporary table dynamicplaylist_random_albums as
select partiallyplayed.album as album from
(select distinct tracks.album as album from tracks
join tracks_persistent on
tracks_persistent.urlmd5 = tracks.urlmd5 and
(tracks_persistent.playCount = 0 or tracks_persistent.playCount is null)
left join dynamicplaylist_history on
dynamicplaylist_history.id=tracks.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
tracks.audio = 1
and dynamicplaylist_history.id is null
and not exists (select * from tracks t2, genre_track,
genres
where
t2.id =
tracks.id and
tracks.id =
genre_track.track and
genre_track.genre = genres.id and
genres.name in
('Spoken','Interview','Comedy'))
group by tracks.album
order by random()
limit 10) as partiallyplayed
order by random()
limit 1;
select distinct tracks.url from tracks
join dynamicplaylist_random_albums on
dynamicplaylist_random_albums.album = tracks.album
join tracks_persistent on
tracks_persistent.urlmd5 = tracks.urlmd5 and
(tracks_persistent.playCount = 0 or tracks_persistent.playCount is null)
left join dynamicplaylist_history on
dynamicplaylist_history.id=tracks.id and
dynamicplaylist_history.client='PlaylistPlayer'
where
tracks.audio = 1
and dynamicplaylist_history.id is null
and not exists (select * from tracks t2, genre_track, genres
where
t2.id = tracks.id and
tracks.id =
genre_track.track and
genre_track.genre =
genres.id and
genres.name in
('Spoken','Interview','Comedy'))
group by tracks.id
order by dynamicplaylist_random_albums.album;
drop table dynamicplaylist_random_albums;
--------------------
Put this code in a (text) file and save it as
-partiallyplayedalbums*.sql.xml*- and then put the file in the DPL
custom playlist folder (if you haven't changed the path it should be in
the LMS playlist folder). It should be listed under -Not classified-.
It will only play *un*played songs of -partially- played albums and
exclude the genres 'Spoken','Interview', and 'Comedy'. You can add more
genres in the 2 lines. I'm not sure if it will add the -entire- album
(did v2 add a complete box of 500 tracks?) because after all DPL is a
lot about dynamic random mixes, very much designed to increase
randomness, in this case getting tracks in small batches and each batch
a new query and therefore possibly new album. Anyway, I really have to
go. Hope this helped a bit.
------------------------------------------------------------------------
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
