Windows - movie sets - what is the preferd way ?

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
rami.shaked Offline
Junior Member
Posts: 12
Joined: Apr 2012
Reputation: 0
Post: #16
(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.
find quote
vikjon0 Offline
---
Posts: 2,500
Joined: Apr 2009
Reputation: 8
Location: Sweden
Post: #17
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.
find quote
rami.shaked Offline
Junior Member
Posts: 12
Joined: Apr 2012
Reputation: 0
Post: #18
(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 !!
find quote
sialivi Offline
Posting Freak
Posts: 1,170
Joined: Dec 2008
Reputation: 9
Location: Sweden
Post: #19
(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>
(This post was last modified: 2012-04-29 22:51 by sialivi.)
find quote
rami.shaked Offline
Junior Member
Posts: 12
Joined: Apr 2012
Reputation: 0
Post: #20
(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...)
find quote
crackers Offline
Member
Posts: 86
Joined: Sep 2009
Reputation: 0
Post: #21
The XWMM remote manager will let you change/manage sets. It does have a bit of weird focus/update issues, but works great for managing sets (and editing other things).
find quote
Chokladkakan Offline
Junior Member
Posts: 40
Joined: Apr 2012
Reputation: 0
Post: #22
(2012-04-30 05:46)rami.shaked Wrote:  I dont like it because i dindnt find a way to see the playlists quickly from the home screen ( you should press librery...)

Most better skins allow for custom buttons on the home screen. Typically, those can be assigned to open playlists.
find quote
rami.shaked Offline
Junior Member
Posts: 12
Joined: Apr 2012
Reputation: 0
Post: #23
(2012-04-30 11:06)Chokladkakan Wrote:  
(2012-04-30 05:46)rami.shaked Wrote:  I dont like it because i dindnt find a way to see the playlists quickly from the home screen ( you should press librery...)

Most better skins allow for custom buttons on the home screen. Typically, those can be assigned to open playlists.

What is your recomnded skin? (i'm using the default)
find quote
Chokladkakan Offline
Junior Member
Posts: 40
Joined: Apr 2012
Reputation: 0
Post: #24
Practically every skin I've tried will do this. Personally I use Xperience1080 in my bedroom and Simplicity in the living room.

If you need help making the home screen buttons, I'm sure people will help you in the corresponding threads.
(This post was last modified: 2012-04-30 20:33 by Chokladkakan.)
find quote
rami.shaked Offline
Junior Member
Posts: 12
Joined: Apr 2012
Reputation: 0
Post: #25
(2012-04-30 19:31)Chokladkakan Wrote:  Practically every skin I've tried will do this. Personally I use Xperience1080 in my room bedroom and Simplicity in the living room.

If you need help making the home screen buttons, I'm sure people will help you in the corresponding threads.

10x Smile works great !!!
(This post was last modified: 2012-05-01 19:52 by rami.shaked.)
find quote
Post Reply