Kodi Community Forum

Full Version: sql total time for all watched movies
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
[i cannot seem to post in off-topic]

hello, im trying to make a web-stats using php of my media collection with the goal of trying to make something in along the lines of trakt.tv by using php and displaying only all the videos and tv shows with the playcount greater then 0 and pulling out all the runtimes to display a total in php. i just dont know how to go about simply doing that for starters. any ideas?
thanks i will look into it. i think first i would like to somehow do importing of the kodi sql and import just the played content with the value of 1 or greater so that cleans dont wipe this database. just the basic movie info like title, imdb, year, and runtime. i am just drunk brainstorming cuz i love stats and kodi Smile