Wow, nice enhancement+ Add jump to Now Playing when music play start
I now have no TV server, but if someone tell me where to get them, I'll add.Any chance of adding latest recorded tv summary/plot ?
United Kingdom
In the tvserver sql database my query isI now have no TV server, but if someone tell me where to get them, I'll add.Any chance of adding latest recorded tv summary/plot ?![]()
[TableColumn("idRecording", NotNull = true), PrimaryKey(AutoGenerated = true)] private int idRecording;
[TableColumn("idChannel", NotNull = true), ForeignKey("Channel", "idChannel")] private int idChannel;
[TableColumn("idSchedule", NotNull = true), ForeignKey("Schedule", "idSchedule")] private int idSchedule;
[TableColumn("isRecording", NotNull = false)] private bool isRecording;
[TableColumn("startTime", NotNull = true)] private DateTime startTime;
[TableColumn("endTime", NotNull = true)] private DateTime endTime;
[TableColumn("title", NotNull = true)] private string title;
[TableColumn("description", NotNull = true)] private string description;
[TableColumn("genre", NotNull = true)] private string genre;
[TableColumn("fileName", NotNull = true)] private string fileName;
[TableColumn("keepUntil", NotNull = true)] private int keepUntil;
[TableColumn("keepUntilDate", NotNull = true)] private DateTime keepUntilDate;
[TableColumn("timesWatched", NotNull = true)] private int timesWatched;
[TableColumn("idServer", NotNull = true), ForeignKey("Server", "idServer")] private int idServer;
// stores the last position - to make resume possible
[TableColumn("stopTime", NotNull = true)] private int stopTime;
[TableColumn("episodeName", NotNull = true)] private string episodeName;
[TableColumn("seriesNum", NotNull = true)] private string seriesNum;
[TableColumn("episodeNum", NotNull = true)] private string episodeNum;
[TableColumn("episodePart", NotNull = true)] private string episodePart;
If I can add here:Also Album Artist Bio when available
SELECT strAlbumArtist, strAlbum, strFileType, MAX(dateAdded) as dateAdded, CAST(ROUND(AVG(iTimesPlayed)) AS INTEGER) as iTimesPlayed, MAX(dateLastPlayed) as dateLastPlayed, "+
"GROUP_CONCAT(strGenre,'|') as strGenre, GROUP_CONCAT(strPath,'|') as strPath "+
"FROM tracks "+
"GROUP BY strAlbumArtist, strAlbum, strFileType "+
"ORDER BY {0} DESC LIMIT {1};