Latest Media Handler v2.4.X.000 (1 Viewer)

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    15,646
    10,593
    Kyiv
    Home Country
    Ukraine Ukraine
    Can we also get strPlotOutline from movieinfo in myvideo as it's much shorter
    I can add another property to whom it must be a brief description, and who complete.
    #latestMediaHandler.myvideo.latest" + z + ".plotoutline
     

    wizard123

    Retired Team Member
  • Premium Supporter
  • January 24, 2012
    2,569
    2,680
    Home Country
    United Kingdom United Kingdom
    Can we also get strPlotOutline from movieinfo in myvideo as it's much shorter
    I can add another property to whom it must be a brief description, and who complete.
    #latestMediaHandler.myvideo.latest" + z + ".plotoutline
    Great ! Is it possible to make a short summary for movies and tvseries too ? for e.g i use a script to collect the plot but limit it to the first two sentences, this means i don't have to have scrolling text in homescreen :)
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,646
    10,593
    Kyiv
    Home Country
    Ukraine Ukraine
    | AlbumArtist |
    Try run select:
    SQL:
    SELECT tracks.strAlbumArtist, tracks.strAlbum, tracks.strFileType, MAX(tracks.dateAdded) as dateAdded,
      CAST(ROUND(AVG(tracks.iTimesPlayed)) AS INTEGER) as iTimesPlayed, MAX(tracks.dateLastPlayed) as dateLastPlayed,
      GROUP_CONCAT(tracks.strGenre,'|') as strGenre, GROUP_CONCAT(tracks.strPath,'|') as strPath,
      artistinfo.strAMGBio as strLyrics
    FROM tracks
    LEFT JOIN artistinfo ON TRIM(tracks.strAlbumArtist,'| ') = TRIM(artistinfo.strArtist)
    GROUP BY strAlbumArtist, strAlbum, strFileType
    ORDER BY dateLastPlayed DESC LIMIT 10;
    PS: Fixed errors :whistle:
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,646
    10,593
    Kyiv
    Home Country
    Ukraine Ukraine
    @wizard123
    On TVSeries:
    Serie - AddColumn(cSummary, new DBField(DBField.cTypeString));
    Season - AddColumn(cSummary, new DBField(DBField.cTypeString));
    Episode - AddColumn(cEpisodeSummary, new DBField(DBField.cTypeString));
    LMH property - #latestMediaHandler.tvseries.latest" + z + ".plot
     

    Users who are viewing this thread

    Top Bottom