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 ?
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};