"Rating" in cached event details xml

[zehd]

Code:

<episode><epnum>107</epnum><seasonnum>04</seasonnum><prodnum>2F01</prodnum><airdate>1994-10-02</airdate><link>http://www.tvrage.com/The_Simpsons/episodes/206574</link><title>Itchy & Scratchy Land</title><screencap>http://images.tvrage.com/screencaps/31/6190/206574.jpg</screencap></episode>

from thetvdb.com

Code:

<Episode>
    <id>55558</id>
    <Combined_episodenumber>4.0</Combined_episodenumber>
    <Combined_season>6</Combined_season>
    <DVD_chapter>
    </DVD_chapter>
    <DVD_discid>
    </DVD_discid>
    <DVD_episodenumber>4.0</DVD_episodenumber>
    <DVD_season>6</DVD_season>
    <Director>Wesley Archer</Director>
    <EpImgFlag>1</EpImgFlag>
    <EpisodeName>Itchy &amp; Scratchy Land</EpisodeName>
    <EpisodeNumber>4</EpisodeNumber>
    <FirstAired>1994-10-02</FirstAired>
    <GuestStars>
    </GuestStars>
    <IMDB_ID>
    </IMDB_ID>
    <Language>en</Language>
    <Overview>The family's trip to Itchy &amp; Scratchy Land takes an unexpected turn when high-tech robots malfunction and become violent. </Overview>
    <ProductionCode>2F01</ProductionCode>
    <Rating>7.7</Rating>
    <RatingCount>16</RatingCount>
    <SeasonNumber>6</SeasonNumber>
    <Writer>John Swartzwelder</Writer>
    <absolute_number>107</absolute_number>
    <filename>episodes/71663/55558.jpg</filename>
    <lastupdated>1268519441</lastupdated>
    <seasonid>2740</seasonid>
    <seriesid>71663</seriesid>
  </Episode>

[mvallevand]

I scrape and use API's. I get art from thetvdb, tvrage and themoviedb in my SearchLite plugin but I also wrote lots of search snippets that I never used while I was playing.

Martin

[zehd]

I scrape and use API's. I get art from thetvdb, tvrage and themoviedb in my SearchLite plugin but I also wrote lots of search snippets that I never used while I was playing.

Martin

That sounds like a lot of jumping around for each entry... was it quick?

And I suppose it was entirely dependant on the inet...

Maybe download from all those sources and fill a series xml that could be cached.. and read.. even when the net isn't working

[mvallevand]

SearchLite already caches the raw series xml in Media\Shows as Titlename.xml Searching is pretty fast.

Martin

[zehd]

I've just been playing with it... pretty cool... it seems that with an extra query for a shows episode list... you'd have your season and ep numbers just like that..

Just don't do Sesame Street or Cops... the're like a couple of MB for the episode list :-)

[zehd]

Anyway.. I guess what we're looking for for the event xml is

Code:

<Event>
  <OID>1017388</OID>
  <Title>Off the Map *</Title>
  <SubTitle>Es Un Milagro</SubTitle>
  <Description>A controversial transplant causes chaos at the clinic; Tommy feels threatened by Mina&apos;s new romantic interest.</Description>
  <ChannelOID>7149</ChannelOID>
  <StartTime>2011-03-24T02:00:00.0000000Z</StartTime>
  <EndTime>2011-03-24T03:00:00.0000000Z</EndTime>
  <UniqueID>EP01279627.0011</UniqueID>
  <SeasNum>1</SeasNum>
  <EpNum>7</EpNum>
  <Rating>PG, Gross Surgery stuff</Rating>
</Event>

and an example of my wish, (cause I haven't been flogged yet)
Maybe something like
<Genre_aRGB>ff480000</Genre_aRGB>
<Genre>Adult Situations</Genre>

don't know... seems like a lot.. But we can fill in that stuff during a xmltv preprocess.. including deciding what colours for what genre...

[mvallevand]

Without genre in the EPG_EVENT table, it would mean nothing to me. Sub has said he didn't want to add this so I can live with this for me it is was a nice to have. In SearchLite I distinguish movies from sports and other shows using the unique_id information here in North America, and that would be good enough for me for the EPG

Martin

[imilne]

I can see several ways we could potentially get genre (and colour) support with the minimum of effort of sub's part, if he was willing to add basic support for it to the TV Guide. zehd's suggestion above is certainly a good way, where xmltv files could be post-processed to have the information and colours added. NPVR would then just have to read it and display it, no processing required.

[mvallevand]

The XML field that zehd is talking about doesn't exist in EPG_EVENT it is in SCHEDULED_RECORDING. EPG_EVENT is still a normal table and I think all the necessary fields exist genre, and I suggested to sub that he add it as a field for post processing but he didn't want to. It is a rather complex field and can get get overloaded

I think hard coding colour values at the title level is dumb. Even the generic way I did this in the skin for SearchLite I regret it now, but it is worse in the db.

Martin

[imilne]

sub had said before that GBPVR's method of handling genres was complicated, due to multiple tables and trying to tie all the relationships back together. That's why I thought a simpler - hardcoded - solution might be better.

I'm maybe misunderstanding it, but why can't EPG_EVENT just have an extra couple of columns for genre and colour. It could then be up to plugins, externals tools, etc to populate that if sub doesn't want to. Then all the TV Guide would have to do is look at the entry for each title it has to paint anyway, and change its colour only if required (on the assumption that most people wouldn't pick a custom colour for every genre type).

I can't see how any lack of table normalization really matters in this case. So what if the table contains 10,000 fields all labelled "movie"? Search plugins could still find them all searching every row. I doubt performance would really be an issue, would it?

Iain