Display total (thetvdb) number of episodes in season.

Discussion in 'My TVSeries' started by ajs, October 28, 2015.

  1. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    Property shows the number of episodes in the series, season. But not those that have a local library and all. To be able to display: Episodes: 10 / 20. That is, 10 is in the local library, of the planned 20.
    ie: 10 - Count of Local Episodes (local_episodes table), 20 - Count of Online Episodes (online_episodes table)
    Like:
    Code (SQL):
    1. SELECT DISTINCT seasonindex, COUNT(episodeindex) FROM local_episodes WHERE seriesid = 259948 GROUP BY seasonindex
    Code (Text):
    1. SeasonIndex    count(episodeindex)
    2. 2    10
    3. 3    2
    Code (SQL):
    1. SELECT DISTINCT seasonindex, COUNT(episodeindex) FROM online_episodes WHERE seriesid = 259948 GROUP BY seasonindex
    Code (Text):
    1. SeasonIndex    count(episodeindex)
    2. 1    13
    3. 2    10
    4. 3    10
    For 3 season of 259948 series - result 2 / 10 :)


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    Any way to display an total (thetvdb) number of episodes in season?

    PS: #TVSeries.Season.EpisodeCount - It shows only the number of episodes in the local database.
     
    • Thank You! Thank You! x 1
  4. catavolt
    • Team MediaPortal
    • Administrator

    catavolt Design Group Manager

    Joined:
    August 13, 2007
    Messages:
    12,286
    Likes Received:
    5,008
    Gender:
    Male
    Occupation:
    Technical Documentation, Translation
    Location:
    Lanzarote
    Ratings:
    +7,452 / 38
    Home Country:
    Germany Germany
    Show System Specs
    Hmm, not sure about this one :eek:
    #TVSeries.Season.EpisodeCount shows me the episodes for that season, even if I don´t have all episodes available ;)
    In the episodes view I use #TVSeries.FilteredEpisodeCount - maybe that helps you?
     
  5. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
  6. catavolt
    • Team MediaPortal
    • Administrator

    catavolt Design Group Manager

    Joined:
    August 13, 2007
    Messages:
    12,286
    Likes Received:
    5,008
    Gender:
    Male
    Occupation:
    Technical Documentation, Translation
    Location:
    Lanzarote
    Ratings:
    +7,452 / 38
    Home Country:
    Germany Germany
    Show System Specs
    Correct ;)
     
  7. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    I do not want turning it on, I want to see how my local episodes and how much this season overall.
     
  8. catavolt
    • Team MediaPortal
    • Administrator

    catavolt Design Group Manager

    Joined:
    August 13, 2007
    Messages:
    12,286
    Likes Received:
    5,008
    Gender:
    Male
    Occupation:
    Technical Documentation, Translation
    Location:
    Lanzarote
    Ratings:
    +7,452 / 38
    Home Country:
    Germany Germany
    Show System Specs
    So why don´t you try the #TVSeries.FilteredEpisodeCount as I suggested already in my first answer?
    You could use it like this "#TVSeries.FilteredEpisodeCount of #TVSeries.Season.EpisodeCount" ;)
     
  9. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    I have turned off the option to show the episodes that are not in the database.
    What does it property?
    It shows the number of episodes in the database.
     
  10. catavolt
    • Team MediaPortal
    • Administrator

    catavolt Design Group Manager

    Joined:
    August 13, 2007
    Messages:
    12,286
    Likes Received:
    5,008
    Gender:
    Male
    Occupation:
    Technical Documentation, Translation
    Location:
    Lanzarote
    Ratings:
    +7,452 / 38
    Home Country:
    Germany Germany
    Show System Specs
    Just try it out, Andrew!!!!
     
  11. ajs
    • Team MediaPortal

    ajs Development Group

    Joined:
    February 29, 2008
    Messages:
    8,829
    Likes Received:
    2,792
    Gender:
    Male
    Occupation:
    IT
    Location:
    Kyiv
    Ratings:
    +4,797 / 30
    Home Country:
    Ukraine Ukraine
    Show System Specs
    No media portal.:( I can not try. :(And wait until the weekend no strength.:mad::):whistle::coffee:
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!