Windows movie sets - what is the preferd way ?

I changed like 100 disney movies directly in the database. requires one to know sql though

Use the XWMM Web Interface Add-On. I was going to write up how I did it but this is close enough:

http://www.howtogeek.com/howto/33873/con...ovie-sets/

(2012-04-29 13:10)rakers8 Wrote:  Use the XWMM Web Interface Add-On. I was going to write up how I did it but this is close enough:

http://www.howtogeek.com/howto/33873/con...ovie-sets/

Hi
Thanks, i already know that toil. The problem is that u have to do so for every movie
Im looking for somthing that can assign many movies to set in s single action

(2012-04-29 11:33)vikjon0 Wrote:  I changed like 100 disney movies directly in the database. requires one to know sql though

hi,
just installd sql spy, it looks like the db is stright forword.
can you please guide me with a way i can assign more than one movie to a pre made movie set ?
i saw a table that have the movie linked to the movie set.

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)

(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)

Code:

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.

Quote:Mayby i'll write a little util for that.

I had the idea to base the sets on folder structure. I.e. make up a naming standard to enable a sql script to create and assign sets based on folder name. E.g. "Disney [SET]" or what ever. If a improved versoin of my script runs every 5 minutes it would automatically assign sets.
You would have to manually sort the movies on disk of course, but any system would need to know your wishes somehow.

(2012-04-29 19:57)rami.shaked Wrote:  

(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)

Code:

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.

works great !!

(2012-04-29 11:33)vikjon0 Wrote:  I changed like 100 disney movies directly in the database. requires one to know sql though

...or with a smart playlist. That way it doesn't need to be done again when more movies are added.

(2012-04-29 22:36)sialivi Wrote:  

(2012-04-29 11:33)vikjon0 Wrote:  I changed like 100 disney movies directly in the database. requires one to know sql though

...or with a smart playlist. That way it doesn't need to be done again when more movies are added.

Code:

<?xml version="1.0"?>
<smartplaylist type="movies">
  <name>Disney Movies</name>
  <match>or</match>
  <rule field="path" operator="contains">Disney</rule>
  <rule field="studio" operator="contains">Disney</rule>
</smartplaylist>

Yes it can be done.
I dont like it because i dindnt find a way to see the playlists quickly from the home screen ( you should press librery...)