torbjorn.jansson at mbox200
Apr 30, 2012, 3:25 PM
Post #10 of 15
> Since he's no longer here to block it I'd be interested in pushing
Re: db schema, metadata and season/episode numbering
[In reply to]
> forward, at
> least in the UK it's pretty decent information. There's no reason to
> ignore it, especially when the current metadata lookup is so hit and
> miss (tv
> espiodes frequently given film metadata and vice-versa), having
> information would either make it more reliable or as reliable, but
> not less. Even if the air order differs from the order at tvdb.com
> etc) can always take precedence over episode number.
> If nothing else it could be inserted as airepisode/airseason - let
> those of us
> who get this data use it in the UI and for sorting.
> Stuart Morgan
I'm all for it.
Thatâ€™s why I started to look into this.
What I have now is a bit of a hack and takes advantage of the syndicatedepisodenumber being updated with the right info by mythfilldatabase with the xmltv season and episode info.
The query below is can probably be done better and it would have been nice with some regexp matching.
IF(INSTR(syndicatedepisodenumber,'S')>0,SUBSTRING(syndicatedepisodenumber,2,INSTR(syndicatedepisodenumber,'S')-2),SUBSTRING(syndicatedepisodenumber,2,LENGTH(syndicatedepisodenumber))) AS e,
IF(INSTR(syndicatedepisodenumber,'S')=0,0,SUBSTRING(syndicatedepisodenumber,INSTR(syndicatedepisodenumber,'S')+1,99)) AS s
) AS A SET `mythconverg`.`recorded`.season=A.s, `mythconverg`.`recorded`.episode=A.e
mythtv-dev mailing list
mythtv-dev [at] mythtv