Media List Editor Examples

  Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
DanCooper Offline
Moderator
Posts: 3,376
Joined: Apr 2012
Reputation: 167
Location: Switzerland
Post: #16
(2016-04-24 03:26)Daydream Wrote:  EMM does not store the resolution of art files (poster, thumbs, fanart, etc), correct?
Nope, but that's a good idea for a new feature ;-)
find quote
Fail$tyle420 Offline
Posting Freak
Posts: 1,187
Joined: Jul 2014
Reputation: 43
Post: #17
Would this work for hevc on tvshows? :
Code:
SELECT DISTINCT
  tvshowlist.*
FROM
  tvshowlist
  INNER JOIN TVShowVStreams ON (tvshowlist.idTVShow = TVShowVStreams.TVShowID)
WHERE
  TVShowVStreams.Video_Codec = 'hevc'

*EDIT* - Just got home and tried this out, no go. I replaced tvshow with episode for everything except first 2 tvshowlists, still nadda. What am I missing??
(This post was last modified: 2016-04-28 02:23 by Fail$tyle420.)
find quote
Daydream Offline
Junior Member
Posts: 26
Joined: Jul 2009
Reputation: 0
Location: New York
Exclamation  RE: Media List Editor Examples
Post: #18
Well, I'm not an expert but for starters there is no TVShowVStreams table in the database (if you just replaced words in the syntax of a previous query, it doesn't work like that; get SQLiteSpy and look at the database, the MyVideos37.emm file or whatever it is). Further there's some description here http://embermediamanager.org/databasemodel/index.html for what's what.

I'd like to understand better too what can we do with episodes. If a movie is a standalone element and everything can be referred to it, an episode is part of a season, part of a series, and displaying a selection works in a more complex way. A proper query should show only the series, with only the seasons, with only the episodes that respect a certain condition. I can't get it to work like that right now.

As it stands there is no direct connection (that I can see) between TVVStream (the table I believe you were actually going for), and the tvshowlist view. We could double join with the episode table but I get weird results. Somebody that is stronger with the Force (*cough SQL*) should show us Smile.
find quote
DanCooper Offline
Moderator
Posts: 3,376
Joined: Apr 2012
Reputation: 167
Location: Switzerland
Post: #19
That's not possible with episodes. There is no "episodes only" list that we can display to list all episodes by a query.
I think we have to change the tv show view/list to make it possible to use custom season/episode filters.
find quote
Fail$tyle420 Offline
Posting Freak
Posts: 1,187
Joined: Jul 2014
Reputation: 43
Post: #20
(2016-04-28 03:50)Daydream Wrote:  Well, I'm not an expert but for starters there is no TVShowVStreams table in the database (if you just replaced words in the syntax of a previous query, it doesn't work like that; get SQLiteSpy and look at the database, the MyVideos37.emm file or whatever it is). Further there's some description here http://embermediamanager.org/databasemodel/index.html for what's what.

I'd like to understand better too what can we do with episodes. If a movie is a standalone element and everything can be referred to it, an episode is part of a season, part of a series, and displaying a selection works in a more complex way. A proper query should show only the series, with only the seasons, with only the episodes that respect a certain condition. I can't get it to work like that right now.

As it stands there is no direct connection (that I can see) between TVVStream (the table I believe you were actually going for), and the tvshowlist view. We could double join with the episode table but I get weird results. Somebody that is stronger with the Force (*cough SQL*) should show us Smile.
Yeah, I have no idea what I'm doing (if it wasn't obvious already). Thank you for the link, now I actually have something to work with lol! Thank you for trying!

(2016-04-28 09:42)DanCooper Wrote:  That's not possible with episodes. There is no "episodes only" list that we can display to list all episodes by a query.
I think we have to change the tv show view/list to make it possible to use custom season/episode filters.

Ok, so I didn't know what the hell I was doing AND it's not possible Tongue Thank you for the info!
find quote
DanCooper Offline
Moderator
Posts: 3,376
Joined: Apr 2012
Reputation: 167
Location: Switzerland
Post: #21
(2016-04-28 19:42)Fail$tyle420 Wrote:  Ok, so I didn't know what the hell I was doing AND it's not possible Tongue Thank you for the info!

It's not possible AND your SQL statement is wrong TongueBig Grin
find quote
brunosso Offline
Member
Posts: 62
Joined: May 2014
Reputation: 1
Location: Italy
Post: #22
Dan is possible to create a list of all tvshows is not "Locked" Confused or with the status "Continuing" and not "Ended"

I'm not in danger Skyler, I'm the danger! A guy opens his door and get shot, and you think that's me? No, I'M THE ONE WHO KNOCKS!!

Ember Media Manager lover...
(This post was last modified: 2016-05-10 13:08 by brunosso.)
find quote
DanCooper Offline
Moderator
Posts: 3,376
Joined: Apr 2012
Reputation: 167
Location: Switzerland
Post: #23
(2016-05-10 13:08)brunosso Wrote:  Dan is possible to create a list of all tvshows is not "Locked" Confused or with the status "Continuing" and not "Ended"

Code:
SELECT
  *
FROM
  tvshowlist
WHERE
  tvshowlist.Lock = 0



Code:
SELECT
  *
FROM
  tvshowlist
WHERE
  tvshowlist.Status NOT LIKE 'ended'


or


Code:
SELECT
  *
FROM
  tvshowlist
WHERE
  tvshowlist.Status LIKE 'continuing'
(This post was last modified: 2016-05-10 13:20 by DanCooper.)
find quote
hst12 Offline
Junior Member
Posts: 1
Joined: Nov 2015
Reputation: 0
Post: #24
Surround sound movies with 6 channels or more

Code:
SELECT DISTINCT movielist.* FROM MoviesAStreams INNER JOIN movielist ON (MoviesAStreams.MovieID=movielist.idMovie) WHERE MoviesAStreams.Audio_Channel>=6
find quote
Post Reply