+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
+--- Thread: Querying for Movies and Filtering on File Quality (/showthread.php?tid=117246)
Querying for Movies and Filtering on File Quality - cancan101 - 2011-12-19
Right now I am running the following query against the Video database (I am using the QueryVideoDatabase command in the web API to make the call):
select c09 from movie where c09="' + imdb + '"
where imdb is the movie's IMDB id
to find whether a given movie is already in the XBMC movie database. I want to limit the results to movies that I have of a certain quality. I know that XBMC shows "SD, 1080, etc" when playing a movie indicating the file's quality. Is the info saved in the database somewhere?
- Montellese - 2011-12-19
Yes it's in the streamdetails table. You'll have to come up with some JOIN query on movie, streamdetails and movie which has an ON condition of streamdetails.idFile = movie.idFile and filter by iStreamType = 0 (video stream) and use iVideoWidth for your condition on SD/HD/whatever.
Although something like this is not possible yet with JSON-RPC I'd discourage the use of HTTP API as it will be removed after Eden has been released and some missing functionality has been added to JSON-RPC.
- cancan101 - 2011-12-19
Is there anyway to tell if the video us 1080p vs 1080i? Does XBMC even show this when playing the file?