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 <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 void RefreshNowPlaying()
{
lock (Locker)
{
if (_parent.MpcLoaded)
{
var result = _parent.MpcHcRemote.GetStatus();
var result2 = new ArrayList();
MpcHcRemote.ParseCSVFields(result2, result);
var data = (string[])result2.ToArray(typeof(string));
if (data.Length > 6)
{
_nowPlaying.MediaType = "Video";
_nowPlaying.Title = "Media Player Classic";
_nowPlaying.Time = new TimeSpan(0, 0, 0, Convert.ToInt32("0" + data[2]) / 1000);
_nowPlaying.Duration = new TimeSpan(0, 0, 0, Convert.ToInt32("0" + data[4]) / 1000);
var percent = Math.Floor(100.0 * Convert.ToInt32("0" + data[2], CultureInfo.InvariantCulture) / Convert.ToInt32("0" + data[4], CultureInfo.InvariantCulture));
if (Double.IsNaN(percent))
{
percent = 0;
}
_nowPlaying.Volume = Convert.ToInt32("0" + data[7], CultureInfo.InvariantCulture);
_nowPlaying.IsMuted = data[6] == "1";
_nowPlaying.Progress = (int)percent;
}
}
else
{
if (!_parent.IsConnected())
{
_nowPlaying.FileName = "";
_nowPlaying.Title = "";
return;
}
var infos = (JsonObject)_parent.JsonCommand("System.GetInfoLabels", new[]
{
"MusicPlayer.Title",
"MusicPlayer.Album",
"MusicPlayer.Artist",
"MusicPlayer.Property(Artist_Description)",
"MusicPlayer.Genre",
"MusicPlayer.Year",
"MusicPlayer.TrackNumber",
"MusicPlayer.Codec",
"Player.Time",
"Player.Duration",
"Player.Volume",
"Player.Filenameandpath",
"VideoPlayer.Title",
"VideoPlayer.TVShowTitle",
"VideoPlayer.Genre",
"VideoPlayer.Director",
"VideoPlayer.Year",
"VideoPlayer.Rating",
"VideoPlayer.Tagline",
"VideoPlayer.Studio",
"VideoPlayer.Plot",
"VideoPlayer.Season",
"VideoPlayer.Episode",
"VideoPlayer.VideoCodec"
});
if (infos == null)
{
return;
}
JsonObject infos2 = null;
_nowPlaying.FileName = infos["Player.Filenameandpath"].ToString();
if (!String.IsNullOrEmpty(infos["VideoPlayer.TVShowTitle"].ToString()))
{
_nowPlaying.MediaType = "TvShow";
}
else if (!String.IsNullOrEmpty(infos["MusicPlayer.Title"].ToString()))
{
_nowPlaying.MediaType = "Audio";
}
else if (!String.IsNullOrEmpty(infos["VideoPlayer.Title"].ToString()))
{
_nowPlaying.MediaType = "Movie";
}
else
{
_nowPlaying.MediaType = "Unknown";
_nowPlaying.Title = "";
_nowPlaying.IsPlaying = false;
_nowPlaying.IsPaused = false;
_nowPlaying.Duration = new TimeSpan();
_nowPlaying.Time = new TimeSpan();
}
if (_nowPlaying.MediaType == "Movie" || _nowPlaying.MediaType == "TvShow")
{
infos2 = (JsonObject)_parent.JsonCommand("VideoPlayer.GetTime", null);
_nowPlaying.Genre = infos["VideoPlayer.Genre"].ToString();
_nowPlaying.Title = infos["VideoPlayer.Title"].ToString();
_nowPlaying.Year = Convert.ToInt32("0" + infos["VideoPlayer.Year"]);
_nowPlaying.SeasonNumber = Convert.ToInt32("0" + infos["VideoPlayer.Season"]);
_nowPlaying.EpisodeNumber = Convert.ToInt32("0" + infos["VideoPlayer.Episode"]);
_nowPlaying.ShowTitle = infos["VideoPlayer.TVShowTitle"].ToString();
_nowPlaying.Plot = infos["VideoPlayer.Plot"].ToString();
_nowPlaying.Director = infos["VideoPlayer.Director"].ToString();
_nowPlaying.Studio = infos["VideoPlayer.Studio"].ToString();
_nowPlaying.Tagline = infos["VideoPlayer.Tagline"].ToString();
_nowPlaying.Rating = infos["VideoPlayer.Rating"].ToString();
if (_nowPlaying.FileName.StartsWith("stack://", StringComparison.OrdinalIgnoreCase))
{
var temp = _nowPlaying.FileName.Split(new[] { " , " }, StringSplitOptions.None);
var hash = Xbmc.Hash(temp[0].Replace("stack://", ""));
_nowPlaying.ThumbURL = @"special://profile/Thumbnails/Video/" + hash[0] + "/" + hash + ".tbn";
_nowPlaying.FanartURL = @"special://profile/Thumbnails/Video/Fanart/" + Xbmc.Hash(_nowPlaying.FileName) + ".tbn";
}
else
{
var hash = Xbmc.Hash(_nowPlaying.FileName);
_nowPlaying.ThumbURL = @"special://profile/Thumbnails/Video/" + hash[0] + "/" + hash + ".tbn";
_nowPlaying.FanartURL = @"special://profile/Thumbnails/Video/Fanart/" + hash + ".tbn";
}
}
if (_nowPlaying.MediaType == "Audio")
{
infos2 = (JsonObject)_parent.JsonCommand("AudioPlayer.GetTime", null);
_nowPlaying.Genre = infos["MusicPlayer.Genre"].ToString();
_nowPlaying.Title = infos["MusicPlayer.Title"].ToString();
_nowPlaying.Year = Convert.ToInt32("0" + infos["MusicPlayer.Year"]);
_nowPlaying.Track = Convert.ToInt32("0" + infos["MusicPlayer.TrackNumber"]);
_nowPlaying.Artist = infos["MusicPlayer.Artist"].ToString();
_nowPlaying.Album = infos["MusicPlayer.Album"].ToString();
var hash = Xbmc.Hash(_nowPlaying.Album + _nowPlaying.Artist);
_nowPlaying.ThumbURL = @"special://profile/Thumbnails/Music/" + hash[0] + "/" + hash + ".tbn";
_nowPlaying.FanartURL = @"special://profile/Thumbnails/Music/Fanart/" + hash + ".tbn";
}
if (infos2 != null)
{
_nowPlaying.IsPaused = (bool)infos2["paused"];
_nowPlaying.IsPlaying = !(bool)infos2["paused"] && (bool)infos2["playing"];
_nowPlaying.Time = new TimeSpan(0, 0, 0, Convert.ToInt32("0" + infos2["time"]));
_nowPlaying.Duration = new TimeSpan(0, 0, 0, Convert.ToInt32("0" + infos2["total"]));
}
var percent = Math.Floor(100.0 * _nowPlaying.Time.TotalSeconds / _nowPlaying.Duration.TotalSeconds);
if (Double.IsNaN(percent))
{
percent = 0;
}
_nowPlaying.Progress = (int)percent;
var vol = (1 - Convert.ToDouble("0" + infos["Player.Volume"].ToString().Replace(" dB", "").Replace("-", "").Replace(".", ",")) / 60) * 100;
_nowPlaying.Volume = (int)vol;
_nowPlaying.IsMuted = (vol == 0);
_parent.MpcLoaded = _nowPlaying.Duration == new TimeSpan(0, 0, 0, 1);
}
}
}