public Collection <ApiMovie> GetMovies() { var movies = new Collection <ApiMovie>(); var dblines = _parent.DBCommand("video", "SELECT c00,c01,c03,c04,c05,c07,C09,c11,c12,c14,c15,c16,c18,idFile,idMovie,strFileName,strPath,playCount FROM movieview"); if (dblines == null) { return(movies); } foreach (var dbline in dblines) { if (dbline.Length < 18) { _parent.Log("Invalid request DATA : " + dbline); continue; } dbline[4] = dbline[4].Length > 3 ? dbline[4] : "0.0"; var movie = new ApiMovie { Title = dbline[0], Plot = dbline[1], Tagline = dbline[2], Votes = dbline[3], Rating = dbline[4].Substring(0, 3).Trim('.'), Year = XbmcHttp.StringToNumber(dbline[5]), IdScraper = dbline[6], Length = dbline[7], Mpaa = dbline[8], Genre = dbline[9], Director = dbline[10], OriginalTitle = dbline[11], Studio = dbline[12], IdFile = XbmcHttp.StringToNumber(dbline[13]), IdMovie = XbmcHttp.StringToNumber(dbline[14]), FileName = dbline[15], Path = dbline[16], PlayCount = XbmcHttp.StringToNumber(dbline[17]) }; if (movie.FileName.StartsWith("stack://", StringComparison.OrdinalIgnoreCase)) { var temp = movie.FileName.Split(new[] { " , " }, StringSplitOptions.None); movie.IsStack = 1; movie.Hash = XbmcHttp.Hash(temp[0].Replace("stack://", "")); movie.Thumb = @"special://profile/Thumbnails/Video/" + movie.Hash[0] + "/" + movie.Hash + ".tbn"; movie.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + XbmcHttp.Hash(movie.FileName) + ".tbn"; } else { movie.IsStack = 0; movie.Hash = XbmcHttp.Hash(movie.Path + movie.FileName); movie.Thumb = @"special://profile/Thumbnails/Video/" + movie.Hash[0] + "/" + movie.Hash + ".tbn"; movie.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + movie.Hash + ".tbn"; } movies.Add(movie); } return(movies); }
public Collection <ApiTvEpisode> GetTvEpisodes() { var episodes = new Collection <ApiTvEpisode>(); const string req = "SELECT idEpisode,c00,c01,c03,c05,c10,c12,c13,idFile,strFileName,strPath,playCount,strTitle,strStudio,idShow,mpaa FROM episodeview "; var dblines = _parent.DBCommand("video", req); if (dblines == null) { return(episodes); } foreach (var dbline in dblines) { if (dbline.Length < 15) { _parent.Log("Invalid request DATA : " + dbline); continue; } dbline[3] = dbline[3].Length > 3 ? dbline[3] : "0.0"; var episode = new ApiTvEpisode { IdEpisode = XbmcHttp.StringToNumber(dbline[0]), Title = dbline[1], Plot = dbline[2], Rating = dbline[3].Substring(0, 3).Trim('.'), Date = dbline[4], Director = dbline[5], Season = XbmcHttp.StringToNumber(dbline[6]), Episode = XbmcHttp.StringToNumber(dbline[7]), IdFile = XbmcHttp.StringToNumber(dbline[8]), FileName = dbline[9], Path = dbline[10], PlayCount = XbmcHttp.StringToNumber(dbline[11]), ShowTitle = dbline[12], Studio = dbline[13], IdShow = XbmcHttp.StringToNumber(dbline[14]), Mpaa = dbline[15] }; if (episode.FileName.StartsWith("stack://", StringComparison.OrdinalIgnoreCase)) { var temp = episode.FileName.Split(new[] { " , " }, StringSplitOptions.None); episode.IsStack = 1; episode.Hash = XbmcHttp.Hash(temp[0].Replace("stack://", "")); episode.Thumb = @"special://profile/Thumbnails/Video/" + episode.Hash[0] + "/" + episode.Hash + ".tbn"; episode.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + XbmcHttp.Hash(episode.Path) + ".tbn"; } else { episode.IsStack = 0; episode.Hash = XbmcHttp.Hash(episode.Path + episode.FileName); episode.Thumb = @"special://profile/Thumbnails/Video/" + episode.Hash[0] + "/" + episode.Hash + ".tbn"; episode.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + XbmcHttp.Hash(episode.Path) + ".tbn"; } episodes.Add(episode); } return(episodes); }
public Collection <ApiAudioArtist> GetArtists() { var artists = new Collection <ApiAudioArtist>(); var dblines = _parent.DBCommand("music", "SELECT idArtist,strArtist FROM artist"); if (dblines == null) { return(artists); } foreach (var dbline in dblines) { if (dbline.Length < 2) { _parent.Log("Invalid request DATA : " + dbline); continue; } var hash = XbmcHttp.Hash(dbline[1]); var hash2 = XbmcHttp.Hash("artist" + dbline[1]); var genre = new ApiAudioArtist { IdArtist = XbmcHttp.StringToNumber(dbline[0]), Name = dbline[1], Thumb = @"special://profile/Thumbnails/Music/Artists/" + hash2 + ".tbn", Fanart = @"special://profile/Thumbnails/Music/Fanart/" + hash + ".tbn", Hash = hash2 }; artists.Add(genre); } dblines = _parent.DBCommand("music", "SELECT idArtist,strBiography FROM artistinfo"); if (dblines == null) { return(artists); } foreach (var dbline in dblines) { if (dbline.Length < 2) { _parent.Log("Invalid request DATA : " + dbline); continue; } foreach (var artist in artists) { if (artist.IdArtist.ToString(CultureInfo.InvariantCulture) == dbline[0]) { artist.Biography = dbline[1]; } } } return(artists); }
public Collection <ApiAudioSong> GetSongs() { var songs = new Collection <ApiAudioSong>(); const string req = "SELECT idSong,strTitle,iTrack,iDuration,iYear,strFileName,idAlbum,strAlbum,strPath,idArtist,strArtist,idGenre,strGenre,strThumb FROM songview"; var dblines = _parent.DBCommand("music", req); if (dblines == null) { return(songs); } foreach (var dbline in dblines) { if (dbline.Length < 14) { _parent.Log("Invalid request DATA : " + dbline); continue; } var song = new ApiAudioSong { IdSong = XbmcHttp.StringToNumber(dbline[0]), Title = dbline[1], Track = XbmcHttp.StringToNumber(dbline[2]), Duration = XbmcHttp.StringToNumber(dbline[3]), Year = XbmcHttp.StringToNumber(dbline[4]), FileName = dbline[5], IdAlbum = XbmcHttp.StringToNumber(dbline[6]), Album = dbline[7], Path = dbline[8], IdArtist = XbmcHttp.StringToNumber(dbline[9]), Artist = dbline[10], IdGenre = XbmcHttp.StringToNumber(dbline[11]), Genre = dbline[12], Thumb = dbline[13], }; var thumbparts = dbline[13].Split('/'); var hash = thumbparts[thumbparts.Length - 1].Replace(".tbn", ""); song.Hash = hash; songs.Add(song); } return(songs); }
public Collection <ApiTvShow> GetTvShows() { var shows = new Collection <ApiTvShow>(); var dblines = _parent.DBCommand("video", "SELECT idShow,c00,c01,c04,c05,c08,c12,c13,c14,strPath,totalCount FROM tvshowview"); if (dblines == null) { return(shows); } foreach (var dbline in dblines) { if (dbline.Length < 11) { _parent.Log("Invalid request DATA : " + dbline); continue; } dbline[3] = dbline[3].Length > 3 ? dbline[3] : "0.0"; var show = new ApiTvShow { IdShow = XbmcHttp.StringToNumber(dbline[0]), Title = dbline[1], Plot = dbline[2], Rating = dbline[3].Substring(0, 3).Trim('.'), Premiered = dbline[4], Genre = dbline[5], IdScraper = dbline[6], Mpaa = dbline[7], Studio = dbline[8], Path = dbline[9], TotalCount = XbmcHttp.StringToNumber(dbline[10]) }; show.Hash = XbmcHttp.Hash(show.Path); show.Thumb = @"special://profile/Thumbnails/Video/" + show.Hash[0] + "/" + show.Hash + ".tbn"; show.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + show.Hash + ".tbn"; shows.Add(show); } return(shows); }
public Collection <ApiAudioGenre> GetGenres() { var genres = new Collection <ApiAudioGenre>(); var dblines = _parent.DBCommand("music", "SELECT idGenre,strGenre,COUNT(DISTINCT strAlbum) AS albumCount FROM albumview GROUP BY idGenre"); if (dblines == null) { return(genres); } foreach (var dbline in dblines) { if (dbline.Length < 3) { _parent.Log("Invalid request DATA : " + dbline); continue; } var genre = new ApiAudioGenre { IdGenre = XbmcHttp.StringToNumber(dbline[0]), Name = dbline[1], AlbumCount = XbmcHttp.StringToNumber(dbline[2]) }; genres.Add(genre); } return(genres); }
public Collection <ApiAudioAlbum> GetAlbums() { var albums = new Collection <ApiAudioAlbum>(); const string req = "SELECT idAlbum,strAlbum,idGenre,idArtist,strArtist,strGenre,iYear,strThumb FROM albumview GROUP BY strAlbum"; var dblines = _parent.DBCommand("music", req); if (dblines == null) { return(albums); } foreach (var dbline in dblines) { if (dbline.Length < 8) { _parent.Log("Invalid request DATA : " + dbline); continue; } var album = new ApiAudioAlbum { IdAlbum = XbmcHttp.StringToNumber(dbline[0]), Title = dbline[1], IdGenre = XbmcHttp.StringToNumber(dbline[2]), IdArtist = XbmcHttp.StringToNumber(dbline[3]), Artist = dbline[4], Genre = dbline[5], Year = XbmcHttp.StringToNumber(dbline[6]), Thumb = dbline[7] }; var thumbparts = dbline[7].Split('/'); var hash = thumbparts[thumbparts.Length - 1].Replace(".tbn", ""); album.Hash = hash; albums.Add(album); } return(albums); }
public Collection <ApiTvSeason> GetTvSeasons() { var seasons = new Collection <ApiTvSeason>(); const string req = "SELECT idShow, COUNT(idShow), c12, strPath FROM episodeview GROUP BY idShow,c12"; var dblines = _parent.DBCommand("video", req); if (dblines == null) { return(seasons); } foreach (var dbline in dblines) { if (dbline.Length < 4) { _parent.Log("Invalid request DATA : " + dbline); continue; } var season = new ApiTvSeason { EpisodeCount = XbmcHttp.StringToNumber(dbline[1]), IdShow = XbmcHttp.StringToNumber(dbline[0]), SeasonNumber = XbmcHttp.StringToNumber(dbline[2]) }; var temp = dbline[3]; season.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + XbmcHttp.Hash(temp) + ".tbn"; char[] charsToTrim = { '/' }; temp = temp.TrimEnd(charsToTrim); var hash = XbmcHttp.Hash("season" + temp); season.Thumb = @"special://profile/Thumbnails/Video/" + hash[0] + "/" + hash + ".tbn"; season.Hash = temp; seasons.Add(season); } return(seasons); }