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 = Xbmc.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 = Xbmc.StringToNumber(dbline[13]),
IdMovie = Xbmc.StringToNumber(dbline[14]),
FileName = dbline[15],
Path = dbline[16],
PlayCount = Xbmc.StringToNumber(dbline[17])
};
if (movie.FileName.StartsWith("stack://", StringComparison.OrdinalIgnoreCase))
{
var temp = movie.FileName.Split(new[] { " , " }, StringSplitOptions.None);
movie.IsStack = 1;
movie.Hash = Xbmc.Hash(temp[0].Replace("stack://", ""));
movie.Thumb = @"special://profile/Thumbnails/Video/" + movie.Hash[0] + "/" + movie.Hash + ".tbn";
movie.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + Xbmc.Hash(movie.FileName) + ".tbn";
}
else
{
movie.IsStack = 0;
movie.Hash = Xbmc.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 = Xbmc.StringToNumber(dbline[0]),
Title = dbline[1],
Plot = dbline[2],
Rating = dbline[3].Substring(0, 3).Trim('.'),
Date = dbline[4],
Director = dbline[5],
Season = Xbmc.StringToNumber(dbline[6]),
Episode = Xbmc.StringToNumber(dbline[7]),
IdFile = Xbmc.StringToNumber(dbline[8]),
FileName = dbline[9],
Path = dbline[10],
PlayCount = Xbmc.StringToNumber(dbline[11]),
ShowTitle = dbline[12],
Studio = dbline[13],
IdShow = Xbmc.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 = Xbmc.Hash(temp[0].Replace("stack://", ""));
episode.Thumb = @"special://profile/Thumbnails/Video/" + episode.Hash[0] + "/" + episode.Hash + ".tbn";
episode.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + Xbmc.Hash(episode.Path) + ".tbn";
}
else
{
episode.IsStack = 0;
episode.Hash = Xbmc.Hash(episode.Path + episode.FileName);
episode.Thumb = @"special://profile/Thumbnails/Video/" + episode.Hash[0] + "/" + episode.Hash + ".tbn";
episode.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + Xbmc.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 = Xbmc.Hash(dbline[1]);
var hash2 = Xbmc.Hash("artist" + dbline[1]);
var genre = new ApiAudioArtist
{
IdArtist = Xbmc.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 <ApiTvSeason> GetTvSeasons()
{
var seasons = new Collection <ApiTvSeason>();
const string req = "SELECT idShow, COUNT(idShow), c12, strPath,strTitle FROM episodeview GROUP BY idShow,c12";
var showHashes = new Hashtable();
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 = Xbmc.StringToNumber(dbline[1]),
IdShow = Xbmc.StringToNumber(dbline[0]),
SeasonNumber = Xbmc.StringToNumber(dbline[2]),
Show = dbline[4]
};
var temp = dbline[3];
season.Fanart = @"special://profile/Thumbnails/Video/Fanart/" + Xbmc.Hash(temp) + ".tbn";
char[] charsToTrim = { '/' };
temp = temp.TrimEnd(charsToTrim);
var hash = Xbmc.Hash("season" + temp);
season.Thumb = @"special://profile/Thumbnails/Video/" + hash[0] + "/" + hash + ".tbn";
season.Hash = temp;
seasons.Add(season);
}
foreach (var season in seasons)
{
if (!showHashes.ContainsKey(season.IdShow))
{
showHashes.Add(season.IdShow, season.Show);
}
}
return(seasons);
}
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 = Xbmc.StringToNumber(dbline[0]),
Title = dbline[1],
Track = Xbmc.StringToNumber(dbline[2]),
Duration = Xbmc.StringToNumber(dbline[3]),
Year = Xbmc.StringToNumber(dbline[4]),
FileName = dbline[5],
IdAlbum = Xbmc.StringToNumber(dbline[6]),
Album = dbline[7],
Path = dbline[8],
IdArtist = Xbmc.StringToNumber(dbline[9]),
Artist = dbline[10],
IdGenre = Xbmc.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 tvshow.idShow,tvshow.c00,tvshow.c01,tvshow.c04,tvshow.c05,tvshow.c08,tvshow.c12,tvshow.c13,tvshow.c14,path.strPath as strPath,counts.totalcount as totalCount FROM tvshow join tvshowlinkpath on tvshow.idShow=tvshowlinkpath.idShow join path on path.idpath=tvshowlinkpath.idPath left outer join ( select tvshow.idShow as idShow,count(1) as totalcount,count(files.playCount) as watchedcount from tvshow join tvshowlinkepisode on tvshow.idShow = tvshowlinkepisode.idShow join episode on episode.idEpisode = tvshowlinkepisode.idEpisode join files on files.idFile = episode.idFile group by tvshow.idShow) counts on tvshow.idShow = counts.idShow");
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 = Xbmc.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 = Xbmc.StringToNumber(dbline[10])
};
show.Hash = Xbmc.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 = Xbmc.StringToNumber(dbline[0]), Name = dbline[1], AlbumCount = Xbmc.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 = Xbmc.StringToNumber(dbline[0]),
Title = dbline[1],
IdGenre = Xbmc.StringToNumber(dbline[2]),
IdArtist = Xbmc.StringToNumber(dbline[3]),
Artist = dbline[4],
Genre = dbline[5],
Year = Xbmc.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);
}
