(2012-04-29 19:35)vikjon0 Wrote: The exact statement will vary dependning on how you plan to identify the movies.
I had all Disney on a separate folder.
I also created the set first manually (id =2)
insert into setlinkmovie
select '2',movie.idMovie from movie
left outer join files on movie.idFile = files.idFile
left outer join path on files.idPath = path.idPath
where strPath like '%- Disney%'
and movie.idMovie not in (select idMovie from setlinkmovie)
Woo, so fast. Thank you very much!!!!
I'll give it a try. Mayby i'll write a little util for that.
It strange, i didnt find a way to assign movie to a set from the xbmc itself.